#!/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

# Collect test roles to be dropped
# Concatenate with dummy role to prevent syntax error if there is no test role
TEST_ROLES=$(psql -qtc \
    "SELECT concat_ws(',', 'test', string_agg(rolname, ',')) FROM pg_roles
         WHERE rolname LIKE 'test%'")

# Drop test roles, add test data and run tests
psql -qXv ON_ERROR_STOP= -v -d gemma_test \
    -c "DROP ROLE IF EXISTS $TEST_ROLES" \
    -f tap_tests_data.sql \
    -c 'SELECT plan(23)' \
    -f auth_tests.sql \
    -f manage_users_tests.sql \
    -c 'SELECT * FROM finish()'