"offsets" and "transaction" need to be combined into one relation with
a backref() so that an attribute set on one side generates a
collection add on the other. Backrefs are described in the ORM
tutorial and mapper configuration docs, to send arguments to a backref
use the backref() function (examples are also within those docs).
On Jun 6, 2008, at 12:08 PM, Brad Wells wrote:
>
> 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 [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
-~----------~----~----~----~------~----~------~--~---
