#!/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 -d gemma_test \
    -c 'DROP ROLE IF EXISTS user_at, user_ro, admin_at, sys_admin1, test1' \
    -f tap_tests_data.sql \
    -c 'SELECT plan(23)' \
    -f auth_tests.sql \
    -f manage_users_tests.sql \
    -c 'SELECT * FROM finish()'