def replace_loc(script): c.execute("DROP TABLE IF EXISTS temp1") c.execute("CREATE TEMPORARY TABLE temp1 (jaro_match_value FLOAT, count INTEGER, \ cityA TEXT, stateA TEXT, countryA TEXT, ncity TEXT, nstate TEXT, ncountry TEXT, nlat FLOAT, nlong FLOAT);") c.execute("INSERT OR REPLACE INTO temp1 %s;" % script) #print_table_info(c) # TODO: Which tables will pass this conditional? if table_temp1_has_rows(c): geocode_replace_loc.create_loc_and_locmerge_tables(c) geocode_replace_loc.print_loc_and_merge(c) conn.commit()
def replace_loc(script): c.execute("DROP TABLE IF EXISTS temp1") c.execute("CREATE TEMPORARY TABLE temp1 AS %s" % script) # Apparently, this tmp1_idx is either superfluous or redundant. #c.execute("CREATE INDEX IF NOT EXISTS tmp1_idx ON temp1 (CityA, StateA, CountryA, ZipcodeA)") #print_table_info(c) # TODO: Which tables will pass this conditional? if table_temp1_has_rows(c): geocode_replace_loc.create_loc_and_locmerge_tables(c) geocode_replace_loc.print_loc_and_merge(c) conn.commit()