[sqlalchemy] Re: Adjacency list problem

2009-08-13 Thread Michael Bayer
droolz wrote: mapper(ArkInvoice, invoices_table, properties={ 'entries': relation(ArkInvoiceEntry, secondary=invoice_entries_primary_table, backref='invoice', cascade=all, delete, delete-orphan), 'user': relation(ArkUsers, backref='user'), 'child_invoices':relation(ArkInvoice,

[sqlalchemy] Re: Adjacency list problem

2009-08-13 Thread Jules Stevenson
the mapping seems perfect to me.  parent_invoice would only be None for the actual parent.  perhaps there's some issue with your usage.   check your SQL echoing to make sure things are as expected. My bad, was using 5.0, not 5.5 - just upgraded and it works fine.