def setupdb(filepath, config):
print "Creating database..."
datastore = Datastore(filepath)
cursor = datastore.connect()
cleanup(cursor)
datastore.commit()
create_tables(cursor)
datastore.commit()
ansi = Datastore('/tmp/ansi.db')
c = ansi.connect()
cleanup(c)
load_ansi(c, 'national.txt')
ansi.commit()
ansi.close()
load_data(cursor, config)
datastore.commit()
update_data(cursor)
datastore.commit()
datastore.close()
def build():
ds = Datastore(f'{homeDir}lootnika_tasks_journal.db')
try:
newRst = check_rst(ds)
except Exception as e:
log.fatal(f"Error: fail check docs rst: {traceback.format_exc()}")
sphinxecutor(newRst)
snapshot(ds, newRst)
ds.close()
def get_locality(county_id, state_fips):
ds = Datastore('/tmp/ansi.db')
c = ds.connect()
c.execute(
"""SELECT state_id, county_id, county_name
FROM
Ansi
WHERE
state_id=? AND
county_id=?""",
(
state_fips,
county_id,
)
)
row = dict(c.fetchone())
id = "".join([str(row['state_id']),str(row['county_id']).rjust(3,'0')])
name = row['county_name']
ds.close()
return (id,name,)
