So, I've spent quite a long time working on this, with many nights
spent sleepless, and I've eventually managed to create a monster. :P
The class described in the following TG Docs link works quite well,
but could use some optimization which, alas, I do not have the skill
to perform. Basically it's a combination of a nested set model and
adjacency list model, giving you the joys of both. Some things, like
single-level children, are hard to query using pure nested sets,
whereas adjacency lists make those queries trivial.
The reason I'm posting it as-is is because I'll be porting this to
SQLAlchemy today. *winces*
http://docs.turbogears.org/1.0/HybridNestedSetModel
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---