view prod/install-workflows-db.sh @ 539:5d5525414c8d production tip

update exec-all-projects-docker.sh to search for ./env/*-shared.properties in place of ./env/ssdt-*-shared.properties. ESS doesn't follow the same pattern for property file names.
author Marc Davis <marc.davis@mcoecn.org>
date Mon, 13 May 2024 13:28:30 -0400
parents 5909f75b4f13
children
line wrap: on
line source
#!/bin/bash
#
# read required env variables
BASEDIR="$PWD"
source $BASEDIR/.env/ssdt-workflows-shared.properties
source $BASEDIR/.env/ssdt-workflows-db.properties
#
# docker login
echo "Attempting to login to $artifactUrl"
docker login $artifactUrl -u $artifactUser -p $artifactPassword
# docker pull db image
echo "Attempting to pull $artifactUrl/ssdt-workflows-$dbVersion"
docker pull $artifactUrl/ssdt-workflows-db:$dbVersion
#
# Create workflows specific docker network for $entityId
echo "Attempting to create $entityId-workflows-net docker network"
docker network create $entityId-workflows-net
#docker run workflows-db (data mounted as volume) connected to $entityId-workflows-net docker network
echo "Attempting to execute docker run command"
docker run --name $entityId-workflows-db \
           --restart=unless-stopped \
           --mount source=$entityId-workflows-db,target=/var/lib/postgresql/data \
           --network $entityId-workflows-net \
           -e POSTGRES_DB=workflowsdb \
           -e POSTGRES_PASSWORD=$dbPassword \
           -d $artifactUrl/ssdt-workflows-db:$dbVersion