Skip to content

Fix number of tests #50

Fix number of tests

Fix number of tests #50

Workflow file for this run

# .github/workflows/pgtest.yml
name: Postgres tests
on: push
jobs:
pgtap:
runs-on: ubuntu-latest
strategy:
matrix:
version: [ '16', '17' ]
container: pgxn/pgxn-tools
env:
PGUSER: postgres
steps:
- run: pg-start ${{ matrix.version }}
- uses: actions/checkout@main
# Basic regression test.
- run: pg-build-test
# Basic regression test.
- name: install dependency from pgxn.org
run: pgxn install ddl_historization
- name: build application
run: make all
- name: install extension
run: make install
- name: create extension
run: >-
psql --host localhost --username postgres --dbname postgres \
-c 'CREATE EXTENSION schedoc CASCADE'
env:
PGPASSWORD: postgres
- name: start the extension
run: >-
psql --host localhost --username postgres --dbname postgres \
-c 'SELECT schedoc_start()'
env:
PGPASSWORD: postgres
- name: Checkout pgtap
uses: actions/checkout@v4
with:
repository: theory/pgtap
path: pgtap
ref: v1.3.3
- name: install pgtap
working-directory: pgtap
run: make && psql --host localhost --username postgres --dbname postgres --file sql/pgtap.sql
env:
PGPASSWORD: postgres
- name: run unit tests
run: pg_prove -v --host localhost --dbname postgres --username postgres test/sql/*.sql
env:
PGPASSWORD: postgres
- name: run integration tests
run: pg_prove -v --host localhost --dbname postgres --username postgres test/*.sql
env:
PGPASSWORD: postgres
# - name: shell tests
# working-directory: test/shell
# run: ./run.sh
# env:
# PGPASSWORD: postgres