deploy/deploy_db.sh
author ymh <ymh.work@gmail.com>
Mon, 17 Jun 2019 18:09:10 +0200
changeset 27 03b0f48818d7
parent 14 30f2ac9a7656
permissions -rwxr-xr-x
Add documentation on db import
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
14
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     1
#!/usr/bin/env bash
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     2
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     3
SCRIPTPATH="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     4
SCRIPTNAME=`basename "$0"`
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     5
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     6
usage() {
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     7
  echo -n "${SCRIPTNAME} [CONFIG] [DB_FILE_PATH] [ORIGIN_URL]
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     8
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
     9
Deploy the database <DB_FILE_PATH> using ansible.
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    10
Replacing the <ORIGIN_URL> by the destination url in the ansible config (rc_wp_home).
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    11
"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    12
}
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    13
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    14
if [[ "$#" -ne 3 ]]; then
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    15
    usage
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    16
    exit 1
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    17
fi
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    18
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    19
config=${1}
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    20
db_file_path=${2}
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    21
origin_url=${3}
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    22
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    23
case $config in
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    24
    test) configOK=true;;
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    25
    prod) configOK=true;;
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    26
    *)    configOK=false;;
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    27
esac
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    28
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    29
if [[ "$configOK" = false ]]; then
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    30
    usage
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    31
    exit 1
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    32
fi
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    33
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    34
pushd "$SCRIPTPATH"
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    35
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    36
ANSIBLE_SSH_PIPELINING=1 ANSIBLE_STDOUT_CALLBACK=debug ansible-playbook -v -i "./hosts/hosts.$config" -l "$config" ./deploy_db.yml --extra-vars "db_file_path='${db_file_path}' origin_url='${origin_url}'" --ask-vault-pass
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    37
30f2ac9a7656 Add command to deploy batabase
ymh <ymh.work@gmail.com>
parents:
diff changeset
    38
popd