Re: [Openstack] GLANCE: How to deal with SQLAlchemy-migrate problems

2011-03-22 Thread Jay Pipes
On Mon, Mar 21, 2011 at 5:42 PM, Brian Schott wrote: > 1.a.) Not yet, but our branch unit tests (when we get there) will certainly > test the architecture-related columns we added to instances, instance_types, > and compute_node tables. > > 1.b) Is that a unit test responsibility or an integrati

Re: [Openstack] GLANCE: How to deal with SQLAlchemy-migrate problems

2011-03-21 Thread Brian Schott
1.a.) Not yet, but our branch unit tests (when we get there) will certainly test the architecture-related columns we added to instances, instance_types, and compute_node tables. 1.b) Is that a unit test responsibility or an integration test farm with different "typical" configurations that ge

Re: [Openstack] GLANCE: How to deal with SQLAlchemy-migrate problems

2011-03-21 Thread Jay Pipes
On Mon, Mar 21, 2011 at 3:27 PM, Brian Schott wrote: > I've done a few migration scripts in recent weeks for our nova/hpc-trunk.  It > was a painful learning curve mostly because I come from the Perl generation, > but I got through it. > > Is the design pattern for migrations written down somewh

Re: [Openstack] GLANCE: How to deal with SQLAlchemy-migrate problems

2011-03-21 Thread Brian Schott
I've done a few migration scripts in recent weeks for our nova/hpc-trunk. It was a painful learning curve mostly because I come from the Perl generation, but I got through it. Is the design pattern for migrations written down somewhere? If not, we should add some instructions to the migrate

Re: [Openstack] GLANCE: How to deal with SQLAlchemy-migrate problems

2011-03-21 Thread Jay Pipes
On Mon, Mar 21, 2011 at 1:08 PM, Justin Santa Barbara wrote: >> By "seemed powerful", did you actually try it on anything more than >> simple add a table/drop a table scripts? Did you try it on more than a >> single database? Did you use the SQL scripting as well as the Python >> change scripts? >

Re: [Openstack] GLANCE: How to deal with SQLAlchemy-migrate problems

2011-03-21 Thread Jay Pipes
On Mon, Mar 21, 2011 at 12:21 PM, Justin Santa Barbara wrote: > Do we have patches for approach #3? For some things, not all. > I'm thinking that if we have a few > specific issues, that maybe we could maintain our own branch and/or > monkey-patch SA-migrate, and get a better handle on the probl

Re: [Openstack] GLANCE: How to deal with SQLAlchemy-migrate problems

2011-03-21 Thread Justin Santa Barbara
Do we have patches for approach #3? I'm thinking that if we have a few specific issues, that maybe we could maintain our own branch and/or monkey-patch SA-migrate, and get a better handle on the problem, and the upstream's project receptiveness to patches (rather than bug reports). It's a bit mor

[Openstack] GLANCE: How to deal with SQLAlchemy-migrate problems

2011-03-21 Thread Jay Pipes
Hey all, For the better part of the last week, I've been struggling to use SQLAlchemy-Migrate to produce database migration scripts for Glance. In Glance, unlike Nova, we have a unit test that tests that the database for Glance's registry can be downgraded and upgraded smoothly. In Nova, none of t