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