[sqlalchemy] reflecting schema with autoload in Table creation

2011-01-24 Thread Mark Sharp
I am wanting to have SQLAlchemy pull the table schema from the database. I have just started trying to work through Essential SQLAlchemy and believe that I am using a syntax that is no longer supported in SQLAlchemy 0.6.6. This what I have tried: from sqlalchemy import MetaData,

Re: [sqlalchemy] reflecting schema with autoload in Table creation

2011-01-24 Thread Michael Bayer
On Jan 24, 2011, at 5:45 PM, Mark Sharp wrote: I am wanting to have SQLAlchemy pull the table schema from the database. I have just started trying to work through Essential SQLAlchemy and believe that I am using a syntax that is no longer supported in SQLAlchemy 0.6.6. This what I have

Re: [sqlalchemy] reflecting schema with autoload in Table creation

2011-01-24 Thread Mark Sharp
Michael, I had missed calling MetaData, but after making the call, I get the following traceback. from sqlalchemy import MetaData, create_engine, Table meta = MetaData() engine1 = create_engine(mssql+pyodbc://mydsn) valid_species_table = Table( ... 'tf_valid_species', meta, autoload =