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

2012-10-02 Thread Christopher Loverich
Great, works as expected now. Not sure I understand it completely - I guess calling `table` with an existing table links to it and provides access to whatever columns you specified. Have to read up some more. Thanks again for the help. On Monday, October 1, 2012 10:39:43 PM UTC-5, Michael

[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') )

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

2012-10-01 Thread Michael Bayer
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, Christopher Loverich wrote: Hello. Loving alembic sqlachemy - really great