df-web/setup-postgres.sh

#! /usr/bin/env bash
# Run on the first time configuring database
if [ ! -d $PGHOST ]; then
      mkdir -p $PGHOST
fi

if [ ! -d $PGDATA ]; then
      echo 'Initializing postgresql database...'
      initdb $PGDATA --auth=trust >/dev/null
fi

# pg_ctl start -l $LOG_PATH -o "-c listen_addresses= -c unix_socket_directories=$PGHOST"

# TODO move to alembic migrations
psql $PGDATABASE << EOF
CREATE TABLE routes ( \
	id text PRIMARY KEY,
	name text,
	"creatorName" text,
	"creatorCharacter" int,
	dustpoints jsonb[],
	checkpoints jsonb[],
	"startLocation" jsonb,
	"endLocation" jsonb,
	"creationDate" text
);