= Upgrades =
[[TOC]]

The basic process is:
* Update your local development branch:
{{{
git pull upstream master
git push
}}}
* Refresh your Test instance with the current Production data
{{{
clean test
}}}
* Upgrade the Test instance (which also migrates to the new DB schema):
{{{
pull test
}}}
* Resolve any database migration issues that you encounter...documenting these for the script which you use to upgrade Prod
* TEST
* Enhance your migration script as-required to fix silent database migration issues
 - some of thesse can be found by reviewing the code changes for the modules which you are using
* Repeat until happy
* Backup Prod
* Repeat upgrade script on Prod

You may find this useful (especially if you have a smaller database...the process here takes too long for longer databases):
* https://github.com/flavour/eden/blob/master/modules/s3migration.py

== Old ==
=== Fabfile ===
This can be done using Fab:
{{{
fab <systemname> deploy
}}}

* Current Fabfile: http://eden.sahanafoundation.org/browser/static/scripts/tools/fabfile.py
* Current Aliases: ConfigurationGuidelines#Usefulaliases 

=== Older ===
Put site into Maintenance:
{{{
vim /etc/crontab
#0-59/1 * * * * www-data cd /path/to/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1

vim /etc/apache/sites-available/maintenance
  RewriteEngine On
  RewriteRule ^/(.*) /maintenance.html

ln -sf /etc/apache/sites-available/maintenance /etc/apache/sites-enabled/mysite
/etc/init.d/apache2 force-reload
}}}

Update code:
{{{
cd /path/to/web2py
git pull upstream
}}}

Trial run:
{{{
cd /path/to/web2py
python web2py.py -S eden -M
}}}
Fix any Database Issues:
 1. The .table files in the databases directory contains what web2py knows about your database
 2. You need to set deployment_settings.base.migrate=True in {{{models/000_config.py}}} before you update the code and switch back to deployment_settings.base.migrate=False later on.
 3. In case of database mismatches - check the databases directory for the appropriate {{{.table}}} file and change accordingly.

If using [wiki:InstallationGuidelines/MySQL MySQL], then can use [http://phpmyadmin.net phpMyAdmin], if using SQLite then can use {{{sqlite3}}} command-line tool:
 * Linux: ({{{apt-get install sqlite3}}})
 * Windows: http://www.sqlite.org/sqlite-3_6_23_1.zip
 * Documentation: http://www.sqlite.org/sqlite.html

Restore site into production:
{{{
vim /etc/crontab
0-59/1 * * * * www-data cd /path/to/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1

ln -sf /etc/apache/sites-available/mysite /etc/apache/sites-enabled/mysite
/etc/init.d/apache2 force-reload
}}}

== See Also ==
* MaintenanceGuidelines
* UserGuidelines/Admin/DataMigration
* BluePrintUpgrades
* PakistanDeploymentCycle