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.
[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.
