[Cosmo-dev] testing data migration for cosmo 0.6

[Randy Letness]

Aparna Kadakia wrote:
> Also how do developers plan to do unit testing of the migration script?

I hadn't thought about unit testing for the migration script as its just 
a sql script.  Its a good idea though, but this would require a db and 
would probably have to be some custom test sql.

> What QA test scripts do we need to test the upgrade?

The functional tests definitely should be run.  Even though they don't 
test the migrated data, they test the schema changes.  You could also 
create some scripts that verify that the correct number of records are 
in each table given the state of the data before migration.

> What manual tests will be involved?

Theres a bunch of tests you could do manually, but just verifying that 
the 0.5 data is viewable/updateable using 0.6 should be a good start.  
Also, a test that is a must is verifying that the db schema from a clean 
0.6 install is exactly the same as a migrated 0.5 db (table names/field 
names/indexes/contraints/etc).  There should be some db tools out there 
that do a diff of two db instances, which would make this pretty easy.

> Should we get the dogfooders to test against this instance?

Definitely.

-Randy