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