-
Notifications
You must be signed in to change notification settings - Fork 23
Closed
Milestone
Description
This is the issue for loading code onto dev for the release. The issue for deciding which pulls to bring to staging is #2133.
As features are merged into the dev codebase branch, redeploy dev.buttonweavers.com with those changes.
Generic procedures for use in deployments:
Use a checked-out copy of buttonmen-dev to find a sort order for database updates:
cd deploy/database/updates/
UPDATES="<space-separated list of DB updates>"
git log --reverse --first-parent --oneline $UPDATES
UPDATES="<space-separated list of DB updates, now in the order reported by that output>"Database update plan:
# in the correct git working directory
git pull origin dev
cd deploy/vagrant
vagrant provision
# on the sandbox or dev VM
UPDATES="<space-separated ordered list of DB updates, as determined above>"
sudo -u mysql mkdir /tmp/pre /tmp/post
ls /tmp/pre /tmp/post
sudo -u mysql mysqldump -u root --skip-comments -T /tmp/pre buttonmen
cd /buttonmen/deploy/database/updates
for update in $UPDATES; do
echo "APPLYING: $update"
cat $update | mysql -u root buttonmen
done
sudo -u mysql mysqldump -u root --skip-comments -T /tmp/post buttonmenHow to diff database dumps:
diff -r --brief /tmp/pre /tmp/post#217 is the master ticket linking all dev code pushes.
Metadata
Metadata
Assignees
Labels
No labels