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