Re: [sqlalchemy] Why no Raw Query Builder?
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) { $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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
Re: [sqlalchemy] Why no Raw Query Builder?
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! On Saturday, August 3, 2013 11:38:48 PM UTC+7, Michael Bayer wrote: On Aug 3, 2013, at 12:34 PM, Taba Taba beta...@gmail.com javascript: 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(); // Produces: // SELECT * FROM blogs // JOIN comments ON comments.id = blogs.id // LIMIT 20, 10 I need model name in string ('blog') not class name (Blog). How can i do it with SQLAlchemy? try reading the SQL Expression tutorial: http://docs.sqlalchemy.org/en/rel_0_8/core/tutorial.html -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
Re: [sqlalchemy] Why no Raw Query Builder?
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); // 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
[sqlalchemy] Why no Raw Query Builder?
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 = blogs.id // LIMIT 20, 10 I need model name in string ('blog') not class name (Blog). How can i do it with SQLAlchemy? -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
Re: [sqlalchemy] Why no Raw Query Builder?
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(); // Produces: // SELECT * FROM blogs // JOIN comments ON comments.id = blogs.id // LIMIT 20, 10 I need model name in string ('blog') not class name (Blog). How can i do it with SQLAlchemy? try reading the SQL Expression tutorial: http://docs.sqlalchemy.org/en/rel_0_8/core/tutorial.html signature.asc Description: Message signed with OpenPGP using GPGMail