Alembic bulk_insert when primary key is a String

[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('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. 

[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, ...)

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

[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.