Migrate schemas #409
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: PGMQ Extension | |
| defaults: | |
| run: | |
| shell: bash | |
| working-directory: ./ | |
| on: | |
| pull_request: | |
| branches: | |
| - main | |
| paths-ignore: | |
| - 'pgmq-rs/**' | |
| push: | |
| branches: | |
| - main | |
| paths-ignore: | |
| - 'pgmq-rs/**' | |
| release: | |
| types: | |
| - created | |
| jobs: | |
| 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: "pgmq-extension-lint" | |
| workspaces: | | |
| pgmq/ | |
| # 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 | |
| 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: "pgmq-extension-test" | |
| workspaces: | | |
| pgmq | |
| # Additional directories to cache | |
| cache-directories: | | |
| /home/runner/.pgrx | |
| - uses: ./.github/actions/pgx-init | |
| with: | |
| working-directory: ./ | |
| - name: test | |
| run: | | |
| sudo apt-get update && sudo apt-get install -y postgresql-server-dev-14 | |
| git clone https://github.com/pgpartman/pg_partman.git && \ | |
| cd pg_partman && \ | |
| sudo make install && cd ../ | |
| cp /usr/share/postgresql/14/extension/pg_partman* ~/.pgrx/15.4/pgrx-install/share/postgresql/extension/ | |
| cp /usr/lib/postgresql/14/lib/pg_partman_bgw.so ~/.pgrx/15.4/pgrx-install/lib/postgresql/ | |
| rm -rf ./target/pgrx-test-data-* || true | |
| pg_version=$(stoml Cargo.toml features.default) | |
| cargo pgrx run ${pg_version} --pgcli || true | |
| cargo pgrx test ${pg_version} | |
| publish: | |
| # only publish release events | |
| if: github.event_name == 'release' | |
| name: trunk publish | |
| 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: "pgmq-extension-test" | |
| workspaces: | | |
| pgmq/extension | |
| # Additional directories to cache | |
| 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: trunk build | |
| working-directory: ./ | |
| run: trunk build | |
| # use below when trunk build supports --dockerfile for pgrx | |
| # run: | | |
| # pgmq_ver=$(stoml extension/Cargo.toml package.version) | |
| # trunk build --path . --dockerfile ./Dockerfile.build --install-command "cd extension && cargo pgrx install" --name pgmq --version ${pgmq_ver} | |
| - name: trunk publish | |
| working-directory: ./ | |
| env: | |
| TRUNK_API_TOKEN: ${{ secrets.TRUNK_AUTH_TOKEN }} | |
| run: | | |
| pgmq_ver=$(stoml Cargo.toml package.version) | |
| pgmq_descr=$(stoml Cargo.toml package.description) | |
| pgmq_repo=$(stoml Cargo.toml package.repository) | |
| trunk publish pgmq --version ${pgmq_ver} --file .trunk/pgmq-${pgmq_ver}.tar.gz --description "A lightweight distributed message queue. Like AWS SQS and RSMQ, on Postgres." --homepage "https://github.com/tembo-io/pgmq" --repository "https://github.com/tembo-io/pgmq" --license "PostgreSQL" --category featured --category orchestration | |
| 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 Cargo.toml package.version)" >> $GITHUB_OUTPUT | |
| - name: Build and upload image | |
| run: | | |
| docker build --build-arg="PGMQ_VER=${{ steps.versions.outputs.TAG_VER }}" -t pgmq-pg images/pgmq-pg | |
| docker tag pgmq-pg quay.io/tembo/pgmq-pg:v${{ steps.versions.outputs.TAG_VER }} | |
| docker tag pgmq-pg quay.io/tembo/pgmq-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/pgmq-pg:v${{ steps.versions.outputs.TAG_VER }} | |
| docker push quay.io/tembo/pgmq-pg:latest |