Update tests versions, PostgreSQL 16.4 and PostGIS 3.4.3 #192
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
name: Test services db, api | |
on: | |
pull_request: | |
paths: | |
- 'initdb/**' | |
- 'tests/**' | |
branches: | |
- 'main' | |
push: | |
branches: | |
- 'main' | |
paths: | |
- 'initdb/**' | |
- 'tests/**' | |
tags: | |
- "*" | |
workflow_dispatch: | |
jobs: | |
smoketest: | |
name: tests | |
runs-on: ubuntu-latest | |
steps: | |
- name: Check out the source | |
uses: actions/checkout@v4 | |
- name: Set env | |
run: cp .env.example .env | |
- name: Pull Docker images | |
run: docker compose pull db api | |
- name: Build Docker images | |
run: docker compose -f docker-compose.dev.yml -f docker-compose.yml build tests | |
- name: Install psql | |
run: sudo apt install postgresql-client | |
- name: Run PostgSail Database & API tests | |
# Environment variables | |
env: | |
# The hostname used to communicate with the PostgreSQL service container | |
PGHOST: localhost | |
PGPORT: 5432 | |
PGDATABASE: signalk | |
PGUSER: username | |
PGPASSWORD: password | |
run: | | |
set -eu | |
source .env | |
docker compose stop || true | |
docker compose rm || true | |
docker compose up -d db && sleep 30 && docker compose up -d api && sleep 5 | |
docker compose ps -a | |
echo ${PGSAIL_API_URL} | |
curl ${PGSAIL_API_URL} | |
psql -c "select 1" | |
echo "Test PostgreSQL version" | |
psql -c "SELECT version();" | |
echo "Test PostgSail version" | |
psql -c "SELECT value FROM app_settings WHERE name = 'app.version';" | |
echo "Test PostgSail Unit Test" | |
docker compose -f docker-compose.dev.yml -f docker-compose.yml up tests --abort-on-container-exit --exit-code-from tests | |
if [ $? != 0 ]; | |
then | |
echo "Error running db-tests" | |
exit 1 | |
fi | |
- name: Show the logs | |
if: always() | |
run: | | |
docker compose logs |