def get_results(table, i, year, data):
data_set = ','.join([f'{x} char' for x in data])
api_set = ','.join([f'{x}' for x in data])
census_call = c.get_table(f'{table}.csv')
try:
results = census_call(api_set, year)
for r in results[1:]:
countyid = r[-1]
stateid = r[-2]
tablename = f'{table}_{stateid}_{countyid}_{i}'
if tablename not in db.get_tables():
db.create_data_table(tablename, stateid, countyid, data_set)
data_package = [[data[i], r[i]] for i in range(len(data))]
db.populate_dataset(tablename, stateid, countyid, data_package, year)
except:
pass
def _test(argv):
print database.get_tables()
def ls(self, argv):
"""ls
List available tables."""
names = database.get_tables()
self._print("\n".join(names))
def _reset_scopes(self):
names = database.get_tables()
self.add_completion_scope("add", names)
self.add_completion_scope("create", names)
self.add_completion_scope("edit", names)
# from __future__ import unicode_literal
from database import get_tables
from database import execute
from xlsxhelper import write_document
if __name__ == "__main__":
table_list = get_tables()
for table in table_list:
try:
table_name = table[2]
query = "SELECT * FROM {0}".format(table_name)
results = execute(query)
write_document("data/{0}.xlsx".format(table_name), results)
print("{0}.xlsx imported".format(table_name))
except:
pass
