Update CI #70

	name: 🧰 Verify SQLx Metadata

	on:
	push:
	paths:
	- "engine/**"
	- ".github/workflows/verify_sqlx.yaml"

	jobs:
	verify_sqlx:
	runs-on: ubuntu-20.04
	permissions:
	contents: read
	packages: write
	attestations: write
	id-token: write
	services:
	# Label used to access the service container
	postgres:
	# Docker Hub image
	image: postgres:17
	# Provide the password for postgres
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: property
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 5s
	--health-timeout 2s
	--health-retries 10
	ports:
	# Maps tcp port 5432 on service container to the host
	- 5432:5432

	steps:
	- name: Checkout
	uses: actions/checkout@v4

	- name: Install Rust
	run: \|
	rustup toolchain install stable --profile minimal --no-self-update

	- name: Cache Rust
	uses: Swatinem/rust-cache@v2
	with:
	workspaces: engine

	- name: Install sqlx-cli
	working-directory: ./engine
	run: \|
	cargo install sqlx-cli --no-default-features --features native-tls,postgres

	- name: Set github env
	run: \|
	echo "DATABASE_URL=postgres://postgres:postgres@localhost:5432/property" >> $GITHUB_ENV

	- name: Prepare DB
	working-directory: ./engine
	run: cargo sqlx migrate run

	- name: Check sqlx metadata files
	working-directory: ./engine
	run: cargo sqlx prepare --check

Provide feedback