diff scripts/backup-container-docker.sh @ 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 579a61f2037d
children
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