Hello,I need some hints on how to build a query on a data structure which turned out to be a hierarchy. Please find the picture of the EER diagram attached. I want to get all "note" entities for a given project with their corresponding project, shots and assets. Something like:
(project1, shot1, asset1, note1) (project1, shot1, asset1, note2) (project1, shot1, asset2, note1)
No problem with joins.
but I also want to get also:
(project1, None, None, note1)
(project1, Shot1, None, note1)
How is this possible with one query?
Cheers
Sebastian
--
Sebastian Elsner - pipeline td - r i s e | fx
t: +49 30 20180300 sebast...@risefx.com
www.risefx.com
r i s e | fx GmbH
Schlesische Strasse 28 Aufgang B, 10997 Berlin
Geschäftsführer: Sven Pannicke, Robert Pinnow
Handelsregister Berlin HRB 106667 B
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@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.
<<attachment: hierarchy.png>>
