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)