def __str__(self):
return unicode(self).encode('utf8')
+ def __repr__(self):
+ return unicode(self).encode('utf8')
+
mapped_classes = []
class TableMetaclass(DeclarativeMeta):
def __init__(cls, name, bases, attrs):
info=dict(description="The name", format='plaintext', official=True, ripped=True)),
)
create_translation_table('ability_prose', Ability, 'prose',
- effect = Column(markdown.MarkdownColumn(5120), nullable=False,
+ effect = Column(markdown.MarkdownColumn(5120), nullable=True,
info=dict(description="A detailed description of this ability's effect", format='markdown')),
- short_effect = Column(markdown.MarkdownColumn(255), nullable=False,
+ short_effect = Column(markdown.MarkdownColumn(255), nullable=True,
info=dict(description="A short summary of this ability's effect", format='markdown')),
)
info=dict(description="The base number of hearts the user's opponent loses"))
create_translation_table('contest_effect_prose', ContestEffect, 'prose',
- flavor_text = Column(Unicode(64), nullable=False,
+ flavor_text = Column(Unicode(64), nullable=True,
info=dict(description="The in-game description of this effect", official=True, format='gametext')),
- effect = Column(Unicode(255), nullable=False,
+ effect = Column(Unicode(255), nullable=True,
info=dict(description="A detailed description of the effect", format='plaintext')),
)
create_translation_table('contest_type_names', ContestType, 'names',
relation_lazy='joined',
- name = Column(Unicode(6), nullable=False, index=True,
+ name = Column(Unicode(6), nullable=True, index=True,
info=dict(description="The name", format='plaintext', official=True)),
- flavor = Column(Unicode(6), nullable=False,
+ flavor = Column(Unicode(6), nullable=True,
info=dict(description="The name of the corresponding Berry flavor", official=True, format='plaintext')),
- color = Column(Unicode(6), nullable=False,
+ color = Column(Unicode(6), nullable=True,
info=dict(description=u"The name of the corresponding Pokéblock color", official=True, format='plaintext')),
)
info=dict(description="The name", format='plaintext', official=True, ripped=True)),
)
create_translation_table('item_prose', Item, 'prose',
- short_effect = Column(markdown.MarkdownColumn(256), nullable=False,
- info=dict(description="A short summary of the effect", format='plaintext')),
- effect = Column(markdown.MarkdownColumn(5120), nullable=False,
+ short_effect = Column(markdown.MarkdownColumn(256), nullable=True,
+ info=dict(description="A short summary of the effect", format='markdown')),
+ effect = Column(markdown.MarkdownColumn(5120), nullable=True,
info=dict(description=u"Detailed description of the item's effect.", format='markdown')),
)
create_translation_table('item_flavor_summaries', Item, 'flavor_summaries',
info=dict(description="Identifier of the flag", format='identifier'))
create_translation_table('item_flag_prose', ItemFlag, 'prose',
- name = Column(Unicode(24), nullable=False, index=True,
+ name = Column(Unicode(24), nullable=True, index=True,
info=dict(description="The name", format='plaintext', official=False)),
- description = Column(Unicode(64), nullable=False,
+ description = Column(Unicode(64), nullable=True,
info=dict(description="Short description of the flag", format='plaintext')),
)
create_translation_table('move_damage_class_prose', MoveDamageClass, 'prose',
relation_lazy='joined',
- name = Column(Unicode(16), nullable=False, index=True,
+ name = Column(Unicode(16), nullable=True, index=True,
info=dict(description="The name", format='plaintext', official=False)),
- description = Column(Unicode(64), nullable=False,
+ description = Column(Unicode(64), nullable=True,
info=dict(description="A description of the class", format='plaintext')),
)
info=dict(description="A numeric ID"))
create_translation_table('move_effect_prose', MoveEffect, 'prose',
- short_effect = Column(Unicode(256), nullable=False,
+ short_effect = Column(Unicode(256), nullable=True,
info=dict(description="A short summary of the effect", format='plaintext')),
- effect = Column(Unicode(5120), nullable=False,
+ effect = Column(Unicode(5120), nullable=True,
info=dict(description="A detailed description of the effect", format='plaintext')),
)
-class MoveEffectCategory(TableBase):
- u"""Category of a move effect
- """
- __tablename__ = 'move_effect_categories'
- __singlename__ = 'move_effect_category'
- id = Column(Integer, primary_key=True, nullable=False,
- info=dict(description="A numeric ID"))
- identifier = Column(Unicode(64), nullable=False,
- info=dict(description="An identifier", format='identifier'))
- can_affect_user = Column(Boolean, nullable=False,
- info=dict(description="Set if the user can be affected"))
-
-create_translation_table('move_effect_category_prose', MoveEffectCategory, 'prose',
- name = Column(Unicode(64), nullable=False, index=True,
- info=dict(description="The name", format='plaintext', official=False)),
-)
-
-class MoveEffectCategoryMap(TableBase):
- u"""Maps a move effect category to a move effect
- """
- __tablename__ = 'move_effect_category_map'
- move_effect_id = Column(Integer, ForeignKey('move_effects.id'), primary_key=True, nullable=False,
- info=dict(description="ID of the move effect"))
- move_effect_category_id = Column(Integer, ForeignKey('move_effect_categories.id'), primary_key=True, nullable=False,
- info=dict(description="ID of the category"))
- affects_user = Column(Boolean, primary_key=True, nullable=False,
- info=dict(description="Set if the user is affected"))
-
class MoveEffectChangelog(TableBase):
"""History of changes to move effects across main game versions."""
__tablename__ = 'move_effect_changelog'
create_translation_table('move_flag_type_prose', MoveFlagType, 'prose',
relation_lazy='joined',
- name = Column(Unicode(32), nullable=False, index=True,
+ name = Column(Unicode(32), nullable=True, index=True,
info=dict(description="The name", format='plaintext', official=False)),
- description = Column(markdown.MarkdownColumn(128), nullable=False,
+ description = Column(markdown.MarkdownColumn(128), nullable=True,
info=dict(description="A short description of the flag", format='markdown')),
)
__singlename__ = 'move_meta_ailment'
id = Column(Integer, primary_key=True, nullable=False, autoincrement=False,
info=dict(description="A numeric ID"))
- identifier = Column(Unicode(24), nullable=False,
+ identifier = Column(Unicode(24), nullable=False, index=True, unique=True,
info=dict(description="An identifier", format='identifier'))
create_translation_table('move_meta_ailment_names', MoveMetaAilment, 'names',
__singlename__ = 'move_meta_category'
id = Column(Integer, primary_key=True, nullable=False,
info=dict(description="A numeric ID"))
+ identifier = Column(Unicode(32), nullable=False, index=True, unique=True,
+ info=dict(description="An identifier", format='identifier'))
create_translation_table('move_meta_category_prose', MoveMetaCategory, 'prose',
relation_lazy='joined',
create_translation_table('move_target_prose', MoveTarget, 'prose',
relation_lazy='joined',
- name = Column(Unicode(32), nullable=False, index=True,
+ name = Column(Unicode(32), nullable=True, index=True,
info=dict(description="The name", format='plaintext', official=False)),
- description = Column(Unicode(128), nullable=False,
+ description = Column(Unicode(128), nullable=True,
info=dict(description="A description", format='plaintext')),
)
create_translation_table('pokedex_prose', Pokedex, 'prose',
relation_lazy='joined',
- name = Column(Unicode(16), nullable=False, index=True,
+ name = Column(Unicode(16), nullable=True, index=True,
info=dict(description="The name", format='plaintext', official=False)),
- description = Column(Unicode(512), nullable=False,
+ description = Column(Unicode(512), nullable=True,
info=dict(description=u"A longer description of the Pokédex", format='plaintext')),
)
create_translation_table('pokemon_names', Pokemon, 'names',
relation_lazy='joined',
- name = Column(Unicode(20), nullable=False, index=True,
+ name = Column(Unicode(20), nullable=True, index=True,
info=dict(description="The name", format='plaintext', official=True, ripped=True)),
- species = Column(Unicode(16), nullable=False,
+ species = Column(Unicode(16), nullable=True,
info=dict(description=u'The short flavor text, such as "Seed" or "Lizard"; usually affixed with the word "Pokémon"',
official=True, format='plaintext')),
)
create_translation_table('pokemon_form_group_prose', PokemonFormGroup, 'prose',
term = Column(Unicode(16), nullable=True,
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')),
- description = Column(markdown.MarkdownColumn(1024), nullable=False,
+ description = Column(markdown.MarkdownColumn(1024), nullable=True,
info=dict(description=u"Description of how the forms work", format='markdown')),
)
create_translation_table('pokemon_move_method_prose', PokemonMoveMethod, 'prose',
relation_lazy='joined',
- name = Column(Unicode(64), nullable=False, index=True,
+ name = Column(Unicode(64), nullable=True, index=True,
info=dict(description="The name", format='plaintext', official=False)),
- description = Column(Unicode(255), nullable=False,
+ description = Column(Unicode(255), nullable=True,
info=dict(description=u"A detailed description of how the method works", format='plaintext')),
)
create_translation_table('pokemon_shape_prose', PokemonShape, 'prose',
relation_lazy='joined',
- name = Column(Unicode(24), nullable=False, index=True,
+ name = Column(Unicode(24), nullable=True, index=True,
info=dict(description="The name", format='plaintext', official=False)),
- awesome_name = Column(Unicode(16), nullable=False,
+ awesome_name = Column(Unicode(16), nullable=True,
info=dict(description=u"A splendiferous name of the body shape", format='plaintext')),
)
MoveChangelog.short_effect = markdown.MoveEffectProperty('short_effect')
MoveChangelog.short_effect_map = markdown.MoveEffectPropertyMap('short_effect_map')
-MoveEffect.category_map = relation(MoveEffectCategoryMap)
-MoveEffect.categories = association_proxy('category_map', 'category')
MoveEffect.changelog = relation(MoveEffectChangelog,
order_by=MoveEffectChangelog.changed_in_version_group_id.desc(),
backref='move_effect')
-MoveEffectCategoryMap.category = relation(MoveEffectCategory)
MoveEffectChangelog.changed_in = relation(VersionGroup,
innerjoin=True, lazy='joined',