#!/bin/bash
set -e

DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null && pwd )"

SCHEMA=$(cat "$DIR/../sql/schema.sql")

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<EOF
	CREATE DATABASE timescale_built;
EOF

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "timescale_built" <<EOF
    CREATE USER ohm WITH PASSWORD 'itsohm';
    $SCHEMA
    GRANT INSERT ON ohm_stats TO ohm;
EOF