ci: add postgres service and migration run for tests #28

	name: 🧪 Test

	on:
	push:
	branches:
	- main
	pull_request:
	branches:
	- main

	jobs:
	build-vertex:
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:17
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: vaffelbot
	ports:
	- 5432:5432
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

	env:
	DATABASE_URL: postgres://postgres:postgres@localhost:5432/vaffelbot

	steps:
	- name: 🔍 Checkout
	uses: actions/checkout@v6

	- name: 🗄️ Run migrations
	run: cargo sqlx migrate run --source migrations

	- name: 🧪 Run tests
	run: cargo test -- --test-threads=1

	- name: ✅ Clippy
	run: cargo clippy -- -D warnings

	- name: 📦 Build
	run: cargo build --release

Provide feedback