ci: prepare database #42

	name: Commit Phase

	on:
	push:
	branches: ['main']
	pull_request:
	branches: ['main']

	env:
	CARGO_TERM_COLOR: always

	jobs:

	prepare_database:
	name: Prepare Database
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- uses: dtolnay/rust-toolchain@stable

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

	- name: Create database
	run: sqlx database create
	env:
	DATABASE_URL: ${{ secrets.DATABASE_URL }}

	- name: Run migrations
	run: sqlx migrate run
	env:
	DATABASE_URL: ${{ secrets.DATABASE_URL }}

	test:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- uses: dtolnay/rust-toolchain@stable
	- run: cargo test --bins

	lint:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- uses: dtolnay/rust-toolchain@stable
	with:
	components: clippy
	- name: Lint check
	run: cargo clippy -- -D clippy::pedantic -W clippy::nursery

	build_and_upload:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4
	- uses: dtolnay/rust-toolchain@stable

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

	- name: Upload artifact
	uses: actions/upload-artifact@v4
	with:
	name: connect
	path: target/release/connect

Provide feedback