Re: [sqlalchemy] MetaData not refreshed properly when using SQLite

2011-03-22 Thread Michael Bayer
On Mar 22, 2011, at 12:44 PM, jaypipes wrote: Hello all, I've decided to post here because bug reports and the mailing list for sqlalchemy-migrate don't seem to be monitored any more... I don't see a post regarding this issue at http://groups.google.com/group/migrate-users , have you

Re: [sqlalchemy] MetaData not refreshed properly when using SQLite

2011-03-22 Thread Jay Pipes
On Tue, Mar 22, 2011 at 1:35 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Mar 22, 2011, at 12:44 PM, jaypipes wrote: Hello all, I've decided to post here because bug reports and the mailing list for sqlalchemy-migrate don't seem to be monitored any more... I don't see a post

Re: [sqlalchemy] MetaData not refreshed properly when using SQLite

2011-03-22 Thread Michael Bayer
On Mar 22, 2011, at 2:32 PM, Jay Pipes wrote: I don't think it's a migrate problem. I think it's a SQLAlchemy problem. In the case when SQLite is the engine, a Table() object constructed with a new MetaData() before and after a SQL script is executed against the database will not show the

Re: [sqlalchemy] MetaData not refreshed properly when using SQLite

2011-03-22 Thread Jay Pipes
On Tue, Mar 22, 2011 at 3:12 PM, Michael Bayer mike...@zzzcomputing.com wrote: if you say this: Table('sometable', MetaData(), autoload=True, autoload_with=some_engine) its not looking for changes, its reflecting the entire form of that table brand new, each time. This because the

Re: [sqlalchemy] MetaData not refreshed properly when using SQLite

2011-03-22 Thread Michael Bayer
On Mar 22, 2011, at 3:56 PM, Jay Pipes wrote: On Tue, Mar 22, 2011 at 3:12 PM, Michael Bayer mike...@zzzcomputing.com wrote: if you say this: Table('sometable', MetaData(), autoload=True, autoload_with=some_engine) its not looking for changes, its reflecting the entire form of that

Re: [sqlalchemy] MetaData not refreshed properly when using SQLite

2011-03-22 Thread Jay Pipes
On Tue, Mar 22, 2011 at 3:58 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Mar 22, 2011, at 3:56 PM, Jay Pipes wrote: On Tue, Mar 22, 2011 at 3:12 PM, Michael Bayer mike...@zzzcomputing.com wrote: if you say this: Table('sometable', MetaData(), autoload=True,

Re: [sqlalchemy] MetaData not refreshed properly when using SQLite

2011-03-22 Thread Jay Pipes
On Tue, Mar 22, 2011 at 4:27 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Mar 22, 2011, at 4:09 PM, Jay Pipes wrote: Running with sqlite3 executes a brand new process with all new state, whereas using engine uses a SQLite connection that has remained established throughout the

Re: [sqlalchemy] MetaData not refreshed properly when using SQLite

2011-03-22 Thread Michael Bayer
On Mar 22, 2011, at 6:46 PM, Jay Pipes wrote: On Tue, Mar 22, 2011 at 4:27 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Mar 22, 2011, at 4:09 PM, Jay Pipes wrote: Running with sqlite3 executes a brand new process with all new state, whereas using engine uses a SQLite connection