#!/bin/sh # # pg_shell test environment generation script # # # BIN_DIR="/opt/postgresql/bin/" TEMP_DIR="/tmp/test-env/" DB_USER="pgsql" TEST_USER="someone" TEST_DBNAME="testdb" TEST_TABLE="testtab" validate() { if [ $1 = $2 ] ; then echo "done" else echo "failed" exit fi } echo " * generating test environment" # TEMP DIR echo -n " - creating temporary directory $TEMP_DIR ..." mkdir -p $TEMP_DIR validate $? 0 # TEST USER echo -n " - creating non-superuser $TEST_USER ..." $BIN_DIR/createuser --username=$DB_USER --no-superuser --no-createdb --no-createrole --quiet $TEST_USER validate $? 0 # TEST DATABASE echo -n " - creating database $TEST_DBNAME ..." $BIN_DIR/createdb --username=$DB_USER --quiet --owner $TEST_USER $TEST_DBNAME validate $? 0 # TEST TABLE echo -n " - creating table $TEST_TABLE ..." cat < $TEMP_DIR/test-env.php pg_shell test page data; } } ?>
id
data
EOF validate $? 0 # REQUEST FILE echo -n " - creating HTTP request file ..." cat < $TEMP_DIR/http-request GET /test-env.php?id=1;<> HTTP/1.0 EOF validate $? 0 echo " * finished" cat <