dbusers.sh

#!/bin/bash

if [ "$1" = "" ]; then
  OUTPUT_FILE=.env.ec2
else
  OUTPUT_FILE=$1
fi

source $OUTPUT_FILE

echo From environment file $OUTPUT_FILE

export $(cat $OUTPUT_FILE | grep -v '^#' | xargs) && envsubst <scripts/database.template

export $(cat $OUTPUT_FILE | grep -v '^#' | xargs) && envsubst <scripts/privs.api.template
export $(cat $OUTPUT_FILE | grep -v '^#' | xargs) && envsubst <scripts/privs.prisma.template

echo ""
echo ""
export $(cat $OUTPUT_FILE | grep -v '^#' | xargs) && echo "*** ENV FILE ***
MYSQL_HOST=$MYSQL_HOST
MYSQL_USER=$MYSQL_USER
MYSQL_PASSWORD=$MYSQL_PASSWORD
MYSQL_DATABASE=$MYSQL_DATABASE
MYSQL_PORT=$MYSQL_PORT
"

SAFE_PRISMA_PASSWORD=$PRISMA_PASSWORD
SAFE_PRISMA_PASSWORD=$(echo $SAFE_PRISMA_PASSWORD | sed 's/\%/%25/')
SAFE_PRISMA_PASSWORD=$(echo $SAFE_PRISMA_PASSWORD | sed 's/\+/%2B/' | sed 's/\//%2F/')

export $(cat $OUTPUT_FILE | grep -v '^#' | xargs) && echo set PRISMA_DATABASE_URL=mysql://$PRISMA_USER:$SAFE_PRISMA_PASSWORD@$MYSQL_HOST:$MYSQL_PORT/$MYSQL_DATABASE