Added an is_shiny accessor to Pokémon structs.
[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, eagerload_all, relation
7 from sqlalchemy.orm.session import Session
8 from sqlalchemy.sql import and_
9 from sqlalchemy.types import *
10
11 from pokedex.db import markdown
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 generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
22 effect = Column(markdown.MarkdownColumn(5120), nullable=False)
23 short_effect = Column(markdown.MarkdownColumn(255), nullable=False)
24
25 class AbilityFlavorText(TableBase):
26 __tablename__ = 'ability_flavor_text'
27 ability_id = Column(Integer, ForeignKey('abilities.id'), primary_key=True, nullable=False, autoincrement=False)
28 version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
29 flavor_text = Column(Unicode(64), nullable=False)
30
31 class AbilityName(TableBase):
32 __tablename__ = 'ability_names'
33 ability_id = Column(Integer, ForeignKey('abilities.id'), primary_key=True, nullable=False, autoincrement=False)
34 language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
35 name = Column(Unicode(16), nullable=False)
36
37 class Berry(TableBase):
38 __tablename__ = 'berries'
39 id = Column(Integer, primary_key=True, nullable=False)
40 item_id = Column(Integer, ForeignKey('items.id'), nullable=False)
41 firmness_id = Column(Integer, ForeignKey('berry_firmness.id'), nullable=False)
42 natural_gift_power = Column(Integer, nullable=True)
43 natural_gift_type_id = Column(Integer, ForeignKey('types.id'), nullable=True)
44 size = Column(Integer, nullable=False)
45 max_harvest = Column(Integer, nullable=False)
46 growth_time = Column(Integer, nullable=False)
47 soil_dryness = Column(Integer, nullable=False)
48 smoothness = Column(Integer, nullable=False)
49
50 class BerryFirmness(TableBase):
51 __tablename__ = 'berry_firmness'
52 id = Column(Integer, primary_key=True, nullable=False)
53 name = Column(Unicode(10), nullable=False)
54
55 class BerryFlavor(TableBase):
56 __tablename__ = 'berry_flavors'
57 berry_id = Column(Integer, ForeignKey('berries.id'), primary_key=True, nullable=False, autoincrement=False)
58 contest_type_id = Column(Integer, ForeignKey('contest_types.id'), primary_key=True, nullable=False, autoincrement=False)
59 flavor = Column(Integer, nullable=False)
60
61 class ContestCombo(TableBase):
62 __tablename__ = 'contest_combos'
63 first_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
64 second_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
65
66 class ContestEffect(TableBase):
67 __tablename__ = 'contest_effects'
68 id = Column(Integer, primary_key=True, nullable=False)
69 appeal = Column(SmallInteger, nullable=False)
70 jam = Column(SmallInteger, nullable=False)
71 flavor_text = Column(Unicode(64), nullable=False)
72 effect = Column(Unicode(255), nullable=False)
73
74 class ContestType(TableBase):
75 __tablename__ = 'contest_types'
76 id = Column(Integer, primary_key=True, nullable=False)
77 name = Column(Unicode(6), nullable=False)
78 flavor = Column(Unicode(6), nullable=False)
79 color = Column(Unicode(6), nullable=False)
80
81 class EggGroup(TableBase):
82 __tablename__ = 'egg_groups'
83 id = Column(Integer, primary_key=True, nullable=False)
84 name = Column(Unicode(16), nullable=False)
85
86 class Encounter(TableBase):
87 """Rows in this table represent encounters with wild Pokémon. Bear with
88 me, here.
89
90 Within a given area in a given game, encounters are differentiated by the
91 "slot" they are in and the state of the game world.
92
93 What the player is doing to get an encounter, such as surfing or walking
94 through tall grass, is called terrain. Each terrain has its own set of
95 encounter slots.
96
97 Within a terrain, slots are defined primarily by rarity. Each slot can
98 also be affected by world conditions; for example, the 20% slot for walking
99 in tall grass is affected by whether a swarm is in effect in that area.
100 "Is there a swarm?" is a condition; "there is a swarm" and "there is not a
101 swarm" are the possible values of this condition.
102
103 A slot (20% walking in grass) and any appropriate world conditions (no
104 swarm) are thus enough to define a specific encounter.
105
106 Well, okay, almost: each slot actually appears twice.
107 """
108
109 __tablename__ = 'encounters'
110 id = Column(Integer, primary_key=True, nullable=False)
111 version_id = Column(Integer, ForeignKey('versions.id'), nullable=False, autoincrement=False)
112 location_area_id = Column(Integer, ForeignKey('location_areas.id'), nullable=False, autoincrement=False)
113 encounter_slot_id = Column(Integer, ForeignKey('encounter_slots.id'), nullable=False, autoincrement=False)
114 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), nullable=False, autoincrement=False)
115 min_level = Column(Integer, nullable=False, autoincrement=False)
116 max_level = Column(Integer, nullable=False, autoincrement=False)
117
118 class EncounterCondition(TableBase):
119 """Rows in this table represent varying conditions in the game world, such
120 as time of day.
121 """
122
123 __tablename__ = 'encounter_conditions'
124 id = Column(Integer, primary_key=True, nullable=False)
125 name = Column(Unicode(64), nullable=False)
126
127 class EncounterConditionValue(TableBase):
128 """Rows in this table represent possible states for a condition; for
129 example, the state of 'swarm' could be 'swarm' or 'no swarm'.
130 """
131
132 __tablename__ = 'encounter_condition_values'
133 id = Column(Integer, primary_key=True, nullable=False)
134 encounter_condition_id = Column(Integer, ForeignKey('encounter_conditions.id'), primary_key=False, nullable=False, autoincrement=False)
135 name = Column(Unicode(64), nullable=False)
136 is_default = Column(Boolean, nullable=False)
137
138 class EncounterConditionValueMap(TableBase):
139 """Maps encounters to the specific conditions under which they occur."""
140
141 __tablename__ = 'encounter_condition_value_map'
142 encounter_id = Column(Integer, ForeignKey('encounters.id'), primary_key=True, nullable=False, autoincrement=False)
143 encounter_condition_value_id = Column(Integer, ForeignKey('encounter_condition_values.id'), primary_key=True, nullable=False, autoincrement=False)
144
145 class EncounterTerrain(TableBase):
146 """Rows in this table represent ways the player can enter a wild encounter,
147 e.g., surfing, fishing, or walking through tall grass.
148 """
149
150 __tablename__ = 'encounter_terrain'
151 id = Column(Integer, primary_key=True, nullable=False)
152 name = Column(Unicode(64), nullable=False)
153
154 class EncounterSlot(TableBase):
155 """Rows in this table represent an abstract "slot" within a terrain,
156 associated with both some set of conditions and a rarity.
157
158 Note that there are two encounters per slot, so the rarities will only add
159 up to 50.
160 """
161
162 __tablename__ = 'encounter_slots'
163 id = Column(Integer, primary_key=True, nullable=False)
164 version_group_id = Column(Integer, ForeignKey('version_groups.id'), nullable=False, autoincrement=False)
165 encounter_terrain_id = Column(Integer, ForeignKey('encounter_terrain.id'), primary_key=False, nullable=False, autoincrement=False)
166 slot = Column(Integer, nullable=True)
167 rarity = Column(Integer, nullable=False)
168
169 class EncounterSlotCondition(TableBase):
170 """Lists all conditions that affect each slot."""
171
172 __tablename__ = 'encounter_slot_conditions'
173 encounter_slot_id = Column(Integer, ForeignKey('encounter_slots.id'), primary_key=True, nullable=False, autoincrement=False)
174 encounter_condition_id = Column(Integer, ForeignKey('encounter_conditions.id'), primary_key=True, nullable=False, autoincrement=False)
175
176 class EvolutionChain(TableBase):
177 __tablename__ = 'evolution_chains'
178 id = Column(Integer, primary_key=True, nullable=False)
179 growth_rate_id = Column(Integer, ForeignKey('growth_rates.id'), nullable=False)
180 steps_to_hatch = Column(Integer, nullable=False)
181 baby_trigger_item = Column(Unicode(12))
182
183 class EvolutionTrigger(TableBase):
184 __tablename__ = 'evolution_triggers'
185 id = Column(Integer, primary_key=True, nullable=False)
186 identifier = Column(Unicode(16), nullable=False)
187
188 class Experience(TableBase):
189 __tablename__ = 'experience'
190 growth_rate_id = Column(Integer, ForeignKey('growth_rates.id'), primary_key=True, nullable=False)
191 level = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
192 experience = Column(Integer, nullable=False)
193
194 class Generation(TableBase):
195 __tablename__ = 'generations'
196 id = Column(Integer, primary_key=True, nullable=False)
197 main_region_id = Column(Integer, ForeignKey('regions.id'))
198 canonical_pokedex_id = Column(Integer, ForeignKey('pokedexes.id'))
199 name = Column(Unicode(16), nullable=False)
200
201 class GrowthRate(TableBase):
202 """`formula` is written in LaTeX math notation."""
203 __tablename__ = 'growth_rates'
204 id = Column(Integer, primary_key=True, nullable=False)
205 name = Column(Unicode(20), nullable=False)
206 formula = Column(Unicode(500), nullable=False)
207
208 class Item(TableBase):
209 __tablename__ = 'items'
210 __singlename__ = 'item'
211 id = Column(Integer, primary_key=True, nullable=False)
212 name = Column(Unicode(16), nullable=False)
213 category_id = Column(Integer, ForeignKey('item_categories.id'), nullable=False)
214 cost = Column(Integer, nullable=False)
215 fling_power = Column(Integer, nullable=True)
216 fling_effect_id = Column(Integer, ForeignKey('item_fling_effects.id'), nullable=True)
217 effect = Column(markdown.MarkdownColumn(5120), nullable=False)
218
219 @property
220 def appears_underground(self):
221 return any(flag.identifier == u'underground' for flag in self.flags)
222
223 class ItemCategory(TableBase):
224 __tablename__ = 'item_categories'
225 id = Column(Integer, primary_key=True, nullable=False)
226 pocket_id = Column(Integer, ForeignKey('item_pockets.id'), nullable=False)
227 name = Column(Unicode(16), nullable=False)
228
229 class ItemFlag(TableBase):
230 __tablename__ = 'item_flags'
231 id = Column(Integer, primary_key=True, nullable=False)
232 identifier = Column(Unicode(24), nullable=False)
233 name = Column(Unicode(64), nullable=False)
234
235 class ItemFlagMap(TableBase):
236 __tablename__ = 'item_flag_map'
237 item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, autoincrement=False, nullable=False)
238 item_flag_id = Column(Integer, ForeignKey('item_flags.id'), primary_key=True, autoincrement=False, nullable=False)
239
240 class ItemFlavorText(TableBase):
241 __tablename__ = 'item_flavor_text'
242 item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, autoincrement=False, nullable=False)
243 version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, autoincrement=False, nullable=False)
244 flavor_text = Column(Unicode(255), nullable=False)
245
246 class ItemFlingEffect(TableBase):
247 __tablename__ = 'item_fling_effects'
248 id = Column(Integer, primary_key=True, nullable=False)
249 effect = Column(Unicode(255), nullable=False)
250
251 class ItemInternalID(TableBase):
252 __tablename__ = 'item_internal_ids'
253 item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, autoincrement=False, nullable=False)
254 generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, autoincrement=False, nullable=False)
255 internal_id = Column(Integer, nullable=False)
256
257 class ItemName(TableBase):
258 __tablename__ = 'item_names'
259 item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, nullable=False, autoincrement=False)
260 language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
261 name = Column(Unicode(16), nullable=False)
262
263 class ItemPocket(TableBase):
264 __tablename__ = 'item_pockets'
265 id = Column(Integer, primary_key=True, nullable=False)
266 identifier = Column(Unicode(16), nullable=False)
267 name = Column(Unicode(16), nullable=False)
268
269 class Language(TableBase):
270 __tablename__ = 'languages'
271 id = Column(Integer, primary_key=True, nullable=False)
272 iso639 = Column(Unicode(2), nullable=False)
273 iso3166 = Column(Unicode(2), nullable=False)
274 name = Column(Unicode(16), nullable=False)
275
276 class Location(TableBase):
277 __tablename__ = 'locations'
278 __singlename__ = 'location'
279 id = Column(Integer, primary_key=True, nullable=False)
280 region_id = Column(Integer, ForeignKey('regions.id'))
281 name = Column(Unicode(64), nullable=False)
282
283 class LocationArea(TableBase):
284 __tablename__ = 'location_areas'
285 id = Column(Integer, primary_key=True, nullable=False)
286 location_id = Column(Integer, ForeignKey('locations.id'), nullable=False)
287 internal_id = Column(Integer, nullable=False)
288 name = Column(Unicode(64), nullable=True)
289
290 class LocationAreaEncounterRate(TableBase):
291 __tablename__ = 'location_area_encounter_rates'
292 location_area_id = Column(Integer, ForeignKey('location_areas.id'), primary_key=True, nullable=False, autoincrement=False)
293 encounter_terrain_id = Column(Integer, ForeignKey('encounter_terrain.id'), primary_key=True, nullable=False, autoincrement=False)
294 version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, autoincrement=False)
295 rate = Column(Integer, nullable=True)
296
297 class Machine(TableBase):
298 __tablename__ = 'machines'
299 machine_number = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
300 version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
301 item_id = Column(Integer, ForeignKey('items.id'), nullable=False)
302 move_id = Column(Integer, ForeignKey('moves.id'), nullable=False)
303
304 @property
305 def is_hm(self):
306 return self.machine_number >= 100
307
308 class MoveBattleStyle(TableBase):
309 __tablename__ = 'move_battle_styles'
310 id = Column(Integer, primary_key=True, nullable=False)
311 name = Column(Unicode(8), nullable=False)
312
313 class MoveEffectCategory(TableBase):
314 __tablename__ = 'move_effect_categories'
315 id = Column(Integer, primary_key=True, nullable=False)
316 name = Column(Unicode(64), nullable=False)
317 can_affect_user = Column(Boolean, nullable=False)
318
319 class MoveEffectCategoryMap(TableBase):
320 __tablename__ = 'move_effect_category_map'
321 move_effect_id = Column(Integer, ForeignKey('move_effects.id'), primary_key=True, nullable=False)
322 move_effect_category_id = Column(Integer, ForeignKey('move_effect_categories.id'), primary_key=True, nullable=False)
323 affects_user = Column(Boolean, primary_key=True, nullable=False)
324
325 class MoveDamageClass(TableBase):
326 __tablename__ = 'move_damage_classes'
327 id = Column(Integer, primary_key=True, nullable=False)
328 name = Column(Unicode(8), nullable=False)
329 description = Column(Unicode(64), nullable=False)
330
331 class MoveEffect(TableBase):
332 __tablename__ = 'move_effects'
333 id = Column(Integer, primary_key=True, nullable=False)
334 priority = Column(SmallInteger, nullable=False)
335 short_effect = Column(Unicode(256), nullable=False)
336 effect = Column(Unicode(5120), nullable=False)
337
338 class MoveFlag(TableBase):
339 __tablename__ = 'move_flags'
340 move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
341 move_flag_type_id = Column(Integer, ForeignKey('move_flag_types.id'), primary_key=True, nullable=False, autoincrement=False)
342
343 class MoveFlagType(TableBase):
344 __tablename__ = 'move_flag_types'
345 id = Column(Integer, primary_key=True, nullable=False)
346 name = Column(Unicode(32), nullable=False)
347 description = Column(markdown.MarkdownColumn(128), nullable=False)
348
349 class MoveFlavorText(TableBase):
350 __tablename__ = 'move_flavor_text'
351 move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
352 version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
353 flavor_text = Column(Unicode(255), nullable=False)
354
355 class MoveName(TableBase):
356 __tablename__ = 'move_names'
357 move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
358 language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
359 name = Column(Unicode(16), nullable=False)
360
361 class MoveTarget(TableBase):
362 __tablename__ = 'move_targets'
363 id = Column(Integer, primary_key=True, nullable=False)
364 name = Column(Unicode(32), nullable=False)
365 description = Column(Unicode(128), nullable=False)
366
367 class Move(TableBase):
368 __tablename__ = 'moves'
369 __singlename__ = 'move'
370 id = Column(Integer, primary_key=True, nullable=False)
371 name = Column(Unicode(12), nullable=False)
372 generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
373 type_id = Column(Integer, ForeignKey('types.id'), nullable=False)
374 power = Column(SmallInteger)
375 pp = Column(SmallInteger, nullable=False)
376 accuracy = Column(SmallInteger)
377 target_id = Column(Integer, ForeignKey('move_targets.id'), nullable=False)
378 damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=False)
379 effect_id = Column(Integer, ForeignKey('move_effects.id'), nullable=False)
380 effect_chance = Column(Integer)
381 contest_type_id = Column(Integer, ForeignKey('contest_types.id'), nullable=True)
382 contest_effect_id = Column(Integer, ForeignKey('contest_effects.id'), nullable=True)
383 super_contest_effect_id = Column(Integer, ForeignKey('super_contest_effects.id'), nullable=False)
384
385 class Nature(TableBase):
386 __tablename__ = 'natures'
387 __singlename__ = 'nature'
388 id = Column(Integer, primary_key=True, nullable=False)
389 name = Column(Unicode(8), nullable=False)
390 decreased_stat_id = Column(Integer, ForeignKey('stats.id'), nullable=False)
391 increased_stat_id = Column(Integer, ForeignKey('stats.id'), nullable=False)
392 hates_flavor_id = Column(Integer, ForeignKey('contest_types.id'), nullable=False)
393 likes_flavor_id = Column(Integer, ForeignKey('contest_types.id'), nullable=False)
394
395 class NatureBattleStylePreference(TableBase):
396 __tablename__ = 'nature_battle_style_preferences'
397 nature_id = Column(Integer, ForeignKey('natures.id'), primary_key=True, nullable=False)
398 move_battle_style_id = Column(Integer, ForeignKey('move_battle_styles.id'), primary_key=True, nullable=False)
399 low_hp_preference = Column(Integer, nullable=False)
400 high_hp_preference = Column(Integer, nullable=False)
401
402 class NatureName(TableBase):
403 __tablename__ = 'nature_names'
404 nature_id = Column(Integer, ForeignKey('natures.id'), primary_key=True, nullable=False, autoincrement=False)
405 language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
406 name = Column(Unicode(8), nullable=False)
407
408 class NaturePokeathlonStat(TableBase):
409 __tablename__ = 'nature_pokeathlon_stats'
410 nature_id = Column(Integer, ForeignKey('natures.id'), primary_key=True, nullable=False)
411 pokeathlon_stat_id = Column(Integer, ForeignKey('pokeathlon_stats.id'), primary_key=True, nullable=False)
412 max_change = Column(Integer, nullable=False)
413
414 class PokeathlonStat(TableBase):
415 __tablename__ = 'pokeathlon_stats'
416 id = Column(Integer, primary_key=True, nullable=False)
417 name = Column(Unicode(8), nullable=False)
418
419 class Pokedex(TableBase):
420 __tablename__ = 'pokedexes'
421 id = Column(Integer, primary_key=True, nullable=False)
422 region_id = Column(Integer, ForeignKey('regions.id'), nullable=True)
423 name = Column(Unicode(16), nullable=False)
424 description = Column(Unicode(512))
425
426 class PokedexVersionGroup(TableBase):
427 __tablename__ = 'pokedex_version_groups'
428 pokedex_id = Column(Integer, ForeignKey('pokedexes.id'), primary_key=True, nullable=False, autoincrement=False)
429 version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
430
431 class Pokemon(TableBase):
432 """The core to this whole mess.
433
434 Note that I use both 'forme' and 'form' in both code and the database. I
435 only use 'forme' when specifically referring to Pokémon that have multiple
436 distinct species as forms—i.e., different stats or movesets. 'Form' is a
437 more general term referring to any variation within a species, including
438 purely cosmetic forms like Unown.
439 """
440 __tablename__ = 'pokemon'
441 __singlename__ = 'pokemon'
442 id = Column(Integer, primary_key=True, nullable=False)
443 name = Column(Unicode(20), nullable=False)
444 forme_name = Column(Unicode(16))
445 forme_base_pokemon_id = Column(Integer, ForeignKey('pokemon.id'))
446 generation_id = Column(Integer, ForeignKey('generations.id'))
447 evolution_chain_id = Column(Integer, ForeignKey('evolution_chains.id'))
448 height = Column(Integer, nullable=False)
449 weight = Column(Integer, nullable=False)
450 species = Column(Unicode(16), nullable=False)
451 color_id = Column(Integer, ForeignKey('pokemon_colors.id'), nullable=False)
452 pokemon_shape_id = Column(Integer, ForeignKey('pokemon_shapes.id'), nullable=False)
453 habitat_id = Column(Integer, ForeignKey('pokemon_habitats.id'), nullable=True)
454 gender_rate = Column(Integer, nullable=False)
455 capture_rate = Column(Integer, nullable=False)
456 base_experience = Column(Integer, nullable=False)
457 base_happiness = Column(Integer, nullable=False)
458 is_baby = Column(Boolean, nullable=False)
459 has_gen4_fem_sprite = Column(Boolean, nullable=False)
460 has_gen4_fem_back_sprite = Column(Boolean, nullable=False)
461
462 ### Stuff to handle alternate Pokémon forms
463
464 @property
465 def national_id(self):
466 """Returns the National Pokédex number for this Pokémon. Use this
467 instead of the id directly; alternate formes may make the id incorrect.
468 """
469
470 if self.forme_base_pokemon_id:
471 return self.forme_base_pokemon_id
472 return self.id
473
474 @property
475 def full_name(self):
476 """Returns the name of this Pokémon, including its Forme, if any."""
477
478 if self.forme_name:
479 return "%s %s" % (self.forme_name.title(), self.name)
480 return self.name
481
482 @property
483 def normal_form(self):
484 """Returns the normal form for this Pokémon; i.e., this will return
485 regular Deoxys when called on any Deoxys form.
486 """
487
488 if self.forme_base_pokemon:
489 return self.forme_base_pokemon
490
491 return self
492
493 ### Not forms!
494
495 def stat(self, stat_name):
496 """Returns a PokemonStat record for the given stat name (or Stat row
497 object). Uses the normal has-many machinery, so all the stats are
498 effectively cached.
499 """
500 if isinstance(stat_name, Stat):
501 stat_name = stat_name.name
502
503 for pokemon_stat in self.stats:
504 if pokemon_stat.stat.name == stat_name:
505 return pokemon_stat
506
507 raise KeyError(u'No stat named %s' % stat_name)
508
509 @property
510 def better_damage_class(self):
511 u"""Returns the MoveDamageClass that this Pokémon is best suited for,
512 based on its attack stats.
513
514 If the attack stats are about equal (within 5), returns None. The
515 value None, not the damage class called 'None'.
516 """
517 phys = self.stat(u'Attack')
518 spec = self.stat(u'Special Attack')
519
520 diff = phys.base_stat - spec.base_stat
521
522 if diff > 5:
523 return phys.stat.damage_class
524 elif diff < -5:
525 return spec.stat.damage_class
526 else:
527 return None
528
529 class PokemonAbility(TableBase):
530 __tablename__ = 'pokemon_abilities'
531 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
532 ability_id = Column(Integer, ForeignKey('abilities.id'), nullable=False)
533 slot = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
534
535 class PokemonColor(TableBase):
536 __tablename__ = 'pokemon_colors'
537 id = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
538 name = Column(Unicode(6), nullable=False)
539
540 class PokemonDexNumber(TableBase):
541 __tablename__ = 'pokemon_dex_numbers'
542 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
543 pokedex_id = Column(Integer, ForeignKey('pokedexes.id'), primary_key=True, nullable=False, autoincrement=False)
544 pokedex_number = Column(Integer, nullable=False)
545
546 class PokemonEggGroup(TableBase):
547 __tablename__ = 'pokemon_egg_groups'
548 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
549 egg_group_id = Column(Integer, ForeignKey('egg_groups.id'), primary_key=True, nullable=False, autoincrement=False)
550
551 class PokemonEvolution(TableBase):
552 __tablename__ = 'pokemon_evolution'
553 from_pokemon_id = Column(Integer, ForeignKey('pokemon.id'), nullable=False)
554 to_pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
555 evolution_trigger_id = Column(Integer, ForeignKey('evolution_triggers.id'), nullable=False)
556 trigger_item_id = Column(Integer, ForeignKey('items.id'), nullable=True)
557 minimum_level = Column(Integer, nullable=True)
558 gender = Column(Enum('male', 'female', name='pokemon_evolution_gender'), nullable=True)
559 location_id = Column(Integer, ForeignKey('locations.id'), nullable=True)
560 held_item_id = Column(Integer, ForeignKey('items.id'), nullable=True)
561 time_of_day = Column(Enum('morning', 'day', 'night', name='pokemon_evolution_time_of_day'), nullable=True)
562 known_move_id = Column(Integer, ForeignKey('moves.id'), nullable=True)
563 minimum_happiness = Column(Integer, nullable=True)
564 minimum_beauty = Column(Integer, nullable=True)
565 relative_physical_stats = Column(Integer, nullable=True)
566 party_pokemon_id = Column(Integer, ForeignKey('pokemon.id'), nullable=True)
567
568 class PokemonFlavorText(TableBase):
569 __tablename__ = 'pokemon_flavor_text'
570 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
571 version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
572 flavor_text = Column(Unicode(255), nullable=False)
573
574 class PokemonFormGroup(TableBase):
575 __tablename__ = 'pokemon_form_groups'
576 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
577 is_battle_only = Column(Boolean, nullable=False)
578 description = Column(markdown.MarkdownColumn(1024), nullable=False)
579
580 class PokemonFormSprite(TableBase):
581 __tablename__ = 'pokemon_form_sprites'
582 id = Column(Integer, primary_key=True, nullable=False)
583 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
584 introduced_in_version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
585 name = Column(Unicode(16), nullable=True)
586 is_default = Column(Boolean, nullable=True)
587
588 class PokemonHabitat(TableBase):
589 __tablename__ = 'pokemon_habitats'
590 id = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
591 name = Column(Unicode(16), nullable=False)
592
593 class PokemonInternalID(TableBase):
594 __tablename__ = 'pokemon_internal_ids'
595 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, autoincrement=False, nullable=False)
596 generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, autoincrement=False, nullable=False)
597 internal_id = Column(Integer, nullable=False)
598
599 class PokemonItem(TableBase):
600 __tablename__ = 'pokemon_items'
601 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
602 version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
603 item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, nullable=False, autoincrement=False)
604 rarity = Column(Integer, nullable=False)
605
606 class PokemonMove(TableBase):
607 __tablename__ = 'pokemon_moves'
608 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
609 version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
610 move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False, index=True)
611 pokemon_move_method_id = Column(Integer, ForeignKey('pokemon_move_methods.id'), primary_key=True, nullable=False, autoincrement=False)
612 level = Column(Integer, primary_key=True, nullable=True, autoincrement=False, index=True)
613 order = Column(Integer, nullable=True, index=True)
614
615 class PokemonMoveMethod(TableBase):
616 __tablename__ = 'pokemon_move_methods'
617 id = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
618 name = Column(Unicode(64), nullable=False)
619 description = Column(Unicode(255), nullable=False)
620
621 class PokemonName(TableBase):
622 __tablename__ = 'pokemon_names'
623 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
624 language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
625 name = Column(Unicode(16), nullable=False)
626
627 class PokemonShape(TableBase):
628 __tablename__ = 'pokemon_shapes'
629 id = Column(Integer, primary_key=True, nullable=False)
630 name = Column(Unicode(24), nullable=False)
631 awesome_name = Column(Unicode(16), nullable=False)
632
633 class PokemonStat(TableBase):
634 __tablename__ = 'pokemon_stats'
635 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
636 stat_id = Column(Integer, ForeignKey('stats.id'), primary_key=True, nullable=False, autoincrement=False)
637 base_stat = Column(Integer, nullable=False)
638 effort = Column(Integer, nullable=False)
639
640 class PokemonType(TableBase):
641 __tablename__ = 'pokemon_types'
642 pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
643 type_id = Column(Integer, ForeignKey('types.id'), nullable=False)
644 slot = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
645
646 class Region(TableBase):
647 """Major areas of the world: Kanto, Johto, etc."""
648 __tablename__ = 'regions'
649 id = Column(Integer, primary_key=True, nullable=False)
650 name = Column(Unicode(16), nullable=False)
651
652 class Stat(TableBase):
653 __tablename__ = 'stats'
654 id = Column(Integer, primary_key=True, nullable=False)
655 damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=True)
656 name = Column(Unicode(16), nullable=False)
657
658 class SuperContestCombo(TableBase):
659 __tablename__ = 'super_contest_combos'
660 first_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
661 second_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
662
663 class SuperContestEffect(TableBase):
664 __tablename__ = 'super_contest_effects'
665 id = Column(Integer, primary_key=True, nullable=False)
666 appeal = Column(SmallInteger, nullable=False)
667 flavor_text = Column(Unicode(64), nullable=False)
668
669 class TypeEfficacy(TableBase):
670 __tablename__ = 'type_efficacy'
671 damage_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
672 target_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
673 damage_factor = Column(Integer, nullable=False)
674
675 class Type(TableBase):
676 __tablename__ = 'types'
677 __singlename__ = 'type'
678 id = Column(Integer, primary_key=True, nullable=False)
679 name = Column(Unicode(8), nullable=False)
680 abbreviation = Column(Unicode(3), nullable=False)
681 generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
682 damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=False) ## ??? is none; everything else is physical or special
683
684 class VersionGroup(TableBase):
685 __tablename__ = 'version_groups'
686 id = Column(Integer, primary_key=True, nullable=False)
687 generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
688
689 class VersionGroupRegion(TableBase):
690 __tablename__ = 'version_group_regions'
691 version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False)
692 region_id = Column(Integer, ForeignKey('regions.id'), primary_key=True, nullable=False)
693
694 class Version(TableBase):
695 __tablename__ = 'versions'
696 id = Column(Integer, primary_key=True, nullable=False)
697 version_group_id = Column(Integer, ForeignKey('version_groups.id'), nullable=False)
698 name = Column(Unicode(32), nullable=False)
699
700
701 ### Relations down here, to avoid ordering problems
702 Ability.flavor_text = relation(AbilityFlavorText, order_by=AbilityFlavorText.version_group_id, backref='ability')
703 Ability.foreign_names = relation(AbilityName, backref='ability')
704 Ability.generation = relation(Generation, backref='abilities')
705
706 AbilityFlavorText.version_group = relation(VersionGroup)
707
708 AbilityName.language = relation(Language)
709
710 Berry.berry_firmness = relation(BerryFirmness, backref='berries')
711 Berry.firmness = association_proxy('berry_firmness', 'name')
712 Berry.flavors = relation(BerryFlavor, order_by=BerryFlavor.contest_type_id, backref='berry')
713 Berry.natural_gift_type = relation(Type)
714
715 BerryFlavor.contest_type = relation(ContestType)
716
717 ContestCombo.first = relation(Move, primaryjoin=ContestCombo.first_move_id==Move.id,
718 backref='contest_combo_first')
719 ContestCombo.second = relation(Move, primaryjoin=ContestCombo.second_move_id==Move.id,
720 backref='contest_combo_second')
721
722 Encounter.location_area = relation(LocationArea, backref='encounters')
723 Encounter.pokemon = relation(Pokemon, backref='encounters')
724 Encounter.version = relation(Version, backref='encounters')
725 Encounter.slot = relation(EncounterSlot, backref='encounters')
726
727 EncounterConditionValue.condition = relation(EncounterCondition, backref='values')
728
729 Encounter.condition_value_map = relation(EncounterConditionValueMap, backref='encounter')
730 Encounter.condition_values = association_proxy('condition_value_map', 'condition_value')
731 EncounterConditionValueMap.condition_value = relation(EncounterConditionValue,
732 backref='encounter_map')
733
734 EncounterSlot.terrain = relation(EncounterTerrain, backref='slots')
735
736 EncounterSlot.condition_map = relation(EncounterSlotCondition, backref='slot')
737 EncounterSlot.conditions = association_proxy('condition_map', 'condition')
738 EncounterSlotCondition.condition = relation(EncounterCondition,
739 backref='slot_map')
740
741 EvolutionChain.growth_rate = relation(GrowthRate, backref='evolution_chains')
742
743 Experience.growth_rate = relation(GrowthRate, backref='experience_table')
744
745 Generation.canonical_pokedex = relation(Pokedex, backref='canonical_for_generation')
746 Generation.versions = relation(Version, secondary=VersionGroup.__table__)
747 Generation.main_region = relation(Region)
748
749 GrowthRate.max_experience_obj = relation(Experience, primaryjoin=and_(Experience.growth_rate_id == GrowthRate.id, Experience.level == 100), uselist=False)
750 GrowthRate.max_experience = association_proxy('max_experience_obj', 'experience')
751
752 Item.berry = relation(Berry, uselist=False, backref='item')
753 Item.flags = relation(ItemFlag, secondary=ItemFlagMap.__table__)
754 Item.flavor_text = relation(ItemFlavorText, order_by=ItemFlavorText.version_group_id.asc(), backref='item')
755 Item.fling_effect = relation(ItemFlingEffect, backref='items')
756 Item.foreign_names = relation(ItemName, backref='item')
757 Item.machines = relation(Machine, order_by=Machine.version_group_id.asc())
758 Item.category = relation(ItemCategory)
759 Item.pocket = association_proxy('category', 'pocket')
760
761 ItemCategory.items = relation(Item, order_by=Item.name)
762 ItemCategory.pocket = relation(ItemPocket)
763
764 ItemFlavorText.version_group = relation(VersionGroup)
765
766 ItemName.language = relation(Language)
767
768 ItemPocket.categories = relation(ItemCategory, order_by=ItemCategory.name)
769
770 Location.region = relation(Region, backref='locations')
771
772 LocationArea.location = relation(Location, backref='areas')
773
774 Machine.item = relation(Item)
775 Machine.version_group = relation(VersionGroup)
776
777 Move.contest_effect = relation(ContestEffect, backref='moves')
778 Move.contest_combo_next = association_proxy('contest_combo_first', 'second')
779 Move.contest_combo_prev = association_proxy('contest_combo_second', 'first')
780 Move.contest_type = relation(ContestType, backref='moves')
781 Move.damage_class = relation(MoveDamageClass, backref='moves')
782 Move.flags = association_proxy('move_flags', 'flag')
783 Move.flavor_text = relation(MoveFlavorText, order_by=MoveFlavorText.version_group_id, backref='move')
784 Move.foreign_names = relation(MoveName, backref='move')
785 Move.generation = relation(Generation, backref='moves')
786 Move.machines = relation(Machine, backref='move')
787 Move.move_effect = relation(MoveEffect, backref='moves')
788 Move.move_flags = relation(MoveFlag, backref='move')
789 Move.super_contest_effect = relation(SuperContestEffect, backref='moves')
790 Move.super_contest_combo_next = association_proxy('super_contest_combo_first', 'second')
791 Move.super_contest_combo_prev = association_proxy('super_contest_combo_second', 'first')
792 Move.target = relation(MoveTarget, backref='moves')
793 Move.type = relation(Type, backref='moves')
794
795 Move.effect = markdown.MoveEffectProperty('effect')
796 Move.priority = association_proxy('move_effect', 'priority')
797 Move.short_effect = markdown.MoveEffectProperty('short_effect')
798
799 MoveEffect.category_map = relation(MoveEffectCategoryMap)
800 MoveEffect.categories = association_proxy('category_map', 'category')
801 MoveEffectCategoryMap.category = relation(MoveEffectCategory)
802
803 MoveFlag.flag = relation(MoveFlagType)
804
805 MoveFlavorText.version_group = relation(VersionGroup)
806
807 MoveName.language = relation(Language)
808
809 Nature.foreign_names = relation(NatureName, backref='nature')
810 Nature.decreased_stat = relation(Stat, primaryjoin=Nature.decreased_stat_id==Stat.id,
811 backref='decreasing_natures')
812 Nature.increased_stat = relation(Stat, primaryjoin=Nature.increased_stat_id==Stat.id,
813 backref='increasing_natures')
814 Nature.hates_flavor = relation(ContestType, primaryjoin=Nature.hates_flavor_id==ContestType.id,
815 backref='hating_natures')
816 Nature.likes_flavor = relation(ContestType, primaryjoin=Nature.likes_flavor_id==ContestType.id,
817 backref='liking_natures')
818 Nature.battle_style_preferences = relation(NatureBattleStylePreference,
819 order_by=NatureBattleStylePreference.move_battle_style_id,
820 backref='nature')
821 Nature.pokeathlon_effects = relation(NaturePokeathlonStat, order_by=NaturePokeathlonStat.pokeathlon_stat_id)
822
823 NatureBattleStylePreference.battle_style = relation(MoveBattleStyle, backref='nature_preferences')
824
825 NatureName.language = relation(Language)
826
827 NaturePokeathlonStat.pokeathlon_stat = relation(PokeathlonStat, backref='nature_effects')
828
829 Pokedex.region = relation(Region, backref='pokedexes')
830 Pokedex.version_groups = relation(VersionGroup, secondary=PokedexVersionGroup.__table__, backref='pokedexes')
831
832 Pokemon.abilities = relation(Ability, secondary=PokemonAbility.__table__,
833 order_by=PokemonAbility.slot,
834 backref='pokemon')
835 Pokemon.formes = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.forme_base_pokemon_id,
836 backref=backref('forme_base_pokemon',
837 remote_side=[Pokemon.id]))
838 Pokemon.pokemon_color = relation(PokemonColor, backref='pokemon')
839 Pokemon.color = association_proxy('pokemon_color', 'name')
840 Pokemon.dex_numbers = relation(PokemonDexNumber, order_by=PokemonDexNumber.pokedex_id.asc(), backref='pokemon')
841 Pokemon.default_form_sprite = relation(PokemonFormSprite,
842 primaryjoin=and_(
843 Pokemon.id==PokemonFormSprite.pokemon_id,
844 PokemonFormSprite.is_default==True,
845 ),
846 uselist=False)
847 Pokemon.egg_groups = relation(EggGroup, secondary=PokemonEggGroup.__table__,
848 order_by=PokemonEggGroup.egg_group_id,
849 backref='pokemon')
850 Pokemon.evolution_chain = relation(EvolutionChain, backref='pokemon')
851 Pokemon.child_pokemon = relation(Pokemon,
852 primaryjoin=Pokemon.id==PokemonEvolution.from_pokemon_id,
853 secondary=PokemonEvolution.__table__,
854 secondaryjoin=PokemonEvolution.to_pokemon_id==Pokemon.id,
855 backref=backref('parent_pokemon', uselist=False),
856 )
857 Pokemon.flavor_text = relation(PokemonFlavorText, order_by=PokemonFlavorText.version_id.asc(), backref='pokemon')
858 Pokemon.foreign_names = relation(PokemonName, backref='pokemon')
859 Pokemon.pokemon_habitat = relation(PokemonHabitat, backref='pokemon')
860 Pokemon.habitat = association_proxy('pokemon_habitat', 'name')
861 Pokemon.items = relation(PokemonItem, backref='pokemon')
862 Pokemon.generation = relation(Generation, backref='pokemon')
863 Pokemon.shape = relation(PokemonShape, backref='pokemon')
864 Pokemon.stats = relation(PokemonStat, backref='pokemon')
865 Pokemon.types = relation(Type, secondary=PokemonType.__table__, order_by=PokemonType.slot.asc())
866
867 PokemonDexNumber.pokedex = relation(Pokedex)
868
869 PokemonEvolution.from_pokemon = relation(Pokemon,
870 primaryjoin=PokemonEvolution.from_pokemon_id==Pokemon.id,
871 backref='child_evolutions',
872 )
873 PokemonEvolution.to_pokemon = relation(Pokemon,
874 primaryjoin=PokemonEvolution.to_pokemon_id==Pokemon.id,
875 backref=backref('parent_evolution', uselist=False),
876 )
877 PokemonEvolution.child_evolutions = relation(PokemonEvolution,
878 primaryjoin=PokemonEvolution.from_pokemon_id==PokemonEvolution.to_pokemon_id,
879 foreign_keys=[PokemonEvolution.to_pokemon_id],
880 backref=backref('parent_evolution',
881 remote_side=[PokemonEvolution.from_pokemon_id],
882 uselist=False,
883 ),
884 )
885 PokemonEvolution.trigger = relation(EvolutionTrigger, backref='evolutions')
886 PokemonEvolution.trigger_item = relation(Item,
887 primaryjoin=PokemonEvolution.trigger_item_id==Item.id,
888 backref='triggered_evolutions',
889 )
890 PokemonEvolution.held_item = relation(Item,
891 primaryjoin=PokemonEvolution.held_item_id==Item.id,
892 backref='required_for_evolutions',
893 )
894 PokemonEvolution.location = relation(Location, backref='triggered_evolutions')
895 PokemonEvolution.known_move = relation(Move, backref='triggered_evolutions')
896 PokemonEvolution.party_pokemon = relation(Pokemon,
897 primaryjoin=PokemonEvolution.party_pokemon_id==Pokemon.id,
898 backref='triggered_evolutions',
899 )
900
901 PokemonFlavorText.version = relation(Version)
902
903 PokemonItem.item = relation(Item, backref='pokemon')
904 PokemonItem.version = relation(Version)
905
906 PokemonFormGroup.pokemon = relation(Pokemon, backref=backref('form_group',
907 uselist=False))
908 PokemonFormSprite.pokemon = relation(Pokemon, backref='form_sprites')
909 PokemonFormSprite.introduced_in = relation(VersionGroup)
910
911 PokemonMove.pokemon = relation(Pokemon, backref='pokemon_moves')
912 PokemonMove.version_group = relation(VersionGroup)
913 PokemonMove.machine = relation(Machine, backref='pokemon_moves',
914 primaryjoin=and_(Machine.version_group_id==PokemonMove.version_group_id,
915 Machine.move_id==PokemonMove.move_id),
916 foreign_keys=[Machine.version_group_id, Machine.move_id],
917 uselist=False)
918 PokemonMove.move = relation(Move, backref='pokemon_moves')
919 PokemonMove.method = relation(PokemonMoveMethod)
920
921 PokemonName.language = relation(Language)
922
923 PokemonStat.stat = relation(Stat)
924
925 # This is technically a has-many; Generation.main_region_id -> Region.id
926 Region.generation = relation(Generation, uselist=False)
927 Region.version_group_regions = relation(VersionGroupRegion, backref='region',
928 order_by='VersionGroupRegion.version_group_id')
929 Region.version_groups = association_proxy('version_group_regions', 'version_group')
930
931 Stat.damage_class = relation(MoveDamageClass, backref='stats')
932
933 SuperContestCombo.first = relation(Move, primaryjoin=SuperContestCombo.first_move_id==Move.id,
934 backref='super_contest_combo_first')
935 SuperContestCombo.second = relation(Move, primaryjoin=SuperContestCombo.second_move_id==Move.id,
936 backref='super_contest_combo_second')
937
938 Type.damage_efficacies = relation(TypeEfficacy,
939 primaryjoin=Type.id
940 ==TypeEfficacy.damage_type_id,
941 backref='damage_type')
942 Type.target_efficacies = relation(TypeEfficacy,
943 primaryjoin=Type.id
944 ==TypeEfficacy.target_type_id,
945 backref='target_type')
946
947 Type.generation = relation(Generation, backref='types')
948 Type.damage_class = relation(MoveDamageClass, backref='types')
949
950 Version.version_group = relation(VersionGroup, backref='versions')
951 Version.generation = association_proxy('version_group', 'generation')
952
953 VersionGroup.generation = relation(Generation, backref='version_groups')
954 VersionGroup.version_group_regions = relation(VersionGroupRegion, backref='version_group')
955 VersionGroup.regions = association_proxy('version_group_regions', 'region')