[sqlalchemy] Booleans not converted to integers on pymssql

2010-11-15 Thread Bertrand Janin
Hello all, Here is what I have: table = Table(contract, metadata, ... Column(is_awesome, Boolean), ... ) mapper(Contract, table, properties={ ... is_awesome: table.c.is_awesome, ... }) When using mssql+pymssql, if I set the

Re: [sqlalchemy] Booleans not converted to integers on pymssql

2010-11-15 Thread Michael Bayer
any chance on contacting the pymssql author on that one ? False is actually the integer 0. If pymssql is doing a naive sql % params kind of expression, that's a seriously poor practice on their part. will try to commit a compatible patch on this end. On Nov 15, 2010, at 11:57 AM,

Re: [sqlalchemy] Booleans not converted to integers on pymssql

2010-11-15 Thread Michael Bayer
confirmed for pymssql committed in r1a1ef69edef7 . On Nov 15, 2010, at 11:57 AM, Bertrand Janin wrote: Hello all, Here is what I have: table = Table(contract, metadata, ... Column(is_awesome, Boolean), ... ) mapper(Contract, table, properties={