Re: [sqlalchemy] Why no Raw Query Builder?

2013-08-11 Thread Taba Taba
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 beta...@gmail.comjavascript: wrote: Thank you so much. Another question: $this-select(col1); if(1 0) {

Re: [sqlalchemy] Why no Raw Query Builder?

2013-08-10 Thread Taba Taba
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 //

Re: [sqlalchemy] Why no Raw Query Builder?

2013-08-10 Thread Claudio Freire
On Sat, Aug 10, 2013 at 11:31 AM, Taba Taba betak...@gmail.com 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);

[sqlalchemy] Why no Raw Query Builder?

2013-08-03 Thread Taba Taba
Hi all, I switch from php to python I'm using Codeigniter Query Builder: $this-db-select('*'); $this-db-from('blogs'); $this-db-join('comments', 'comments.id = blogs.id'); $this-db-limit(10, 20); $query = $this-db-get(); // Produces: // SELECT * FROM blogs // JOIN comments ON comments.id =

Re: [sqlalchemy] Why no Raw Query Builder?

2013-08-03 Thread Michael Bayer
On Aug 3, 2013, at 12:34 PM, Taba Taba betak...@gmail.com wrote: Hi all, I switch from php to python I'm using Codeigniter Query Builder: $this-db-select('*'); $this-db-from('blogs'); $this-db-join('comments', 'comments.id = blogs.id'); $this-db-limit(10, 20); $query = $this-db-get();