[sqlalchemy] Re: returning values as a list of values rather than as list of tuples

2009-01-15 Thread Matthew Zwier
Hi Faheem, On Thu, Jan 15, 2009 at 11:05 AM, Faheem Mitha wrote: > > > Hi, > > The following code returns a list of tuples to python from the db, > corresponding to the values of the 'snpval_id' column in the table 'cell'. > I was wondering if there was an easy way to have it return a list of >

[sqlalchemy] Re: Deleted rowcount doesn't match number of objects deleted.

2008-09-08 Thread Matthew Zwier
I've gotten this before with incorrectly configured backrefs on my mappers, so that might be another thing to look at. On Mon, Sep 8, 2008 at 5:18 AM, Harish K Vishwanath <[EMAIL PROTECTED]> wrote: > Hello, > > I am getting the below exception : > > Traceback (most recent call last): > File "d:

[sqlalchemy] Re: SQL for "(col1, col2) NOT IN (SELECT ...)"

2008-04-28 Thread Matthew Zwier
Thanks for the quick reply! I've always been quite impressed with the quality of SA and its support. I'm a bit swamped at work at the moment but I'll see about putting a 'CREATE TEMPORARY TABLE' patch together. MZ On Mon, Apr 28, 2008 at 4:09 PM, Michael Bayer <[EMAIL PROTECTED]> wrote: > > t

[sqlalchemy] SQL for "(col1, col2) NOT IN (SELECT ...)"

2008-04-28 Thread Matthew Zwier
Hi all, I'm trying to run a (non-ORM) query of the form: SELECT job_id, pathname FROM jobfilesTable WHERE (job_id, pathname) NOT IN (SELECT job_id, pathname FROM tempTable) After searching the docs and the mailing list, the best I've been able to come up with is something like: from sqlalchem