def dump_table(engine, table): file_name = '%s-%s.csv' % (table.name, datetime.utcnow().strftime("%Y-%m-%d")) fh = open(file_name, 'wb') sl.dump_csv(sl.all(engine, table), fh)
def dump_query(engine, q, file_name): fh = open(file_name, 'wb') rp = engine.execute(q) sl.dump_csv(sl.resultiter(rp), fh)