[sqlalchemy] how to test a Boolean column ?

2007-08-05 Thread Alexandre CONRAD
Hi, just wondering is there could be a method to a Column object to know if it's a Boolean column ? I'm trying to retrieve a list of boolean columns from a table and I'm doing the following: from sqlalchemy.types import Boolean for col in table.c.keys(): if

[sqlalchemy] Re: Hierachical data

2007-08-05 Thread Arnar Birgisson
On 8/5/07, Alexandre CONRAD [EMAIL PROTECTED] wrote: As Michael pointed out, the ElementTree example stores the XML data en-masse, so if you don't need those kind of queries, you might see better performance and a simpler way of life if you just serialize the ElementTree instances to XML

[sqlalchemy] Re: how to test a Boolean column ?

2007-08-05 Thread Paul Johnston
Hi, just wondering is there could be a method to a Column object to know if it's a Boolean column ? You can use: isinstance(table.c['mycol'].type, Boolean) Paul --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[sqlalchemy] Re: Using SA to move data between databases

2007-08-05 Thread Paul Johnston
Hi, I'm in the same process, and very interested in the answer ! I've found what I think is the best solution, and it sounds quite obvious thinking about it. Define the table, do a select on the old database and an insert on the new database. This leverages all SQLAlchemy's cleverness in

[sqlalchemy] Microsoft Access Support

2007-08-05 Thread Paul Johnston
Hi, I have just committed Microsoft Access support in the 0.4 branch. It's pretty basic (e.g. a lot of unit tests fail) but it does have functional table reflection. For me, this is a big help in migrating legacy Access databases to newer formats. The table reflection is based on jet2sql.py