def setUpClass(self): remove_existing_databases() make_assignee_db() make_inventor_db() self.conn = sqlite3.connect("hashTbl.sqlite3") self.cursor = self.conn.cursor() create_sql_helper_functions(self.conn) create_hashtbl(self.cursor, self.conn)
import datetime # TODO: cover geocode setup functions with unit tests. import sqlite3 import geocode_setup # geocode_replace_loc consists of a series of functions, # each with a SQL statement that is passed as a parameter # to replace_loc. Uses temporary tables for handling # intermediate relations. import geocode_replace_loc conn = sqlite3.connect("hashTbl.sqlite3") c = conn.cursor() geocode_setup.create_sql_helper_functions(conn) print "Start setup for geocoding: ", datetime.datetime.now() geocode_setup.create_hashtbl(c, conn) print "Finish setup for geocoding: ", datetime.datetime.now() # End of setup. # Exiting here gets the initial hashTbl.sqlite3 file when # executed as `python lib/geocode.py` #exit() 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)