Added terrain icons for Rock Smash and unknown.
[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 main_region_id = Column(Integer, ForeignKey('regions.id'))
148 name = 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 region_id = Column(Integer, ForeignKey('regions.id'))
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 Region(TableBase):
416 """Major areas of the world: Kanto, Johto, etc."""
417 __tablename__ = 'regions'
418 id = Column(Integer, primary_key=True, nullable=False)
419 name = Column(Unicode(16), nullable=False)
420
421 class Stat(TableBase):
422 __tablename__ = 'stats'
423 id = Column(Integer, primary_key=True, nullable=False)
424 name = Column(Unicode(16), nullable=False)
425
426 class SuperContestCombo(TableBase):
427 __tablename__ = 'super_contest_combos'
428 first_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
429 second_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
430
431 class SuperContestEffect(TableBase):
432 __tablename__ = 'super_contest_effects'
433 id = Column(Integer, primary_key=True, nullable=False)
434 appeal = Column(SmallInteger, nullable=False)
435 flavor_text = Column(Unicode(64), nullable=False)
436
437 class TypeEfficacy(TableBase):
438 __tablename__ = 'type_efficacy'
439 damage_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
440 target_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
441 damage_factor = Column(Integer, nullable=False)
442
443 class Type(TableBase):
444 __tablename__ = 'types'
445 __singlename__ = 'type'
446 id = Column(Integer, primary_key=True, nullable=False)
447 name = Column(Unicode(8), nullable=False)
448 abbreviation = Column(Unicode(3), nullable=False)
449 generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
450 damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=False) ## ??? is none; everything else is physical or special
451
452 class VersionGroup(TableBase):
453 __tablename__ = 'version_groups'
454 id = Column(Integer, primary_key=True, nullable=False)
455 generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
456
457 class VersionGroupRegion(TableBase):
458 __tablename__ = 'version_group_regions'
459 version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False)
460 region_id = Column(Integer, ForeignKey('regions.id'), primary_key=True, nullable=False)
461
462 class Version(TableBase):
463 __tablename__ = 'versions'
464 id = Column(Integer, primary_key=True, nullable=False)
465 version_group_id = Column(Integer, ForeignKey('version_groups.id'), nullable=False)
466 name = Column(Unicode(32), nullable=False)
467
468
469 ### Relations down here, to avoid ordering problems
470 ContestCombo.first = relation(Move, primaryjoin=ContestCombo.first_move_id==Move.id,
471 backref='contest_combo_first')
472 ContestCombo.second = relation(Move, primaryjoin=ContestCombo.second_move_id==Move.id,
473 backref='contest_combo_second')
474
475 Encounter.location_area = relation(LocationArea, backref='encounters')
476 Encounter.pokemon = relation(Pokemon, backref='encounters')
477 Encounter.version = relation(Version, backref='encounters')
478 Encounter.slot = relation(EncounterSlot, backref='encounters')
479
480 EncounterConditionValue.condition = relation(EncounterCondition, backref='values')
481
482 Encounter.condition_value_map = relation(EncounterConditionValueMap, backref='encounter')
483 Encounter.condition_values = association_proxy('condition_value_map', 'condition_value')
484 EncounterConditionValueMap.condition_value = relation(EncounterConditionValue,
485 backref='encounter_map')
486
487 EncounterSlot.terrain = relation(EncounterTerrain, backref='slots')
488
489 EncounterSlot.condition_map = relation(EncounterSlotCondition, backref='slot')
490 EncounterSlot.conditions = association_proxy('condition_map', 'condition')
491 EncounterSlotCondition.condition = relation(EncounterCondition,
492 backref='slot_map')
493
494 EvolutionChain.growth_rate = relation(GrowthRate, backref='evolution_chains')
495
496 Generation.versions = relation(Version, secondary=VersionGroup.__table__)
497 Generation.main_region = relation(Region)
498
499 Location.region = relation(Region, backref='locations')
500
501 LocationArea.location = relation(Location, backref='areas')
502
503 Machine.version_group = relation(VersionGroup)
504
505 Move.contest_effect = relation(ContestEffect, backref='moves')
506 Move.contest_combo_next = association_proxy('contest_combo_first', 'second')
507 Move.contest_combo_prev = association_proxy('contest_combo_second', 'first')
508 Move.damage_class = relation(MoveDamageClass, backref='moves')
509 Move.flags = association_proxy('move_flags', 'flag')
510 Move.flavor_text = relation(MoveFlavorText, order_by=MoveFlavorText.generation_id, backref='move')
511 Move.foreign_names = relation(MoveName, backref='pokemon')
512 Move.generation = relation(Generation, backref='moves')
513 Move.machines = relation(Machine, backref='move')
514 Move.move_effect = relation(MoveEffect, backref='moves')
515 Move.move_flags = relation(MoveFlag, backref='move')
516 Move.super_contest_effect = relation(SuperContestEffect, backref='moves')
517 Move.super_contest_combo_next = association_proxy('super_contest_combo_first', 'second')
518 Move.super_contest_combo_prev = association_proxy('super_contest_combo_second', 'first')
519 Move.target = relation(MoveTarget, backref='moves')
520 Move.type = relation(Type, backref='moves')
521
522 Move.effect = rst.MoveEffectProperty('effect')
523 Move.priority = association_proxy('move_effect', 'priority')
524 Move.short_effect = rst.MoveEffectProperty('short_effect')
525
526 MoveEffect.category_map = relation(MoveEffectCategoryMap)
527 MoveEffect.categories = association_proxy('category_map', 'category')
528 MoveEffectCategoryMap.category = relation(MoveEffectCategory)
529
530 MoveFlag.flag = relation(MoveFlagType)
531
532 MoveFlavorText.generation = relation(Generation)
533
534 MoveName.language = relation(Language)
535
536 Pokemon.abilities = relation(Ability, secondary=PokemonAbility.__table__,
537 order_by=PokemonAbility.slot,
538 backref='pokemon')
539 Pokemon.formes = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.forme_base_pokemon_id,
540 backref=backref('forme_base_pokemon',
541 remote_side=[Pokemon.id]))
542 Pokemon.dex_numbers = relation(PokemonDexNumber, backref='pokemon')
543 Pokemon.egg_groups = relation(EggGroup, secondary=PokemonEggGroup.__table__,
544 order_by=PokemonEggGroup.egg_group_id,
545 backref='pokemon')
546 Pokemon.evolution_chain = relation(EvolutionChain, backref='pokemon')
547 Pokemon.evolution_method = relation(EvolutionMethod)
548 Pokemon.evolution_children = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.evolution_parent_pokemon_id,
549 backref=backref('evolution_parent',
550 remote_side=[Pokemon.id]))
551 Pokemon.flavor_text = relation(PokemonFlavorText, order_by=PokemonFlavorText.pokemon_id, backref='pokemon')
552 Pokemon.foreign_names = relation(PokemonName, backref='pokemon')
553 Pokemon.items = relation(PokemonItem)
554 Pokemon.generation = relation(Generation, backref='pokemon')
555 Pokemon.shape = relation(PokemonShape, backref='pokemon')
556 Pokemon.stats = relation(PokemonStat, backref='pokemon')
557 Pokemon.types = relation(Type, secondary=PokemonType.__table__)
558
559 PokemonDexNumber.generation = relation(Generation)
560
561 PokemonFlavorText.version = relation(Version)
562
563 PokemonItem.item = relation(Item, backref='pokemon')
564 PokemonItem.version = relation(Version)
565
566 PokemonFormGroup.pokemon = relation(Pokemon, backref=backref('form_group',
567 uselist=False))
568 PokemonFormSprite.pokemon = relation(Pokemon, backref='form_sprites')
569 PokemonFormSprite.introduced_in = relation(VersionGroup)
570
571 PokemonMove.pokemon = relation(Pokemon, backref='pokemon_moves')
572 PokemonMove.version_group = relation(VersionGroup)
573 PokemonMove.machine = relation(Machine, backref='pokemon_moves',
574 primaryjoin=and_(Machine.version_group_id==PokemonMove.version_group_id,
575 Machine.move_id==PokemonMove.move_id),
576 foreign_keys=[Machine.version_group_id, Machine.move_id],
577 uselist=False)
578 PokemonMove.move = relation(Move, backref='pokemon_moves')
579 PokemonMove.method = relation(PokemonMoveMethod)
580
581 PokemonName.language = relation(Language)
582
583 PokemonStat.stat = relation(Stat)
584
585 # This is technically a has-many; Generation.main_region_id -> Region.id
586 Region.generation = relation(Generation, uselist=False)
587 Region.version_group_regions = relation(VersionGroupRegion, backref='region',
588 order_by='VersionGroupRegion.version_group_id')
589 Region.version_groups = association_proxy('version_group_regions', 'version_group')
590
591 SuperContestCombo.first = relation(Move, primaryjoin=SuperContestCombo.first_move_id==Move.id,
592 backref='super_contest_combo_first')
593 SuperContestCombo.second = relation(Move, primaryjoin=SuperContestCombo.second_move_id==Move.id,
594 backref='super_contest_combo_second')
595
596 Type.damage_efficacies = relation(TypeEfficacy,
597 primaryjoin=Type.id
598 ==TypeEfficacy.damage_type_id,
599 backref='damage_type')
600 Type.target_efficacies = relation(TypeEfficacy,
601 primaryjoin=Type.id
602 ==TypeEfficacy.target_type_id,
603 backref='target_type')
604
605 Type.generation = relation(Generation, backref='types')
606 Type.damage_class = relation(MoveDamageClass, backref='types')
607
608 Version.version_group = relation(VersionGroup, backref='versions')
609 Version.generation = association_proxy('version_group', 'generation')
610
611 VersionGroup.generation = relation(Generation, backref='version_groups')
612 VersionGroup.version_group_regions = relation(VersionGroupRegion, backref='version_group')
613 VersionGroup.regions = association_proxy('version_group_regions', 'region')