db.sh

#!/usr/bin/env bash

export PGDATA="$PWD/.pgdata"
export PGPORT=5432
export PGHOST="localhost"

export POSTGRES_USER="recipe"
export POSTGRES_PASSWORD="test"
export POSTGRES_DBNAME="recipe"
export DATABASE_URL="postgresql://$POSTGRES_USER:$POSTGRES_PASSWORD@localhost:5432/$POSTGRES_DBNAME"


function start_db {
  if [ ! -d "$PGDATA" ]; then 
    echo "Initializing PostgreSQL database..."
    initdb --username=postgres --encoding=UTF8 "$PGDATA"
    pg_ctl -D "$PGDATA" -o "-k /tmp" -l "$PGDATA/logfile" start
    psql -U postgres -c "CREATE ROLE $POSTGRES_USER WITH LOGIN PASSWORD '$POSTGRES_PASSWORD' SUPERUSER;"
    psql -U postgres -c "CREATE DATABASE $POSTGRES_DBNAME;"
    psql -U postgres -c "GRANT ALL PRIVILEGES ON DATABASE $POSTGRES_DBNAME TO $POSTGRES_USER;"
    psql -U postgres -d $POSTGRES_DBNAME -c "GRANT ALL ON SCHEMA public TO $POSTGRES_USER;"
    pg_ctl -D "$PGDATA" stop
  fi
  echo "Starting PostgreSQL server..."
  pg_ctl -D "$PGDATA" -o "-k /tmp" -l "$PGDATA/logfile" start 
  echo "PostgreSQL server running on port $PGPORT"
} 

function stop_db {
  echo "Stopping PostgreSQL server..."
  pg_ctl -D "$PGDATA" -o "-k /tmp" -l "$PGDATA/logfile" stop
}

case "$1" in 
  start)
    start_db
    ;;
  stop)
    stop_db
    ;;
  *)
    echo "Usage: $0 {start|stop}"
    exit 1
    ;;
esac