Update and fix pljava, plrust, a couple others #1389
Workflow file for this run
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: Build, install and publish extensions | |
| on: | |
| push: | |
| branches: | |
| - "main" | |
| paths: | |
| - "contrib/**" | |
| pull_request: | |
| branches: | |
| - "main" | |
| paths: | |
| - "contrib/**" | |
| jobs: | |
| find_directories: | |
| name: 🔍 Find changed extensions | |
| runs-on: ubuntu-20.04 | |
| outputs: | |
| directories: ${{ steps.find_directories.outputs.build_matrix }} | |
| steps: | |
| - name: Check out the repo | |
| uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 0 | |
| - name: Find commit to compare with | |
| id: versions | |
| run: | | |
| set -xe | |
| BRANCH_NAME=$(git rev-parse --abbrev-ref HEAD) | |
| # On main branch, the diff should compare to the previous commit hash. | |
| # On PR, the diff should compare with main branch. | |
| if [ "${BRANCH_NAME}" == "main" ]; then | |
| changed_relative_to_ref=$(git show --quiet HEAD^1 | grep commit | cut -d" " -f2) | |
| else | |
| changed_relative_to_ref="origin/${{ github.base_ref || 'not-a-branch' }}" | |
| fi | |
| echo "changed_relative_to_ref=${changed_relative_to_ref}" >> $GITHUB_OUTPUT | |
| - name: Check out the coredb repo to reuse some actions | |
| uses: actions/checkout@v4 | |
| with: | |
| repository: tembo-io/tembo | |
| path: ./.tembo | |
| ref: 21a43bbd64936b6b7fe7b080c2bfbd82df31fe2c | |
| - name: Find directories with Dockerfiles that changed | |
| id: find_directories | |
| uses: ./.tembo/.github/actions/find-changed-directories | |
| with: | |
| contains_the_file: Trunk.toml | |
| changed_relative_to_ref: ${{ steps.versions.outputs.changed_relative_to_ref }} | |
| ignore_dirs: ".tembo cli" | |
| test: | |
| name: 🧪 ${{ matrix.ext.name }} on 🐘 ${{ matrix.pg }} | |
| runs-on: | |
| - self-hosted | |
| - dind | |
| - xlarge-16x16 | |
| container: | |
| image: quay.io/tembo/trunk-test-tembo:f3b2a28-pg15 | |
| options: --user root | |
| needs: | |
| - find_directories | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| ext: ${{ fromJson(needs.find_directories.outputs.directories).include }} | |
| pg: [15] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Install system dependencies | |
| run: | | |
| set -xe | |
| apt-get update | |
| apt-get install -y pkg-config libssl-dev gosu | |
| - name: Test the extension within Docker | |
| run: cd ${{ matrix.ext.path }} && trunk build --test | |
| build: | |
| name: 📦 ${{ matrix.ext.name }} on 🐘 ${{ matrix.pg }} | |
| runs-on: | |
| - self-hosted | |
| - dind | |
| - xlarge-16x16 | |
| container: | |
| image: quay.io/tembo/trunk-test-tembo:f3b2a28-pg15 | |
| options: --user root | |
| needs: | |
| - find_directories | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| ext: ${{ fromJson(needs.find_directories.outputs.directories).include }} | |
| pg: [17, 16, 15, 14] | |
| env: | |
| TRUNK_API_TOKEN: ${{ secrets.TRUNK_AUTH_TOKEN }} | |
| PGHOST: "localhost" | |
| PGPORT: "5432" | |
| PGDATABASE: "postgres" | |
| PGUSER: "postgres" | |
| PGPASSWORD: "postgres" | |
| POSTGRES_PASSWORD: "password" | |
| TRUNK_AMPLIFY_WEBHOOK: ${{ secrets.TRUNK_AMPLIFY_WEBHOOK }} | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Install system dependencies | |
| run: | | |
| set -xe | |
| apt-get update | |
| apt-get install -y pkg-config libssl-dev gosu | |
| - name: Build extension | |
| id: build | |
| run: cd ${{ matrix.ext.path }} && trunk build --pg-version ${{ matrix.pg }} | |
| continue-on-error: true | |
| - name: Install the extension | |
| if: matrix.pg == 15 | |
| run: cd ${{ matrix.ext.path }} && EXTENSION=${{ matrix.ext.name }} && trunk install -f .trunk/*.tar.gz $EXTENSION | |
| - name: Handle shared_preload_libraries | |
| if: matrix.pg == 15 | |
| shell: bash -e {0} | |
| run: | | |
| for val in pg_cron timescaledb pg_search pg_analytics citus plrust; do | |
| if [[ "${{ matrix.ext.path }}" == *"$val"* ]]; then | |
| echo handling shared_preload_libraries for $val | |
| echo "shared_preload_libraries = '$val'" >> /var/lib/postgresql/data2/postgresql.conf | |
| fi | |
| done | |
| - name: Enable the extension | |
| if: matrix.pg == 15 && github.ref != 'refs/heads/main' | |
| run: | | |
| su postgres -c '/usr/lib/postgresql/15/bin/postgres &' | |
| sleep 5 | |
| export EXTENSIONS=$(psql postgres://postgres:postgres@localhost:5432 -tA -c "select name from pg_available_extensions where name NOT IN ('plpgsql', 'plperlu', 'plperl', 'pltcl', 'plpython3u', 'pltclu', 'pg_stat_statements', 'pgml')";) | |
| for EXTENSION in $EXTENSIONS; do | |
| echo "enabling extension: $EXTENSION" | |
| psql postgres://postgres:postgres@localhost:5432 -c "create extension if not exists \"$EXTENSION\" cascade;" | |
| done | |
| - name: Publish the extension | |
| if: steps.build.outcome == 'success' && github.ref == 'refs/heads/main' | |
| run: cd ${{ matrix.ext.path }} && trunk publish | |
| - name: Re-build Trunk UI | |
| if: github.ref == 'refs/heads/main' | |
| run: | | |
| sleep 2 | |
| curl -X POST -d '{}' \ | |
| "${{ secrets.TRUNK_AMPLIFY_WEBHOOK }}" \ | |
| -H "Content-Type:application/json" |