remove old file #755
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: 🧪 Run tests and deploy demo data | |
on: | |
push: | |
branches: | |
- master | |
- control | |
paths-ignore: | |
- 'website/**' | |
- '.github/workflows/website.yml' | |
pull_request: | |
branches: | |
- master | |
paths-ignore: | |
- 'website/**' | |
- '.github/workflows/website.yml' | |
workflow_dispatch: | |
jobs: | |
docker-tests: | |
name: Run tests and deploy demo data | |
runs-on: ubuntu-latest | |
steps: | |
- uses: actions/checkout@v4 | |
- name: "build dockerfile" | |
run: docker build -f .docker/Dockerfile --tag opengisch/signalo:unstable . | |
- name: "initialize container" | |
run: | | |
docker run -d -p 5432:5432 --name signalo -v $(pwd):/src opengisch/signalo:unstable | |
docker exec signalo init_db.sh wait | |
docker exec -e PGSERVICE=pg_signalo_demo signalo init_db.sh build -d | |
docker exec signalo pg_dump --format custom --exclude-schema=public --blobs --compress 5 --file signalo-testing-db-dump-with-demo.backup signalo_demo | |
docker exec -e PGSERVICE=pg_signalo_demo signalo /src/scripts/all-signs.py | |
# - uses: actions/setup-node@v3 | |
# with: | |
# node-version: '18' | |
- name: "test data model" | |
run: docker exec signalo pytest | |
- name: "test images" | |
run: docker exec signalo /src/test/official_sign_images.sh | |
- name: "test changelog" | |
run: docker exec signalo /src/test/test-changelog.sh | |
# - name: "schema lint" | |
# run: | | |
# npm i --no-fund -g schemalint | |
# cp .schemalintrc.js.template .schemalintrc.js | |
# schemalint | |
- name: Login to DockerHub | |
if: github.event_name != 'pull_request' | |
uses: docker/login-action@v3 | |
with: | |
username: ${{ secrets.DOCKER_USERNAME }} | |
password: ${{ secrets.DOCKER_PASSWORD }} | |
- name: "push to dockerhub" | |
if: github.event_name != 'pull_request' | |
run: | | |
docker push opengisch/signalo:unstable | |
- name: Deploy Demo DB | |
if: github.event_name != 'pull_request' | |
env: | |
DEMO_DB_HOST: ${{ secrets.DEMO_DB_HOST }} | |
DEMO_DB_USER: ${{ secrets.DEMO_DB_USER }} | |
DEMO_DB_PORT: ${{ secrets.DEMO_DB_PORT }} | |
DEMO_DB_TESTING: ${{ secrets.DEMO_DB_TESTING }} | |
DEMO_DB_PASSWORD: ${{ secrets.DEMO_DB_PASSWORD }} | |
run: | | |
CONNECTION="--host=${DEMO_DB_HOST} --username=${DEMO_DB_USER} --port=${DEMO_DB_PORT} --dbname=${DEMO_DB_TESTING}" | |
export PGPASSWORD=${DEMO_DB_PASSWORD} | |
psql ${CONNECTION} -c "DROP SCHEMA IF EXISTS signalo_app CASCADE; DROP SCHEMA IF EXISTS signalo_db CASCADE;" | |
pg_restore ${CONNECTION} --exit-on-error --clean --if-exists --no-owner signalo-testing-db-dump-with-demo.backup | |
psql ${CONNECTION} -v EXIT_ON_ERROR=on -f ./datamodel/roles/setup.sql | |
- name: "failure logs" | |
if: failure() | |
run: | | |
docker logs signalo | |
- uses: actions/upload-artifact@v4 | |
id: artifact | |
if: github.event_name == 'pull_request' | |
with: | |
name: signalo-pr-testing | |
path: | | |
signalo-testing-db-dump-with-demo.backup | |
project | |
- name: Schedule download comment | |
uses: ./.github/actions/post_sticky_comment | |
if: github.event_name == 'pull_request' | |
with: | |
marker: pr-testing | |
body: | | |
### Testing | |
Download [demo data dump and QGIS project](${{ steps.artifact.outputs.artifact-url }}). | |
*(Built from commit ${{ github.event.pull_request.head.sha }})* | |
pr: ${{ github.event.number }} |