From b1e513dbb14e2f514da1bb43f9c1ab2b2aa8ea80 Mon Sep 17 00:00:00 2001
From: a_magical_me <andrew@turnipmints.mooo.com>
Date: Sun, 3 Apr 2011 05:16:15 -0700
Subject: [PATCH] Add script for adding B/W locations

in the hope that it will be useful in future generations.
---
 scripts/add-bw-locations.py | 49 +++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100755 scripts/add-bw-locations.py

diff --git a/scripts/add-bw-locations.py b/scripts/add-bw-locations.py
new file mode 100755
index 0000000..5f031a0
--- /dev/null
+++ b/scripts/add-bw-locations.py
@@ -0,0 +1,49 @@
+#!/usr/bin/env python2
+
+from codecs import open
+
+from pokedex.db import connect, identifier_from_name
+from pokedex.db.tables import Language
+from pokedex.db.tables import Location, LocationGameIndex
+
+session = connect()
+
+en = session.query(Language).filter_by(identifier='en').one() # English
+ja = session.query(Language).filter_by(identifier='ja').one() # Japanese
+
+with open("bw-location-names-en", "r", "utf-8") as f:
+    en_names = [line.rstrip("\n") for line in f]
+with open("bw-location-names-kanji", "r", "utf-8") as f:
+    ja_names = [line.rstrip("\n") for line in f]
+
+locations = {}
+for i, name in enumerate(zip(en_names, ja_names)):
+    if i == 0:
+        continue
+
+    en_name, ja_name = name
+    if not en_name:
+        continue
+
+    if name in locations:
+        loc = locations[name]
+    else:
+        loc = Location()
+        if en_name:
+            loc.name_map[en] = en_name
+        if ja_name:
+            loc.name_map[ja] = ja_name
+        loc.region_id = 5 # Unova
+        loc.identifier = identifier_from_name(en_name)
+
+        locations[name] = loc
+
+    lgi = LocationGameIndex()
+    lgi.location = loc
+    lgi.generation_id = 5 # Gen 5
+    lgi.game_index = i
+
+    session.add(loc)
+    session.add(lgi)
+
+session.commit()
-- 
2.7.4