Mercurial > public > ssdt-docker
comparison scripts/backup-container-docker.sh @ 388:23d40b345e1e
INV-197 create db backup helper scripts for inventory and workflow
| author | Matt Calmes <calmes@ssdt-ohio.org> |
|---|---|
| date | Mon, 18 Oct 2021 06:33:33 -0400 |
| parents | |
| children | 4e42c10e3c0d |
comparison
equal
deleted
inserted
replaced
| 369:3dc92d4243ef | 388:23d40b345e1e |
|---|---|
| 1 #!/bin/bash | |
| 2 # Executes a database backup for the specifed database container. | |
| 3 # The current directory is expected to contain a project configured | |
| 4 # as with SSDT conventions for an application database. | |
| 5 # | |
| 6 # When successful, the output file will be in ./backup with the | |
| 7 # container name and timestamp in the file. The format of the output | |
| 8 # is a compressed pg_dump (sql) format. | |
| 9 # | |
| 10 container=${1?Must provide container name to backup} | |
| 11 | |
| 12 projectDir=${2:-$PWD} | |
| 13 | |
| 14 project=${3?Must provide project name to backup} | |
| 15 | |
| 16 cd $projectDir | |
| 17 | |
| 18 source "${SSDT_SCRIPTS:-$(dirname "${BASH_SOURCE[0]}")}/.functions.sh" | |
| 19 | |
| 20 set -o pipefail | |
| 21 mkdir -p ./backup | |
| 22 | |
| 23 if [ "$container" = "invdb" ]; then | |
| 24 function prop { | |
| 25 grep "${1}" .env/ssdt-inventory-shared.properties|cut -d'=' -f2 | |
| 26 } | |
| 27 entityId=$(prop 'entityId' | tr -d '"') | |
| 28 containerName="$entityId-inventory-db" | |
| 29 IRN=$(docker exec $containerName psql --username=postgres --dbname=$container -t -c 'select districtirn from inventoryconfiguration') | |
| 30 backupFile=./backup/${IRN}${entityId}-${container}.$(date +%Y-%m-%d-%H-%M-%S).backup | |
| 31 echo "entityId is $entityId" | |
| 32 echo "container name is $containerName" | |
| 33 fi | |
| 34 | |
| 35 #If the project is empty, we want to stop the process because this is being run from the wrong directory | |
| 36 | |
| 37 #if [ "$project" == "" ]; then | |
| 38 # echo "no project available" | |
| 39 # exit 1 | |
| 40 #fi | |
| 41 # | |
| 42 ##Take out the extra space from IRN returned from db. | |
| 43 IRN=`echo $IRN | sed -e 's/^[[:space:]]*//'` | |
| 44 | |
| 45 ## if database is empty, it will put IRN 000000 | |
| 46 if [ "$IRN" == "" ]; then | |
| 47 echo "no IRN set,using 000000" | |
| 48 IRN=000000 | |
| 49 fi | |
| 50 | |
| 51 | |
| 52 | |
| 53 echo "Project is $project" | |
| 54 echo "Container is $container" | |
| 55 echo "IRN is $IRN" | |
| 56 | |
| 57 echo "backup file ${backupFile}" | |
| 58 echo "preparing to backup ${container} on current project at ${projectDir}:" | |
| 59 echo " " | |
| 60 | |
| 61 | |
| 62 | |
| 63 echo "starting backup of $container for $project" | |
| 64 docker exec -t $containerName sh -c "gosu postgres pg_dump -Cc --if-exists --dbname=$container ; (exit $?) " > ${backupFile} | |
| 65 #if [[ $( grep --count "CREATE TABLE" ${backupFile} ) -lt 200 || $( grep --count "PostgreSQL database dump complete" ${backupFile} ) -eq 0 ]]; then | |
| 66 # echo "ERROR: backup verification FAILED" | |
| 67 # echo "Error: empty database" | |
| 68 # echo "ERROR: $(tail ${backupFile})" | |
| 69 # We want the process to continue even if the db is blank | |
| 70 # exit 1 | |
| 71 #fi | |
| 72 | |
| 73 gzip ${backupFile} | |
| 74 | |
| 75 | |
| 76 echo "completed backup of $container for $project to ${backupFile}" | |
| 77 |