# HG changeset patch
# User Matt Calmes <calmes@ssdt-ohio.org>
# Date 1635180515 14400
# Node ID d75786228e6ba60f1e7d4262febb480e0a268899
# Parent  4e42c10e3c0d7eb3aec1ff92cb1892543a107780
INV-197 wire workflows backup into shared scripts

diff -r 4e42c10e3c0d -r d75786228e6b scripts/backup-container-docker.sh
--- a/scripts/backup-container-docker.sh	Mon Oct 18 07:05:16 2021 -0400
+++ b/scripts/backup-container-docker.sh	Mon Oct 25 12:48:35 2021 -0400
@@ -24,6 +24,11 @@
    entityId=$(prop 'entityId' | tr -d '"')
    containerName="$entityId-inventory-db"
    IRN=$(docker exec $containerName psql --username=postgres --dbname=$container -t -c 'select districtirn from inventoryconfiguration')
+   ## 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}-${container}.$(date +%Y-%m-%d-%H-%M-%S).backup
@@ -31,10 +36,15 @@
    echo "container name is $containerName"
 fi
 
-## if database is empty, it will put IRN 000000
-if [ "$IRN" == "" ]; then
-   echo "no IRN set,using 000000"
-    IRN=000000
+if [ "$container" = "workflowsdb" ]; then
+   function prop {
+       grep "${1}" .env/ssdt-workflows-shared.properties|cut -d'=' -f2
+   }
+   entityId=$(prop 'entityId' | tr -d '"')
+   containerName="$entityId-workflows-db"
+   backupFile=./backup/${entityId}-${container}.$(date +%Y-%m-%d-%H-%M-%S).backup
+   echo "entityId is $entityId"
+   echo "container name is $containerName"
 fi
 
 echo "Container is $container"
diff -r 4e42c10e3c0d -r d75786228e6b scripts/backup-workflow.sh
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/backup-workflow.sh	Mon Oct 25 12:48:35 2021 -0400
@@ -0,0 +1,5 @@
+#!/bin/bash
+
+source "${SSDT_SCRIPTS:-$(dirname "${BASH_SOURCE[0]}")}/.functions.sh"
+
+${SSDT_SCRIPTS}/backup-container-docker.sh workflowdb ${1}
diff -r 4e42c10e3c0d -r d75786228e6b scripts/exec-all-projects-docker.sh
--- a/scripts/exec-all-projects-docker.sh	Mon Oct 18 07:05:16 2021 -0400
+++ b/scripts/exec-all-projects-docker.sh	Mon Oct 25 12:48:35 2021 -0400
@@ -1,27 +1,17 @@
 #!/bin/bash
-# Scans for docker projects in specified parent path and
+# Scans for standard SSDT docker projects in specified parent path and
 # executes the specified command.
 #
-# The first parameter specifices theparent directory to search for 
-# docker-compose.yml # files must be specified.  #
+# The first parameter specifices the parent directory to search for. 
 # 
-# the second paramter specifies the command to execute against each
-# compose project.
+# The second parameter specifies the command to execute against each
+# SSDT standard docker project found under the parent directory.
 #
 # examples:
 #
-#   /ssdt/scripts/exec-all-projects.sh /data/prod docker-compose ps
-# 
-#     executes "docker-compose ps" against all projects under /data/prod
-#
-#   /ssdt/scripts/exec-all-projects.sh /data/prod /ssdt/ /ssdt/scripts/backup-usas.sh
+#   /ssdt/scripts/exec-all-projects-docker.sh /data/prod /ssdt/scripts/backup-inventory.sh
 #
-#     runs backup-usas.sh script against all projects under /data/prod
-#
-#   /ssdt/scripts/exec-all-projects.sh /data/prod "/ssdt/scripts/capture.sh | /ssdt/scripts/send.sh -"
-#
-#       captures the log files from all containers and sends one log file per project 
-#       to the SSDT support server.
+#     runs backup-inventory.sh script against all projects under /data/prod
 #
 ##
 
@@ -40,12 +30,13 @@
    projectdir=`dirname $f`
    project=`basename $projectdir`
    cd $projectdir
-   echo "projectdir is $projectdir"
-   echo -e "----\n$executing $COMMAND on $project \n----"      
+   if ls .env/ssdt-*-shared.properties 1> /dev/null 2>&1; then
+      echo "projectdir is $projectdir"
+      echo -e "----\n$executing $COMMAND on $project \n----"      
 
-   #bash -c "${COMMAND}"
-   echo ""
-
+      bash -c "${COMMAND}"
+      echo ""
+   fi
 done
 
 cd $ORIGINALDIR