Hi! I have 2 relations: - recipes-categories (M:N) - recipes-flags (M:N)
I'd like to get something like:
SELECT recipes.title FROM recipes
JOIN _recipes_ctgs_recipes
ON _recipes_ctgs_recipes.id_recipe = recipes.id
JOIN recipes_ctgs
ON _recipes_ctgs_recipes.id_recipes_ctg=recipes_ctgs.id
JOIN _recipes_flgs_recipes
ON _recipes_flgs_recipes.id_recipe = recipes.id
JOIN recipes_flgs
ON _recipes_flgs_recipes.id_recipes_flg=recipes_flgs.id
WHERE recipes_ctgs.title='cat1' AND recipes_flgs.title='flag1'
when I run
sess.query(Recipe).join("ctgs").join("flgs").select(...)
it fails with
sqlalchemy.exceptions.SQLError: (ProgrammingError) table name
"_recipes_ctgs_recipes" specified more than once
where "_recipes_ctgs_recipes" is a secondary table. Full example attached.
SA 0.3.7, PostgreSQL 8.1
David
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
test.tgz
Description: GNU Unix tar archive
