Re: [sqlalchemy] Alembic bulk_insert when primary key is a String

2012-10-02 Thread Christopher Loverich
Bayer wrote: > > yeah you just need to create table() there with the columns you want as > well: > > proc_table = table('generalprocedures_lu', column('procedure', String)) > op.bulk_insert(proc_table, ...) > > > On Oct 1, 2012, at 10:49 PM, Christop

[sqlalchemy] Alembic bulk_insert when primary key is a String

2012-10-01 Thread Christopher Loverich
Hello.* Loving* alembic & sqlachemy - really great libraries. Just having a bit of trouble with something: op.create_table('generalprocedures_lu', sa.Column('procedure', sa.String(length=80), nullable=False), sa.PrimaryKeyConstraint('procedure') ) op.bulk_insert(table('generalprocedu