| 51 | | * pull |
| 52 | | * check for conflicts & copy all .THIS over (either parse the bzr output or search filesystem - whichever is easier/quicker) |
| 53 | | * migrate (CLI web2py load as 'su web2py') |
| 54 | | * check for migration failures in databases/sql.log |
| 55 | | * integrate {{{dbstruct.py}}}? |
| 56 | | * resolve any migration failures |
| 57 | | * let user know which table failed (in sql.log) |
| 58 | | * Collect MySQL username/password from /home/web2py/applications/eden/models/000_config.py |
| 59 | | {{{ |
| 60 | | deployment_settings.database.username = "sahana" |
| 61 | | deployment_settings.database.password = "password" |
| 62 | | }}} |
| 63 | | * Parse output from {{{mysql -u root -p=password -e "show innodb status;"}}} |
| 64 | | * Fix it automatically from the parsed output: {{{ALTER TABLE {table_name} DROP FOREIGN KEY {table_name}_ibfk_{indexid}; }}} |
| 65 | | * migrateoff |
| 66 | | |
| | 51 | * as per (1) |
