Skip to content

push code to dev.buttonweavers.com for July 2016 release #2056

@cgolubi1

Description

@cgolubi1

As features are merged into the main codebase, redeploy dev.buttonweavers.com with those changes.

Generic procedures for use in deployments:

Use a checked-out copy of buttonmen-master 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 buttonmen

How to diff database dumps:

diff -r --brief /tmp/pre /tmp/post

#217 is the master ticket linking all dev code pushes.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions