feat: add github workflow #6
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 | ||
| on: | ||
| push: | ||
| branches: | ||
| - main | ||
| pull_request: | ||
| branches: | ||
| - main | ||
| env: | ||
| CARGO_TERM_COLOR: always | ||
| RUST_BACKTRACE: 1 | ||
| CARGO_INCREMENTAL: "false" | ||
| jobs: | ||
| Test: | ||
| strategy: | ||
| fail-fast: false # We want all of them to run, even if one fails | ||
| matrix: | ||
| os: ubuntu-latest | ||
| pg: [ "12", "13", "14", "15", "16" ] | ||
| include: | ||
| - postgres: 16 | ||
| rust: "beta" | ||
| runs-on: ${{ matrix.os }} | ||
| env: | ||
| RUSTC_WRAPPER: sccache | ||
| SCCACHE_DIR: /home/runner/.cache/sccache | ||
| PG_VER: ${{ matrix.postgres }} | ||
| RUST_TOOLCHAIN: ${{ matrix.rust || 'stable' }} | ||
| steps: | ||
| - uses: actions/checkout@v4 | ||
| - name: Set up prerequisites and environment | ||
| run: | | ||
| sudo apt-get update -y -qq --fix-missing | ||
| echo "" | ||
| echo "----- Install sccache -----" | ||
| mkdir -p $HOME/.local/bin | ||
| curl -L https://github.com/mozilla/sccache/releases/download/v0.2.15/sccache-v0.2.15-x86_64-unknown-linux-musl.tar.gz | tar xz | ||
| mv -f sccache-v0.2.15-x86_64-unknown-linux-musl/sccache $HOME/.local/bin/sccache | ||
| chmod +x $HOME/.local/bin/sccache | ||
| echo "$HOME/.local/bin" >> $GITHUB_PATH | ||
| mkdir -p /home/runner/.cache/sccache | ||
| echo "" | ||
| echo "----- Set up dynamic variables -----" | ||
| cat $GITHUB_ENV | ||
| echo "" | ||
| echo "----- Remove old postgres -----" | ||
| sudo apt remove -y '^postgres.*' '^libpq.*' '^clang.*' '^llvm.*' '^libclang.*' '^libllvm.*' '^mono-llvm.*' | ||
| echo "" | ||
| echo "----- Install system dependencies -----" | ||
| sudo apt-get install -y \ | ||
| build-essential \ | ||
| llvm-14-dev libclang-14-dev clang-14 \ | ||
| gcc \ | ||
| libssl-dev \ | ||
| libz-dev \ | ||
| make \ | ||
| pkg-config \ | ||
| strace \ | ||
| zlib1g-dev | ||
| echo "" | ||
| ./ci/rustup.sh | ||
| echo "----- Set up cross compilation -----" | ||
| sudo apt-get install -y --fix-missing crossbuild-essential-arm64 | ||
| echo 'CARGO_TARGET_AARCH64_UNKNOWN_LINUX_GNU_LINKER=aarch64-linux-gnu-gcc' >> $GITHUB_ENV | ||
| # TODO: not all of these should be needed, but for now it's likely fine. | ||
| echo 'BINDGEN_EXTRA_CLANG_ARGS_aarch64-unknown-linux-gnu=-target aarch64-unknown-linux-gnu -isystem /usr/aarch64-linux-gnu/include/ -ccc-gcc-name aarch64-linux-gnu-gcc' >> $GITHUB_ENV | ||
| echo "----- Print env -----" | ||
| env | ||
| echo "" | ||
| - name: Install release version of PostgreSQL | ||
| run: | | ||
| echo "----- Set up PostgreSQL Apt repository -----" | ||
| sudo apt-get install -y wget gnupg | ||
| sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' | ||
| wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - | ||
| sudo apt-get update -y -qq --fix-missing | ||
| echo "" | ||
| sudo apt-get install -y \ | ||
| postgresql-$PG_VER \ | ||
| postgresql-server-dev-$PG_VER | ||
| echo "" | ||
| echo "----- pg_config -----" | ||
| pg_config | ||
| echo "" | ||
| - name: Set up PostgreSQL permissions | ||
| run: sudo chmod a+rwx `/usr/lib/postgresql/$PG_VER/bin/pg_config --pkglibdir` `/usr/lib/postgresql/$PG_VER/bin/pg_config --sharedir`/extension /var/run/postgresql/ | ||
| - name: Cache cargo registry | ||
| uses: actions/cache@v4 | ||
| continue-on-error: false | ||
| with: | ||
| path: | | ||
| ~/.cargo/registry | ||
| ~/.cargo/git | ||
| key: tests-${{ runner.os }}-${{ hashFiles('**/Cargo.lock', '.github/workflows/tests.yml') }} | ||
| - name: Cache sccache directory | ||
| uses: actions/cache@v4 | ||
| continue-on-error: false | ||
| with: | ||
| path: /home/runner/.cache/sccache | ||
| key: pgrx-tests-sccache-${{ runner.os }}-${{ hashFiles('**/Cargo.lock', '.github/workflows/tests.yml') }} | ||
| - name: Start sccache server | ||
| run: sccache --start-server | ||
| - name: Print sccache stats (before run) | ||
| run: sccache --show-stats | ||
| - name: Install cargo-pgrx | ||
| run: | | ||
| PGRX_VERSION=$(cargo metadata --format-version 1 | jq -r '.packages[]|select(.name=="pgrx")|.version') | ||
| cargo install --locked --version=$PGRX_VERSION cargo-pgrx --debug --force | ||
| cargo pgrx init --pg${{ matrix.pg }} /usr/lib/postgresql/$PG_VER/bin/pg_config | ||
| - name: Run tests | ||
| run: echo "\q" | cargo pgrx run pg${{ matrix.pg }} && cargo test --no-default-features --features pg${{ matrix.pg }} | ||
| # Attempt to make the cache payload slightly smaller. | ||
| - name: Clean up built PGRX files | ||
| run: | | ||
| cd target/debug/deps/ | ||
| for built_file in $(find * -type f -executable -print | grep -v "\.so$"); do | ||
| base_name=$(echo $built_file | cut -d- -f1); | ||
| for basefile in "$base_name".*; do | ||
| [ -f "$basefile" ] || continue; | ||
| echo "Removing $basefile" | ||
| rm $basefile | ||
| done; | ||
| echo "Removing $built_file" | ||
| rm $built_file | ||
| done | ||
| - name: Stop sccache server | ||
| run: sccache --stop-server || true | ||
| Install: | ||
| runs-on: ubuntu-latest | ||
| steps: | ||
| - uses: actions/checkout@v4 | ||
| - name: Install PostgreSQL headers | ||
| run: | | ||
| sudo apt-get update | ||
| sudo apt-get install postgresql-server-dev-14 | ||
| - name: Install cargo-pgrx | ||
| run: | | ||
| PGRX_VERSION=$(cargo metadata --format-version 1 | jq -r '.packages[]|select(.name=="pgrx")|.version') | ||
| cargo install --locked --version=$PGRX_VERSION cargo-pgrx --debug --force | ||
| cargo pgrx init --pg14 $(which pg_config) | ||
| - name: Install TypeID/pgrx | ||
| run: | | ||
| cargo pgrx install --no-default-features --release --sudo | ||
| - name: Start PostgreSQL | ||
| run: | | ||
| sudo systemctl start postgresql.service | ||
| pg_isready | ||
| # superuser (-s), can create databases (-d) and roles (-r), no password prompt (-w) named runner | ||
| sudo -u postgres createuser -s -d -r -w runner | ||
| - name: Verify install | ||
| run: | | ||
| createdb -U runner runner | ||
| psql -U runner -c "create extension typeid;" | ||
| psql -U runner -c "select typeid_generate('user');" | ||
| rustfmt: | ||
| runs-on: ubuntu-latest | ||
| steps: | ||
| - name: Checkout code | ||
| uses: actions/checkout@v4 | ||
| - name: Run rustfmt | ||
| run: cargo fmt -- --check | ||
