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)