Excerpts from Ergo's message of Sun Jun 27 14:11:58 -0300 2010: > Hello, > > I'm looking for a way to execute a recursive query and get ORM > instances with it. > > http://www.postgresql.org/docs/8.4/interactive/queries-with.html > > I know we don't have any direct support for recursive syntax in SA, > but is there a way to execure arbitrary query that would return all > the data to build ORM objects and use those objects later ? >
I built a little extension to support WITH RECURSIVE with SA's SQL Expression Language. You can find all about it here [1]. It might not address your problem directly but you might use it as inspiration. http://www.sqlalchemy.org/trac/wiki/UsageRecipes/PgsqlRecursive -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
