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 [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
