[Sqlalchemy-tickets] [sqlalchemy] #2932: textasfrom compatibility with columns, query
Brought to you by:
zzzeek
|
From: sqlalchemy <mi...@zz...> - 2014-02-02 15:13:32
|
#2932: textasfrom compatibility with columns, query
---------------------+------------------------------------
Reporter: zzzeek | Owner: zzzeek
Type: defect | Status: new
Priority: highest | Milestone: 0.9.2
Component: sql | Severity: major - 1-3 hours
Keywords: | Progress State: in progress
---------------------+------------------------------------
{{{
#!python
def test_via_textasfrom(self):
User = self.classes.User
s = create_session()
eq_(
s.query(User).from_statement(
text("select * from users order by id").\
columns(id=Integer, name=String)
).all(),
[User(id=7), User(id=8), User(id=9), User(id=10)]
)
}}}
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2932>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|