[sqlalchemy] Re: Left Joins and Improper Parenthesis when Building Query Expressions

2007-02-02 Thread svilen
stmt = doc_type_table.select() join_table = get_join_table('widgets') stmt = stmt.join(join_table, SA.and_(doc_type_table.c.ref_id==join_table.primary_key[0], doc_type_table.c.doc_type=='widgets')) join_table2 = get_join_table('spam') stmt = stmt.join(join_table2,

[sqlalchemy] Re: Left Joins and Improper Parenthesis when Building Query Expressions

2007-02-02 Thread Michael Bayer
a join() by itself shouldnt be executed. you need to call select() off of it (or use it inside the from_obj param of another select()). notice its not the parenthesis that are the problem, its the lack of an enclosing SELECT ... FROM. On Feb 2, 5:04 am, jlowery [EMAIL PROTECTED] wrote: I am

[sqlalchemy] Re: Left Joins and Improper Parenthesis when Building Query Expressions

2007-02-02 Thread Michael Bayer
As I understand the confusion here, Ive added a check for supports execution in rev 2289. so that when you try to execute the join, it will raise an error. originally i wasnt sure what would be executable and what would not but im hoping its pretty well nailed down at this point. so far its: