from sqlalchemy import sql
for row in metadata.bind.execute( sql.select( [Movie.id, Movie.title,
Movie.year] ) ):
print row
On Sep 21, 3:14 pm, Andrew Colin Kissa <[email protected]> wrote:
> Hi All,
>
> Sorry if this has been answered before, i have searched the archive but did
> not find
> any info.
>
> How would i run a SQLAlchemy query like this in elixir
>
> Session.query(Movie.id, Movie.title, Movie.year)
>
> As far as i know this Movie.query.all() will return all the fields in that
> table
>
> Thanks in advance.
>
> Andrew
--
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en.
