Make it actually release to PGXN on tagging #118
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: PG Later Extension | |
| defaults: | |
| run: | |
| shell: bash | |
| working-directory: ./ | |
| on: | |
| pull_request: | |
| branches: | |
| - main | |
| paths-ignore: | |
| - 'pglater-pg/**' | |
| push: | |
| branches: | |
| - main | |
| paths-ignore: | |
| - 'pglater-pg/**' | |
| release: | |
| types: | |
| - created | |
| jobs: | |
| dependencies: | |
| name: Install dependencies | |
| runs-on: ubuntu-22.04 | |
| steps: | |
| - uses: actions/checkout@v2 | |
| # rust needed to install trunk | |
| - name: Install Rust stable toolchain | |
| uses: actions-rs/toolchain@v1 | |
| with: | |
| toolchain: stable | |
| cache-directories: /home/runner/.pgrx | |
| - name: Install stoml and pg-trunk | |
| shell: bash | |
| run: | | |
| set -xe | |
| wget https://github.com/freshautomations/stoml/releases/download/v0.7.1/stoml_linux_amd64 &> /dev/null | |
| mv stoml_linux_amd64 stoml | |
| chmod +x stoml | |
| sudo mv stoml /usr/local/bin/ | |
| cargo install pg-trunk | |
| - name: Cache binaries | |
| uses: actions/cache@v2 | |
| with: | |
| path: | | |
| /usr/local/bin/stoml | |
| ~/.cargo/bin/trunk | |
| key: ${{ runner.os }}-bins-${{ github.sha }} | |
| restore-keys: | | |
| ${{ runner.os }}-bins- | |
| lint: | |
| name: Run linters | |
| runs-on: ubuntu-22.04 | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Install Rust minimal nightly with clippy and rustfmt | |
| uses: actions-rs/toolchain@v1 | |
| with: | |
| profile: minimal | |
| toolchain: nightly | |
| components: rustfmt, clippy | |
| - uses: Swatinem/rust-cache@v2 | |
| with: | |
| prefix-key: "pg_later-extension-lint" | |
| workspaces: | | |
| pg_later/ | |
| # Additional directories to cache | |
| cache-directories: | | |
| /home/runner/.pgrx | |
| - uses: ./.github/actions/pgx-init | |
| with: | |
| working-directory: ./ | |
| - name: Cargo format | |
| run: cargo +nightly fmt --all --check | |
| - name: Clippy | |
| run: cargo clippy | |
| test: | |
| name: Run tests | |
| needs: dependencies | |
| runs-on: ubuntu-22.04 | |
| steps: | |
| - uses: actions/checkout@v2 | |
| - name: Install Rust stable toolchain | |
| uses: actions-rs/toolchain@v1 | |
| with: | |
| toolchain: stable | |
| - uses: Swatinem/rust-cache@v2 | |
| with: | |
| prefix-key: "pg_later-extension-test" | |
| workspaces: | | |
| pg_later | |
| # Additional directories to cache | |
| cache-directories: | | |
| /home/runner/.pgrx | |
| - uses: ./.github/actions/pgx-init | |
| with: | |
| working-directory: ./ | |
| - name: Restore cached binaries | |
| uses: actions/cache@v2 | |
| with: | |
| path: | | |
| /usr/local/bin/stoml | |
| ~/.cargo/bin/trunk | |
| key: ${{ runner.os }}-bins-${{ github.sha }} | |
| restore-keys: | | |
| ${{ runner.os }}-bins- | |
| - name: test | |
| run: | | |
| pgrx15_config=$(/usr/local/bin/stoml ~/.pgrx/config.toml configs.pg15) | |
| echo "shared_preload_libraries = 'pg_later'" >> ~/.pgrx/data-15/postgresql.conf | |
| ~/.cargo/bin/trunk install pgmq --version 0.28.0 --pg-config ${pgrx15_config} | |
| pg_version=$(stoml Cargo.toml features.default) | |
| export PGLATER_SOCKET_URL="postgresql:///pg_later?host=/home/runner/.pgrx&user=${USER}&dbname=postgres&port=28815" | |
| cargo pgrx install --pg-config ${pgrx15_config} | |
| cargo pgrx run ${pg_version} --pgcli || true | |
| cargo pgrx start ${pg_version} | |
| cargo pgrx test ${pg_version} | |
| - name: Debugging information | |
| if: always() | |
| run: | | |
| set +e | |
| set -x | |
| echo "==========" | |
| cat ~/.pgrx/15.log | |
| publish: | |
| if: startsWith(github.ref, 'refs/tags/') | |
| name: trunk publish | |
| needs: dependencies | |
| runs-on: ubuntu-22.04 | |
| steps: | |
| - uses: actions/checkout@v2 | |
| - name: Install Rust stable toolchain | |
| uses: actions-rs/toolchain@v1 | |
| with: | |
| toolchain: stable | |
| - uses: Swatinem/rust-cache@v2 | |
| with: | |
| prefix-key: "pg_later-extension-test" | |
| workspaces: | | |
| pg_later/extension | |
| # Additional directories to cache | |
| cache-directories: | | |
| /home/runner/.pgrx | |
| - name: Restore cached binaries | |
| uses: actions/cache@v2 | |
| with: | |
| path: | | |
| /usr/local/bin/stoml | |
| ~/.cargo/bin/trunk | |
| key: ${{ runner.os }}-bins-${{ github.sha }} | |
| restore-keys: | | |
| ${{ runner.os }}-bins- | |
| - name: trunk build | |
| working-directory: ./ | |
| run: ~/.cargo/bin/trunk build | |
| - name: trunk publish | |
| working-directory: ./ | |
| env: | |
| TRUNK_API_TOKEN: ${{ secrets.TRUNK_AUTH_TOKEN }} | |
| run: ~/.cargo/bin/trunk publish | |
| build_and_push: | |
| name: Build and push images | |
| needs: | |
| - publish | |
| runs-on: | |
| - self-hosted | |
| - dind | |
| - large-8x8 | |
| outputs: | |
| short_sha: ${{ steps.versions.outputs.SHORT_SHA }} | |
| steps: | |
| - name: Check out the repo | |
| uses: actions/checkout@v3 | |
| - name: Install stoml and pg-trunk | |
| shell: bash | |
| run: | | |
| set -xe | |
| wget https://github.com/freshautomations/stoml/releases/download/v0.7.1/stoml_linux_amd64 &> /dev/null | |
| mv stoml_linux_amd64 stoml | |
| chmod +x stoml | |
| sudo mv stoml /usr/local/bin/ | |
| - name: Set version strings | |
| id: versions | |
| run: | | |
| echo "SHORT_SHA=$(git rev-parse --short HEAD)" >> $GITHUB_OUTPUT | |
| echo "TAG_VER=$(/usr/local/bin/stoml Trunk.toml extension.version)" >> $GITHUB_OUTPUT | |
| - name: Build and upload image | |
| run: | | |
| docker build --build-arg="PG_LATER_VER=${{ steps.versions.outputs.TAG_VER }}" -t pglater-pg images/pglater-pg | |
| docker tag pglater-pg quay.io/tembo/pglater-pg:v${{ steps.versions.outputs.TAG_VER }} | |
| docker tag pglater-pg quay.io/tembo/pglater-pg:latest | |
| - name: Login to Quay | |
| uses: docker/login-action@v2 | |
| with: | |
| registry: quay.io/tembo | |
| username: ${{ secrets.QUAY_USER_TEMBO }} | |
| password: ${{ secrets.QUAY_PASSWORD_TEMBO }} | |
| - name: Push image | |
| run: | | |
| docker push quay.io/tembo/pglater-pg:v${{ steps.versions.outputs.TAG_VER }} | |
| docker push quay.io/tembo/pglater-pg:latest |