# HG changeset patch
# User Marc Davis <marc.davis@mcoecn.org>
# Date 1725561486 14400
# Node ID fb25711eead77b1e5ab73259a7f3fcba17b2b742
# Parent  646ecb227dbcde27d152e6ac18ef617a7f8b72e5
add irn to the ess backup

diff -r 646ecb227dbc -r fb25711eead7 scripts/backup-container-docker.sh
--- 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