def create_table_from_headers(name, headers): e = Session.engine() metadata= MetaData(bind=e) table = Table(name, metadata, Column('id', Integer, primary_key=True), *(Column(head, Unicode(255)) for head in headers)) metadata.create_all() return 0
def copy_to_table(table_name, file): mem_str = prepare_csv(file) session = Session() session.copy_from(mem_str, table_name)