5 Columns have a info dictionary with these keys:
6 - description: The description of the column
7 - official: True if the values appear in games or official material; False if
8 they are fan-created or fan-written. This flag is currently only set for
10 - markup: The format of a text column. Can be one of:
11 - plaintext: Normal Unicode text (widely used in names)
12 - markdown: Veekun's Markdown flavor (generally used in effect descriptions)
13 - gametext: Transcription of in-game text that strives to be both
14 human-readable and represent the original text exactly.
15 - identifier: A fan-made identifier in the [-_a-z0-9]* format. Not intended
17 - latex: A formula in LaTeX syntax.
18 - ripped: True for text that has been ripped from the games, and can be ripped
19 again for new versions or languages
21 See `pokedex.db.multilang` for how localizable text columns work. The session
22 classes in that module can be used to change the default language.
24 # XXX: Check if "gametext" is set correctly everywhere
27 from functools
import partial
29 from sqlalchemy
import Column
, ForeignKey
, MetaData
, PrimaryKeyConstraint
, Table
, UniqueConstraint
30 from sqlalchemy
.ext
.declarative
import declarative_base
, DeclarativeMeta
31 from sqlalchemy
.ext
.associationproxy
import association_proxy
32 from sqlalchemy
.orm
import backref
, relation
33 from sqlalchemy
.orm
.session
import Session
34 from sqlalchemy
.orm
.interfaces
import AttributeExtension
35 from sqlalchemy
.sql
import and_
36 from sqlalchemy
.schema
import ColumnDefault
37 from sqlalchemy
.types
import *
39 from pokedex
.db
import markdown
, multilang
41 class TableSuperclass(object):
42 """Superclass for declarative tables, to give them some generic niceties
45 def __unicode__(self
):
46 """Be as useful as possible. Show the primary key, and an identifier
49 typename
= u
'.'.join((__name__
, type(self
).__name__
))
51 pk_constraint
= self
.__table__
.primary_key
53 return u
"<%s object at %x>" %
(typename
, id(self
))
55 pk
= u
', '.join(unicode(getattr(self
, column
.name
))
56 for column
in pk_constraint
.columns
)
58 return u
"<%s object (%s): %s>" %
(typename
, pk
, self
.identifier
)
59 except AttributeError:
60 return u
"<%s object (%s)>" %
(typename
, pk
)
63 return unicode(self
).encode('utf8')
66 return unicode(self
).encode('utf8')
69 class TableMetaclass(DeclarativeMeta
):
70 def __init__(cls
, name
, bases
, attrs
):
71 super(TableMetaclass
, cls
).__init__(name
, bases
, attrs
)
72 if hasattr(cls
, '__tablename__'):
73 mapped_classes
.append(cls
)
74 cls
.translation_classes
= []
77 TableBase
= declarative_base(metadata
=metadata
, cls
=TableSuperclass
, metaclass
=TableMetaclass
)
80 ### Need Language first, to create the partial() below
82 class Language(TableBase
):
83 u
"""A language the Pokémon games have been translated into
85 __tablename__
= 'languages'
86 __singlename__
= 'language'
87 id = Column(Integer
, primary_key
=True, nullable
=False,
88 info
=dict(description
="A numeric ID"))
89 iso639
= Column(Unicode(2), nullable
=False,
90 info
=dict(description
="The two-letter code of the country where this language is spoken. Note that it is not unique.", format
='identifier'))
91 iso3166
= Column(Unicode(2), nullable
=False,
92 info
=dict(description
="The two-letter code of the language. Note that it is not unique.", format
='identifier'))
93 identifier
= Column(Unicode(16), nullable
=False,
94 info
=dict(description
="An identifier", format
='identifier'))
95 official
= Column(Boolean
, nullable
=False, index
=True,
96 info
=dict(description
=u
"True iff games are produced in the language."))
97 order
= Column(Integer
, nullable
=True,
98 info
=dict(description
=u
"Order for sorting in foreign name lists."))
100 create_translation_table
= partial(multilang
.create_translation_table
, language_class
=Language
)
102 create_translation_table('language_names', Language
, 'names',
103 name
= Column(Unicode(16), nullable
=False, index
=True,
104 info
=dict(description
="The name", format
='plaintext', official
=True)),
107 ### The actual tables
109 class Ability(TableBase
):
110 u
"""An ability a Pokémon can have, such as Static or Pressure.
112 __tablename__
= 'abilities'
113 __singlename__
= 'ability'
114 id = Column(Integer
, primary_key
=True, nullable
=False,
115 info
=dict(description
="This ability's unique ID; matches the games' internal ID"))
116 identifier
= Column(Unicode(24), nullable
=False,
117 info
=dict(description
="An identifier", format
='identifier'))
118 generation_id
= Column(Integer
, ForeignKey('generations.id'), nullable
=False,
119 info
=dict(description
="The ID of the generation this ability was introduced in", detail
=True))
121 create_translation_table('ability_names', Ability
, 'names',
122 relation_lazy
='joined',
123 name
= Column(Unicode(24), nullable
=False, index
=True,
124 info
=dict(description
="The name", format
='plaintext', official
=True, ripped
=True)),
126 create_translation_table('ability_prose', Ability
, 'prose',
127 effect
= Column(markdown
.MarkdownColumn(5120), nullable
=True,
128 info
=dict(description
="A detailed description of this ability's effect", format
='markdown')),
129 short_effect
= Column(markdown
.MarkdownColumn(512), nullable
=True,
130 info
=dict(description
="A short summary of this ability's effect", format
='markdown')),
133 class AbilityChangelog(TableBase
):
134 """History of changes to abilities across main game versions."""
135 __tablename__
= 'ability_changelog'
136 __singlename__
= 'ability_changelog'
137 id = Column(Integer
, primary_key
=True, nullable
=False,
138 info
=dict(description
="This change's unique ID"))
139 ability_id
= Column(Integer
, ForeignKey('abilities.id'), nullable
=False,
140 info
=dict(description
="The ID of the ability that changed"))
141 changed_in_version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), nullable
=False,
142 info
=dict(description
="The ID of the version group in which the ability changed"))
144 create_translation_table('ability_changelog_prose', AbilityChangelog
, 'prose',
145 effect
= Column(markdown
.MarkdownColumn(255), nullable
=False,
146 info
=dict(description
="A description of the old behavior", format
='markdown'))
149 class AbilityFlavorText(TableBase
):
150 u
"""In-game flavor text of an ability
152 __tablename__
= 'ability_flavor_text'
153 ability_id
= Column(Integer
, ForeignKey('abilities.id'), primary_key
=True, nullable
=False, autoincrement
=False,
154 info
=dict(description
="The ID of the ability"))
155 version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), primary_key
=True, nullable
=False, autoincrement
=False,
156 info
=dict(description
="The ID of the version group this flavor text is taken from"))
157 language_id
= Column(Integer
, ForeignKey('languages.id'), primary_key
=True, nullable
=False,
158 info
=dict(description
="The language"))
159 flavor_text
= Column(Unicode(64), nullable
=False,
160 info
=dict(description
="The actual flavor text", official
=True, format
='gametext'))
162 class Berry(TableBase
):
163 u
"""A Berry, consumable item that grows on trees
165 For data common to all items, such as the name, see the corresponding item entry.
167 __tablename__
= 'berries'
168 id = Column(Integer
, primary_key
=True, nullable
=False,
169 info
=dict(description
="This Berry's in-game number"))
170 item_id
= Column(Integer
, ForeignKey('items.id'), nullable
=False,
171 info
=dict(description
="The ID of the item that represents this Berry"))
172 firmness_id
= Column(Integer
, ForeignKey('berry_firmness.id'), nullable
=False,
173 info
=dict(description
="The ID of this Berry's firmness category"))
174 natural_gift_power
= Column(Integer
, nullable
=True,
175 info
=dict(description
="Natural Gift's power when used with this Berry"))
176 natural_gift_type_id
= Column(Integer
, ForeignKey('types.id'), nullable
=True,
177 info
=dict(description
="The ID of the Type that Natural Gift has when used with this Berry"))
178 size
= Column(Integer
, nullable
=False,
179 info
=dict(description
=u
"The size of this Berry, in millimeters"))
180 max_harvest
= Column(Integer
, nullable
=False,
181 info
=dict(description
="The maximum number of these berries that can grow on one tree in Generation IV"))
182 growth_time
= Column(Integer
, nullable
=False,
183 info
=dict(description
="Time it takes the tree to grow one stage, in hours. Berry trees go through four of these growth stages before they can be picked."))
184 soil_dryness
= Column(Integer
, nullable
=False,
185 info
=dict(description
="The speed at which this Berry dries out the soil as it grows. A higher rate means the soil dries more quickly."))
186 smoothness
= Column(Integer
, nullable
=False,
187 info
=dict(description
="The smoothness of this Berry, used in making Pokéblocks or Poffins"))
189 class BerryFirmness(TableBase
):
190 u
"""A Berry firmness, such as "hard" or "very soft".
192 __tablename__
= 'berry_firmness'
193 __singlename__
= 'berry_firmness'
194 id = Column(Integer
, primary_key
=True, nullable
=False,
195 info
=dict(description
="A unique ID for this firmness"))
196 identifier
= Column(Unicode(10), nullable
=False,
197 info
=dict(description
="An identifier", format
='identifier'))
199 create_translation_table('berry_firmness_names', BerryFirmness
, 'names',
200 relation_lazy
='joined',
201 name
= Column(Unicode(10), nullable
=False, index
=True,
202 info
=dict(description
="The name", format
='plaintext', official
=True)),
205 class BerryFlavor(TableBase
):
206 u
"""A Berry flavor level.
208 __tablename__
= 'berry_flavors'
209 berry_id
= Column(Integer
, ForeignKey('berries.id'), primary_key
=True, nullable
=False, autoincrement
=False,
210 info
=dict(description
="The ID of the berry"))
211 contest_type_id
= Column(Integer
, ForeignKey('contest_types.id'), primary_key
=True, nullable
=False, autoincrement
=False,
212 info
=dict(description
="The ID of the flavor"))
213 flavor
= Column(Integer
, nullable
=False,
214 info
=dict(description
="The level of the flavor in the berry"))
216 class ContestCombo(TableBase
):
217 u
"""Combo of two moves in a Contest.
219 __tablename__
= 'contest_combos'
220 first_move_id
= Column(Integer
, ForeignKey('moves.id'), primary_key
=True, nullable
=False, autoincrement
=False,
221 info
=dict(description
="The ID of the first move in the combo"))
222 second_move_id
= Column(Integer
, ForeignKey('moves.id'), primary_key
=True, nullable
=False, autoincrement
=False,
223 info
=dict(description
="The ID of the second and final move in the combo"))
225 class ContestEffect(TableBase
):
226 u
"""Effect of a move when used in a Contest.
228 __tablename__
= 'contest_effects'
229 __singlename__
= 'contest_effect'
230 id = Column(Integer
, primary_key
=True, nullable
=False,
231 info
=dict(description
="A unique ID for this effect"))
232 appeal
= Column(SmallInteger
, nullable
=False,
233 info
=dict(description
="The base number of hearts the user of this move gets"))
234 jam
= Column(SmallInteger
, nullable
=False,
235 info
=dict(description
="The base number of hearts the user's opponent loses"))
237 create_translation_table('contest_effect_prose', ContestEffect
, 'prose',
238 flavor_text
= Column(Unicode(64), nullable
=True,
239 info
=dict(description
="The in-game description of this effect", official
=True, format
='gametext')),
240 effect
= Column(Unicode(255), nullable
=True,
241 info
=dict(description
="A detailed description of the effect", format
='plaintext')),
244 class ContestType(TableBase
):
245 u
"""A Contest type, such as "cool" or "smart", and their associated Berry flavors and Pokéblock colors.
247 __tablename__
= 'contest_types'
248 __singlename__
= 'contest_type'
249 id = Column(Integer
, primary_key
=True, nullable
=False,
250 info
=dict(description
="A unique ID for this Contest type"))
251 identifier
= Column(Unicode(6), nullable
=False,
252 info
=dict(description
="An identifier", format
='identifier'))
254 create_translation_table('contest_type_names', ContestType
, 'names',
255 relation_lazy
='joined',
256 name
= Column(Unicode(6), nullable
=True, index
=True,
257 info
=dict(description
="The name", format
='plaintext', official
=True)),
258 flavor
= Column(Unicode(6), nullable
=True,
259 info
=dict(description
="The name of the corresponding Berry flavor", official
=True, format
='plaintext')),
260 color
= Column(Unicode(6), nullable
=True,
261 info
=dict(description
=u
"The name of the corresponding Pokéblock color", official
=True, format
='plaintext')),
264 class EggGroup(TableBase
):
265 u
"""An Egg group. Usually, two Pokémon can breed if they share an Egg Group.
267 (exceptions are the Ditto and No Eggs groups)
269 __tablename__
= 'egg_groups'
270 __singlename__
= 'egg_group'
271 id = Column(Integer
, primary_key
=True, nullable
=False,
272 info
=dict(description
="A unique ID for this group"))
273 identifier
= Column(Unicode(16), nullable
=False,
274 info
=dict(description
=u
"An identifier.", format
='identifier'))
276 create_translation_table('egg_group_prose', EggGroup
, 'names',
277 relation_lazy
='joined',
278 name
= Column(Unicode(16), nullable
=False, index
=True,
279 info
=dict(description
="The name", format
='plaintext', official
=True)),
282 class Encounter(TableBase
):
283 u
"""Encounters with wild Pokémon.
287 Within a given area in a given game, encounters are differentiated by the
288 "slot" they are in and the state of the game world.
290 What the player is doing to get an encounter, such as surfing or walking
291 through tall grass, is called a method. Each method has its own set of
294 Within a method, slots are defined primarily by rarity. Each slot can
295 also be affected by world conditions; for example, the 20% slot for walking
296 in tall grass is affected by whether a swarm is in effect in that area.
297 "Is there a swarm?" is a condition; "there is a swarm" and "there is not a
298 swarm" are the possible values of this condition.
300 A slot (20% walking in grass) and any appropriate world conditions (no
301 swarm) are thus enough to define a specific encounter.
303 Well, okay, almost: each slot actually appears twice.
306 __tablename__
= 'encounters'
307 id = Column(Integer
, primary_key
=True, nullable
=False,
308 info
=dict(description
="A unique ID for this encounter"))
309 version_id
= Column(Integer
, ForeignKey('versions.id'), nullable
=False, autoincrement
=False,
310 info
=dict(description
="The ID of the version this applies to"))
311 location_area_id
= Column(Integer
, ForeignKey('location_areas.id'), nullable
=False, autoincrement
=False,
312 info
=dict(description
="The ID of the location of this encounter"))
313 encounter_slot_id
= Column(Integer
, ForeignKey('encounter_slots.id'), nullable
=False, autoincrement
=False,
314 info
=dict(description
="The ID of the encounter slot, which determines method and rarity"))
315 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), nullable
=False, autoincrement
=False,
316 info
=dict(description
=u
"The ID of the encountered Pokémon"))
317 min_level
= Column(Integer
, nullable
=False, autoincrement
=False,
318 info
=dict(description
=u
"The minimum level of the encountered Pokémon"))
319 max_level
= Column(Integer
, nullable
=False, autoincrement
=False,
320 info
=dict(description
=u
"The maxmum level of the encountered Pokémon"))
322 class EncounterCondition(TableBase
):
323 u
"""A conditions in the game world that affects Pokémon encounters, such as time of day.
326 __tablename__
= 'encounter_conditions'
327 __singlename__
= 'encounter_condition'
328 id = Column(Integer
, primary_key
=True, nullable
=False,
329 info
=dict(description
="A unique ID for this condition"))
330 identifier
= Column(Unicode(64), nullable
=False,
331 info
=dict(description
="An identifier", format
='identifier'))
333 create_translation_table('encounter_condition_prose', EncounterCondition
, 'prose',
334 name
= Column(Unicode(64), nullable
=False, index
=True,
335 info
=dict(description
="The name", format
='plaintext', official
=False)),
338 class EncounterConditionValue(TableBase
):
339 u
"""A possible state for a condition; for example, the state of 'swarm' could be 'swarm' or 'no swarm'.
342 __tablename__
= 'encounter_condition_values'
343 __singlename__
= 'encounter_condition_value'
344 id = Column(Integer
, primary_key
=True, nullable
=False,
345 info
=dict(description
="A numeric ID"))
346 encounter_condition_id
= Column(Integer
, ForeignKey('encounter_conditions.id'), primary_key
=False, nullable
=False, autoincrement
=False,
347 info
=dict(description
="The ID of the encounter condition this is a value of"))
348 identifier
= Column(Unicode(64), nullable
=False,
349 info
=dict(description
="An identifier", format
='identifier'))
350 is_default
= Column(Boolean
, nullable
=False,
351 info
=dict(description
='Set if this value is the default state for the condition'))
353 create_translation_table('encounter_condition_value_prose', EncounterConditionValue
, 'prose',
354 name
= Column(Unicode(64), nullable
=False, index
=True,
355 info
=dict(description
="The name", format
='plaintext', official
=False)),
358 class EncounterConditionValueMap(TableBase
):
359 u
"""Maps encounters to the specific conditions under which they occur.
361 __tablename__
= 'encounter_condition_value_map'
362 encounter_id
= Column(Integer
, ForeignKey('encounters.id'), primary_key
=True, nullable
=False, autoincrement
=False,
363 info
=dict(description
="The ID of the encounter"))
364 encounter_condition_value_id
= Column(Integer
, ForeignKey('encounter_condition_values.id'), primary_key
=True, nullable
=False, autoincrement
=False,
365 info
=dict(description
="The ID of the encounter condition value"))
367 class EncounterMethod(TableBase
):
368 u
"""A way the player can enter a wild encounter, e.g., surfing, fishing, or walking through tall grass.
371 __tablename__
= 'encounter_methods'
372 __singlename__
= 'encounter_method'
373 id = Column(Integer
, primary_key
=True, nullable
=False,
374 info
=dict(description
="A unique ID for the method"))
375 identifier
= Column(Unicode(16), nullable
=False, unique
=True,
376 info
=dict(description
="An identifier", format
='identifier'))
378 create_translation_table('encounter_method_prose', EncounterMethod
, 'prose',
379 name
= Column(Unicode(64), nullable
=False, index
=True,
380 info
=dict(description
="The name", format
='plaintext', official
=False)),
383 class EncounterSlot(TableBase
):
384 u
"""An abstract "slot" within a method, associated with both some set of conditions and a rarity.
386 Note that there are two encounters per slot, so the rarities will only add
390 __tablename__
= 'encounter_slots'
391 id = Column(Integer
, primary_key
=True, nullable
=False,
392 info
=dict(description
="A unique ID for this slot"))
393 version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), nullable
=False, autoincrement
=False,
394 info
=dict(description
="The ID of the version group this slot is in"))
395 encounter_method_id
= Column(Integer
, ForeignKey('encounter_methods.id'), primary_key
=False, nullable
=False, autoincrement
=False,
396 info
=dict(description
="The ID of the method"))
397 slot
= Column(Integer
, nullable
=True,
398 info
=dict(description
="This slot's order for the location and method"))
399 rarity
= Column(Integer
, nullable
=True,
400 info
=dict(description
="The chance of the encounter as a percentage"))
402 class EvolutionChain(TableBase
):
403 u
"""A family of Pokémon that are linked by evolution
405 __tablename__
= 'evolution_chains'
406 id = Column(Integer
, primary_key
=True, nullable
=False,
407 info
=dict(description
="A numeric ID"))
408 growth_rate_id
= Column(Integer
, ForeignKey('growth_rates.id'), nullable
=False,
409 info
=dict(description
="ID of the growth rate for this family"))
410 baby_trigger_item_id
= Column(Integer
, ForeignKey('items.id'), nullable
=True,
411 info
=dict(description
="Item that a parent must hold while breeding to produce a baby"))
413 class EvolutionTrigger(TableBase
):
414 u
"""An evolution type, such as "level" or "trade".
416 __tablename__
= 'evolution_triggers'
417 __singlename__
= 'evolution_trigger'
418 id = Column(Integer
, primary_key
=True, nullable
=False,
419 info
=dict(description
="A numeric ID"))
420 identifier
= Column(Unicode(16), nullable
=False,
421 info
=dict(description
="An identifier", format
='identifier'))
423 create_translation_table('evolution_trigger_prose', EvolutionTrigger
, 'prose',
424 name
= Column(Unicode(16), nullable
=False, index
=True,
425 info
=dict(description
="The name", format
='plaintext', official
=False)),
428 class Experience(TableBase
):
429 u
"""EXP needed for a certain level with a certain growth rate
431 __tablename__
= 'experience'
432 growth_rate_id
= Column(Integer
, ForeignKey('growth_rates.id'), primary_key
=True, nullable
=False,
433 info
=dict(description
="ID of the growth rate"))
434 level
= Column(Integer
, primary_key
=True, nullable
=False, autoincrement
=False,
435 info
=dict(description
="The level"))
436 experience
= Column(Integer
, nullable
=False,
437 info
=dict(description
="The number of EXP points needed to get to that level"))
439 class Generation(TableBase
):
440 u
"""A Generation of the Pokémon franchise
442 __tablename__
= 'generations'
443 __singlename__
= 'generation'
444 id = Column(Integer
, primary_key
=True, nullable
=False,
445 info
=dict(description
="A numeric ID"))
446 main_region_id
= Column(Integer
, ForeignKey('regions.id'), nullable
=False,
447 info
=dict(description
="ID of the region this generation's main games take place in"))
448 canonical_pokedex_id
= Column(Integer
, ForeignKey('pokedexes.id'), nullable
=False,
449 info
=dict(description
=u
"ID of the Pokédex this generation's main games use by default"))
450 identifier
= Column(Unicode(16), nullable
=False,
451 info
=dict(description
=u
'An identifier', format
='identifier'))
453 create_translation_table('generation_names', Generation
, 'names',
454 relation_lazy
='joined',
455 name
= Column(Unicode(16), nullable
=False, index
=True,
456 info
=dict(description
="The name", format
='plaintext', official
=True)),
459 class GrowthRate(TableBase
):
460 u
"""Growth rate of a Pokémon, i.e. the EXP → level function.
462 __tablename__
= 'growth_rates'
463 __singlename__
= 'growth_rate'
464 id = Column(Integer
, primary_key
=True, nullable
=False,
465 info
=dict(description
="A numeric ID"))
466 identifier
= Column(Unicode(20), nullable
=False,
467 info
=dict(description
="An identifier", format
='identifier'))
468 formula
= Column(Unicode(500), nullable
=False,
469 info
=dict(description
="The formula", format
='latex'))
471 create_translation_table('growth_rate_prose', GrowthRate
, 'prose',
472 name
= Column(Unicode(20), nullable
=False, index
=True,
473 info
=dict(description
="The name", format
='plaintext', official
=False)),
476 class Item(TableBase
):
477 u
"""An Item from the games, like "Poké Ball" or "Bicycle".
479 __tablename__
= 'items'
480 __singlename__
= 'item'
481 id = Column(Integer
, primary_key
=True, nullable
=False,
482 info
=dict(description
="A numeric ID"))
483 identifier
= Column(Unicode(20), nullable
=False,
484 info
=dict(description
="An identifier", format
='identifier'))
485 category_id
= Column(Integer
, ForeignKey('item_categories.id'), nullable
=False,
486 info
=dict(description
="ID of a category this item belongs to"))
487 cost
= Column(Integer
, nullable
=False,
488 info
=dict(description
=u
"Cost of the item when bought. Items sell for half this price."))
489 fling_power
= Column(Integer
, nullable
=True,
490 info
=dict(description
=u
"Power of the move Fling when used with this item."))
491 fling_effect_id
= Column(Integer
, ForeignKey('item_fling_effects.id'), nullable
=True,
492 info
=dict(description
=u
"ID of the fling-effect of the move Fling when used with this item. Note that these are different from move effects."))
495 def appears_underground(self
):
496 u
"""True if the item appears underground, as specified by the appropriate flag
498 return any(flag
.identifier
== u
'underground' for flag
in self
.flags
)
500 create_translation_table('item_names', Item
, 'names',
501 relation_lazy
='joined',
502 name
= Column(Unicode(20), nullable
=False, index
=True,
503 info
=dict(description
="The name", format
='plaintext', official
=True, ripped
=True)),
505 create_translation_table('item_prose', Item
, 'prose',
506 short_effect
= Column(markdown
.MarkdownColumn(256), nullable
=True,
507 info
=dict(description
="A short summary of the effect", format
='markdown')),
508 effect
= Column(markdown
.MarkdownColumn(5120), nullable
=True,
509 info
=dict(description
=u
"Detailed description of the item's effect.", format
='markdown')),
511 create_translation_table('item_flavor_summaries', Item
, 'flavor_summaries',
512 flavor_summary
= Column(Unicode(512), nullable
=True,
513 info
=dict(description
=u
"Text containing facts from all flavor texts, for languages without official game translations", official
=False, format
='plaintext', ripped
=True)),
516 class ItemCategory(TableBase
):
519 # XXX: This is fanon, right?
520 __tablename__
= 'item_categories'
521 __singlename__
= 'item_category'
522 id = Column(Integer
, primary_key
=True, nullable
=False,
523 info
=dict(description
="A numeric ID"))
524 pocket_id
= Column(Integer
, ForeignKey('item_pockets.id'), nullable
=False,
525 info
=dict(description
="ID of the pocket these items go to"))
526 identifier
= Column(Unicode(16), nullable
=False,
527 info
=dict(description
="An identifier", format
='identifier'))
529 create_translation_table('item_category_prose', ItemCategory
, 'prose',
530 relation_lazy
='joined',
531 name
= Column(Unicode(16), nullable
=False, index
=True,
532 info
=dict(description
="The name", format
='plaintext', official
=False)),
535 class ItemFlag(TableBase
):
536 u
"""An item attribute such as "consumable" or "holdable".
538 __tablename__
= 'item_flags'
539 __singlename__
= 'item_flag'
540 id = Column(Integer
, primary_key
=True, nullable
=False,
541 info
=dict(description
="A numeric ID"))
542 identifier
= Column(Unicode(24), nullable
=False,
543 info
=dict(description
="Identifier of the flag", format
='identifier'))
545 create_translation_table('item_flag_prose', ItemFlag
, 'prose',
546 name
= Column(Unicode(24), nullable
=True, index
=True,
547 info
=dict(description
="The name", format
='plaintext', official
=False)),
548 description
= Column(Unicode(64), nullable
=True,
549 info
=dict(description
="Short description of the flag", format
='plaintext')),
552 class ItemFlagMap(TableBase
):
553 u
"""Maps an item flag to its item.
555 __tablename__
= 'item_flag_map'
556 item_id
= Column(Integer
, ForeignKey('items.id'), primary_key
=True, autoincrement
=False, nullable
=False,
557 info
=dict(description
="The ID of the item"))
558 item_flag_id
= Column(Integer
, ForeignKey('item_flags.id'), primary_key
=True, autoincrement
=False, nullable
=False,
559 info
=dict(description
="The ID of the item flag"))
561 class ItemFlavorText(TableBase
):
562 u
"""An in-game description of an item
564 __tablename__
= 'item_flavor_text'
565 __singlename__
= 'item_flavor_text'
566 summary_column
= Item
.flavor_summaries_table
, 'flavor_summary'
567 item_id
= Column(Integer
, ForeignKey('items.id'), primary_key
=True, autoincrement
=False, nullable
=False,
568 info
=dict(description
="The ID of the item"))
569 version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), primary_key
=True, autoincrement
=False, nullable
=False,
570 info
=dict(description
="ID of the version group that sports this text"))
571 language_id
= Column(Integer
, ForeignKey('languages.id'), primary_key
=True, nullable
=False,
572 info
=dict(description
="The language"))
573 flavor_text
= Column(Unicode(255), nullable
=False,
574 info
=dict(description
="The flavor text itself", official
=True, format
='gametext'))
576 class ItemFlingEffect(TableBase
):
577 u
"""An effect of the move Fling when used with a specific item
579 __tablename__
= 'item_fling_effects'
580 __singlename__
= 'item_fling_effect'
581 id = Column(Integer
, primary_key
=True, nullable
=False,
582 info
=dict(description
="A numeric ID"))
584 create_translation_table('item_fling_effect_prose', ItemFlingEffect
, 'prose',
585 effect
= Column(Unicode(255), nullable
=False,
586 info
=dict(description
="Description of the effect", format
='plaintext')),
589 class ItemGameIndex(TableBase
):
590 u
"""The internal ID number a game uses for an item
592 __tablename__
= 'item_game_indices'
593 item_id
= Column(Integer
, ForeignKey('items.id'), primary_key
=True, autoincrement
=False, nullable
=False,
594 info
=dict(description
="The database ID of the item"))
595 generation_id
= Column(Integer
, ForeignKey('generations.id'), primary_key
=True, autoincrement
=False, nullable
=False,
596 info
=dict(description
="ID of the generation of games"))
597 game_index
= Column(Integer
, nullable
=False,
598 info
=dict(description
="Internal ID of the item in the generation"))
600 class ItemPocket(TableBase
):
601 u
"""A pocket that categorizes items
603 __tablename__
= 'item_pockets'
604 __singlename__
= 'item_pocket'
605 id = Column(Integer
, primary_key
=True, nullable
=False,
606 info
=dict(description
="A numeric ID"))
607 identifier
= Column(Unicode(16), nullable
=False,
608 info
=dict(description
="An identifier of this pocket", format
='identifier'))
610 create_translation_table('item_pocket_names', ItemPocket
, 'names',
611 relation_lazy
='joined',
612 name
= Column(Unicode(16), nullable
=False, index
=True,
613 info
=dict(description
="The name", format
='plaintext', official
=True)),
616 class Location(TableBase
):
617 u
"""A place in the Pokémon world
619 __tablename__
= 'locations'
620 __singlename__
= 'location'
621 id = Column(Integer
, primary_key
=True, nullable
=False,
622 info
=dict(description
="A numeric ID"))
623 region_id
= Column(Integer
, ForeignKey('regions.id'),
624 info
=dict(description
="ID of the region this location is in"))
625 identifier
= Column(Unicode(64), nullable
=False,
626 info
=dict(description
="An identifier", format
='identifier'))
628 create_translation_table('location_names', Location
, 'names',
629 relation_lazy
='joined',
630 name
= Column(Unicode(64), nullable
=False, index
=True,
631 info
=dict(description
="The name", format
='plaintext', official
=True)),
634 class LocationArea(TableBase
):
635 u
"""A sub-area of a location
637 __tablename__
= 'location_areas'
638 __singlename__
= 'location_area'
639 id = Column(Integer
, primary_key
=True, nullable
=False,
640 info
=dict(description
="A numeric ID"))
641 location_id
= Column(Integer
, ForeignKey('locations.id'), nullable
=False,
642 info
=dict(description
="ID of the location this area is part of"))
643 game_index
= Column(Integer
, nullable
=False,
644 info
=dict(description
="ID the games ude for this area"))
645 identifier
= Column(Unicode(64), nullable
=True,
646 info
=dict(description
="An identifier", format
='identifier'))
648 create_translation_table('location_area_prose', LocationArea
, 'prose',
649 relation_lazy
='joined',
650 name
= Column(Unicode(64), nullable
=False, index
=True,
651 info
=dict(description
="The name", format
='plaintext', official
=False)),
654 class LocationAreaEncounterRate(TableBase
):
655 # XXX: What's this exactly? Someone add the docstring & revise the descriptions
656 __tablename__
= 'location_area_encounter_rates'
657 location_area_id
= Column(Integer
, ForeignKey('location_areas.id'), primary_key
=True, nullable
=False, autoincrement
=False,
658 info
=dict(description
="ID of the area"))
659 encounter_method_id
= Column(Integer
, ForeignKey('encounter_methods.id'), primary_key
=True, nullable
=False, autoincrement
=False,
660 info
=dict(description
="ID of the method"))
661 version_id
= Column(Integer
, ForeignKey('versions.id'), primary_key
=True, autoincrement
=False,
662 info
=dict(description
="ID of the version"))
663 rate
= Column(Integer
, nullable
=True,
664 info
=dict(description
="The encounter rate")) # units?
666 class LocationGameIndex(TableBase
):
667 u
"""IDs the games use internally for locations
669 __tablename__
= 'location_game_indices'
670 location_id
= Column(Integer
, ForeignKey('locations.id'), nullable
=False, primary_key
=True,
671 info
=dict(description
="Database ID of the locaion"))
672 generation_id
= Column(Integer
, ForeignKey('generations.id'), nullable
=False, primary_key
=True,
673 info
=dict(description
="ID of the generation this entry to"))
674 game_index
= Column(Integer
, nullable
=False, primary_key
=True, autoincrement
=False,
675 info
=dict(description
="Internal game ID of the location"))
677 class Machine(TableBase
):
678 u
"""A TM or HM; numbered item that can teach a move to a Pokémon
680 __tablename__
= 'machines'
681 machine_number
= Column(Integer
, primary_key
=True, nullable
=False, autoincrement
=False,
682 info
=dict(description
="Number of the machine for TMs, or 100 + the munber for HMs"))
683 version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), primary_key
=True, nullable
=False, autoincrement
=False,
684 info
=dict(description
="Versions this entry applies to"))
685 item_id
= Column(Integer
, ForeignKey('items.id'), nullable
=False,
686 info
=dict(description
="ID of the corresponding Item"))
687 move_id
= Column(Integer
, ForeignKey('moves.id'), nullable
=False,
688 info
=dict(description
="ID of the taught move"))
692 u
"""True if this machine is a HM, False if it's a TM
694 return self
.machine_number
>= 100
696 class Move(TableBase
):
697 u
"""A Move: technique or attack a Pokémon can learn to use
699 __tablename__
= 'moves'
700 __singlename__
= 'move'
701 id = Column(Integer
, primary_key
=True, nullable
=False,
702 info
=dict(description
="A numeric ID"))
703 identifier
= Column(Unicode(24), nullable
=False,
704 info
=dict(description
="An identifier", format
='identifier'))
705 generation_id
= Column(Integer
, ForeignKey('generations.id'), nullable
=False,
706 info
=dict(description
="ID of the generation this move first appeared in"))
707 type_id
= Column(Integer
, ForeignKey('types.id'), nullable
=False,
708 info
=dict(description
="ID of the move's elemental type"))
709 power
= Column(SmallInteger
, nullable
=False,
710 info
=dict(description
="Base power of the move"))
711 pp
= Column(SmallInteger
, nullable
=True,
712 info
=dict(description
="Base PP (Power Points) of the move, nullable if not applicable (e.g. Struggle and Shadow moves)."))
713 accuracy
= Column(SmallInteger
, nullable
=True,
714 info
=dict(description
="Accuracy of the move; NULL means it never misses"))
715 priority
= Column(SmallInteger
, nullable
=False,
716 info
=dict(description
="The move's priority bracket"))
717 target_id
= Column(Integer
, ForeignKey('move_targets.id'), nullable
=False,
718 info
=dict(description
="ID of the target (range) of the move"))
719 damage_class_id
= Column(Integer
, ForeignKey('move_damage_classes.id'), nullable
=False,
720 info
=dict(description
="ID of the damage class (physical/special) of the move"))
721 effect_id
= Column(Integer
, ForeignKey('move_effects.id'), nullable
=False,
722 info
=dict(description
="ID of the move's effect"))
723 effect_chance
= Column(Integer
, nullable
=True,
724 info
=dict(description
="The chance for a secondary effect. What this is a chance of is specified by the move's effect."))
725 contest_type_id
= Column(Integer
, ForeignKey('contest_types.id'), nullable
=True,
726 info
=dict(description
="ID of the move's Contest type (e.g. cool or smart)"))
727 contest_effect_id
= Column(Integer
, ForeignKey('contest_effects.id'), nullable
=True,
728 info
=dict(description
="ID of the move's Contest effect"))
729 super_contest_effect_id
= Column(Integer
, ForeignKey('super_contest_effects.id'), nullable
=True,
730 info
=dict(description
="ID of the move's Super Contest effect"))
732 create_translation_table('move_names', Move
, 'names',
733 relation_lazy
='joined',
734 name
= Column(Unicode(24), nullable
=False, index
=True,
735 info
=dict(description
="The name", format
='plaintext', official
=True, ripped
=True))
737 create_translation_table('move_flavor_summaries', Move
, 'flavor_summaries',
738 flavor_summary
= Column(Unicode(512), nullable
=True,
739 info
=dict(description
=u
"Text containing facts from all flavor texts, for languages without official game translations", official
=False, format
='plaintext', ripped
=True)),
742 class MoveBattleStyle(TableBase
):
743 u
"""A battle style of a move""" # XXX: Explain better
744 __tablename__
= 'move_battle_styles'
745 __singlename__
= 'move_battle_style'
746 id = Column(Integer
, primary_key
=True, nullable
=False,
747 info
=dict(description
="A numeric ID"))
748 identifier
= Column(Unicode(8), nullable
=False,
749 info
=dict(description
="An identifier", format
='identifier'))
751 create_translation_table('move_battle_style_prose', MoveBattleStyle
, 'prose',
752 relation_lazy
='joined',
753 name
= Column(Unicode(8), nullable
=False, index
=True,
754 info
=dict(description
="The name", format
='plaintext', official
=False)),
757 class MoveChangelog(TableBase
):
758 """History of changes to moves across main game versions."""
759 __tablename__
= 'move_changelog'
760 __singlename__
= 'move_changelog'
761 move_id
= Column(Integer
, ForeignKey('moves.id'), primary_key
=True, nullable
=False,
762 info
=dict(description
="ID of the move that changed"))
763 changed_in_version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), primary_key
=True, nullable
=False,
764 info
=dict(description
="ID of the version group in which the move changed"))
765 type_id
= Column(Integer
, ForeignKey('types.id'), nullable
=True,
766 info
=dict(description
="Prior type of the move, or NULL if unchanged"))
767 power
= Column(SmallInteger
, nullable
=True,
768 info
=dict(description
="Prior base power of the move, or NULL if unchanged"))
769 pp
= Column(SmallInteger
, nullable
=True,
770 info
=dict(description
="Prior base PP of the move, or NULL if unchanged"))
771 accuracy
= Column(SmallInteger
, nullable
=True,
772 info
=dict(description
="Prior accuracy of the move, or NULL if unchanged"))
773 effect_id
= Column(Integer
, ForeignKey('move_effects.id'), nullable
=True,
774 info
=dict(description
="Prior ID of the effect, or NULL if unchanged"))
775 effect_chance
= Column(Integer
, nullable
=True,
776 info
=dict(description
="Prior effect chance, or NULL if unchanged"))
778 class MoveDamageClass(TableBase
):
779 u
"""Any of the damage classes moves can have, i.e. physical, special, or non-damaging.
781 __tablename__
= 'move_damage_classes'
782 __singlename__
= 'move_damage_class'
783 id = Column(Integer
, primary_key
=True, nullable
=False,
784 info
=dict(description
="A numeric ID"))
785 identifier
= Column(Unicode(16), nullable
=False,
786 info
=dict(description
="An identifier", format
='identifier'))
788 create_translation_table('move_damage_class_prose', MoveDamageClass
, 'prose',
789 relation_lazy
='joined',
790 name
= Column(Unicode(16), nullable
=True, index
=True,
791 info
=dict(description
="The name", format
='plaintext', official
=False)),
792 description
= Column(Unicode(64), nullable
=True,
793 info
=dict(description
="A description of the class", format
='plaintext')),
796 class MoveEffect(TableBase
):
797 u
"""An effect of a move
799 __tablename__
= 'move_effects'
800 __singlename__
= 'move_effect'
801 id = Column(Integer
, primary_key
=True, nullable
=False,
802 info
=dict(description
="A numeric ID"))
804 create_translation_table('move_effect_prose', MoveEffect
, 'prose',
805 short_effect
= Column(Unicode(256), nullable
=True,
806 info
=dict(description
="A short summary of the effect", format
='plaintext')),
807 effect
= Column(Unicode(5120), nullable
=True,
808 info
=dict(description
="A detailed description of the effect", format
='plaintext')),
811 class MoveEffectChangelog(TableBase
):
812 """History of changes to move effects across main game versions."""
813 __tablename__
= 'move_effect_changelog'
814 __singlename__
= 'move_effect_changelog'
815 id = Column(Integer
, primary_key
=True, nullable
=False,
816 info
=dict(description
="A numeric ID"))
817 effect_id
= Column(Integer
, ForeignKey('move_effects.id'), nullable
=False,
818 info
=dict(description
="The ID of the effect that changed"))
819 changed_in_version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), nullable
=False,
820 info
=dict(description
="The ID of the version group in which the effect changed"))
823 UniqueConstraint(effect_id
, changed_in_version_group_id
),
827 create_translation_table('move_effect_changelog_prose', MoveEffectChangelog
, 'prose',
828 effect
= Column(markdown
.MarkdownColumn(512), nullable
=False,
829 info
=dict(description
="A description of the old behavior", format
='markdown')),
832 class MoveFlag(TableBase
):
833 u
"""Maps a move flag to a move
835 # XXX: Other flags have a ___Flag class for the actual flag and ___FlagMap for the map,
836 # these, somewhat confusingly, have MoveFlagType and MoveFlag
837 __tablename__
= 'move_flags'
838 move_id
= Column(Integer
, ForeignKey('moves.id'), primary_key
=True, nullable
=False, autoincrement
=False,
839 info
=dict(description
="ID of the move"))
840 move_flag_type_id
= Column(Integer
, ForeignKey('move_flag_types.id'), primary_key
=True, nullable
=False, autoincrement
=False,
841 info
=dict(description
="ID of the flag"))
843 class MoveFlagType(TableBase
):
844 u
"""A Move attribute such as "snatchable" or "contact".
846 __tablename__
= 'move_flag_types'
847 __singlename__
= 'move_flag_type'
848 id = Column(Integer
, primary_key
=True, nullable
=False,
849 info
=dict(description
="A numeric ID"))
850 identifier
= Column(Unicode(32), nullable
=False,
851 info
=dict(description
="A short identifier for the flag", format
='identifier'))
853 create_translation_table('move_flag_type_prose', MoveFlagType
, 'prose',
854 relation_lazy
='joined',
855 name
= Column(Unicode(32), nullable
=True, index
=True,
856 info
=dict(description
="The name", format
='plaintext', official
=False)),
857 description
= Column(markdown
.MarkdownColumn(256), nullable
=True,
858 info
=dict(description
="A short description of the flag", format
='markdown')),
861 class MoveFlavorText(TableBase
):
862 u
"""In-game description of a move
864 __tablename__
= 'move_flavor_text'
865 summary_column
= Move
.flavor_summaries_table
, 'flavor_summary'
866 move_id
= Column(Integer
, ForeignKey('moves.id'), primary_key
=True, nullable
=False, autoincrement
=False,
867 info
=dict(description
="ID of the move"))
868 version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), primary_key
=True, nullable
=False, autoincrement
=False,
869 info
=dict(description
="ID of the version group this text appears in"))
870 language_id
= Column(Integer
, ForeignKey('languages.id'), primary_key
=True, nullable
=False,
871 info
=dict(description
="The language"))
872 flavor_text
= Column(Unicode(255), nullable
=False,
873 info
=dict(description
="The flavor text", official
=True, format
='gametext'))
875 class MoveMeta(TableBase
):
876 u
"""Metadata for move effects, sorta-kinda ripped straight from the game"""
877 __tablename__
= 'move_meta'
878 move_id
= Column(Integer
, ForeignKey('moves.id'), primary_key
=True, nullable
=False, autoincrement
=False,
879 info
=dict(description
="A numeric ID"))
880 meta_category_id
= Column(Integer
, ForeignKey('move_meta_categories.id'), nullable
=False,
881 info
=dict(description
="ID of the move category"))
882 meta_ailment_id
= Column(Integer
, ForeignKey('move_meta_ailments.id'), nullable
=False,
883 info
=dict(description
="ID of the caused ailment"))
884 min_hits
= Column(Integer
, nullable
=True, index
=True,
885 info
=dict(description
="Minimum number of hits per use"))
886 max_hits
= Column(Integer
, nullable
=True, index
=True,
887 info
=dict(description
="Maximum number of hits per use"))
888 min_turns
= Column(Integer
, nullable
=True, index
=True,
889 info
=dict(description
="Minimum number of turns the user is forced to use the move"))
890 max_turns
= Column(Integer
, nullable
=True, index
=True,
891 info
=dict(description
="Maximum number of turns the user is forced to use the move"))
892 recoil
= Column(Integer
, nullable
=False, index
=True,
893 info
=dict(description
="Recoil damage, in percent of damage done"))
894 healing
= Column(Integer
, nullable
=False, index
=True,
895 info
=dict(description
="Healing, in percent of user's max HP"))
896 crit_rate
= Column(Integer
, nullable
=False, index
=True,
897 info
=dict(description
="Critical hit rate bonus"))
898 ailment_chance
= Column(Integer
, nullable
=False, index
=True,
899 info
=dict(description
="Chance to cause an ailment, in percent"))
900 flinch_chance
= Column(Integer
, nullable
=False, index
=True,
901 info
=dict(description
="Chance to cause flinching, in percent"))
902 stat_chance
= Column(Integer
, nullable
=False, index
=True,
903 info
=dict(description
="Chance to cause a stat change, in percent"))
905 class MoveMetaAilment(TableBase
):
906 u
"""Common status ailments moves can inflict on a single Pokémon, including
907 major ailments like paralysis and minor ailments like trapping.
909 __tablename__
= 'move_meta_ailments'
910 __singlename__
= 'move_meta_ailment'
911 id = Column(Integer
, primary_key
=True, nullable
=False, autoincrement
=False,
912 info
=dict(description
="A numeric ID"))
913 identifier
= Column(Unicode(24), nullable
=False, index
=True, unique
=True,
914 info
=dict(description
="An identifier", format
='identifier'))
916 create_translation_table('move_meta_ailment_names', MoveMetaAilment
, 'names',
917 relation_lazy
='joined',
918 name
= Column(Unicode(24), nullable
=False, index
=True,
919 info
=dict(description
="The name", format
='plaintext', official
=True)),
922 class MoveMetaCategory(TableBase
):
923 u
"""Very general categories that loosely group move effects."""
924 __tablename__
= 'move_meta_categories'
925 __singlename__
= 'move_meta_category'
926 id = Column(Integer
, primary_key
=True, nullable
=False,
927 info
=dict(description
="A numeric ID"))
928 identifier
= Column(Unicode(32), nullable
=False, index
=True, unique
=True,
929 info
=dict(description
="An identifier", format
='identifier'))
931 create_translation_table('move_meta_category_prose', MoveMetaCategory
, 'prose',
932 relation_lazy
='joined',
933 description
= Column(Unicode(64), nullable
=False,
934 info
=dict(description
="A description of the category", format
="plaintext", official
=False)),
937 class MoveMetaStatChange(TableBase
):
938 u
"""Stat changes moves (may) make."""
939 __tablename__
= 'move_meta_stat_changes'
940 move_id
= Column(Integer
, ForeignKey('moves.id'), primary_key
=True, nullable
=False, autoincrement
=False,
941 info
=dict(description
="ID of the move"))
942 stat_id
= Column(Integer
, ForeignKey('stats.id'), primary_key
=True, nullable
=False, autoincrement
=False,
943 info
=dict(description
="ID of the stat"))
944 change
= Column(Integer
, nullable
=False, index
=True,
945 info
=dict(description
="Amount of increase/decrease, in stages"))
947 class MoveTarget(TableBase
):
948 u
"""Targetting or "range" of a move, e.g. "Affects all opponents" or "Affects user".
950 __tablename__
= 'move_targets'
951 __singlename__
= 'move_target'
952 id = Column(Integer
, primary_key
=True, nullable
=False,
953 info
=dict(description
="A numeric ID"))
954 identifier
= Column(Unicode(32), nullable
=False,
955 info
=dict(description
="An identifier", format
='identifier'))
957 create_translation_table('move_target_prose', MoveTarget
, 'prose',
958 relation_lazy
='joined',
959 name
= Column(Unicode(32), nullable
=True, index
=True,
960 info
=dict(description
="The name", format
='plaintext', official
=False)),
961 description
= Column(Unicode(128), nullable
=True,
962 info
=dict(description
="A description", format
='plaintext')),
965 class Nature(TableBase
):
966 u
"""A nature a Pokémon can have, such as Calm or Brave
968 __tablename__
= 'natures'
969 __singlename__
= 'nature'
970 id = Column(Integer
, primary_key
=True, nullable
=False,
971 info
=dict(description
="A numeric ID"))
972 identifier
= Column(Unicode(8), nullable
=False,
973 info
=dict(description
="An identifier", format
='identifier'))
974 decreased_stat_id
= Column(Integer
, ForeignKey('stats.id'), nullable
=False,
975 info
=dict(description
="ID of the stat that this nature decreases by 10% (if decreased_stat_id is the same, the effects cancel out)"))
976 increased_stat_id
= Column(Integer
, ForeignKey('stats.id'), nullable
=False,
977 info
=dict(description
="ID of the stat that this nature increases by 10% (if decreased_stat_id is the same, the effects cancel out)"))
978 hates_flavor_id
= Column(Integer
, ForeignKey('contest_types.id'), nullable
=False,
979 info
=dict(description
=u
"ID of the Berry flavor the Pokémon hates (if likes_flavor_id is the same, the effects cancel out)"))
980 likes_flavor_id
= Column(Integer
, ForeignKey('contest_types.id'), nullable
=False,
981 info
=dict(description
=u
"ID of the Berry flavor the Pokémon likes (if hates_flavor_id is the same, the effects cancel out)"))
984 def is_neutral(self
):
985 u
"""Returns True iff this nature doesn't alter a Pokémon's stats,
986 bestow taste preferences, etc.
988 return self
.increased_stat_id
== self
.decreased_stat_id
990 create_translation_table('nature_names', Nature
, 'names',
991 relation_lazy
='joined',
992 name
= Column(Unicode(8), nullable
=False, index
=True,
993 info
=dict(description
="The name", format
='plaintext', official
=True, ripped
=True)),
996 class NatureBattleStylePreference(TableBase
):
997 u
"""Battle Palace move preference
999 Specifies how likely a Pokémon with a specific Nature is to use a move of
1000 a particular battl style in Battle Palace or Battle Tent
1002 __tablename__
= 'nature_battle_style_preferences'
1003 nature_id
= Column(Integer
, ForeignKey('natures.id'), primary_key
=True, nullable
=False,
1004 info
=dict(description
=u
"ID of the Pokémon's nature"))
1005 move_battle_style_id
= Column(Integer
, ForeignKey('move_battle_styles.id'), primary_key
=True, nullable
=False,
1006 info
=dict(description
="ID of the battle style"))
1007 low_hp_preference
= Column(Integer
, nullable
=False,
1008 info
=dict(description
=u
"Chance of using the move, in percent, if HP is under ½"))
1009 high_hp_preference
= Column(Integer
, nullable
=False,
1010 info
=dict(description
=u
"Chance of using the move, in percent, if HP is over ½"))
1012 class NaturePokeathlonStat(TableBase
):
1013 u
"""Specifies how a Nature affects a Pokéathlon stat
1015 __tablename__
= 'nature_pokeathlon_stats'
1016 nature_id
= Column(Integer
, ForeignKey('natures.id'), primary_key
=True, nullable
=False,
1017 info
=dict(description
="ID of the nature"))
1018 pokeathlon_stat_id
= Column(Integer
, ForeignKey('pokeathlon_stats.id'), primary_key
=True, nullable
=False,
1019 info
=dict(description
="ID of the stat"))
1020 max_change
= Column(Integer
, nullable
=False,
1021 info
=dict(description
="Maximum change"))
1023 class PokeathlonStat(TableBase
):
1024 u
"""A Pokéathlon stat, such as "Stamina" or "Jump".
1026 __tablename__
= 'pokeathlon_stats'
1027 __singlename__
= 'pokeathlon_stat'
1028 id = Column(Integer
, primary_key
=True, nullable
=False,
1029 info
=dict(description
="A numeric ID"))
1030 identifier
= Column(Unicode(8), nullable
=False,
1031 info
=dict(description
="An identifier", format
='identifier'))
1033 create_translation_table('pokeathlon_stat_names', PokeathlonStat
, 'names',
1034 name
= Column(Unicode(8), nullable
=False, index
=True,
1035 info
=dict(description
="The name", format
='plaintext', official
=True)),
1038 class Pokedex(TableBase
):
1039 u
"""A collection of Pokémon species ordered in a particular way
1041 __tablename__
= 'pokedexes'
1042 __singlename__
= 'pokedex'
1043 id = Column(Integer
, primary_key
=True, nullable
=False,
1044 info
=dict(description
="A numeric ID"))
1045 region_id
= Column(Integer
, ForeignKey('regions.id'), nullable
=True,
1046 info
=dict(description
=u
"ID of the region this Pokédex is used in, or None if it's global"))
1047 identifier
= Column(Unicode(16), nullable
=False,
1048 info
=dict(description
=u
"An identifier", format
='identifier'))
1050 create_translation_table('pokedex_prose', Pokedex
, 'prose',
1051 relation_lazy
='joined',
1052 name
= Column(Unicode(16), nullable
=True, index
=True,
1053 info
=dict(description
="The name", format
='plaintext', official
=False)),
1054 description
= Column(Unicode(512), nullable
=True,
1055 info
=dict(description
=u
"A longer description of the Pokédex", format
='plaintext')),
1058 class Pokemon(TableBase
):
1059 u
"""A species of Pokémon. The core to this whole mess.
1061 __tablename__
= 'pokemon'
1062 __singlename__
= 'pokemon'
1063 id = Column(Integer
, primary_key
=True, nullable
=False,
1064 info
=dict(description
=u
"A numeric ID"))
1065 identifier
= Column(Unicode(20), nullable
=False,
1066 info
=dict(description
=u
"An identifier", format
='identifier'))
1067 generation_id
= Column(Integer
, ForeignKey('generations.id'),
1068 info
=dict(description
=u
"ID of the generation this species first appeared in"))
1069 evolution_chain_id
= Column(Integer
, ForeignKey('evolution_chains.id'),
1070 info
=dict(description
=u
"ID of the species' evolution chain (a.k.a. family)"))
1071 evolves_from_pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), nullable
=True,
1072 info
=dict(description
=u
"The Pokémon species from which this one evolves"))
1073 height
= Column(Integer
, nullable
=False,
1074 info
=dict(description
=u
"The height of the Pokémon, in decimeters (tenths of a meter)"))
1075 weight
= Column(Integer
, nullable
=False,
1076 info
=dict(description
=u
"The weight of the Pokémon, in tenths of a kilogram (decigrams)"))
1077 color_id
= Column(Integer
, ForeignKey('pokemon_colors.id'), nullable
=False,
1078 info
=dict(description
=u
"ID of this Pokémon's Pokédex color, as used for a gimmick search function in the games."))
1079 pokemon_shape_id
= Column(Integer
, ForeignKey('pokemon_shapes.id'), nullable
=False,
1080 info
=dict(description
=u
"ID of this Pokémon's body shape, as used for a gimmick search function in the games."))
1081 habitat_id
= Column(Integer
, ForeignKey('pokemon_habitats.id'), nullable
=True,
1082 info
=dict(description
=u
"ID of this Pokémon's habitat, as used for a gimmick search function in the games."))
1083 gender_rate
= Column(Integer
, nullable
=False,
1084 info
=dict(description
=u
"The chance of this Pokémon being female, in eighths; or -1 for genderless"))
1085 capture_rate
= Column(Integer
, nullable
=False,
1086 info
=dict(description
=u
"The base capture rate; up to 255"))
1087 base_experience
= Column(Integer
, nullable
=False,
1088 info
=dict(description
=u
"The base EXP gained when defeating this Pokémon")) # XXX: Is this correct?
1089 base_happiness
= Column(Integer
, nullable
=False,
1090 info
=dict(description
=u
"The tameness when caught by a normal ball"))
1091 is_baby
= Column(Boolean
, nullable
=False,
1092 info
=dict(description
=u
"True iff the Pokémon is a baby, i.e. a lowest-stage Pokémon that cannot breed but whose evolved form can."))
1093 hatch_counter
= Column(Integer
, nullable
=False,
1094 info
=dict(description
=u
"Initial hatch counter: one must walk 255 × (hatch_counter + 1) steps before this Pokémon's egg hatches, unless utilizing bonuses like Flame Body's"))
1095 has_gender_differences
= Column(Boolean
, nullable
=False,
1096 info
=dict(description
=u
"Set iff the species exhibits enough sexual dimorphism to have separate sets of sprites in Gen IV and beyond."))
1097 order
= Column(Integer
, nullable
=False, index
=True,
1098 info
=dict(description
=u
"Order for sorting. Almost national order, except families and forms are grouped together."))
1100 ### Stuff to handle alternate Pokémon forms
1104 u
"""Returns the Pokémon's form, using its default form as fallback."""
1106 return self
.unique_form
or self
.default_form
1109 def is_base_form(self
):
1110 u
"""Returns True iff the Pokémon is the base form for its species,
1114 return self
.unique_form
is None or self
.unique_form
.is_default
1117 def form_name(self
):
1118 u
"""Returns the Pokémon's form name if it represents a particular form
1119 and that form has a name, or None otherwise.
1122 # If self.unique_form is None, the short-circuit "and" will go ahead
1123 # and return that. Otherwise, it'll return the form's name, which may
1125 return self
.unique_form
and self
.unique_form
.name
1128 def full_name(self
):
1129 u
"""Returns the Pokémon's name, including its form if applicable."""
1132 return u
'%s %s' %
(self
.form_name
, self
.name
)
1137 def normal_form(self
):
1138 u
"""Returns the normal form for this Pokémon; i.e., this will return
1139 regular Deoxys when called on any Deoxys form.
1142 if self
.unique_form
:
1143 return self
.unique_form
.form_base_pokemon
1148 def stat(self
, stat_name
):
1149 u
"""Returns a PokemonStat record for the given stat name (or Stat row
1150 object). Uses the normal has-many machinery, so all the stats are
1153 if isinstance(stat_name
, Stat
):
1154 stat_name
= stat_name
.name
1156 for pokemon_stat
in self
.stats
:
1157 if pokemon_stat
.stat
.name
== stat_name
:
1160 raise KeyError(u
'No stat named %s' % stat_name
)
1163 def better_damage_class(self
):
1164 u
"""Returns the MoveDamageClass that this Pokémon is best suited for,
1165 based on its attack stats.
1167 If the attack stats are about equal (within 5), returns None. The
1168 value None, not the damage class called 'None'.
1170 phys
= self
.stat(u
'Attack')
1171 spec
= self
.stat(u
'Special Attack')
1173 diff
= phys
.base_stat
- spec
.base_stat
1176 return phys
.stat
.damage_class
1178 return spec
.stat
.damage_class
1182 create_translation_table('pokemon_names', Pokemon
, 'names',
1183 relation_lazy
='joined',
1184 name
= Column(Unicode(20), nullable
=True, index
=True,
1185 info
=dict(description
="The name", format
='plaintext', official
=True, ripped
=True)),
1186 species
= Column(Unicode(16), nullable
=True,
1187 info
=dict(description
=u
'The short flavor text, such as "Seed" or "Lizard"; usually affixed with the word "Pokémon"',
1188 official
=True, format
='plaintext')),
1190 create_translation_table('pokemon_flavor_summaries', Pokemon
, 'flavor_summaries',
1191 flavor_summary
= Column(Unicode(512), nullable
=True,
1192 info
=dict(description
=u
"Text containing facts from all flavor texts, for languages without official game translations", official
=False, format
='plaintext', ripped
=True)),
1195 class PokemonAbility(TableBase
):
1196 u
"""Maps an ability to a Pokémon that can have it
1198 __tablename__
= 'pokemon_abilities'
1199 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1200 info
=dict(description
=u
"ID of the Pokémon"))
1201 ability_id
= Column(Integer
, ForeignKey('abilities.id'), nullable
=False,
1202 info
=dict(description
=u
"ID of the ability"))
1203 # XXX having both a method and a slot is kind of gross. "slot" is a
1204 # misnomer, anyway: duplicate abilities don't appear in slot 2.
1205 # Probably should replace that with "order".
1206 is_dream
= Column(Boolean
, nullable
=False, index
=True,
1207 info
=dict(description
=u
"Whether this is a Dream World ability"))
1208 slot
= Column(Integer
, primary_key
=True, nullable
=False, autoincrement
=False,
1209 info
=dict(description
=u
"The ability slot, i.e. 1 or 2 for gen. IV"))
1211 class PokemonColor(TableBase
):
1212 u
"""The "Pokédex color" of a Pokémon species. Usually based on the Pokémon's color.
1214 __tablename__
= 'pokemon_colors'
1215 __singlename__
= 'pokemon_color'
1216 id = Column(Integer
, primary_key
=True, nullable
=False, autoincrement
=False,
1217 info
=dict(description
=u
"ID of the Pokémon"))
1218 identifier
= Column(Unicode(6), nullable
=False,
1219 info
=dict(description
=u
"An identifier", format
='identifier'))
1221 create_translation_table('pokemon_color_names', PokemonColor
, 'names',
1222 relation_lazy
='joined',
1223 name
= Column(Unicode(6), nullable
=False, index
=True,
1224 info
=dict(description
="The name", format
='plaintext', official
=True)),
1227 class PokemonDexNumber(TableBase
):
1228 u
"""The number of a Pokémon in a particular Pokédex (e.g. Jigglypuff is #138 in Hoenn's 'dex)
1230 __tablename__
= 'pokemon_dex_numbers'
1231 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1232 info
=dict(description
=u
"ID of the Pokémon"))
1233 pokedex_id
= Column(Integer
, ForeignKey('pokedexes.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1234 info
=dict(description
=u
"ID of the Pokédex"))
1235 pokedex_number
= Column(Integer
, nullable
=False,
1236 info
=dict(description
=u
"Number of the Pokémon in that the Pokédex"))
1238 class PokemonEggGroup(TableBase
):
1239 u
"""Maps an Egg group to a Pokémon; each Pokémon belongs to one or two egg groups
1241 __tablename__
= 'pokemon_egg_groups'
1242 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1243 info
=dict(description
=u
"ID of the Pokémon"))
1244 egg_group_id
= Column(Integer
, ForeignKey('egg_groups.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1245 info
=dict(description
=u
"ID of the egg group"))
1247 class PokemonEvolution(TableBase
):
1248 u
"""A required action ("trigger") and the conditions under which the trigger
1249 must occur to cause a Pokémon to evolve.
1251 Any condition may be null if it does not apply for a particular Pokémon.
1253 __tablename__
= 'pokemon_evolution'
1254 id = Column(Integer
, primary_key
=True, nullable
=False,
1255 info
=dict(description
=u
"A numeric ID"))
1256 evolved_pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), nullable
=False,
1257 info
=dict(description
=u
"The ID of the post-evolution Pokémon."))
1258 evolution_trigger_id
= Column(Integer
, ForeignKey('evolution_triggers.id'), nullable
=False,
1259 info
=dict(description
=u
"The ID of the evolution trigger."))
1260 trigger_item_id
= Column(Integer
, ForeignKey('items.id'), nullable
=True,
1261 info
=dict(description
=u
"The ID of the item that must be used on the Pokémon."))
1262 minimum_level
= Column(Integer
, nullable
=True,
1263 info
=dict(description
=u
"The minimum level for the Pokémon."))
1264 gender
= Column(Enum('male', 'female', name
='pokemon_evolution_gender'), nullable
=True,
1265 info
=dict(description
=u
"The Pokémon's required gender, or None if gender doesn't matter"))
1266 location_id
= Column(Integer
, ForeignKey('locations.id'), nullable
=True,
1267 info
=dict(description
=u
"The ID of the location the evolution must be triggered at."))
1268 held_item_id
= Column(Integer
, ForeignKey('items.id'), nullable
=True,
1269 info
=dict(description
=u
"The ID of the item the Pokémon must hold."))
1270 time_of_day
= Column(Enum('day', 'night', name
='pokemon_evolution_time_of_day'), nullable
=True,
1271 info
=dict(description
=u
"The required time of day."))
1272 known_move_id
= Column(Integer
, ForeignKey('moves.id'), nullable
=True,
1273 info
=dict(description
=u
"The ID of the move the Pokémon must know."))
1274 minimum_happiness
= Column(Integer
, nullable
=True,
1275 info
=dict(description
=u
"The minimum happiness value the Pokémon must have."))
1276 minimum_beauty
= Column(Integer
, nullable
=True,
1277 info
=dict(description
=u
"The minimum Beauty value the Pokémon must have."))
1278 relative_physical_stats
= Column(Integer
, nullable
=True,
1279 info
=dict(description
=u
"The required relation between the Pokémon's Attack and Defense stats, as sgn(atk-def)."))
1280 party_pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), nullable
=True,
1281 info
=dict(description
=u
"The ID of the Pokémon that must be present in the party."))
1282 trade_pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), nullable
=True,
1283 info
=dict(description
=u
"The ID of the Pokémon for which this Pokémon must be traded."))
1285 class PokemonFlavorText(TableBase
):
1286 u
"""In-game Pokédex descrption of a Pokémon.
1288 __tablename__
= 'pokemon_flavor_text'
1289 summary_column
= Pokemon
.flavor_summaries_table
, 'flavor_summary'
1290 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1291 info
=dict(description
=u
"ID of the Pokémon"))
1292 version_id
= Column(Integer
, ForeignKey('versions.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1293 info
=dict(description
=u
"ID of the version that has this flavor text"))
1294 language_id
= Column(Integer
, ForeignKey('languages.id'), primary_key
=True, nullable
=False,
1295 info
=dict(description
="The language"))
1296 flavor_text
= Column(Unicode(255), nullable
=False,
1297 info
=dict(description
=u
"The flavor text", official
=True, format
='gametext'))
1299 class PokemonForm(TableBase
):
1300 u
"""An individual form of a Pokémon.
1302 Pokémon that do not have separate forms are still given a single row to
1303 represent their single form.
1305 __tablename__
= 'pokemon_forms'
1306 __singlename__
= 'pokemon_form'
1307 id = Column(Integer
, primary_key
=True, nullable
=False,
1308 info
=dict(description
=u
'A unique ID for this form.'))
1309 identifier
= Column(Unicode(16), nullable
=True,
1310 info
=dict(description
=u
"An identifier", format
='identifier'))
1311 form_base_pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), nullable
=False, autoincrement
=False,
1312 info
=dict(description
=u
'The ID of the base Pokémon for this form.'))
1313 unique_pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), autoincrement
=False,
1314 info
=dict(description
=u
'The ID of a Pokémon that represents specifically this form, for Pokémon with functionally-different forms like Wormadam.'))
1315 introduced_in_version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), autoincrement
=False,
1316 info
=dict(description
=u
'The ID of the version group in which this form first appeared.'))
1317 is_default
= Column(Boolean
, nullable
=False,
1318 info
=dict(description
=u
'Set for exactly one form used as the default for each species.'))
1319 order
= Column(Integer
, nullable
=False, autoincrement
=False,
1320 info
=dict(description
=u
'The order in which forms should be sorted. Multiple forms may have equal order, in which case they should fall back on sorting by name.'))
1324 u
"""Returns the Pokémon for this form, using the form base as fallback.
1327 return self
.unique_pokemon
or self
.form_base_pokemon
1330 def full_name(self
):
1331 u
"""Returns the full name of this form, e.g. "Plant Cloak"."""
1335 elif self
.form_group
and self
.form_group
.term
:
1336 return u
'%s %s' %
(self
.name
, self
.form_group
.term
)
1341 def pokemon_name(self
):
1342 u
"""Returns the name of this Pokémon with this form, e.g. "Plant
1347 return u
'%s %s' %
(self
.name
, self
.form_base_pokemon
.name
)
1349 return self
.form_base_pokemon
.name
1351 create_translation_table('pokemon_form_names', PokemonForm
, 'names',
1352 relation_lazy
='joined',
1353 name
= Column(Unicode(16), nullable
=False, index
=True,
1354 info
=dict(description
="The name", format
='plaintext', official
=True)),
1357 class PokemonFormGroup(TableBase
):
1358 u
"""Information about a Pokémon's forms as a group."""
1359 __tablename__
= 'pokemon_form_groups'
1360 __singlename__
= 'pokemon_form_group'
1361 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1362 info
=dict(description
=u
"ID of the base form Pokémon"))
1363 is_battle_only
= Column(Boolean
, nullable
=False,
1364 info
=dict(description
=u
"Set iff the forms only change in battle"))
1366 PokemonFormGroup
.id = PokemonFormGroup
.pokemon_id
1368 create_translation_table('pokemon_form_group_prose', PokemonFormGroup
, 'prose',
1369 term
= Column(Unicode(16), nullable
=True,
1370 info
=dict(description
=u
"The term for this Pokémon's forms, e.g. \"Cloak\" for Burmy or \"Forme\" for Deoxys.", official
=True, format
='plaintext')),
1371 description
= Column(markdown
.MarkdownColumn(1024), nullable
=True,
1372 info
=dict(description
=u
"Description of how the forms work", format
='markdown')),
1375 class PokemonFormPokeathlonStat(TableBase
):
1376 u
"""A Pokémon form's performance in one Pokéathlon stat."""
1377 __tablename__
= 'pokemon_form_pokeathlon_stats'
1378 pokemon_form_id
= Column(Integer
, ForeignKey('pokemon_forms.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1379 info
=dict(description
=u
'The ID of the Pokémon form.'))
1380 pokeathlon_stat_id
= Column(Integer
, ForeignKey('pokeathlon_stats.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1381 info
=dict(description
=u
'The ID of the Pokéathlon stat.'))
1382 minimum_stat
= Column(Integer
, nullable
=False, autoincrement
=False,
1383 info
=dict(description
=u
'The minimum value for this stat for this Pokémon form.'))
1384 base_stat
= Column(Integer
, nullable
=False, autoincrement
=False,
1385 info
=dict(description
=u
'The default value for this stat for this Pokémon form.'))
1386 maximum_stat
= Column(Integer
, nullable
=False, autoincrement
=False,
1387 info
=dict(description
=u
'The maximum value for this stat for this Pokémon form.'))
1389 class PokemonGameIndex(TableBase
):
1390 u
"""The number of a Pokémon a game uses internally
1392 __tablename__
= 'pokemon_game_indices'
1393 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), primary_key
=True, autoincrement
=False, nullable
=False,
1394 info
=dict(description
=u
"Database ID of the Pokémon"))
1395 generation_id
= Column(Integer
, ForeignKey('generations.id'), primary_key
=True, autoincrement
=False, nullable
=False,
1396 info
=dict(description
=u
"Database ID of the generation"))
1397 game_index
= Column(Integer
, nullable
=False,
1398 info
=dict(description
=u
"Internal ID the generation's games use for the Pokémon"))
1400 class PokemonHabitat(TableBase
):
1401 u
"""The habitat of a Pokémon, as given in the FireRed/LeafGreen version Pokédex
1403 __tablename__
= 'pokemon_habitats'
1404 __singlename__
= 'pokemon_habitat'
1405 id = Column(Integer
, primary_key
=True, nullable
=False, autoincrement
=False,
1406 info
=dict(description
=u
"A numeric ID"))
1407 identifier
= Column(Unicode(16), nullable
=False,
1408 info
=dict(description
=u
"An identifier", format
='identifier'))
1410 create_translation_table('pokemon_habitat_names', PokemonHabitat
, 'names',
1411 relation_lazy
='joined',
1412 name
= Column(Unicode(16), nullable
=False, index
=True,
1413 info
=dict(description
="The name", format
='plaintext', official
=True)),
1416 class PokemonItem(TableBase
):
1417 u
"""Record of an item a Pokémon can hold in the wild
1419 __tablename__
= 'pokemon_items'
1420 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1421 info
=dict(description
=u
"ID of the Pokémon"))
1422 version_id
= Column(Integer
, ForeignKey('versions.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1423 info
=dict(description
=u
"ID of the version this applies to"))
1424 item_id
= Column(Integer
, ForeignKey('items.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1425 info
=dict(description
=u
"ID of the item"))
1426 rarity
= Column(Integer
, nullable
=False,
1427 info
=dict(description
=u
"Chance of the Pokémon holding the item, in percent"))
1429 class PokemonMove(TableBase
):
1430 u
"""Record of a move a Pokémon can learn
1432 __tablename__
= 'pokemon_moves'
1433 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), nullable
=False, index
=True,
1434 info
=dict(description
=u
"ID of the Pokémon"))
1435 version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), nullable
=False, index
=True,
1436 info
=dict(description
=u
"ID of the version group this applies to"))
1437 move_id
= Column(Integer
, ForeignKey('moves.id'), nullable
=False, index
=True,
1438 info
=dict(description
=u
"ID of the move"))
1439 pokemon_move_method_id
= Column(Integer
, ForeignKey('pokemon_move_methods.id'), nullable
=False, index
=True,
1440 info
=dict(description
=u
"ID of the method this move is learned by"))
1441 level
= Column(Integer
, nullable
=True, index
=True,
1442 info
=dict(description
=u
"Level the move is learned at, if applicable"))
1443 order
= Column(Integer
, nullable
=True,
1444 info
=dict(description
=u
"A sort key to produce the correct ordering when all else is equal")) # XXX: This needs a better description
1447 PrimaryKeyConstraint('pokemon_id', 'version_group_id', 'move_id', 'pokemon_move_method_id', 'level'),
1451 class PokemonMoveMethod(TableBase
):
1452 u
"""A method a move can be learned by, such as "Level up" or "Tutor".
1454 __tablename__
= 'pokemon_move_methods'
1455 __singlename__
= 'pokemon_move_method'
1456 id = Column(Integer
, primary_key
=True, nullable
=False, autoincrement
=False,
1457 info
=dict(description
=u
"A numeric ID"))
1458 identifier
= Column(Unicode(64), nullable
=False,
1459 info
=dict(description
=u
"An identifier", format
='identifier'))
1461 create_translation_table('pokemon_move_method_prose', PokemonMoveMethod
, 'prose',
1462 relation_lazy
='joined',
1463 name
= Column(Unicode(64), nullable
=True, index
=True,
1464 info
=dict(description
="The name", format
='plaintext', official
=False)),
1465 description
= Column(Unicode(255), nullable
=True,
1466 info
=dict(description
=u
"A detailed description of how the method works", format
='plaintext')),
1469 class PokemonShape(TableBase
):
1470 u
"""The shape of a Pokémon's body, as used in generation IV Pokédexes.
1472 __tablename__
= 'pokemon_shapes'
1473 __singlename__
= 'pokemon_shape'
1474 id = Column(Integer
, primary_key
=True, nullable
=False,
1475 info
=dict(description
=u
"A numeric ID"))
1476 identifier
= Column(Unicode(24), nullable
=False,
1477 info
=dict(description
=u
"An identifier", format
='identifier'))
1479 create_translation_table('pokemon_shape_prose', PokemonShape
, 'prose',
1480 relation_lazy
='joined',
1481 name
= Column(Unicode(24), nullable
=True, index
=True,
1482 info
=dict(description
="The name", format
='plaintext', official
=False)),
1483 awesome_name
= Column(Unicode(16), nullable
=True,
1484 info
=dict(description
=u
"A splendiferous name of the body shape", format
='plaintext')),
1487 class PokemonStat(TableBase
):
1488 u
"""A stat value of a Pokémon
1490 __tablename__
= 'pokemon_stats'
1491 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1492 info
=dict(description
=u
"ID of the Pokémon"))
1493 stat_id
= Column(Integer
, ForeignKey('stats.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1494 info
=dict(description
=u
"ID of the stat"))
1495 base_stat
= Column(Integer
, nullable
=False,
1496 info
=dict(description
=u
"The base stat"))
1497 effort
= Column(Integer
, nullable
=False,
1498 info
=dict(description
=u
"The effort increase in this stat gained when this Pokémon is defeated"))
1500 class PokemonType(TableBase
):
1501 u
"""Maps a type to a Pokémon. Each Pokémon has 1 or 2 types.
1503 __tablename__
= 'pokemon_types'
1504 pokemon_id
= Column(Integer
, ForeignKey('pokemon.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1505 info
=dict(description
=u
"ID of the Pokémon"))
1506 type_id
= Column(Integer
, ForeignKey('types.id'), nullable
=False,
1507 info
=dict(description
=u
"ID of the type"))
1508 slot
= Column(Integer
, primary_key
=True, nullable
=False, autoincrement
=False,
1509 info
=dict(description
=u
"The type's slot, 1 or 2, used to sort types if there are two of them"))
1511 class Region(TableBase
):
1512 u
"""Major areas of the world: Kanto, Johto, etc.
1514 __tablename__
= 'regions'
1515 __singlename__
= 'region'
1516 id = Column(Integer
, primary_key
=True, nullable
=False,
1517 info
=dict(description
=u
"A numeric ID"))
1518 identifier
= Column(Unicode(16), nullable
=False,
1519 info
=dict(description
=u
"An identifier", format
='identifier'))
1521 create_translation_table('region_names', Region
, 'names',
1522 relation_lazy
='joined',
1523 name
= Column(Unicode(16), nullable
=False, index
=True,
1524 info
=dict(description
="The name", format
='plaintext', official
=True)),
1527 class Stat(TableBase
):
1528 u
"""A Stat, such as Attack or Speed
1530 __tablename__
= 'stats'
1531 __singlename__
= 'stat'
1532 id = Column(Integer
, primary_key
=True, nullable
=False,
1533 info
=dict(description
=u
"A numeric ID"))
1534 damage_class_id
= Column(Integer
, ForeignKey('move_damage_classes.id'), nullable
=True,
1535 info
=dict(description
=u
"For offensive and defensive stats, the damage this stat relates to; otherwise None (the NULL value)"))
1536 identifier
= Column(Unicode(16), nullable
=False,
1537 info
=dict(description
=u
"An identifier", format
='identifier'))
1538 is_battle_only
= Column(Boolean
, nullable
=False,
1539 info
=dict(description
=u
"Whether this stat only exists within a battle"))
1541 create_translation_table('stat_names', Stat
, 'names',
1542 relation_lazy
='joined',
1543 name
= Column(Unicode(16), nullable
=False, index
=True,
1544 info
=dict(description
="The name", format
='plaintext', official
=True)),
1547 class StatHint(TableBase
):
1548 u
"""Flavor text for genes that appears in a Pokémon's summary. Sometimes
1549 called "characteristics".
1551 __tablename__
= 'stat_hints'
1552 __singlename__
= 'stat_hint'
1553 id = Column(Integer
, primary_key
=True, nullable
=False,
1554 info
=dict(description
=u
"A numeric ID"))
1555 stat_id
= Column(Integer
, ForeignKey('stats.id'), nullable
=False,
1556 info
=dict(description
=u
"ID of the highest stat"))
1557 gene_mod_5
= Column(Integer
, nullable
=False, index
=True,
1558 info
=dict(description
=u
"Value of the highest stat modulo 5"))
1560 create_translation_table('stat_hint_names', StatHint
, 'names',
1561 relation_lazy
='joined',
1562 message
= Column(Unicode(24), nullable
=False, index
=True,
1563 info
=dict(description
=u
"The text displayed", official
=True, format
='plaintext')),
1566 class SuperContestCombo(TableBase
):
1567 u
"""Combo of two moves in a Super Contest.
1569 __tablename__
= 'super_contest_combos'
1570 first_move_id
= Column(Integer
, ForeignKey('moves.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1571 info
=dict(description
=u
"The ID of the first move in the combo."))
1572 second_move_id
= Column(Integer
, ForeignKey('moves.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1573 info
=dict(description
=u
"The ID of the second and last move."))
1575 class SuperContestEffect(TableBase
):
1576 u
"""An effect a move can have when used in the Super Contest
1578 __tablename__
= 'super_contest_effects'
1579 __singlename__
= 'super_contest_effect'
1580 id = Column(Integer
, primary_key
=True, nullable
=False,
1581 info
=dict(description
=u
"This effect's unique ID."))
1582 appeal
= Column(SmallInteger
, nullable
=False,
1583 info
=dict(description
=u
"The number of hearts the user gains."))
1585 create_translation_table('super_contest_effect_prose', SuperContestEffect
, 'prose',
1586 flavor_text
= Column(Unicode(64), nullable
=False,
1587 info
=dict(description
=u
"A description of the effect.", format
='plaintext', official
=True)),
1590 class Type(TableBase
):
1591 u
"""Any of the elemental types Pokémon and moves can have."""
1592 __tablename__
= 'types'
1593 __singlename__
= 'type'
1594 id = Column(Integer
, primary_key
=True, nullable
=False,
1595 info
=dict(description
=u
"A unique ID for this type."))
1596 identifier
= Column(Unicode(12), nullable
=False,
1597 info
=dict(description
=u
"An identifier", format
='identifier'))
1598 generation_id
= Column(Integer
, ForeignKey('generations.id'), nullable
=False,
1599 info
=dict(description
=u
"The ID of the generation this type first appeared in."))
1600 damage_class_id
= Column(Integer
, ForeignKey('move_damage_classes.id'), nullable
=True,
1601 info
=dict(description
=u
"The ID of the damage class this type's moves had before Generation IV, null if not applicable (e.g. ???)."))
1603 create_translation_table('type_names', Type
, 'names',
1604 relation_lazy
='joined',
1605 name
= Column(Unicode(12), nullable
=False, index
=True,
1606 info
=dict(description
="The name", format
='plaintext', official
=True)),
1609 class TypeEfficacy(TableBase
):
1610 u
"""The damage multiplier used when a move of a particular type damages a
1611 Pokémon of a particular other type.
1613 __tablename__
= 'type_efficacy'
1614 damage_type_id
= Column(Integer
, ForeignKey('types.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1615 info
=dict(description
=u
"The ID of the damaging type."))
1616 target_type_id
= Column(Integer
, ForeignKey('types.id'), primary_key
=True, nullable
=False, autoincrement
=False,
1617 info
=dict(description
=u
"The ID of the defending Pokémon's type."))
1618 damage_factor
= Column(Integer
, nullable
=False,
1619 info
=dict(description
=u
"The multiplier, as a percentage of damage inflicted."))
1621 class Version(TableBase
):
1622 u
"""An individual main-series Pokémon game."""
1623 __tablename__
= 'versions'
1624 __singlename__
= 'version'
1625 id = Column(Integer
, primary_key
=True, nullable
=False,
1626 info
=dict(description
=u
"A unique ID for this version."))
1627 version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), nullable
=False,
1628 info
=dict(description
=u
"The ID of the version group this game belongs to."))
1629 identifier
= Column(Unicode(32), nullable
=False,
1630 info
=dict(description
=u
'And identifier', format
='identifier'))
1632 create_translation_table('version_names', Version
, 'names',
1633 relation_lazy
='joined',
1634 name
= Column(Unicode(32), nullable
=False, index
=True,
1635 info
=dict(description
="The name", format
='plaintext', official
=True)),
1638 class VersionGroup(TableBase
):
1639 u
"""A group of versions, containing either two paired versions (such as Red
1640 and Blue) or a single game (such as Yellow.)
1642 __tablename__
= 'version_groups'
1643 id = Column(Integer
, primary_key
=True, nullable
=False,
1644 info
=dict(description
=u
"This version group's unique ID."))
1645 generation_id
= Column(Integer
, ForeignKey('generations.id'), nullable
=False,
1646 info
=dict(description
=u
"The ID of the generation the games in this group belong to."))
1647 pokedex_id
= Column(Integer
, ForeignKey('pokedexes.id'), nullable
=False,
1648 info
=dict(description
=u
"The ID of the regional Pokédex used in this version group."))
1650 class VersionGroupRegion(TableBase
):
1651 u
"""Maps a version group to a region that appears in it."""
1652 __tablename__
= 'version_group_regions'
1653 version_group_id
= Column(Integer
, ForeignKey('version_groups.id'), primary_key
=True, nullable
=False,
1654 info
=dict(description
=u
"The ID of the version group."))
1655 region_id
= Column(Integer
, ForeignKey('regions.id'), primary_key
=True, nullable
=False,
1656 info
=dict(description
=u
"The ID of the region."))
1659 ### Relations down here, to avoid dependency ordering problems
1661 Ability
.changelog
= relation(AbilityChangelog
,
1662 order_by
=AbilityChangelog
.changed_in_version_group_id
.desc(),
1663 backref
=backref('ability', innerjoin
=True, lazy
='joined'))
1664 Ability
.flavor_text
= relation(AbilityFlavorText
,
1665 order_by
=AbilityFlavorText
.version_group_id
,
1666 backref
=backref('ability', innerjoin
=True, lazy
='joined'))
1667 Ability
.generation
= relation(Generation
,
1669 backref
='abilities')
1671 AbilityChangelog
.changed_in
= relation(VersionGroup
,
1672 innerjoin
=True, lazy
='joined',
1673 backref
='ability_changelog')
1675 AbilityFlavorText
.version_group
= relation(VersionGroup
,
1677 AbilityFlavorText
.language
= relation(Language
,
1678 innerjoin
=True, lazy
='joined')
1681 Berry
.berry_firmness
= relation(BerryFirmness
,
1684 Berry
.firmness
= association_proxy('berry_firmness', 'name')
1685 Berry
.flavors
= relation(BerryFlavor
,
1686 order_by
=BerryFlavor
.contest_type_id
,
1687 backref
=backref('berry', innerjoin
=True))
1688 Berry
.natural_gift_type
= relation(Type
, innerjoin
=True)
1690 BerryFlavor
.contest_type
= relation(ContestType
, innerjoin
=True)
1693 ContestCombo
.first
= relation(Move
,
1694 primaryjoin
=ContestCombo
.first_move_id
==Move
.id,
1695 innerjoin
=True, lazy
='joined',
1696 backref
='contest_combo_first')
1697 ContestCombo
.second
= relation(Move
,
1698 primaryjoin
=ContestCombo
.second_move_id
==Move
.id,
1699 innerjoin
=True, lazy
='joined',
1700 backref
='contest_combo_second')
1703 Encounter
.condition_value_map
= relation(EncounterConditionValueMap
,
1704 backref
='encounter')
1705 Encounter
.condition_values
= association_proxy('condition_value_map', 'condition_value')
1706 Encounter
.location_area
= relation(LocationArea
,
1707 innerjoin
=True, lazy
='joined',
1708 backref
='encounters')
1709 Encounter
.pokemon
= relation(Pokemon
,
1710 innerjoin
=True, lazy
='joined',
1711 backref
='encounters')
1712 Encounter
.version
= relation(Version
,
1713 innerjoin
=True, lazy
='joined',
1714 backref
='encounters')
1715 Encounter
.slot
= relation(EncounterSlot
,
1716 innerjoin
=True, lazy
='joined',
1717 backref
='encounters')
1719 EncounterConditionValue
.condition
= relation(EncounterCondition
,
1720 innerjoin
=True, lazy
='joined',
1722 EncounterConditionValueMap
.condition_value
= relation(EncounterConditionValue
,
1723 innerjoin
=True, lazy
='joined',
1724 backref
='encounter_map')
1726 EncounterSlot
.method
= relation(EncounterMethod
,
1727 innerjoin
=True, lazy
='joined',
1729 EncounterSlot
.version_group
= relation(VersionGroup
, innerjoin
=True)
1732 EvolutionChain
.growth_rate
= relation(GrowthRate
,
1734 backref
='evolution_chains')
1735 EvolutionChain
.baby_trigger_item
= relation(Item
,
1736 backref
='evolution_chains')
1739 Experience
.growth_rate
= relation(GrowthRate
,
1740 innerjoin
=True, lazy
='joined',
1741 backref
='experience_table')
1744 Generation
.canonical_pokedex
= relation(Pokedex
,
1745 backref
='canonical_for_generation')
1746 Generation
.versions
= relation(Version
,
1747 secondary
=VersionGroup
.__table__
,
1749 Generation
.main_region
= relation(Region
, innerjoin
=True)
1752 GrowthRate
.max_experience_obj
= relation(Experience
,
1754 Experience
.growth_rate_id
== GrowthRate
.id,
1755 Experience
.level
== 100),
1756 uselist
=False, innerjoin
=True)
1757 GrowthRate
.max_experience
= association_proxy('max_experience_obj', 'experience')
1760 Item
.berry
= relation(Berry
,
1763 Item
.flags
= relation(ItemFlag
,
1764 secondary
=ItemFlagMap
.__table__
)
1765 Item
.flavor_text
= relation(ItemFlavorText
,
1766 order_by
=ItemFlavorText
.version_group_id
.asc(),
1767 backref
=backref('item', innerjoin
=True, lazy
='joined'))
1768 Item
.fling_effect
= relation(ItemFlingEffect
,
1770 Item
.machines
= relation(Machine
,
1771 order_by
=Machine
.version_group_id
.asc())
1772 Item
.category
= relation(ItemCategory
,
1774 backref
=backref('items', order_by
=Item
.identifier
.asc()))
1775 Item
.pocket
= association_proxy('category', 'pocket')
1777 ItemCategory
.pocket
= relation(ItemPocket
, innerjoin
=True)
1779 ItemFlavorText
.version_group
= relation(VersionGroup
,
1780 innerjoin
=True, lazy
='joined')
1781 ItemFlavorText
.language
= relation(Language
,
1782 innerjoin
=True, lazy
='joined')
1784 ItemGameIndex
.item
= relation(Item
,
1785 innerjoin
=True, lazy
='joined',
1786 backref
='game_indices')
1787 ItemGameIndex
.generation
= relation(Generation
,
1788 innerjoin
=True, lazy
='joined')
1790 ItemPocket
.categories
= relation(ItemCategory
,
1792 order_by
=ItemCategory
.identifier
.asc())
1795 Location
.region
= relation(Region
,
1797 backref
='locations')
1799 LocationArea
.location
= relation(Location
,
1800 innerjoin
=True, lazy
='joined',
1803 LocationAreaEncounterRate
.location_area
= relation(LocationArea
,
1805 backref
='encounter_rates')
1806 LocationAreaEncounterRate
.method
= relation(EncounterMethod
,
1809 LocationGameIndex
.location
= relation(Location
,
1810 innerjoin
=True, lazy
='joined',
1811 backref
='game_indices')
1812 LocationGameIndex
.generation
= relation(Generation
,
1813 innerjoin
=True, lazy
='joined')
1816 Machine
.item
= relation(Item
)
1817 Machine
.version_group
= relation(VersionGroup
,
1818 innerjoin
=True, lazy
='joined')
1821 Move
.changelog
= relation(MoveChangelog
,
1822 order_by
=MoveChangelog
.changed_in_version_group_id
.desc(),
1823 backref
=backref('move', innerjoin
=True, lazy
='joined'))
1824 Move
.contest_effect
= relation(ContestEffect
,
1826 Move
.contest_combo_next
= association_proxy('contest_combo_first', 'second')
1827 Move
.contest_combo_prev
= association_proxy('contest_combo_second', 'first')
1828 Move
.contest_type
= relation(ContestType
,
1830 Move
.damage_class
= relation(MoveDamageClass
,
1833 Move
.flags
= association_proxy('move_flags', 'flag')
1834 Move
.flavor_text
= relation(MoveFlavorText
,
1835 order_by
=MoveFlavorText
.version_group_id
, backref
='move')
1836 Move
.generation
= relation(Generation
,
1839 Move
.machines
= relation(Machine
,
1841 Move
.meta
= relation(MoveMeta
,
1842 uselist
=False, innerjoin
=True,
1844 Move
.meta_stat_changes
= relation(MoveMetaStatChange
)
1845 Move
.move_effect
= relation(MoveEffect
,
1848 Move
.move_flags
= relation(MoveFlag
,
1850 Move
.super_contest_effect
= relation(SuperContestEffect
,
1852 Move
.super_contest_combo_next
= association_proxy('super_contest_combo_first', 'second')
1853 Move
.super_contest_combo_prev
= association_proxy('super_contest_combo_second', 'first')
1854 Move
.target
= relation(MoveTarget
,
1857 Move
.type = relation(Type
,
1861 Move
.effect
= markdown
.MoveEffectProperty('effect')
1862 Move
.effect_map
= markdown
.MoveEffectPropertyMap('effect_map')
1863 Move
.short_effect
= markdown
.MoveEffectProperty('short_effect')
1864 Move
.short_effect_map
= markdown
.MoveEffectPropertyMap('short_effect_map')
1866 MoveChangelog
.changed_in
= relation(VersionGroup
,
1867 innerjoin
=True, lazy
='joined',
1868 backref
='move_changelog')
1869 MoveChangelog
.move_effect
= relation(MoveEffect
,
1870 backref
='move_changelog')
1871 MoveChangelog
.type = relation(Type
,
1872 backref
='move_changelog')
1874 MoveChangelog
.effect
= markdown
.MoveEffectProperty('effect')
1875 MoveChangelog
.effect_map
= markdown
.MoveEffectPropertyMap('effect_map')
1876 MoveChangelog
.short_effect
= markdown
.MoveEffectProperty('short_effect')
1877 MoveChangelog
.short_effect_map
= markdown
.MoveEffectPropertyMap('short_effect_map')
1879 MoveEffect
.changelog
= relation(MoveEffectChangelog
,
1880 order_by
=MoveEffectChangelog
.changed_in_version_group_id
.desc(),
1881 backref
='move_effect')
1883 MoveEffectChangelog
.changed_in
= relation(VersionGroup
,
1884 innerjoin
=True, lazy
='joined',
1885 backref
='move_effect_changelog')
1887 MoveFlag
.flag
= relation(MoveFlagType
, innerjoin
=True, lazy
='joined')
1889 MoveFlavorText
.version_group
= relation(VersionGroup
,
1890 innerjoin
=True, lazy
='joined')
1891 MoveFlavorText
.language
= relation(Language
,
1892 innerjoin
=True, lazy
='joined')
1894 MoveMeta
.category
= relation(MoveMetaCategory
,
1895 innerjoin
=True, lazy
='joined',
1896 backref
='move_meta')
1897 MoveMeta
.ailment
= relation(MoveMetaAilment
,
1898 innerjoin
=True, lazy
='joined',
1899 backref
='move_meta')
1901 MoveMetaStatChange
.stat
= relation(Stat
,
1902 innerjoin
=True, lazy
='joined',
1903 backref
='move_meta_stat_changes')
1906 Nature
.decreased_stat
= relation(Stat
,
1907 primaryjoin
=Nature
.decreased_stat_id
==Stat
.id,
1909 backref
='decreasing_natures')
1910 Nature
.increased_stat
= relation(Stat
,
1911 primaryjoin
=Nature
.increased_stat_id
==Stat
.id,
1913 backref
='increasing_natures')
1914 Nature
.hates_flavor
= relation(ContestType
,
1915 primaryjoin
=Nature
.hates_flavor_id
==ContestType
.id,
1917 backref
='hating_natures')
1918 Nature
.likes_flavor
= relation(ContestType
,
1919 primaryjoin
=Nature
.likes_flavor_id
==ContestType
.id,
1921 backref
='liking_natures')
1922 Nature
.battle_style_preferences
= relation(NatureBattleStylePreference
,
1923 order_by
=NatureBattleStylePreference
.move_battle_style_id
.asc(),
1925 Nature
.pokeathlon_effects
= relation(NaturePokeathlonStat
,
1926 order_by
=NaturePokeathlonStat
.pokeathlon_stat_id
.asc())
1928 NatureBattleStylePreference
.battle_style
= relation(MoveBattleStyle
,
1929 innerjoin
=True, lazy
='joined',
1930 backref
='nature_preferences')
1932 NaturePokeathlonStat
.pokeathlon_stat
= relation(PokeathlonStat
,
1933 innerjoin
=True, lazy
='joined',
1934 backref
='nature_effects')
1937 Pokedex
.region
= relation(Region
,
1939 backref
='pokedexes')
1940 Pokedex
.version_groups
= relation(VersionGroup
,
1942 order_by
=VersionGroup
.id.asc(),
1946 Pokemon
.all_abilities
= relation(Ability
,
1947 secondary
=PokemonAbility
.__table__
,
1948 order_by
=PokemonAbility
.slot
.asc(),
1950 backref
=backref('all_pokemon',
1951 order_by
=Pokemon
.order
.asc(),
1954 Pokemon
.abilities
= relation(Ability
,
1955 secondary
=PokemonAbility
.__table__
,
1957 Pokemon
.id == PokemonAbility
.pokemon_id
,
1958 PokemonAbility
.is_dream
== False,
1961 order_by
=PokemonAbility
.slot
.asc(),
1962 backref
=backref('pokemon',
1963 order_by
=Pokemon
.order
.asc(),
1966 Pokemon
.dream_ability
= relation(Ability
,
1967 secondary
=PokemonAbility
.__table__
,
1969 Pokemon
.id == PokemonAbility
.pokemon_id
,
1970 PokemonAbility
.is_dream
== True,
1973 backref
=backref('dream_pokemon',
1974 order_by
=Pokemon
.order
,
1977 Pokemon
.pokemon_color
= relation(PokemonColor
,
1980 Pokemon
.color
= association_proxy('pokemon_color', 'name')
1981 Pokemon
.dex_numbers
= relation(PokemonDexNumber
,
1983 order_by
=PokemonDexNumber
.pokedex_id
.asc(),
1985 Pokemon
.egg_groups
= relation(EggGroup
,
1986 secondary
=PokemonEggGroup
.__table__
,
1988 order_by
=PokemonEggGroup
.egg_group_id
.asc(),
1989 backref
=backref('pokemon', order_by
=Pokemon
.order
.asc()))
1990 Pokemon
.evolution_chain
= relation(EvolutionChain
,
1992 backref
=backref('pokemon', order_by
=Pokemon
.order
.asc()))
1993 Pokemon
.parent_pokemon
= relation(Pokemon
,
1994 primaryjoin
=Pokemon
.evolves_from_pokemon_id
==Pokemon
.id,
1995 remote_side
=[Pokemon
.id],
1996 backref
='child_pokemon')
1997 Pokemon
.evolutions
= relation(PokemonEvolution
,
1998 primaryjoin
=Pokemon
.id==PokemonEvolution
.evolved_pokemon_id
,
1999 backref
=backref('evolved_pokemon', innerjoin
=True, lazy
='joined'))
2000 Pokemon
.flavor_text
= relation(PokemonFlavorText
,
2001 order_by
=PokemonFlavorText
.version_id
.asc(),
2003 Pokemon
.forms
= relation(PokemonForm
,
2004 primaryjoin
=Pokemon
.id==PokemonForm
.form_base_pokemon_id
,
2005 order_by
=(PokemonForm
.order
.asc(), PokemonForm
.identifier
.asc()))
2006 Pokemon
.default_form
= relation(PokemonForm
,
2008 Pokemon
.id==PokemonForm
.form_base_pokemon_id
,
2009 PokemonForm
.is_default
==True),
2011 Pokemon
.pokemon_habitat
= relation(PokemonHabitat
,
2013 Pokemon
.habitat
= association_proxy('pokemon_habitat', 'name')
2014 Pokemon
.items
= relation(PokemonItem
,
2016 Pokemon
.generation
= relation(Generation
,
2019 Pokemon
.shape
= relation(PokemonShape
,
2022 Pokemon
.stats
= relation(PokemonStat
,
2024 order_by
=PokemonStat
.stat_id
.asc(),
2026 Pokemon
.types
= relation(Type
,
2027 secondary
=PokemonType
.__table__
,
2029 order_by
=PokemonType
.slot
.asc(),
2030 backref
=backref('pokemon', order_by
=Pokemon
.order
))
2032 PokemonDexNumber
.pokedex
= relation(Pokedex
,
2033 innerjoin
=True, lazy
='joined')
2035 PokemonEvolution
.trigger
= relation(EvolutionTrigger
,
2036 innerjoin
=True, lazy
='joined',
2037 backref
='evolutions')
2038 PokemonEvolution
.trigger_item
= relation(Item
,
2039 primaryjoin
=PokemonEvolution
.trigger_item_id
==Item
.id,
2040 backref
='triggered_evolutions')
2041 PokemonEvolution
.held_item
= relation(Item
,
2042 primaryjoin
=PokemonEvolution
.held_item_id
==Item
.id,
2043 backref
='required_for_evolutions')
2044 PokemonEvolution
.location
= relation(Location
,
2045 backref
='triggered_evolutions')
2046 PokemonEvolution
.known_move
= relation(Move
,
2047 backref
='triggered_evolutions')
2048 PokemonEvolution
.party_pokemon
= relation(Pokemon
,
2049 primaryjoin
=PokemonEvolution
.party_pokemon_id
==Pokemon
.id,
2050 backref
='triggered_evolutions')
2051 PokemonEvolution
.trade_pokemon
= relation(Pokemon
,
2052 primaryjoin
=PokemonEvolution
.trade_pokemon_id
==Pokemon
.id)
2054 PokemonFlavorText
.version
= relation(Version
, innerjoin
=True, lazy
='joined')
2055 PokemonFlavorText
.language
= relation(Language
, innerjoin
=True, lazy
='joined')
2057 PokemonForm
.form_base_pokemon
= relation(Pokemon
,
2058 primaryjoin
=PokemonForm
.form_base_pokemon_id
==Pokemon
.id,
2060 PokemonForm
.unique_pokemon
= relation(Pokemon
,
2061 primaryjoin
=PokemonForm
.unique_pokemon_id
==Pokemon
.id,
2062 backref
=backref('unique_form', uselist
=False))
2063 PokemonForm
.version_group
= relation(VersionGroup
,
2065 PokemonForm
.form_group
= association_proxy('form_base_pokemon', 'form_group')
2066 PokemonForm
.pokeathlon_stats
= relation(PokemonFormPokeathlonStat
,
2067 order_by
=PokemonFormPokeathlonStat
.pokeathlon_stat_id
,
2068 backref
='pokemon_form')
2070 PokemonFormGroup
.pokemon
= relation(Pokemon
,
2072 backref
=backref('form_group', uselist
=False))
2074 PokemonFormPokeathlonStat
.pokeathlon_stat
= relation(PokeathlonStat
,
2075 innerjoin
=True, lazy
='joined')
2077 PokemonItem
.item
= relation(Item
,
2078 innerjoin
=True, lazy
='joined',
2080 PokemonItem
.version
= relation(Version
,
2081 innerjoin
=True, lazy
='joined')
2083 PokemonMove
.pokemon
= relation(Pokemon
,
2084 innerjoin
=True, lazy
='joined',
2085 backref
='pokemon_moves')
2086 PokemonMove
.version_group
= relation(VersionGroup
,
2087 innerjoin
=True, lazy
='joined')
2088 PokemonMove
.machine
= relation(Machine
,
2090 Machine
.version_group_id
==PokemonMove
.version_group_id
,
2091 Machine
.move_id
==PokemonMove
.move_id
),
2092 foreign_keys
=[Machine
.version_group_id
, Machine
.move_id
],
2094 backref
='pokemon_moves')
2095 PokemonMove
.move
= relation(Move
,
2096 innerjoin
=True, lazy
='joined',
2097 backref
='pokemon_moves')
2098 PokemonMove
.method
= relation(PokemonMoveMethod
,
2099 innerjoin
=True, lazy
='joined')
2101 PokemonStat
.stat
= relation(Stat
,
2102 innerjoin
=True, lazy
='joined')
2105 Region
.generation
= relation(Generation
, uselist
=False)
2106 Region
.version_group_regions
= relation(VersionGroupRegion
,
2107 order_by
=VersionGroupRegion
.version_group_id
.asc(),
2109 Region
.version_groups
= association_proxy('version_group_regions', 'version_group')
2112 Stat
.damage_class
= relation(MoveDamageClass
,
2115 StatHint
.stat
= relation(Stat
,
2120 SuperContestCombo
.first
= relation(Move
,
2121 primaryjoin
=SuperContestCombo
.first_move_id
==Move
.id,
2122 innerjoin
=True, lazy
='joined',
2123 backref
='super_contest_combo_first')
2124 SuperContestCombo
.second
= relation(Move
,
2125 primaryjoin
=SuperContestCombo
.second_move_id
==Move
.id,
2126 innerjoin
=True, lazy
='joined',
2127 backref
='super_contest_combo_second')
2130 Type
.damage_efficacies
= relation(TypeEfficacy
,
2131 primaryjoin
=Type
.id==TypeEfficacy
.damage_type_id
,
2132 backref
=backref('damage_type', innerjoin
=True, lazy
='joined'))
2133 Type
.target_efficacies
= relation(TypeEfficacy
,
2134 primaryjoin
=Type
.id==TypeEfficacy
.target_type_id
,
2135 backref
=backref('target_type', innerjoin
=True, lazy
='joined'))
2137 Type
.generation
= relation(Generation
,
2140 Type
.damage_class
= relation(MoveDamageClass
,
2144 Version
.generation
= association_proxy('version_group', 'generation')
2146 VersionGroup
.versions
= relation(Version
,
2148 order_by
=Version
.id,
2149 backref
=backref('version_group', lazy
='joined'))
2150 VersionGroup
.generation
= relation(Generation
,
2151 innerjoin
=True, lazy
='joined',
2152 backref
='version_groups')
2153 VersionGroup
.version_group_regions
= relation(VersionGroupRegion
,
2154 backref
='version_group')
2155 VersionGroup
.regions
= association_proxy('version_group_regions', 'region')