From: Eevee <git@veekun.com>
Date: Mon, 2 Mar 2009 03:40:02 +0000 (-0800)
Subject: Added more table relations, for spline-pokedex Pokemon page.
X-Git-Tag: veekun-promotions/2010050901~300
X-Git-Url: http://git.veekun.com/zzz-pokedex.git/commitdiff_plain/e524b9f9589d02e3e76bcde47651505592c189eb

Added more table relations, for spline-pokedex Pokemon page.
---

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')