[sqlalchemy] Syntax for IN (1,2,3)

2007-12-19 Thread Marcin Kasperski
Maybe I missed something but can't find... Does there exist SQLExpression syntax for WHERE column IN (1,2,3,4) ? -- -- | Marcin Kasperski | Software is not released, | http://mekk.waw.pl | it is allowed to e

[sqlalchemy] Plugging explain analyze - is it possible easily

2007-11-29 Thread Marcin Kasperski
such a thing could be injected without too much hassle? PS Explain functionality is of course non-standard and different in every database, but ... most databases do it in a way or another. -- -- | Marcin Kasperski | Working

[sqlalchemy] Couldn't from_obj accept singular value?

2007-09-19 Thread Marcin Kasperski
Well, I tried: select( [... some things ... ], from_obj = table1.outerjoin(table2, table1.fgn_key = table2.key) ) and got very unfriendly: iteration over non-sequence message. Adding [ ] helped, the clause below is OK: select( [... some things ... ], from_o

[sqlalchemy] Re: [patch] max() arg is an empty sequence while trying to reflect bugzilla table

2007-09-06 Thread Marcin Kasperski
Michael Bayer <[EMAIL PROTECTED]> writes: > hey Marcin - > > Seems like Jason Kirtland is out today. Any chance you could add a > simple test case to test/dialect/mysql.py for this ? Seems he already did this ;-) And he also improved my patch, in the meantime I discovered that while my patch

[sqlalchemy] [patch] max() arg is an empty sequence while trying to reflect bugzilla table

2007-09-05 Thread Marcin Kasperski
Attached patch seems to resolve both problems. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send

[sqlalchemy] max() arg is an empty sequence while trying to reflect bugzilla table (detailed diagnostics)max() arg is an empty sequence while trying to reflect bugzilla table (detailed diagnostics)

2007-09-04 Thread Marcin Kasperski
Test made on 0.4.0beta5. I tried to reflect the table from some well known application (bugzilla bugs table) >>> from sqlalchemy import * >>> >>> db = create_engine('mysql://%s:[EMAIL PROTECTED]/bugs' % (username, >>> password) ) >>> metadata = MetaData(bind = db) >>> bugs = Table('bugs', meta