Re: [openstack-dev] [Fuel] Testing DB migrations

2015-03-09 Thread Igor Kalnitsky
Hi, guys, Indeed, it's a hot topic since it looks like there's no silver bullet at all. As OpenStack community, we should move toward oslo.db approach, but it may require hard effort from our side. Meantime, as a part of bp/consume-external-ubuntu [1] I've prepared a base class for testing

Re: [openstack-dev] [Fuel] Testing DB migrations

2015-03-06 Thread Boris Bobrov
On Friday 06 March 2015 16:57:19 Nikolay Markov wrote: Hi everybody, From time to time some bugs appear regarding failed database migrations during upgrade and we have High-priority bug for 6.1 ( https://bugs.launchpad.net/fuel/+bug/1391553) on testing this migration process. I want to

Re: [openstack-dev] [Fuel] Testing DB migrations

2015-03-06 Thread Nikolay Markov
We already run unit tests only using real Postgresql. But this still doesn't answer the question how we should test migrations. On Fri, Mar 6, 2015 at 5:24 PM, Boris Bobrov bbob...@mirantis.com wrote: On Friday 06 March 2015 16:57:19 Nikolay Markov wrote: Hi everybody, From time to time

Re: [openstack-dev] [Fuel] Testing DB migrations

2015-03-06 Thread Roman Podoliaka
Hi all, You could take a look at how this is done in OpenStack projects [1][2] Most important parts: 1) use the same RDBMS you use in production 2) test migration scripts on data, not on empty schema 3) test corner cases (adding a NOT NULL column without a server side default value, etc) 4) do a