[Sqlalchemy-tickets] [sqlalchemy] #2932: textasfrom compatibility with columns, query

[sqlalchemy <mi...@zz...>]

#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