nested sets is pretty tough with the ORM as it requires a mode of operation that resists the ORM's natural state of batching.
Have you looked at an existing package like https://pypi.python.org/pypi/SQLAlchemy-ORM-tree/ ? On Feb 21, 2013, at 10:19 AM, Grzegorz Śliwiński <[email protected]> wrote: > Some time ago I created a NestedSet listeners for sqlalchemy. > > They utilise left/right reaches along with depth and parent_id fields. It > works almost as expected, however I still have some issues especially in the > updating, and can't seem to pinpoint the source, where I'm getting different > than expected results. > > The source for listeners can be found here: > > https://gist.github.com/fizyk/4757230 > > > It contains also test I created so far (but all of them passes). > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
