[sqlalchemy] Re: CASE , CAST, COALESCE

2006-12-13 Thread Jose Soares
Great! jo Michael Bayer ha scritto: we have case(): select(case([(table.c.x==5, 5), (table.c.y==7, 12)], else_=7)) and cast(): select([cast(table.c.x, Numeric)]) which are in the generated documentation for sql.py. for coalesce() you can call that as func.coalesce() for now.

[sqlalchemy] PickleType and MySQL: want mediumblob instead of blob

2006-12-13 Thread [EMAIL PROTECTED]
Hi, Using SA 0.3.2 with Python (TurboGears) and MySQL I see that my PickleType column is stored as a blob in the MySQL table. Can I change the following table definition so that my 'info' column is stored as a mediumblob in MySQL instead of a blob? data_set_table = Table('dataset', metadata,

[sqlalchemy] Re: Again MySQL/unicode - roundtrip failed

2006-12-13 Thread Michael Bayer
in fact its almost definitely a bug in mysqldb - mysqldb should be detecting unicode instances at on the bind parameter side and encoding based on that (otherwise doing nothing), and decoding into unicode instances at the result set level. if it did that, then it would not conflict with the

[sqlalchemy] Re: Again MySQL/unicode - roundtrip failed

2006-12-13 Thread Shannon -jj Behrens
My memory is that MySQLdb recently changed a bunch of stuff and that it was a simple logic bug. Here's the bug I filed: http://sourceforge.net/tracker/index.php?func=detailaid=1592353group_id=22307atid=374932 On 12/13/06, Michael Bayer [EMAIL PROTECTED] wrote: in fact its almost definitely a