Example #1
0
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
Example #2
0
def copy_to_table(table_name, file):
    mem_str = prepare_csv(file)
    session = Session()
    session.copy_from(mem_str, table_name)