From e524b9f9589d02e3e76bcde47651505592c189eb Mon Sep 17 00:00:00 2001
From: Eevee <git@veekun.com>
Date: Sun, 1 Mar 2009 19:40:02 -0800
Subject: [PATCH] Added more table relations, for spline-pokedex Pokemon page.

---
 pokedex/db/tables.py | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py
index e738c0d..7bf7822 100644
--- a/pokedex/db/tables.py
+++ b/pokedex/db/tables.py
@@ -181,4 +181,26 @@ class Version(TableBase):
 
 
 ### Relations down here, to avoid ordering problems
+Pokemon.abilities = relation(Ability, secondary=PokemonAbility.__table__,
+                                      order_by=PokemonAbility.slot,
+                                      backref='pokemon')
+Pokemon.dex_numbers = relation(PokemonDexNumber, backref='pokemon')
+Pokemon.evolution_chain = relation(EvolutionChain, backref='pokemon')
+Pokemon.foreign_names = relation(PokemonName, backref='pokemon')
+Pokemon.stats = relation(PokemonStat, backref='pokemon')
 Pokemon.types = relation(Type, secondary=PokemonType.__table__)
+
+PokemonDexNumber.generation = relation(Generation)
+
+PokemonName.language = relation(Language)
+
+PokemonStat.stat = relation(Stat)
+
+Type.damage_efficacies = relation(TypeEfficacy,
+                                  primaryjoin=Type.id
+                                      ==TypeEfficacy.damage_type_id,
+                                  backref='damage_type')
+Type.target_efficacies = relation(TypeEfficacy,
+                                  primaryjoin=Type.id
+                                      ==TypeEfficacy.target_type_id,
+                                  backref='target_type')
-- 
2.7.4