#!/bin/sh -e

dropdb --if-exists gemma_test
createdb gemma_test
psql -qv ON_ERROR_STOP= -c 'CREATE EXTENSION pgtap' -d gemma_test

psql -qv ON_ERROR_STOP= -d gemma_test \
    -f gemma.sql \
    -f auth.sql \
    -f manage_users.sql

# Add test data, run tests and ROLLBACK to prevent test roles to stay
# in cluster, which would prevent tests from being repeatable
psql -qXv ON_ERROR_STOP= -v AUTOCOMMIT=off -d gemma_test \
    -f tap_tests_data.sql \
    -c 'SELECT plan(23)' \
    -f auth_tests.sql \
    -f manage_users_tests.sql \
    -c 'SELECT * FROM finish()' \
    -c 'ROLLBACK'