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()
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()
