[sqlalchemy] one to may Commit

2011-01-15 Thread borisov
Hello. A have this model. How to make Order() and Orderitems() objects during one commit() I'm trying no = Order() noi = Orderitem() no.orderitems.append(noi) Session.add(no) Session.commit() but get an error IntegrityError: (IntegrityError) null value in column order_id violates not-null

Re: [sqlalchemy] one to may Commit

2011-01-15 Thread Michael Bayer
More information is needed. Test case, psycopg2, SQLA 0.6.6, works fine: from sqlalchemy import * from sqlalchemy.orm import * metadata= MetaData() orders_table = Table('orders', metadata, Column('id', Integer, primary_key=True, autoincrement=True), Column('created', DateTime,