[sqlalchemy] Re: arbitrary join/select from a given list

2007-02-05 Thread sdobrev
i'm not sure if i understand what u want, but u can do nested join( prev_join, table_next). Also see the full spec of select( columns_list, whereclause, from_obj_list, order_by, group_by, ) something like table_a.join(table_b).join(c).join(d).select([columns_here]) for the implicit

[sqlalchemy] Re: arbitrary join/select from a given list

2007-02-05 Thread Michael Bayer
select([x.c.col1, y.c.col2, z.c.col3, ...], from_obj=[x.join(y).join(z).join(q)...]) On Feb 5, 2:27 pm, vkuznet [EMAIL PROTECTED] wrote: Hi, I've trying to solve the following problem. I've given a list of tables and list of columns to look at. All tables are auto-loaded from DB. So, I

[sqlalchemy] Re: arbitrary join/select from a given list

2007-02-05 Thread vkuznet
SQLAlchemy rocks!!! Thanks. P.S. Even though it can't figure out relationship if one table is missing in a chain of relationship, I think I can do some tricks about it. FYI, I just did a test between 4 tables tableA id tableB id, tableA_id tableC id, tableB_id, tableD_id tableD id and did