a84f2d1bb6b361f6dd3de0e7812de78a1e0e3600
[zzz-pokedex.git] / pokedex / db / tables.py
1 # encoding: utf8
2
3 from sqlalchemy import Column, ForeignKey, MetaData, Table
4 from sqlalchemy.ext.declarative import declarative_base
5 from sqlalchemy.ext.associationproxy import association_proxy
6 from sqlalchemy.orm import backref, relation
7 from sqlalchemy.sql import and_
8 from sqlalchemy.types import *
9 from sqlalchemy.databases.mysql import *
10
11 from pokedex.db import rst
12
13 metadata = MetaData()
14 TableBase = declarative_base(metadata=metadata)
15
16 class Ability(TableBase):
17 __tablename__ = 'abilities'
18 __singlename__ = 'ability'
19 id = Column(Integer, primary_key=True, nullable=False)
20 name = Column(Unicode(24), nullable=False)
21 flavor_text = Column(Unicode(64), nullable=False)
22 effect = Column(Unicode(255), nullable=False)
23
24 class ContestCombo(TableBase):
25 __tablename__ = 'contest_combos'
26 first_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
27 second_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
28
29 class ContestEffect(TableBase):
30 __tablename__ = 'contest_effects'
31 id = Column(Integer, primary_key=True, nullable=False)
32 appeal = Column(SmallInteger, nullable=False)
33 jam = Column(SmallInteger, nullable=False)
34 flavor_text = Column(Unicode(64), nullable=False)
35 effect = Column(Unicode(255), nullable=False)
36
37 class EggGroup(TableBase):
38 __tablename__ = 'egg_groups'
39 id = Column(Integer, primary_key=True, nullable=False)
40 name = Column(Unicode(16), nullable=False)
41
42 class Encounter(TableBase):
43 """Rows in this table represent encounters with wild Pokémon. Bear with
44 me, here.
45
46 Within a given area in a given game, encounters are differentiated by the
47 "slot" they are in and the state of the game world.
48
49 What the player is doing to get an encounter, such as surfing or walking
50 through tall grass, is called terrain. Each terrain has its own set of
51 encounter slots.
52
53 Within a terrain, slots are defined primarily by rarity. Each slot can
54 also be affected by world conditions; for example, the 20% slot for walking
55 in tall grass is affected by whether a swarm is in effect in that area.
56 "Is there a swarm?" is a condition; "there is a swarm" and "there is not a
57 swarm" are the possible values of this condition.
58
59 A slot (20% walking in grass) and any appropriate world conditions (no
60 swarm) are thus enough to define a specific encounter.
61
62 Well, okay, almost: each slot actually appears twice.
63 """
64
65 __tablename__ = 'encounters'
66 id = Column(Integer, primary_key=True, nullable=False)
67 version_id = Column(Integer, ForeignKey('versions.id'), nullable=False, autoincrement=False)
68 location_area_id = Column(Integer, ForeignKey('location_areas.id'), nullable=False, autoincrement=False)
69 encounter_slot_id = Column(Integer, ForeignKey('encounter_slots.id'), nullable=False, autoincrement=False)
70 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), nullable=False, autoincrement=False)
71 min_level = Column(Integer, nullable=False, autoincrement=False)
72 max_level = Column(Integer, nullable=False, autoincrement=False)
73
74 class EncounterCondition(TableBase):
75 """Rows in this table represent varying conditions in the game world, such
76 as time of day.
77 """
78
79 __tablename__ = 'encounter_conditions'
80 id = Column(Integer, primary_key=True, nullable=False)
81 name = Column(Unicode(64), nullable=False)
82
83 class EncounterConditionValue(TableBase):
84 """Rows in this table represent possible states for a condition; for
85 example, the state of 'swarm' could be 'swarm' or 'no swarm'.
86 """
87
88 __tablename__ = 'encounter_condition_values'
89 id = Column(Integer, primary_key=True, nullable=False)
90 encounter_condition_id = Column(Integer, ForeignKey('encounter_conditions.id'), primary_key=False, nullable=False, autoincrement=False)
91 name = Column(Unicode(64), nullable=False)
92 is_default = Column(Boolean, nullable=False)
93
94 class EncounterConditionValueMap(TableBase):
95 """Maps encounters to the specific conditions under which they occur."""
96
97 __tablename__ = 'encounter_condition_value_map'
98 encounter_id = Column(Integer, ForeignKey('encounters.id'), primary_key=True, nullable=False, autoincrement=False)
99 encounter_condition_value_id = Column(Integer, ForeignKey('encounter_condition_values.id'), primary_key=True, nullable=False, autoincrement=False)
100
101 class EncounterTerrain(TableBase):
102 """Rows in this table represent ways the player can enter a wild encounter,
103 e.g., surfing, fishing, or walking through tall grass.
104 """
105
106 __tablename__ = 'encounter_terrain'
107 id = Column(Integer, primary_key=True, nullable=False)
108 name = Column(Unicode(64), nullable=False)
109
110 class EncounterSlot(TableBase):
111 """Rows in this table represent an abstract "slot" within a terrain,
112 associated with both some set of conditions and a rarity.
113
114 Note that there are two encounters per slot, so the rarities will only add
115 up to 50.
116 """
117
118 __tablename__ = 'encounter_slots'
119 id = Column(Integer, primary_key=True, nullable=False)
120 version_group_id = Column(Integer, ForeignKey('version_groups.id'), nullable=False, autoincrement=False)
121 encounter_terrain_id = Column(Integer, ForeignKey('encounter_terrain.id'), primary_key=False, nullable=False, autoincrement=False)
122 rarity = Column(Integer, nullable=False, autoincrement=False)
123
124 class EncounterSlotCondition(TableBase):
125 """Lists all conditions that affect each slot."""
126
127 __tablename__ = 'encounter_slot_conditions'
128 encounter_slot_id = Column(Integer, ForeignKey('encounter_slots.id'), primary_key=True, nullable=False, autoincrement=False)
129 encounter_condition_id = Column(Integer, ForeignKey('encounter_conditions.id'), primary_key=True, nullable=False, autoincrement=False)
130
131 class EvolutionChain(TableBase):
132 __tablename__ = 'evolution_chains'
133 id = Column(Integer, primary_key=True, nullable=False)
134 growth_rate_id = Column(Integer, ForeignKey('growth_rates.id'), nullable=False)
135 steps_to_hatch = Column(Integer, nullable=False)
136 baby_trigger_item = Column(Unicode(12))
137
138 class EvolutionMethod(TableBase):
139 __tablename__ = 'evolution_methods'
140 id = Column(Integer, primary_key=True, nullable=False)
141 name = Column(Unicode(64), nullable=False)
142 description = Column(Unicode(255), nullable=False)
143
144 class Generation(TableBase):
145 __tablename__ = 'generations'
146 id = Column(Integer, primary_key=True, nullable=False)
147 name = Column(Unicode(16), nullable=False)
148 main_region = Column(Unicode(16), nullable=False)
149
150 class GrowthRate(TableBase):
151 """`formula` is written in LaTeX math notation."""
152 __tablename__ = 'growth_rates'
153 id = Column(Integer, primary_key=True, nullable=False)
154 name = Column(Unicode(20), nullable=False)
155 formula = Column(Unicode(500), nullable=False)
156
157 class Item(TableBase):
158 __tablename__ = 'items'
159 __singlename__ = 'item'
160 id = Column(Integer, primary_key=True, nullable=False)
161 name = Column(Unicode(16), nullable=False)
162
163 class Language(TableBase):
164 __tablename__ = 'languages'
165 id = Column(Integer, primary_key=True, nullable=False)
166 iso3166 = Column(Unicode(2), nullable=False)
167 name = Column(Unicode(16), nullable=False)
168
169 class Location(TableBase):
170 __tablename__ = 'locations'
171 __singlename__ = 'location'
172 id = Column(Integer, primary_key=True, nullable=False)
173 generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
174 name = Column(Unicode(64), nullable=False)
175
176 class LocationArea(TableBase):
177 __tablename__ = 'location_areas'
178 id = Column(Integer, primary_key=True, nullable=False)
179 location_id = Column(Integer, ForeignKey('locations.id'), nullable=False)
180 internal_id = Column(Integer, nullable=False)
181 name = Column(Unicode(64), nullable=True)
182
183 class LocationAreaEncounterRate(TableBase):
184 __tablename__ = 'location_area_encounter_rates'
185 location_area_id = Column(Integer, ForeignKey('location_areas.id'), primary_key=True, nullable=False, autoincrement=False)
186 encounter_type_id = Column(Integer, ForeignKey('encounter_terrain.id'), primary_key=True, nullable=False, autoincrement=False)
187 rate = Column(Integer, nullable=True)
188
189 class Machine(TableBase):
190 __tablename__ = 'machines'
191 machine_number = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
192 version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
193 move_id = Column(Integer, ForeignKey('moves.id'), nullable=False)
194
195 class MoveEffectCategory(TableBase):
196 __tablename__ = 'move_effect_categories'
197 id = Column(Integer, primary_key=True, nullable=False)
198 name = Column(Unicode(64), nullable=False)
199 can_affect_user = Column(Boolean, nullable=False)
200
201 class MoveEffectCategoryMap(TableBase):
202 __tablename__ = 'move_effect_category_map'
203 move_effect_id = Column(Integer, ForeignKey('move_effects.id'), primary_key=True, nullable=False)
204 move_effect_category_id = Column(Integer, ForeignKey('move_effect_categories.id'), primary_key=True, nullable=False)
205 affects_user = Column(Boolean, primary_key=True, nullable=False)
206
207 class MoveDamageClass(TableBase):
208 __tablename__ = 'move_damage_classes'
209 id = Column(Integer, primary_key=True, nullable=False)
210 name = Column(Unicode(8), nullable=False)
211 description = Column(Unicode(64), nullable=False)
212
213 class MoveEffect(TableBase):
214 __tablename__ = 'move_effects'
215 id = Column(Integer, primary_key=True, nullable=False)
216 priority = Column(SmallInteger, nullable=False)
217 short_effect = Column(Unicode(256), nullable=False)
218 effect = Column(Unicode(5120), nullable=False)
219
220 class MoveFlag(TableBase):
221 __tablename__ = 'move_flags'
222 move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
223 move_flag_type_id = Column(Integer, ForeignKey('move_flag_types.id'), primary_key=True, nullable=False, autoincrement=False)
224
225 class MoveFlagType(TableBase):
226 __tablename__ = 'move_flag_types'
227 id = Column(Integer, primary_key=True, nullable=False)
228 name = Column(Unicode(32), nullable=False)
229 description = Column(rst.RstTextColumn(128), nullable=False)
230
231 class MoveFlavorText(TableBase):
232 __tablename__ = 'move_flavor_text'
233 move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
234 generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, nullable=False, autoincrement=False)
235 flavor_text = Column(Unicode(255), nullable=False)
236
237 class MoveName(TableBase):
238 __tablename__ = 'move_names'
239 move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
240 language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
241 name = Column(Unicode(16), nullable=False)
242
243 class MoveTarget(TableBase):
244 __tablename__ = 'move_targets'
245 id = Column(Integer, primary_key=True, nullable=False)
246 name = Column(Unicode(32), nullable=False)
247 description = Column(Unicode(128), nullable=False)
248
249 class Move(TableBase):
250 __tablename__ = 'moves'
251 __singlename__ = 'move'
252 id = Column(Integer, primary_key=True, nullable=False)
253 name = Column(Unicode(12), nullable=False)
254 generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
255 type_id = Column(Integer, ForeignKey('types.id'), nullable=False)
256 power = Column(SmallInteger)
257 pp = Column(SmallInteger, nullable=False)
258 accuracy = Column(SmallInteger)
259 target_id = Column(Integer, ForeignKey('move_targets.id'), nullable=False)
260 damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=False)
261 effect_id = Column(Integer, ForeignKey('move_effects.id'), nullable=False)
262 effect_chance = Column(Integer)
263 contest_type = Column(Unicode(8), nullable=False)
264 contest_effect_id = Column(Integer, ForeignKey('contest_effects.id'), nullable=True)
265 super_contest_effect_id = Column(Integer, ForeignKey('super_contest_effects.id'), nullable=False)
266
267 class Pokemon(TableBase):
268 """The core to this whole mess.
269
270 Note that I use both 'forme' and 'form' in both code and the database. I
271 only use 'forme' when specifically referring to Pokémon that have multiple
272 distinct species as forms—i.e., different stats or movesets. 'Form' is a
273 more general term referring to any variation within a species, including
274 purely cosmetic forms like Unown.
275 """
276 __tablename__ = 'pokemon'
277 __singlename__ = 'pokemon'
278 id = Column(Integer, primary_key=True, nullable=False)
279 name = Column(Unicode(20), nullable=False)
280 forme_name = Column(Unicode(16))
281 forme_base_pokemon_id = Column(Integer, ForeignKey('pokemon.id'))
282 generation_id = Column(Integer, ForeignKey('generations.id'))
283 evolution_chain_id = Column(Integer, ForeignKey('evolution_chains.id'))
284 evolution_parent_pokemon_id = Column(Integer, ForeignKey('pokemon.id'))
285 evolution_method_id = Column(Integer, ForeignKey('evolution_methods.id'))
286 evolution_parameter = Column(Unicode(32))
287 height = Column(Integer, nullable=False)
288 weight = Column(Integer, nullable=False)
289 species = Column(Unicode(16), nullable=False)
290 color = Column(Unicode(6), nullable=False)
291 pokemon_shape_id = Column(Integer, ForeignKey('pokemon_shapes.id'), nullable=False)
292 habitat = Column(Unicode(16), nullable=False)
293 gender_rate = Column(Integer, nullable=False)
294 capture_rate = Column(Integer, nullable=False)
295 base_experience = Column(Integer, nullable=False)
296 base_happiness = Column(Integer, nullable=False)
297 gen1_internal_id = Column(Integer)
298 is_baby = Column(Boolean, nullable=False)
299 has_gen4_fem_sprite = Column(Boolean, nullable=False)
300 has_gen4_fem_back_sprite = Column(Boolean, nullable=False)
301
302 ### Stuff to handle alternate Pokémon forms
303
304 @property
305 def national_id(self):
306 """Returns the National Pokédex number for this Pokémon. Use this
307 instead of the id directly; alternate formes may make the id incorrect.
308 """
309
310 if self.forme_base_pokemon_id:
311 return self.forme_base_pokemon_id
312 return self.id
313
314 @property
315 def full_name(self):
316 """Returns the name of this Pokémon, including its Forme, if any."""
317
318 if self.forme_name:
319 return "%s %s" % (self.forme_name.capitalize(), self.name)
320 return self.name
321
322 @property
323 def normal_form(self):
324 """Returns the normal form for this Pokémon; i.e., this will return
325 regular Deoxys when called on any Deoxys form.
326 """
327
328 if self.forme_base_pokemon:
329 return self.forme_base_pokemon
330
331 return self
332
333 class PokemonAbility(TableBase):
334 __tablename__ = 'pokemon_abilities'
335 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
336 ability_id = Column(Integer, ForeignKey('abilities.id'), nullable=False)
337 slot = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
338
339 class PokemonDexNumber(TableBase):
340 __tablename__ = 'pokemon_dex_numbers'
341 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
342 generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, nullable=False, autoincrement=False)
343 pokedex_number = Column(Integer, nullable=False)
344
345 class PokemonEggGroup(TableBase):
346 __tablename__ = 'pokemon_egg_groups'
347 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
348 egg_group_id = Column(Integer, ForeignKey('egg_groups.id'), primary_key=True, nullable=False, autoincrement=False)
349
350 class PokemonFlavorText(TableBase):
351 __tablename__ = 'pokemon_flavor_text'
352 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
353 version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
354 flavor_text = Column(Unicode(255), nullable=False)
355
356 class PokemonFormGroup(TableBase):
357 __tablename__ = 'pokemon_form_groups'
358 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
359 description = Column(Unicode(512), nullable=False)
360
361 class PokemonFormSprite(TableBase):
362 __tablename__ = 'pokemon_form_sprites'
363 id = Column(Integer, primary_key=True, nullable=False)
364 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
365 introduced_in_version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
366 name = Column(Unicode(16), nullable=True)
367
368 class PokemonItem(TableBase):
369 __tablename__ = 'pokemon_items'
370 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
371 version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
372 item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, nullable=False, autoincrement=False)
373 rarity = Column(Integer, nullable=False)
374
375 class PokemonMove(TableBase):
376 __tablename__ = 'pokemon_moves'
377 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
378 version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
379 move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False, index=True)
380 pokemon_move_method_id = Column(Integer, ForeignKey('pokemon_move_methods.id'), primary_key=True, nullable=False, autoincrement=False)
381 level = Column(Integer, primary_key=True, nullable=True, autoincrement=False)
382 order = Column(Integer, nullable=True)
383
384 class PokemonMoveMethod(TableBase):
385 __tablename__ = 'pokemon_move_methods'
386 id = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
387 name = Column(Unicode(64), nullable=False)
388 description = Column(Unicode(255), nullable=False)
389
390 class PokemonName(TableBase):
391 __tablename__ = 'pokemon_names'
392 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
393 language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
394 name = Column(Unicode(16), nullable=False)
395
396 class PokemonShape(TableBase):
397 __tablename__ = 'pokemon_shapes'
398 id = Column(Integer, primary_key=True, nullable=False)
399 name = Column(Unicode(24), nullable=False)
400 awesome_name = Column(Unicode(16), nullable=False)
401
402 class PokemonStat(TableBase):
403 __tablename__ = 'pokemon_stats'
404 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
405 stat_id = Column(Integer, ForeignKey('stats.id'), primary_key=True, nullable=False, autoincrement=False)
406 base_stat = Column(Integer, nullable=False)
407 effort = Column(Integer, nullable=False)
408
409 class PokemonType(TableBase):
410 __tablename__ = 'pokemon_types'
411 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
412 type_id = Column(Integer, ForeignKey('types.id'), nullable=False)
413 slot = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
414
415 class Stat(TableBase):
416 __tablename__ = 'stats'
417 id = Column(Integer, primary_key=True, nullable=False)
418 name = Column(Unicode(16), nullable=False)
419
420 class SuperContestCombo(TableBase):
421 __tablename__ = 'super_contest_combos'
422 first_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
423 second_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
424
425 class SuperContestEffect(TableBase):
426 __tablename__ = 'super_contest_effects'
427 id = Column(Integer, primary_key=True, nullable=False)
428 appeal = Column(SmallInteger, nullable=False)
429 flavor_text = Column(Unicode(64), nullable=False)
430
431 class TypeEfficacy(TableBase):
432 __tablename__ = 'type_efficacy'
433 damage_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
434 target_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
435 damage_factor = Column(Integer, nullable=False)
436
437 class Type(TableBase):
438 __tablename__ = 'types'
439 __singlename__ = 'type'
440 id = Column(Integer, primary_key=True, nullable=False)
441 name = Column(Unicode(8), nullable=False)
442 abbreviation = Column(Unicode(3), nullable=False)
443 generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
444 damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=False) ## ??? is none; everything else is physical or special
445
446 class VersionGroup(TableBase):
447 __tablename__ = 'version_groups'
448 id = Column(Integer, primary_key=True, nullable=False)
449 generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
450
451 class Version(TableBase):
452 __tablename__ = 'versions'
453 id = Column(Integer, primary_key=True, nullable=False)
454 version_group_id = Column(Integer, ForeignKey('version_groups.id'), nullable=False)
455 name = Column(Unicode(32), nullable=False)
456
457
458 ### Relations down here, to avoid ordering problems
459 ContestCombo.first = relation(Move, primaryjoin=ContestCombo.first_move_id==Move.id,
460 backref='contest_combo_first')
461 ContestCombo.second = relation(Move, primaryjoin=ContestCombo.second_move_id==Move.id,
462 backref='contest_combo_second')
463
464 Encounter.location_area = relation(LocationArea, backref='encounters')
465 Encounter.pokemon = relation(Pokemon, backref='encounters')
466 Encounter.version = relation(Version, backref='encounters')
467 Encounter.slot = relation(EncounterSlot, backref='encounters')
468
469 EncounterConditionValue.condition = relation(EncounterCondition, backref='values')
470
471 Encounter.condition_value_map = relation(EncounterConditionValueMap, backref='encounter')
472 Encounter.condition_values = association_proxy('condition_value_map', 'condition_value')
473 EncounterConditionValueMap.condition_value = relation(EncounterConditionValue,
474 backref='encounter_map')
475
476 EncounterSlot.terrain = relation(EncounterTerrain, backref='slots')
477
478 EncounterSlot.condition_map = relation(EncounterSlotCondition, backref='slot')
479 EncounterSlot.conditions = association_proxy('condition_map', 'condition')
480 EncounterSlotCondition.condition = relation(EncounterCondition,
481 backref='slot_map')
482
483 EvolutionChain.growth_rate = relation(GrowthRate, backref='evolution_chains')
484
485 Generation.versions = relation(Version, secondary=VersionGroup.__table__)
486
487 LocationArea.location = relation(Location, backref='areas')
488
489 Machine.version_group = relation(VersionGroup)
490
491 Move.contest_effect = relation(ContestEffect, backref='moves')
492 Move.contest_combo_next = association_proxy('contest_combo_first', 'second')
493 Move.contest_combo_prev = association_proxy('contest_combo_second', 'first')
494 Move.damage_class = relation(MoveDamageClass, backref='moves')
495 Move.flags = association_proxy('move_flags', 'flag')
496 Move.flavor_text = relation(MoveFlavorText, order_by=MoveFlavorText.generation_id, backref='move')
497 Move.foreign_names = relation(MoveName, backref='pokemon')
498 Move.generation = relation(Generation, backref='moves')
499 Move.machines = relation(Machine, backref='move')
500 Move.move_effect = relation(MoveEffect, backref='moves')
501 Move.move_flags = relation(MoveFlag, backref='move')
502 Move.super_contest_effect = relation(SuperContestEffect, backref='moves')
503 Move.super_contest_combo_next = association_proxy('super_contest_combo_first', 'second')
504 Move.super_contest_combo_prev = association_proxy('super_contest_combo_second', 'first')
505 Move.target = relation(MoveTarget, backref='moves')
506 Move.type = relation(Type, backref='moves')
507
508 Move.effect = rst.MoveEffectProperty('effect')
509 Move.priority = association_proxy('move_effect', 'priority')
510 Move.short_effect = rst.MoveEffectProperty('short_effect')
511
512 MoveEffect.category_map = relation(MoveEffectCategoryMap)
513 MoveEffect.categories = association_proxy('category_map', 'category')
514 MoveEffectCategoryMap.category = relation(MoveEffectCategory)
515
516 MoveFlag.flag = relation(MoveFlagType)
517
518 MoveFlavorText.generation = relation(Generation)
519
520 MoveName.language = relation(Language)
521
522 Pokemon.abilities = relation(Ability, secondary=PokemonAbility.__table__,
523 order_by=PokemonAbility.slot,
524 backref='pokemon')
525 Pokemon.formes = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.forme_base_pokemon_id,
526 backref=backref('forme_base_pokemon',
527 remote_side=[Pokemon.id]))
528 Pokemon.dex_numbers = relation(PokemonDexNumber, backref='pokemon')
529 Pokemon.egg_groups = relation(EggGroup, secondary=PokemonEggGroup.__table__,
530 order_by=PokemonEggGroup.egg_group_id,
531 backref='pokemon')
532 Pokemon.evolution_chain = relation(EvolutionChain, backref='pokemon')
533 Pokemon.evolution_method = relation(EvolutionMethod)
534 Pokemon.evolution_children = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.evolution_parent_pokemon_id,
535 backref=backref('evolution_parent',
536 remote_side=[Pokemon.id]))
537 Pokemon.flavor_text = relation(PokemonFlavorText, order_by=PokemonFlavorText.pokemon_id, backref='pokemon')
538 Pokemon.foreign_names = relation(PokemonName, backref='pokemon')
539 Pokemon.items = relation(PokemonItem)
540 Pokemon.generation = relation(Generation, backref='pokemon')
541 Pokemon.shape = relation(PokemonShape, backref='pokemon')
542 Pokemon.stats = relation(PokemonStat, backref='pokemon')
543 Pokemon.types = relation(Type, secondary=PokemonType.__table__)
544
545 PokemonDexNumber.generation = relation(Generation)
546
547 PokemonFlavorText.version = relation(Version)
548
549 PokemonItem.item = relation(Item, backref='pokemon')
550 PokemonItem.version = relation(Version)
551
552 PokemonFormGroup.pokemon = relation(Pokemon, backref=backref('form_group',
553 uselist=False))
554 PokemonFormSprite.pokemon = relation(Pokemon, backref='form_sprites')
555 PokemonFormSprite.introduced_in = relation(VersionGroup)
556
557 PokemonMove.pokemon = relation(Pokemon, backref='pokemon_moves')
558 PokemonMove.version_group = relation(VersionGroup)
559 PokemonMove.machine = relation(Machine, backref='pokemon_moves',
560 primaryjoin=and_(Machine.version_group_id==PokemonMove.version_group_id,
561 Machine.move_id==PokemonMove.move_id),
562 foreign_keys=[Machine.version_group_id, Machine.move_id],
563 uselist=False)
564 PokemonMove.move = relation(Move, backref='pokemon_moves')
565 PokemonMove.method = relation(PokemonMoveMethod)
566
567 PokemonName.language = relation(Language)
568
569 PokemonStat.stat = relation(Stat)
570
571 SuperContestCombo.first = relation(Move, primaryjoin=SuperContestCombo.first_move_id==Move.id,
572 backref='super_contest_combo_first')
573 SuperContestCombo.second = relation(Move, primaryjoin=SuperContestCombo.second_move_id==Move.id,
574 backref='super_contest_combo_second')
575
576 Type.damage_efficacies = relation(TypeEfficacy,
577 primaryjoin=Type.id
578 ==TypeEfficacy.damage_type_id,
579 backref='damage_type')
580 Type.target_efficacies = relation(TypeEfficacy,
581 primaryjoin=Type.id
582 ==TypeEfficacy.target_type_id,
583 backref='target_type')
584
585 Type.generation = relation(Generation, backref='types')
586 Type.damage_class = relation(MoveDamageClass, backref='types')
587
588 Version.version_group = relation(VersionGroup, backref='versions')
589 Version.generation = association_proxy('version_group', 'generation')
590
591 VersionGroup.generation = relation(Generation, backref='version_groups')