Add foreign type names to the database.

diff --git a/pokedex/data/csv/type_names.csv b/pokedex/data/csv/type_names.csv
new file mode 100644 (file)
index 0000000..1b30a33
--- /dev/null
+++ b/pokedex/data/csv/type_names.csv
@@ -0,0 +1,91 @@
+type_id,language_id,name
+1,1,ノーマル
+1,5,Normal
+1,6,Normal
+1,7,Normal
+1,8,Normale
+2,1,かくとう
+2,5,Combat
+2,6,Kampf
+2,7,Lucha
+2,8,Lotta
+3,1,ひこう
+3,5,Vol
+3,6,Flug
+3,7,Volador
+3,8,Volante
+4,1,どく
+4,5,Poison
+4,6,Gift
+4,7,Veneno
+4,8,Veleno
+5,1,じめん
+5,5,Sol
+5,6,Boden
+5,7,Tierra
+5,8,Terra
+6,1,いわ
+6,5,Roche
+6,6,Gestein
+6,7,Roca
+6,8,Roccia
+7,1,むし
+7,5,Insecte
+7,6,Käfer
+7,7,Bicho
+7,8,Coleottero
+8,1,ゴースト
+8,5,Spectre
+8,6,Geist
+8,7,Fantasma
+8,8,Spettro
+9,1,はがね
+9,5,Acier
+9,6,Stahl
+9,7,Acero
+9,8,Acciaio
+10,1,ほのお
+10,5,Feu
+10,6,Feuer
+10,7,Fuego
+10,8,Fuoco
+11,1,みず
+11,5,Eau
+11,6,Wasser
+11,7,Agua
+11,8,Acqua
+12,1,くさ
+12,5,Plante
+12,6,Pflanze
+12,7,Planta
+12,8,Erba
+13,1,でんき
+13,5,Electrik
+13,6,Electro
+13,7,Eléctrico
+13,8,Elettro
+14,1,エスパー
+14,5,Psy
+14,6,Psycho
+14,7,Psíquico
+14,8,Psico
+15,1,こおり
+15,5,Glace
+15,6,Eis
+15,7,Hielo
+15,8,Ghiaccio
+16,1,ドラゴン
+16,5,Dragon
+16,6,Drachen
+16,7,Dragón
+16,8,Drago
+17,1,あく
+17,5,Ténèbres
+17,6,Unlicht
+17,7,Siniestro
+17,8,Buio
+18,1,？？？
+18,5,???
+18,6,???
+18,7,???
+18,8,???

diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py
index b771dab..4271efd 100644 (file)
--- a/pokedex/db/tables.py
+++ b/pokedex/db/tables.py
@@ -688,6 +688,12 @@ class Type(TableBase):
     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
     damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=False) ## ??? is none; everything else is physical or special
 
+class TypeName(TableBase):
+    __tablename__ = 'type_names'
+    type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
+    language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
+    name = Column(Unicode(16), nullable=False)
+
 class VersionGroup(TableBase):
     __tablename__ = 'version_groups'
     id = Column(Integer, primary_key=True, nullable=False)
@@ -959,6 +965,9 @@ Type.target_efficacies = relation(TypeEfficacy,
 
 Type.generation = relation(Generation, backref='types')
 Type.damage_class = relation(MoveDamageClass, backref='types')
+Type.foreign_names = relation(TypeName, backref='type')
+
+TypeName.language = relation(Language)
 
 Version.version_group = relation(VersionGroup, backref='versions')
 Version.generation = association_proxy('version_group', 'generation')