customise.sh

apk add --update python python-dev py-pip 

pip install pgxnclient

apk add postgresql-contrib

apk add postgresql-dev=10.4-r0

apk add ca-certificates

apk add build-base

pgxn install temporal_tables

apk add git

apk add bison

apk add flex

# Overwrite the pg_hba.conf connection configuration file with
# the one in the repo

mv /pg_hba.conf /var/lib/postgresql/pgdata

echo 'now creating user root'
su - postgres -c 'psql -c "CREATE USER root WITH SUPERUSER;"'
echo 'created user root'

# also add a password for the postgres user

su - postgres -c $'psql -c "ALTER USER postgres PASSWORD \'postgres\';"'

git clone https://github.com/postgrespro/jsquery.git
cd jsquery
make USE_PGXS=1
make USE_PGXS=1 install

cd ..


#fetch db creation script for ethercis and run it
git clone https://github.com/ethercis/ehrservice || { echo "Could not clone ethercis/ehrservice repository, exiting..." && exit 1; }

cd ehrservice/db # stay in this dir, we'll run graddle in a while

su - postgres -c "psql < /ehrservice/db/createdb.sql"

#now create db schemas etc using graddle && flyway

#need java for graddle
apk add openjdk8
#install graddle
wget https://services.gradle.org/distributions/gradle-4.3-bin.zip
mkdir -p /opt/gradle
unzip -d /opt/gradle gradle-4.3-bin.zip
export PATH=$PATH:/opt/gradle/gradle-4.3/bin
#run flyway via graddle
gradle flywayMigrate

cd / # go to root before clean up

echo "apply v9_migration.sql"
su - postgres -c "psql -d ethercis -a -f /v9_migration.sql"
echo "applied ok"

#clean directories used for installation
rm -f -r /ehrservice
rm -f -r /jsquery
rm -f -r /opt/gradle
rm -f -r /usr/lib/jvm/java-1.8-openjdk
rm -f -r /usr/lib/jvm/default-jvm

su - postgres -c "pg_ctl  -D $PGDATA -m fast -w stop"