| 69 | ==== Changing a set of Lookup Options live ==== |
| 70 | We can eaisly amend the module_resource_opts = {} live in the code (usually models/module.py) however we need to migrate existing data (after backing it up, of course): |
| 71 | {{{ |
| 72 | cd /home/haiti/prod |
| 73 | bzr pull |
| 74 | |
| 75 | cd /home/haiti/web2py |
| 76 | python web2py.py -S prod -M |
| 77 | |
| 78 | db(db.or_organisation.id > 0).select().export_to_csv_file(open('orgs.csv','wb')) |
| 79 | db(db.or_organisation.type == 4).update(type='') |
| 80 | db(db.or_organisation.type == 5).update(type='') |
| 81 | db.commit() |
| 82 | Ctrl+D |
| 83 | |
| 84 | /etc/init.d/apache2 force-reload |
| 85 | }}} |
| 86 | |
| 87 | If the system is being heavily used, need to put up a holding page during this time to prevent data entry. |
| 88 | For switching on maintenance. |
| 89 | {{{ |
| 90 | cd /home/haiti |
| 91 | ./maintenance.on |
| 92 | }}} |
| 93 | For switching off maintenance. |
| 94 | {{{ |
| 95 | cd /home/haiti |
| 96 | ./maintenance.off |
| 97 | }}} |