#!/bin/sh

EXIT_VALUE=0

DB=$PWD/gnc_test

PG_CTL="pg_ctl -D $DB -o -p7777"

case $1 in
  create)
    $PG_CTL status | grep "pid" && $PG_CTL stop && sleep 1
    rm -rf $DB
    initdb $DB || EXIT_VALUE=1
    ;;
  destroy)
    $PG_CTL status | grep "pid" && $PG_CTL stop && sleep 1
    rm -rf $DB
    ;;
  start)
    $PG_CTL start
    ;;
  stop)
    $PG_CTL stop
    ;;
  status)
    $PG_CTL status
    ;;
  connect)
    $PG_CTL status | grep "not running" && $PG_CTL start && sleep 1
    psql -p 7777 $2
    ;;
  *)
    echo "Bad command: $1"
    ;;
esac

exit $EXIT_VALUE