---
title: HTSQL Regression Tests
cache: test/expect.yaml
tests:

- title: Dropping regression database and roles
  id: cleanup
  tests:
  - connect: { database: postgres }
    sql: |
        DROP DATABASE IF EXISTS "htsql_regress";
        DROP ROLE IF EXISTS "htsql_regress.owner",
                            "htsql_regress.user",
                            "htsql_regress.limited",
                            "htsql_regress.admin",
                            "htsql_regress.staff",
                            "htsql_regress.clerk",
                            "htsql_regress.public";

- title: Setting up the database
  id: setup
  tests:
  - connect: { database: postgres }
    sql: |
        CREATE DATABASE "htsql_regress" WITH ENCODING = 'UTF-8';
  - connect: { database: htsql_regress }
    sql-include: test/regress.sql

- db: { database: htsql_regress, username: htsql_regress.owner }
  config: test/config.yaml
  plugins: ['htsql_contrib:SetTimezonePlugin',
            'htsql_contrib:RetryConnectPlugin',
            'htsql_contrib:LoggingPostgreSQLPlugin']
  plugin-parameters: { connection-timezone: '-8' }

- include: test/regress/functions.yaml
- include: test/regress/selection.yaml
- include: test/regress/formatters.yaml
- include: test/regress/presentations.yaml
- include: test/regress/routines.yaml
- include: test/regress/permissions.yaml
- include: test/regress/errors.yaml
- include: test/regress/operations.yaml
- include: test/regress/contrib.yaml