Re: [sqlalchemy] Using use_alter=True when doing a table.metadata.create_all()

2015-01-06 Thread m1yag1
Mike, Thanks a lot for the response it really helped. I look forward to 1.0 and having everything work automatically. On Thursday, January 1, 2015 10:34:43 PM UTC-6, Michael Bayer wrote: Michael Bayer mik...@zzzcomputing.com javascript: wrote: best way is probably to add it on after the

Re: [sqlalchemy] Using use_alter=True when doing a table.metadata.create_all()

2015-01-01 Thread Michael Bayer
Michael Bayer mike...@zzzcomputing.com wrote: best way is probably to add it on after the fact. this is the flag but also because the flag isn’t set up front, seems to need the add/drop directives to be applied as in

[sqlalchemy] Using use_alter=True when doing a table.metadata.create_all()

2014-12-31 Thread Mike Arbelaez
I'm currently reflecting a few tables from a MSSQL database and then creating the table structure over to Postgres. I'm using sqlalchemy 0.9 and python 2.7. So far I've been very successful doing this with most of the tables except on a few tables I've received a

Re: [sqlalchemy] Using use_alter=True when doing a table.metadata.create_all()

2014-12-31 Thread Michael Bayer
best way is probably to add it on after the fact. this is the flag but also because the flag isn’t set up front, seems to need the add/drop directives to be applied as in http://docs.sqlalchemy.org/en/rel_0_9/core/ddl.html#controlling-ddl-sequences: from sqlalchemy.schema import AddConstraint,

Re: [sqlalchemy] Using use_alter=True when doing a table.metadata.create_all()

2014-12-31 Thread Michael Bayer
best way is probably to add it on after the fact. this is the flag but also because the flag isn’t set up front, seems to need the add/drop directives to be applied as in http://docs.sqlalchemy.org/en/rel_0_9/core/ddl.html#controlling-ddl-sequences: from sqlalchemy.schema import AddConstraint,