With the following simplified setup I receive the following error: FlushError: instance <erp.model.financial.TransactionOffset object at 0x0203CC90> is an unsaved, pending instance and is an orphan (is not attached to any parent 'Transaction' instance via that classes' 'offsets' attribute)
When attempting something along the lines of transactions = Transaction.query.all() offset = TransactionOffset() offset.transaction = transactions[4] offset.offset_transaction = transactions[5] meta.Session.commit() However, if I append offset to transactions[4].offsets it will save transaction_id, but not offset_transaction_id Classes: class Transaction(Entity): pass class TransactionOffset(Entity): pass Tables: transactions = Table('transactions', meta, Column('id', Integer, primary_key=True), Column('date', Date), Column('description', Text), Column('amount', Float), Column('transaction_code', String(50)), Column('approval_code', String(50)), Column('voided_at', DateTime), ) transaction_offsets = Table('transaction_offsets', meta, Column('id', Integer, primary_key=True), Column('amount', Float), Column('transaction_id', Integer), Column('offset_transaction_id', Integer), ForeignKeyConstraint(['transaction_id'], ['transactions.id']), ForeignKeyConstraint(['offset_transaction_id'], ['transactions.id']), ) Mappers: transactions_mapper = mapper(Transaction, transactions, properties={ 'offsets': relation(TransactionOffset, primaryjoin=transaction_offsets.c.transaction_id==transactions.c.id, cascade='all, delete- orphan'), }) mapper(TransactionOffset, transaction_offsets, properties={ 'transaction': relation(Transaction, primaryjoin=transaction_offsets.c.transaction_id==transactions.c.id, post_update=True), 'offset_transaction': relation(Transaction, primaryjoin=transaction_offsets.c.offset_transaction_id==transactions.c.id, post_update=True), }) -brad --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---