pokedex/db/tables.py

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