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.
