[sqlalchemy] add_column migration with column enum error

2015-10-19 Thread m1yag1
I have the following in my upgrade function of the revision file: def upgrade(): op.add_column('gates_experiment_users', sa.Column('experiment_group', postgresql.ENUM('Control', 'SPARFA-50',

[sqlalchemy] Re: Mapping Similar yet different table structures automatically

2015-01-30 Thread m1yag1
ohnathan, I was able to get my code working with your help. I was able to create an automapper of sorts between the two similar tables on the databases. I'm one step closer to getting this done. I have one more question. How would I trigger both saves. For example I've accepted some form

[sqlalchemy] Re: Mapping Similar yet different table structures automatically

2015-01-30 Thread m1yag1
Johnathan, I was able to get my code working with your help. I was able to create an automapper of sorts between the two similar tables on the databases. I'm one step closer to getting this done. I have one more question. How would I trigger both saves. For example I've accepted some form

[sqlalchemy] Re: Mapping Similar yet different table structures automatically

2015-01-30 Thread m1yag1
Johnathan, I was able to get my code working with your help. I was able to create an automapper of sorts between the two similar tables on the databases. I'm one step closer to finishing getting this done. I have one more question. How would I trigger this even to take place. For example

[sqlalchemy] Mapping Similar yet different table structures automatically

2015-01-30 Thread m1yag1
The problem I am extracting data from one database and loading the data into another. There isn't much transformation of the data other than the columns are different in each table but a simple conversion of pascal casing to lower_case can be done. For example TestName in my source database

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