Mercurial > public > ssdt-docker
changeset 584:fb25711eead7
add irn to the ess backup
| author | Marc Davis <marc.davis@mcoecn.org> |
|---|---|
| date | Thu, 05 Sep 2024 14:38:06 -0400 |
| parents | 646ecb227dbc |
| children | a4afd20415b2 c8ef1c6829dd |
| files | scripts/backup-container-docker.sh |
| diffstat | 1 files changed, 10 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/scripts/backup-container-docker.sh Thu Sep 05 14:09:51 2024 -0400 +++ b/scripts/backup-container-docker.sh Thu Sep 05 14:38:06 2024 -0400 @@ -1,5 +1,5 @@ #!/bin/bash -# Executes a database backup for the specifed database container. +# Executes a database backup for the specified database container. # The current directory is expected to contain a project configured # as with SSDT conventions for an application database. # @@ -64,7 +64,15 @@ } entityId=$(prop 'entityId' | tr -d '"') containerName="$entityId-ess-db" - backupFile=./backup/${entityId}-ess-db.$(date +%Y-%m-%d-%H-%M-%S).backup + IRN=$(docker exec $containerName psql --username=postgres --dbname=$container -t -c 'select irn from organization') + ## if database is empty, it will put IRN 000000 + if [ "$IRN" == "" ]; then + echo "no IRN set, using 000000" + IRN=000000 + fi + ##Take out the extra space from IRN returned from db. + IRN=`echo $IRN | sed -e 's/^[[:space:]]*//'` + backupFile=./backup/${IRN}${entityId}-ess-db.$(date +%Y-%m-%d-%H-%M-%S).backup echo "entityId is $entityId" echo "container name is $containerName" fi