chore: run tests on macos in ci #754

Workflow file for this run

.github/workflows/pull_request.yml at b014571

	name: Pull Request

	on:
	workflow_dispatch:
	pull_request:
	paths: # Only run when changes are made to rust code or root Cargo
	- "crates/**"
	- "lib/**"
	- "fuzz/**"
	- "xtask/**"
	- "Cargo.toml"
	- "Cargo.lock"
	- "rust-toolchain.toml"
	- "rustfmt.toml"
	# or in js packages
	- "packages/**"
	# or in workflows
	- ".github/workflows/**"

	concurrency:
	group: ${{ github.workflow }}-${{ github.event_name }}-${{ github.ref }}
	cancel-in-progress: true

	env:
	RUST_LOG: info
	RUST_BACKTRACE: 1
	RUSTUP_WINDOWS_PATH_ADD_BIN: 1

	jobs:
	format:
	name: Format
	runs-on: ubuntu-latest
	steps:
	- name: Checkout PR branch
	uses: actions/checkout@v4

	- name: Free Disk Space
	uses: ./.github/actions/free-disk-space

	- name: Install toolchain
	uses: moonrepo/setup-rust@v1
	with:
	components: rustfmt
	bins: taplo-cli
	cache-base: main
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}

	- name: Setup Bun
	uses: oven-sh/setup-bun@v2

	- name: Install JS dependencies
	run: bun install

	- name: Setup Just
	uses: extractions/setup-just@v3

	- name: Echo Tool Versions
	run: \|
	just format-ci-versions

	- name: Run format
	run: \|
	just format-ci

	actionlint:
	name: Lint GitHub Actions
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- name: Download actionlint
	id: get_actionlint
	run: bash <(curl https://raw.githubusercontent.com/rhysd/actionlint/main/scripts/download-actionlint.bash)
	shell: bash
	- name: Check workflow files
	run: ${{ steps.get_actionlint.outputs.executable }} -color
	shell: bash

	lint:
	name: Lint Project
	runs-on: ubuntu-latest
	steps:
	- name: Checkout PR Branch
	uses: actions/checkout@v4
	with:
	submodules: true
	- name: Free Disk Space
	uses: ./.github/actions/free-disk-space
	- name: Install toolchain
	uses: moonrepo/setup-rust@v1
	with:
	components: clippy
	cache-base: main
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}

	# we need to use the same database as we do locally for sqlx prepare to output the same hashes
	- name: Build and start PostgreSQL with plpgsql_check
	run: \|
	docker build -t postgres-plpgsql-check:latest .
	docker run -d --name postgres \
	-e POSTGRES_USER=postgres \
	-e POSTGRES_PASSWORD=postgres \
	-e POSTGRES_DB=postgres \
	-p 5432:5432 \
	postgres-plpgsql-check:latest
	# Wait for postgres to be ready
	for _ in {1..30}; do
	if docker exec postgres pg_isready -U postgres; then
	break
	fi
	sleep 1
	done

	- name: Setup sqlx-cli
	run: cargo install sqlx-cli

	- name: Setup Bun
	uses: oven-sh/setup-bun@v2

	- name: Install JS dependencies
	run: bun install

	- name: Setup Just
	uses: extractions/setup-just@v3

	- name: Echo Tool Versions
	run: \|
	just lint-ci-versions

	- name: Run Lints
	run: \|
	just lint-ci

	- name: Check for changes
	run: \|
	if [[ $(git status --porcelain) ]]; then
	git status
	git diff
	exit 1
	fi

	test:
	name: Test
	runs-on: ${{ matrix.os }}
	strategy:
	matrix:
	include:
	# use the same images we use for compiling
	- os: windows-2022
	- os: ubuntu-22.04
	- os: macos-14
	steps:
	- name: Checkout PR branch
	uses: actions/checkout@v4
	with:
	submodules: true
	- name: Free Disk Space
	uses: ./.github/actions/free-disk-space
	- name: Install toolchain
	uses: moonrepo/setup-rust@v1
	with:
	cache-base: main
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}

	# For Windows and macOS, use the action since PostgreSQL Docker image doesn't support Windows containers
	# and macOS runners do not support Docker
	- name: Setup postgres (Windows)
	if: runner.os == 'Windows' \|\| runner.os == 'macOS'
	id: postgres
	uses: ikalnytskyi/action-setup-postgres@v7

	# Install the pglpgsql_check extension on macOS (Part 1)
	- name: Install PostgreSQL development tools
	if: runner.os == 'macOS'
	run: \|
	brew install postgresql@15
	echo "/opt/homebrew/opt/postgresql@15/bin" >> "$GITHUB_PATH"

	# Install the pglpgsql_check extension on macOS (Part 2)
	- name: Install and compile plpgsql_check
	if: runner.os == 'macOS'
	run: \|
	# First, ensure we're using the same PostgreSQL that the action installed
	export PATH="$(pg_config --bindir):$PATH"

	# Verify we're targeting the right PostgreSQL installation
	echo "PostgreSQL version: $(pg_config --version)"
	echo "Extension directory: $(pg_config --sharedir)/extension"
	echo "Library directory: $(pg_config --pkglibdir)"

	# Clone and build plpgsql_check
	git clone https://github.com/okbob/plpgsql_check.git
	cd plpgsql_check

	# Clean and compile
	make USE_PGXS=1 clean
	make USE_PGXS=1 all

	# Install (may need sudo depending on permissions)
	sudo make USE_PGXS=1 install

	# Verify installation
	echo "Extension control files:"
	ls -la "$(pg_config --sharedir)/extension/" \| grep plpgsql \|\| echo "No plpgsql_check found"

	echo "Extension library files:"
	ls -la "$(pg_config --pkglibdir)/" \| grep plpgsql \|\| echo "No plpgsql_check library found"

	# Install the pglpgsql_check extension on macOS (Part 3)
	- name: Create extension in database
	if: runner.os == 'macOS'
	env:
	PGSERVICE: ${{ steps.postgres.outputs.service-name }}
	run: \|
	psql -c "CREATE EXTENSION plpgsql_check;"

	# Verify installation
	psql -c "SELECT extname, extversion FROM pg_extension WHERE extname = 'plpgsql_check';"

	# For Linux, use custom Docker image with plpgsql_check
	- name: Build and start PostgreSQL with plpgsql_check
	if: runner.os == 'Linux'
	run: \|
	docker build -t postgres-plpgsql-check:latest .
	docker run -d --name postgres \
	-e POSTGRES_USER=postgres \
	-e POSTGRES_PASSWORD=postgres \
	-e POSTGRES_DB=postgres \
	-p 5432:5432 \
	postgres-plpgsql-check:latest
	# Wait for postgres to be ready
	for _ in {1..30}; do
	if docker exec postgres pg_isready -U postgres; then
	break
	fi
	sleep 1
	done

	- name: Run tests
	run: cargo test --workspace

	test-js-bindings:
	name:
	Test JS Bindings
	# use the same image we use for compiling
	runs-on: ubuntu-22.04
	services:
	postgres:
	image: postgres:latest
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: postgres
	ports:
	- 5432:5432
	steps:
	- name: Checkout PR branch
	uses: actions/checkout@v4
	with:
	submodules: true
	- name: Free Disk Space
	uses: ./.github/actions/free-disk-space
	- name: Install toolchain
	uses: moonrepo/setup-rust@v1
	with:
	cache-base: main
	- name: Build main binary
	run: cargo build -p pgt_cli --release
	- name: Setup Bun
	uses: oven-sh/setup-bun@v2
	- name: Install JS dependencies
	run: bun install
	- name: Build TypeScript code
	working-directory: packages/@postgrestools/backend-jsonrpc
	run: bun run build
	- name: Run JS tests
	working-directory: packages/@postgrestools/backend-jsonrpc
	run: bun run test

	codegen:
	name: Check Codegen
	runs-on: ubuntu-22.04
	services:
	postgres:
	image: postgres:latest
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: postgres
	ports:
	- 5432:5432
	steps:
	- name: Checkout PR branch
	uses: actions/checkout@v4
	with:
	submodules: true
	- name: Free Disk Space
	uses: ./.github/actions/free-disk-space
	- name: Install toolchain
	uses: moonrepo/setup-rust@v1
	with:
	cache-base: main
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
	- name: Ensure RustFMT on nightly toolchain
	run: rustup component add rustfmt --toolchain nightly
	- name: echo toolchain
	run: rustup show
	- name: Run the analyser codegen
	run: cargo run -p xtask_codegen -- analyser
	- name: Run the configuration codegen
	run: cargo run -p xtask_codegen -- configuration
	- name: Run the docs codegen
	run: cargo run -p docs_codegen
	- name: Check for git diff -- run "just ready" if you see an error
	run: \|
	if [[ $(git status --porcelain) ]]; then
	git status
	git diff
	exit 1
	fi

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

chore: run tests on macos in ci #754

Workflow file

chore: run tests on macos in ci #754

Uh oh!

Jobs

Run details

Workflow file for this run