"Characteristic" text, here called stat hints.

diff --git a/pokedex/data/csv/stat_hints.csv b/pokedex/data/csv/stat_hints.csv
new file mode 100644 (file)
index 0000000..4579a31
--- /dev/null
+++ b/pokedex/data/csv/stat_hints.csv
@@ -0,0 +1,31 @@
+id,stat_id,gene_mod_5,text
+1,1,0,Loves to eat
+2,2,0,Proud of its power
+3,3,0,Sturdy body
+4,4,0,Highly curious
+5,5,0,Strong willed
+6,6,0,Likes to run
+7,1,1,Often dozes off
+8,2,1,Likes to thrash about
+9,3,1,Capable of taking hits
+10,4,1,Mischievous
+11,5,1,Somewhat vain
+12,6,1,Alert to sounds
+13,1,2,Often scatters things
+14,2,2,A little quick tempered
+15,3,2,Highly persistent
+16,4,2,Thoroughly cunning
+17,5,2,Strongly defiant
+18,6,2,Impetuous and silly
+19,1,3,Scatters things often
+20,2,3,Likes to fight
+21,3,3,Good endurance
+22,4,3,Often lost in thought
+23,5,3,Hates to lose
+24,6,3,Somewhat of a clown
+25,1,4,Likes to relax
+26,2,4,Quick tempered
+27,3,4,Good perseverance
+28,4,4,Very finicky
+29,5,4,Somewhat stubborn
+30,6,4,Quick to flee

diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py
index c8d48fe..adac6f1 100644 (file)
--- a/pokedex/db/tables.py
+++ b/pokedex/db/tables.py
@@ -1258,6 +1258,17 @@ class Stat(TableBase):
     name = Column(Unicode(16), nullable=False,
         info=dict(description=u"The English name of the stat", official=True, format='plaintext'))
 
     name = Column(Unicode(16), nullable=False,
         info=dict(description=u"The English name of the stat", official=True, format='plaintext'))
 

+class StatHint(TableBase):
+    u"""Flavor text for genes that appears in a Pokémon's summary.  Sometimes
+    called "characteristics".
+    """
+    __tablename__ = 'stat_hints'
+    id = Column(Integer, primary_key=True, nullable=False)
+    stat_id = Column(Integer, ForeignKey('stats.id'), nullable=False)
+    gene_mod_5 = Column(Integer, nullable=False, index=True)
+    text = Column(Unicode(24), nullable=False, index=True, unique=True,
+        info=dict(description=u"The English text displayed", official=True, format='plaintext'))
+

 class SuperContestCombo(TableBase):
     u"""Combo of two moves in a Super Contest.
     """
 class SuperContestCombo(TableBase):
     u"""Combo of two moves in a Super Contest.
     """


@@ -1662,6 +1673,8 @@ Region.version_groups = association_proxy('version_group_regions', 'version_grou
 
 Stat.damage_class = relation(MoveDamageClass, backref='stats')
 
 
 Stat.damage_class = relation(MoveDamageClass, backref='stats')
 

+StatHint.stat = relation(Stat, backref='hints')
+

 SuperContestCombo.first = relation(Move, primaryjoin=SuperContestCombo.first_move_id==Move.id,
                                         backref='super_contest_combo_first')
 SuperContestCombo.second = relation(Move, primaryjoin=SuperContestCombo.second_move_id==Move.id,
 SuperContestCombo.first = relation(Move, primaryjoin=SuperContestCombo.first_move_id==Move.id,
                                         backref='super_contest_combo_first')
 SuperContestCombo.second = relation(Move, primaryjoin=SuperContestCombo.second_move_id==Move.id,