Add pgrx test and reorganize PGXS tests #284
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: CI/CD | |
| on: | |
| push: | |
| pull_request: | |
| schedule: | |
| - cron: '0 14 3 * *' # Monthly at 2pm on the 3rd | |
| jobs: | |
| pgxs: | |
| name: 🐘 PGXS on Postgres ${{ matrix.pg }} | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| pg: [17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4, 9.3, 9.2, 9.1, '9.0', 8.4, 8.3, 8.2] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Build Image | |
| run: docker build -t pgxn-tools-test . | |
| # First test system UID, otherwise it can't use files touched by root. | |
| - name: Test with system UID | |
| run: "docker run -w /repo --rm --volume \"$(pwd):/repo\" -e AS_USER=pgxn_worker -e LOCAL_UID=$(id -u) pgxn-tools-test ./test/pgxs/runtest.sh ${{ matrix.pg }}" | |
| - name: Test as root | |
| run: "docker run -w /repo --rm --volume \"$(pwd):/repo\" pgxn-tools-test ./test/pgxs/runtest.sh ${{ matrix.pg }}" | |
| pgrx: | |
| name: 🦀 pgrx on Postgres ${{ matrix.pg }} | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| pg: [16, 15, 14, 13, 12, 11] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Build Image | |
| run: docker build -t pgxn-tools-test . | |
| # First test system UID, otherwise it can't use files touched by root. | |
| - name: Test with system UID | |
| run: "docker run -w /repo --rm --volume \"$(pwd):/repo\" -e AS_USER=pgxn_worker -e LOCAL_UID=$(id -u) pgxn-tools-test ./test/pgrx/runtest.sh ${{ matrix.pg }}" | |
| - name: Test as root | |
| run: "docker run -w /repo --rm --volume \"$(pwd):/repo\" pgxn-tools-test ./test/pgrx/runtest.sh ${{ matrix.pg }}" | |
| bundle: | |
| name: ${{ matrix.util.icon }} Bundle with ${{ matrix.util.name }} | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| util: | |
| - { icon: 🏷️, name: git, dir: "", run: ./test/pgxs } | |
| - { icon: 🤐, name: zip, dir: /test, run: ./pgxs } | |
| env: { PG_VERSION: 16 } | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Build Image | |
| run: docker build -t pgxn-tools-test . | |
| - name: Test ${{ matrix.util.name }} | |
| run: "docker run -w /repo --rm --volume \"$(pwd)${{ matrix.util.dir }}:/repo\" pgxn-tools-test ${{ matrix.util.run }}/runtest.sh ${{ env.PG_VERSION }} ${{ matrix.util[1] }}" | |
| - name: Test ${{ matrix.util.name }} with extra file | |
| run: "docker run -w /repo --rm --volume \"$(pwd)${{ matrix.util.dir }}:/repo\" pgxn-tools-test ${{ matrix.util.run }}/runtest.sh ${{ env.PG_VERSION }} ${{ matrix.util[1] }} yes" | |
| - name: Test ${{ matrix.util.name }} with archive-all | |
| env: { GIT_ARCHIVE_CMD: archive-all } | |
| run: "docker run -w /repo --rm --volume \"$(pwd)${{ matrix.util.dir }}:/repo\" pgxn-tools-test ${{ matrix.util.run }}/runtest.sh ${{ env.PG_VERSION }} ${{ matrix.util[1] }}" | |
| - name: Test NO_CLUSTER | |
| run: "docker run -w /repo -e NO_CLUSTER=1 --rm --volume \"$(pwd)${{ matrix.util.dir }}:/repo\" pgxn-tools-test ${{ matrix.util.run }}/no_cluster_test.sh ${{ env.PG_VERSION }}" | |
| publish: | |
| # Publish for a tag starting with v. | |
| name: Push to Docker Hub | |
| needs: [pgxs, pgrx, bundle] | |
| if: startsWith(github.ref, 'refs/tags/v') | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Check out the repo | |
| uses: actions/checkout@v4 | |
| - name: Docker meta | |
| id: meta | |
| uses: docker/metadata-action@v5 | |
| with: | |
| images: pgxn/pgxn-tools | |
| tags: | | |
| type=semver,pattern={{version}} | |
| type=semver,pattern={{major}}.{{minor}} | |
| type=semver,pattern=v{{major}} | |
| type=raw,value=bookworm | |
| labels: | | |
| org.opencontainers.image.title=PGXN Tools | |
| org.opencontainers.image.licenses=PostgreSQL | |
| - name: Login to DockerHub | |
| uses: docker/login-action@v3 | |
| with: | |
| username: ${{ secrets.DOCKER_USERNAME }} | |
| password: ${{ secrets.DOCKER_PASSWORD }} | |
| - name: Build and Push | |
| # https://github.com/marketplace/actions/build-and-push-docker-images | |
| uses: docker/build-push-action@v5 | |
| with: | |
| push: true | |
| tags: ${{ steps.meta.outputs.tags }} | |
| labels: ${{ steps.meta.outputs.labels }} |