run.sh

#!/usr/bin/env bash
#
# Create the demo01 grafana dev environment.
#
set -e

# Works on linux and mac
SDIR=$(cd $(dirname ${BASH_SOURCE[0]}) && pwd)
PDIR=$(cd $(dirname $(dirname $SDIR)) && pwd)
PORT=4400
NAME='demo01'

printf '\x1b[35m'
cat <<EOF
# ================================================================
#
# Sample: $NAME
#
# ================================================================
EOF
printf '\x1b[0m'

#CIDS=($(docker ps --filter "name=$NAME" --format '{{.ID}}'))
cd $SDIR
rm -f $NAME.zip

printf '\x1b[35mINFO:%d: %s\x1b[0m\n' $LINENO 'initialize the environment'
set -x
(cd $PDIR && pipenv install)
{ set +x; } 2>/dev/null

printf '\x1b[35mINFO:%d: %s\x1b[0m\n' $LINENO 'create the local grafana service'
set -x
pipenv run grape --version
pipenv run grape delete -v -n $NAME -g $PORT
pipenv run grape create -v -n $NAME -g $PORT
{ set +x; } 2>/dev/null

printf '\x1b[35mINFO:%d: %s\x1b[0m\n' $LINENO 'populate the database'
# This is a bit tricky because we need to put the SQL in a place
# where the databased in the container can find it.
set -x
cp init.sql ${NAME}pg/mnt/$NAME.sql
docker exec -it ${NAME}pg ls -l /mnt/
docker exec -it ${NAME}pg psql -d postgres -U postgres -1 -f /mnt/$NAME.sql
{ set +x; } 2>/dev/null

printf '\x1b[35mINFO:%d: %s\x1b[0m\n' $LINENO 'grab the configuration'
set -x
pipenv run grape save -v -n $NAME -g $PORT -f $NAME.zip
{ set +x; } 2>/dev/null

printf '\x1b[35mINFO:%d: %s\x1b[0m\n' $LINENO 'update with the dashboard data'
set -x
unzip -l $NAME.zip
unzip -p $NAME.zip gr.json > gr.json
cp grafana.json gr.json
zip $NAME.zip gr.json
unzip -l $NAME.zip
{ set +x; } 2>/dev/null

printf '\x1b[35mINFO:%d: %s\x1b[0m\n' $LINENO 'upload the modified dashboard'
set -x
pipenv run grape load -v -n $NAME -g $PORT -f $NAME.zip
{ set +x; } 2>/dev/null

printf '\x1b[35mINFO:%d: %s\x1b[0m\n' $LINENO 'done'
cat <<EOF
You can now navigate to http://localhost:$PORT to see the demo
dashboard.
EOF