# HG changeset patch
# User Marc Davis <marc.davis@mcoecn.org>
# Date 1725562900 14400
# Node ID 80f3564f2553a8d4a8b51295c40d25a95395c7da
# Parent  2bd96ab37a7a225174356a82d2912c09b94c8bcc# Parent  208f77b60b783314cfce0a2ec05f46046d94c697
flow: Merged <release> '2.20.0' to <master> ('production').

diff -r 2bd96ab37a7a -r 80f3564f2553 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 15:01:40 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