#!/bin/sh

SCHEMA_CREATION_SCRIPT=./Create_DB.sql
TEST_DATA_SCRIPT=./Test_Data.sql

sudo psql -U postgres -c "DROP DATABASE test_artnet"
set -e

sudo psql -U postgres -c "CREATE DATABASE test_artnet WITH OWNER 'artnet_admin'"
sudo psql -U postgres test_artnet < $SCHEMA_CREATION_SCRIPT

sudo psql -U artnet_editor test_artnet < $TEST_DATA_SCRIPT