[[TOC]]
= Pakistan Deployment Cycle =
 * UAT: http://test.eden.sahanafoundation.org
 * Live: http://pakistan.sahanafoundation.org

We want to do daily upgrades of the system from a single script:
 1. Upgrade Live with code release from UAT
 * Read VERSION from UAT to know which revision to pull to live
  * the 'update' script falls back to 'bzr pull' but supports an 'update XXX' arg to 'bzr pull -r XXX' 
 * Send a notification to the list (for testers) with a summary of the day's changes: Full list of fixed bugs to be verified, New features to be Tested
 2. Upgrade UAT to Trunk code
 * Send a notification to the list (for users) with a summary of yesterday's code changes: Focussed on new features & notable bug fixes
 3. Refresh the UAT database with data from Live
 * Include 'uploads' folder
 * Need to ensure that User Accounts in Test are not overwritten
 * Need to ensure that Role memberships in Live & Test can be different

Notifications can be built with info from:
 * Trac Timeline: http://eden.sahanafoundation.org/timeline
  * LP !ChangeLog: https://code.launchpad.net/~flavour/sahana-eden/trunk (included in Trac timeline)
  * Investigate a custom Trac script to build the report automatically
   * possible examples which can help with writing this:
    * http://trac-hacks.org/wiki/DailyReminderScriptForTracScript
    * http://trac-hacks.org/wiki/TracReleasePlugin

 * UserGuidelinesUpgrade

== Sysadmin !ToDo ==
 * Confirm versions of all base software the same on both sides
 * Set deployment_settings on UAT to the same as Prod
 * Configure Apache Maintenance site
{{{
ln -sf /etc/apache2/sites-available/maintenance ln -sf
/etc/apache2/sites-enabled/pakistan

This should be enhanced by:
 * keeping access to phpMyAdmin
 * allowing access to site through a browser - but using a different
name (which we don't publish)
 * improving the text on the maintenance page
}}}
 * Extend scripts:
  * ConfigurationGuidelines#Usefulaliases
{{{
pull
migrate
{CLI web2py load as 'su web2py')
migrateoff
DBsync (tbc)
}}}
  * Use Fabric:
   * Current status: https://gist.github.com/2b6c811432c8c736ad3f
   * Background: http://lethain.com/entry/2008/nov/04/deploying-django-with-fabric/

 * Rename instance as test.pakistan.sahanafoundation.org
  * keep test.eden.sahanafoundation.org as an alias for now
  * add test.sahanafoundation.org as an alias too

 * Create a new dev.pakistan.sahanafoundation.org instance
  * This shouldn't be fully-automated into the upgrades cycle, but does have a script to refresh data from live manually

=== Other Tasks ===
Update script for debian packages: SSH into each &
{{{
apt-get update; apt-get upgrade
}}}
Use Fabric?
==== Live ====
 * Schedule the Ushahidi imports:
  * http://pakistan.sahanafoundation.org/eden/irs/ireport/ushahidi
  * http://pakreport.org/ushahidi/api?task=incidents&by=all&resp=xml&limit=1000 (how to avoid this?)
  * Can we pass URL as argument?
 * Upgrade Geraldo to 0.4.0 (currently 0.3.9)
 * Upgrade !ReportLab from the debian-packaged 'python-reportlab 2.1dfsg-2' to current 2.4

==== Demo ====
 * Update Demo (whilst keeping the logins there intact - all other data can be dropped)
==== Trac ====
 * Investigate a fix or alternative to http://trac-hacks.org/wiki/MathCaptchaPlugin for allowing Trac users to register bugs anonymously whilst not locking out our testing team.
 * Convert from sqlite to PostgreSQL (or MySQL) to improve performance

----
DeveloperGuidelinesDataMigration

[wiki:Pakistan]