# HG changeset patch
# User smith@nwoca.org
# Date 1453315643 18000
# Node ID a5175713518cddfdcbff991901672e153f14edcb
# Parent  1c74d128973909c537e4afec82f2648fb41b88ba
add training db images

diff -r 1c74d1289739 -r a5175713518c trainingdb-usas/Dockerfile
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/trainingdb-usas/Dockerfile	Wed Jan 20 13:47:23 2016 -0500
@@ -0,0 +1,11 @@
+
+FROM docker.ssdt.io/trainingdb
+
+ADD http://files.ssdt.io/usas-training.backup.gz $BACKUP_FILE
+
+RUN chmod a+r $BACKUP_FILE
+
+env DB_NAME=usasdb \
+    DB_USER=usas \
+    DB_PASS=usasdefault
+
diff -r 1c74d1289739 -r a5175713518c trainingdb-usps/Dockerfile
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/trainingdb-usps/Dockerfile	Wed Jan 20 13:47:23 2016 -0500
@@ -0,0 +1,11 @@
+
+FROM docker.ssdt.io/trainingdb
+
+ADD http://files.ssdt.io/usps-training.backup.gz $BACKUP_FILE
+
+RUN chmod a+r $BACKUP_FILE
+
+env DB_NAME=uspsdb \
+    DB_USER=usps \
+    DB_PASS=uspsdefault
+
diff -r 1c74d1289739 -r a5175713518c trainingdb/Dockerfile
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/trainingdb/Dockerfile	Wed Jan 20 13:47:23 2016 -0500
@@ -0,0 +1,13 @@
+#
+# Docker file to create postgres image for ssdt applications
+
+FROM docker.ssdt.io/ssdt-postgres:2
+
+MAINTAINER Dave Smith smith@nwoca.org
+
+ENV PGDATA=/var/pgdata/trainingdata \
+    BACKUP_FILE=/training.backup.gz
+
+COPY setupDatabase.sh /docker-entrypoint-initdb.d/
+
+RUN chmod 755 /docker-entrypoint-initdb.d/setupDatabase.sh	
diff -r 1c74d1289739 -r a5175713518c trainingdb/setupDatabase.sh
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/trainingdb/setupDatabase.sh	Wed Jan 20 13:47:23 2016 -0500
@@ -0,0 +1,28 @@
+#!/bin/bash
+
+export PGUSER=postgres
+TEST=`psql <<- EOSQL
+   SELECT 1 FROM pg_database WHERE datname='$DB_NAME';
+EOSQL`
+
+if [[ $TEST == "1" ]]; then
+    echo "$DB_NAME exists. continuing startup."
+    # database exists
+    # $? is 0
+    exit 0
+else
+echo "Creating $DB_NAME for $DB_USER"
+psql <<- EOSQL
+   CREATE ROLE $DB_USER WITH LOGIN ENCRYPTED PASSWORD '${DB_PASS}' CREATEDB;
+   CREATE DATABASE $DB_NAME WITH OWNER $DB_USER TEMPLATE template0 ENCODING 'UTF8';
+   GRANT ALL PRIVILEGES ON DATABASE $DB_NAME TO $DB_USER;
+EOSQL
+
+echo "Restoring backup file"
+
+gunzip -f $BACKUP_FILE -c | psql
+
+fi
+
+echo ""
+echo "$DB_NAME database created"