Ah right.. http://docs.sqlalchemy.org/en/latest/core/connections.html#sqlalchemy.engine.ResultProxy You can do fetchmany - and do a partial_results compare to empty list.. I see there is a next option too. So, it's a slightly different paradigm
On Fri, Apr 27, 2018 at 3:14 PM, Jeremy Flowers <[email protected]> wrote: > But can you still do things like slice(0,5)? Struggling to get that to > work atm... > > On Fri, Apr 27, 2018 at 2:48 PM, Simon King <[email protected]> > wrote: > >> On Fri, Apr 27, 2018 at 12:57 PM, Jeremy Flowers >> <[email protected]> wrote: >> > Right... >> > Been trawling back thru this chain of exchanges.. >> > Looking for this: >> >> >> >> At this point I would echo Mike's question: why can't you just use >> >> "text()"? >> > >> > Just spotted another comment from Mike, that I've just fixed too... >> >> >> >> the literal() has to be against the regular value 1 and not the >> string... >> > >> > >> >> as a practical matter, this query is Oracle-specific in any >> >> case, is there a reason you can't just use text() ? The reason >> >> text() exists is for when one has the exact SQL they want already and >> >> there is no need to work it into the expression language. >> > >> > >> > Can I just put that into some sort of session execute? >> > If there's a relevant example someone can point me to, it would help. >> I'll >> > have a dig around. >> > >> >> There are a few examples of using text() with the ORM here: >> >> http://docs.sqlalchemy.org/en/latest/orm/tutorial.html#using >> -textual-sql >> >> session.execute() behaves more like the Core-level >> connection.execute(), which is described here: >> >> http://docs.sqlalchemy.org/en/latest/core/tutorial.html#sqle >> xpression-text >> >> Simon >> >> -- >> SQLAlchemy - >> The Python SQL Toolkit and Object Relational Mapper >> >> http://www.sqlalchemy.org/ >> >> To post example code, please provide an MCVE: Minimal, Complete, and >> Verifiable Example. See http://stackoverflow.com/help/mcve for a full >> description. >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "sqlalchemy" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/to >> pic/sqlalchemy/aWJT1VdY3LU/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/d/optout. >> > > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
