[sqlalchemy] Outerjoin on Subselect?

2007-09-09 Thread Aaron R
Hello all; I am trying to do a subselect on an Outer join. I have a table of votes that can apply to multiple objects in my system so their is no direct foreign key. A Voteable type implementation. When i load the list of Projects, i want to return the current users votes eagerly if possible,

[sqlalchemy] Self Referencing through Association?

2007-09-01 Thread Aaron R
Hello, I am trying to create a self reference so that a Node has children and parents but the information is stored in an association parent so that a Node can have more than one parent. http://www.sqlalchemy.org/docs/04/mappers.html#advdatamapping_relation_selfreferential Tables like this: