Changes between Version 19 and Version 20 of GSOC2012/DatabaseMigration/Userguildlines
- Timestamp:
- 08/20/12 17:52:11 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
GSOC2012/DatabaseMigration/Userguildlines
v19 v20 2 2 == Comparison Script == 3 3 Before using the comparison script , the user of the script should have 2 eden apps , one the containing the old database schema from which the data is to migrated and one with the new database schema 4 5 The apps_db_comparison script compares the db schema of 2 eden apps to tell the differences 6 Just run the script with 3 necessary arguments in this order 7 1.WEB2PY_PATH 8 2.OLD_APP 9 3.NEW_APP 10 i.e python applications/eden/static/scripts/Database_migration/apps_db_comparison.py /home/web2py eden_old eden_new 4 [[br]] 5 The apps_db_comparison script compares the db schema of 2 eden apps to tell the differences[[br]] 6 Just run the script with 3 necessary arguments in this order[[br]] 7 1.WEB2PY_PATH[[br]] 8 2.OLD_APP[[br]] 9 3.NEW_APP[[br]] 10 i.e python applications/eden/static/scripts/Database_migration/apps_db_comparison.py /home/web2py eden_old eden_new[[br]] 11 11 12 12 This script also has an test script that makes 2 new web2py with apps to compare 13 Just run the test script to compare 14 i.e python applications/eden/tests/dbmigration TestScript.py13 Just run the test script to compare[[br]] 14 i.e python applications/eden/tests/dbmigration/TestScript.py[[br]] 15 15 16 The detected changes are displayed , then using the changes displayed user could figure out the what kind of migration is needed , like if there is a field appeared in the new schema which has the same properties as the one disappeared from the old schema then the migration function for the renaming a field can be called . 17 16 The detected changes are displayed , then using the changes displayed user could figure out the what kind of migration is needed , like if there is a field appeared in the new schema which has the same properties as the one disappeared from the old schema then the migration function for the renaming a field can be called . [[br]] 17 [[br]] 18 18 Also the change in the properties of the fields are detected , the migration function for those can be called too . 19 19