def populate_ugc_table(): try: db = DB() db.copy_from(ugc_data_path, 'ugc', columns=('state', 'zone', 'cwa', 'name', 'state_zone', 'countyname', 'fips', 'time_zone', 'fe_area', 'lat', 'lon'), sep="|") db.commit() except Exception as e: print e db.rollback()
def populate_fips_table(): try: db = DB() db.copy_from(fips_data_path_1, 'fips', columns=('geometry', 'lat', 'lon', 'state', 'cwa', 'countyname', 'fips', 'time_zone', 'fe_area'), sep="|") db.commit() db.copy_from(fips_data_path_2, 'fips', columns=('geometry', 'lat', 'lon', 'state', 'cwa', 'countyname', 'fips', 'time_zone', 'fe_area'), sep="|") db.commit() except Exception as e: print e db.rollback()