def create_pipl():
fname = "il_pipl.csv"
sql = dtools.create_table_sql(fname)
for command in sql:
curs.execute(command)
conn.commit()
print "created tables for " + fname
return
def create_il_properties():
fname = "il_properties.csv"
tname = fname.replace('.csv', '')
sql = dtools.create_table_sql(fname)
for command in sql:
curs.execute(command)
curs.execute("CREATE UNIQUE INDEX unique_name ON il_properties (address);")
conn.commit()
print "created tables for " + fname
return