[sqlalchemy] Abort Query

2015-05-11 Thread Warwick Prince
Hi

If I execute a query, is there a way to abort that query and release the server 
before the query completes?

e.g. 

theTable = Table(‘some_large_table’, metadata, autoload=True)

query = theTable.select()

results = query.execute().fetchall()

Is there a way that perhaps another thread, if handed the query object or 
something else could intervene and kill the query execution?  This is so I can 
handle rogue queries that are taking a very long time - I want to be able to 
kill them before they compete.

Cheers
Warwick

-- 
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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.


Re: [sqlalchemy] Abort Query

2015-05-11 Thread Mike Bayer

I found this:

http://stackoverflow.com/a/325528/34549

also Alex Martelli is pretty -1 on the whole idea: 
http://stackoverflow.com/a/1227814/34549


I'm not sure what else you'd have in mind other than interrupting the 
thread from the outside.




On 5/11/15 2:36 AM, Warwick Prince wrote:

Hi

If I execute a query, is there a way to abort that query and release the server 
before the query completes?

e.g.

theTable = Table(‘some_large_table’, metadata, autoload=True)

query = theTable.select()

results = query.execute().fetchall()

Is there a way that perhaps another thread, if handed the query object or 
something else could intervene and kill the query execution?  This is so I can 
handle rogue queries that are taking a very long time - I want to be able to 
kill them before they compete.

Cheers
Warwick



--
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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.