Python create_table_sql Examples

Example #1

File: create_db.py Project: thechrisfischer/tparkinson

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 

Example #2

File: create_db.py Project: thechrisfischer/tparkinson

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