X-Git-Url: http://git.veekun.com/zzz-pokedex.git/blobdiff_plain/2efa91d9daf718debf9ed920efaf02a155054cac..4041d85dff793268e3e80287d2c2fcc7618182bb:/pokedex/db/tables.py?ds=inline diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py index a7dd9c8..19289c1 100644 --- a/pokedex/db/tables.py +++ b/pokedex/db/tables.py @@ -14,6 +14,7 @@ TableBase = declarative_base(metadata=metadata) class Ability(TableBase): __tablename__ = 'abilities' + __singlename__ = 'ability' id = Column(Integer, primary_key=True, nullable=False) name = Column(Unicode(24), nullable=False) flavor_text = Column(Unicode(64), nullable=False) @@ -138,6 +139,7 @@ class GrowthRate(TableBase): class Item(TableBase): __tablename__ = 'items' + __singlename__ = 'item' id = Column(Integer, primary_key=True, nullable=False) name = Column(Unicode(16), nullable=False) @@ -148,6 +150,7 @@ class Language(TableBase): class Location(TableBase): __tablename__ = 'locations' + __singlename__ = 'location' id = Column(Integer, primary_key=True, nullable=False) generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False) name = Column(Unicode(64), nullable=False) @@ -175,7 +178,7 @@ class MoveEffect(TableBase): __tablename__ = 'move_effects' id = Column(Integer, primary_key=True, nullable=False) priority = Column(SmallInteger, nullable=False) - short_effect = Column(Unicode(128), nullable=False) + short_effect = Column(Unicode(256), nullable=False) effect = Column(Unicode(5120), nullable=False) class MoveTarget(TableBase): @@ -186,6 +189,7 @@ class MoveTarget(TableBase): class Move(TableBase): __tablename__ = 'moves' + __singlename__ = 'move' id = Column(Integer, primary_key=True, nullable=False) name = Column(Unicode(12), nullable=False) generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False) @@ -211,6 +215,7 @@ class Pokemon(TableBase): purely cosmetic forms like Unown. """ __tablename__ = 'pokemon' + __singlename__ = 'pokemon' id = Column(Integer, primary_key=True, nullable=False) name = Column(Unicode(20), nullable=False) forme_name = Column(Unicode(16)) @@ -360,6 +365,7 @@ class TypeEfficacy(TableBase): class Type(TableBase): __tablename__ = 'types' + __singlename__ = 'type' id = Column(Integer, primary_key=True, nullable=False) name = Column(Unicode(8), nullable=False) abbreviation = Column(Unicode(3), nullable=False) @@ -403,9 +409,9 @@ Move.machines = relation(Machine, backref='move') Move.target = relation(MoveTarget, backref='moves') Move.type = relation(Type, backref='moves') -Move.effect = rst.MoveEffectProperty() +Move.effect = rst.MoveEffectProperty('effect') Move.priority = association_proxy('move_effect', 'priority') -Move.short_effect = association_proxy('move_effect', 'short_effect') +Move.short_effect = rst.MoveEffectProperty('short_effect') Pokemon.abilities = relation(Ability, secondary=PokemonAbility.__table__, order_by=PokemonAbility.slot,