[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 in

[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 info

[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 I've

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

2015-01-30 Thread Jonathan Vanasco
You could use sqlacodegen (https://pypi.python.org/pypi/sqlacodegen) to generate your model: • generate both models • generate one model, then regex the other if you make a lookup table/function to map one column name to another, you could also loop over the columns. something sort of like th