Please review my question. Some use cases, SqlAlchemy does not support :( On Sunday, August 11, 2013 2:03:25 AM UTC+7, Klauss wrote: > > On Sat, Aug 10, 2013 at 11:31 AM, Taba Taba <[email protected]<javascript:>> > wrote: > > Thank you so much. Another question: > > > > $this->select("col1"); > > if(1 > 0) { > > $this->select("col2, col3"); > > } > > $this->from("tbl")->where("1 = 1"); > > if( 2 > 1) { > > $this->where("2 > 1"); > > } > > $this->left_outer_join("tbl2", "tbl2.t_id = tbl.id"); > > // output: SELECT col1, col2, col3 > > // FROM tbl > > // LEFT OUTER JOIN tbl2 > > // ON tbl2.t_id = tbl.id > > // WHERE 1=1 AND 2 > 1 > > > > On sqlalchemy? > > > > s = select(["col1"]) > > if 1 > 0: > > s.append_column("col2, col3") > > s.from("tbl") # not found from(...) in sqlalchemy.sql.expression.Select > or > > _SelectBase > > s.where("1 = 1") > > if 2 > 1: > > s.where("2 > 1") > > s.outerjoin("tbl2", "tbl2.t_id = tbl.id") # not works > > print s > > > > Thank you in advance! > > > Where's the question? > > I think your problem, though, is that you didn't read the tutorial[0]. > Or if you did, not carefully enough. > > [0] http://docs.sqlalchemy.org/en/rel_0_8/core/tutorial.html#selecting >
-- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
