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 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('generalprocedures_lu'), > [ > {'procedure':u'Fetoscopic guided laser photocoagulation'} > ], > ) > > The above fails with: > sqlalchemy.exc.IntegrityError: (IntegrityError) null value in column > "procedure" violates not-null constraint > 'INSERT INTO generalprocedures_lu DEFAULT VALUES' {} > > If I attempt to insert multiple rows, alembic seems to try and insert > multiple empty {}'s. Also, *confused* about the 'DEFAULT' argument. > > My apologies if I'm doing something very wrong here (ott single column lookup > table ^^), but I"m not sure what to try as a work-around. I attempted using a > traditional lookup table with an integer primary key, but got the same > results. If I leave out the bulk insert, I can manually put in values. > Database is Postgres 9.2 (if relevant). Let me know if I need to give a more > complete example. > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sqlalchemy/-/baybV1cO4ecJ. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.