well ... just bumped at "Bundle". it does the job :)
http://docs.sqlalchemy.org/en/rel_0_9/orm/query.html?highlight=aliased#sqlalchemy.orm.query.Bundle
best regards,
richard.
On 03/20/2014 02:20 PM, Richard Gerd Kuesters wrote:
thanks Ladislav!
yup, that one gives me what i want, but i was kinda working on plain
select([col1, col2], from_obj=....) function :)
but nevermind bothering, its just part of a building process that's
i'm writing in SA (instead of making them by hand), people are used to
do selects like the one i described ... i already made a join, i think
i bothered people enough (here) because of that ;)
my best regards,
richard.
On 03/20/2014 10:35 AM, Ladislav Lenart wrote:
Hello.
On 20.3.2014 12:13, Richard Gerd Kuesters wrote:
thanks again, AM. no need to have this "extra trouble", as I just asking this as
a matter of curiosity. it thought it was something rather simple as hell :)
I think the following:
q = session.query(A, B).filter(A.b_id == B.id)
print q
# for eachA, eachB in q...
should produce what you want:
SELECT A.*, B.* FROM A, B WHERE A.b_id = B.id
HTH,
Ladislav Lenart
--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to sqlalchemy+unsubscr...@googlegroups.com
<mailto:sqlalchemy+unsubscr...@googlegroups.com>.
To post to this group, send email to sqlalchemy@googlegroups.com
<mailto:sqlalchemy@googlegroups.com>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
