Add some more tests #60
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# .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 |