Re: [sqlalchemy] a [probably] stupid query question

2014-03-20 Thread Richard Gerd Kuesters
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 :) best regards, richard. On 03/19/2014 09:50 PM, AM wrote: Not at my desk so I cannot test this, but IIRC in the select you can specify

Re: [sqlalchemy] a [probably] stupid query question

2014-03-20 Thread Ladislav Lenart
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 #

Re: [sqlalchemy] a [probably] stupid query question

2014-03-20 Thread Richard Gerd Kuesters
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

Re: [sqlalchemy] a [probably] stupid query question

2014-03-20 Thread Richard Gerd Kuesters
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

[sqlalchemy] a [probably] stupid query question

2014-03-19 Thread Richard Gerd Kuesters
hi, i have a simple stupid query question, which i didn't found any examples. let's say i have table A and B, and would like to reproduce in SA the following SQL: SELECT A.*, B.* FROM A, B WHERE A.b_id = B.id i would probably need a new fuse, too ... best regards, richard. -- You received

Re: [sqlalchemy] a [probably] stupid query question

2014-03-19 Thread AM
On 03/19/2014 02:07 PM, Richard Gerd Kuesters wrote: hi, i have a simple stupid query question, which i didn't found any examples. let's say i have table A and B, and would like to reproduce in SA the following SQL: SELECT A.*, B.* FROM A, B WHERE A.b_id = B.id i would probably need a new

Re: [sqlalchemy] a [probably] stupid query question

2014-03-19 Thread Richard Gerd Kuesters
thanks AM! i know that a join have the same effect (that's why i already told it's probably stupid question), but i was wondering if the select ... from tbl1, tbl2 is possible using SA. that's all :) cheers, richard. Em 2014-03-19 20:11, AM escreveu: On 03/19/2014 02:07 PM, Richard

Re: [sqlalchemy] a [probably] stupid query question

2014-03-19 Thread AM
On 03/19/2014 04:44 PM, Richard Gerd Kuesters wrote: thanks AM! i know that a join have the same effect (that's why i already told it's probably stupid question), but i was wondering if the select ... from tbl1, tbl2 is possible using SA. that's all :) cheers, richard. Em 2014-03-19