ci: test postgres #6

	name: CI

	on:
	push:
	branches: [ "master" ]

	pull_request:
	types: [ opened, synchronize, reopened ]
	branches:
	- master

	env:
	CARGO_TERM_COLOR: auto
	SQLX_VERSION: 0.8.2
	DATABASE_TEST_URL: postgres://postgres:password@localhost:5432/testdb

	jobs:
	build-test:
	name: Build + Test
	runs-on: ubuntu-latest
	services:
	postgres:
	image: postgres:14
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: password
	POSTGRES_DB: postgres
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	# Map ports on service container to the host
	ports:
	- 5432:5432
	steps:
	- uses: actions/checkout@v4
	- uses: dtolnay/rust-toolchain@stable
	- uses: Swatinem/rust-cache@v2
	with:
	key: sqlx-${{ env.SQLX_VERSION }}
	- name: Create database
	run: \|
	sudo apt-get install libpq-dev -y
	psql -h localhost -p 5432 -U postgres -d postgres -c 'create user testuser'
	psql -h localhost -p 5432 -U postgres -d postgres -c 'create database testdb with owner = testuser'
	- name: Test
	run: cargo test

	# fmt-clippy:
	# name: Check
	# runs-on: ubuntu-latest
	# steps:
	# - uses: actions/checkout@v4
	# - uses: dtolnay/rust-toolchain@stable
	# with:
	# components: rustfmt, clippy
	# - name: Check fmt
	# run: cargo fmt --check
	# - name: Clippy
	# run: cargo clippy -- -D warnings

Provide feedback