initialize_region.py
415 Bytes
import csv, re, sqlite3
con = sqlite3.connect("database2.db")
cur = con.cursor()
f = open("region_init", "w+")
toWrite = ''
for i in range(0, 1373):
cur.execute("Select region from region where ug like "+str(i))
result = cur.fetchall()
if(result == []):
toWrite = "Null\n"
else:
toWrite = str(result[0]).replace(')','').replace('(','').replace('\'','')
toWrite = toWrite[:-1]+"\n"
f.write(toWrite)