Dne sobota 28 Únor 2009 14:53:11 Chris Curvey napsal(a):
try
q= Game.query.order_by(Game.id).all()
> this may be more of a SQLAlchemy question, but I'll ask here anyway :)
>
> I have a real simple setup.  I've created an Entity class called Game
> (which relies on a MySQL table called "game").  It's pretty simple,
> just some fields and some many-to-one relationships.  I'm surprised
> that
>
> q = Game.query()
> print q
>
> tells me that there is an "order by game.id" tacked on the end of my
> sql statement.  I don't need that (and because the Game table is
> pretty big, I actively don't want it).
>
> is there a way to suppress this?
>
> P.S.  For double points, what I really want is just an iterator that
> goes through the results of the query, without trying to instantiate
> the entire list in memory.
> 

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to