CI-CD

move to postgres on github #4

	name: CI-CD

	on: [ push ]

	jobs:
	ci:
	runs-on: ubuntu-latest
	env:
	DB_CONNECTION: pgsql
	DB_DATABASE: test
	DB_USERNAME: postgres
	DB_PASSWORD: password
	APP_ENV: testing
	BROADCAST_DRIVER: log
	services:
	postgres:
	image: postgres:latest
	env:
	POSTGRES_PASSWORD: password
	POSTGRES_DB: test
	ports:
	- 5432/tcp
	options: --health-cmd="pg_isready -U postgres" --health-interval=10s --health-timeout=5s --health-retries=5

	strategy:
	fail-fast: false
	matrix:
	php-versions: [ "8.2" ]
	steps:
	- uses: actions/checkout@v4

	- name: Setup PHP, with composer and extensions
	uses: shivammathur/setup-php@v2
	with:
	php-version: ${{ matrix.php-versions }}
	tools: phpmd
	extensions: mbstring, dom, fileinfo, pgsql, grpc, :psr
	coverage: xdebug

	- name: Enable PostgreSQL Extensions
	run: \|
	sudo service postgresql start
	sudo -u postgres psql -c "CREATE EXTENSION IF NOT EXISTS vector;" -d test

	- name: Test with phpunit
	run: \|
	npm install && npm run build
	XDEBUG_MODE=coverage php artisan test --coverage --min=50
	env:
	DB_PORT: ${{ job.services.mysql.ports['3306'] }}

	cd:
	runs-on: ubuntu-latest
	needs: ci
	if: github.ref == 'refs/heads/main'
	steps:
	- name: Checkout code
	uses: actions/checkout@v4
	- name: Setup PHP
	uses: shivammathur/setup-php@v2
	with:
	php-version: 8.2
	tools: composer:v2
	coverage: none
	- name: Install Project Dependencies
	run: \|
	curl https://envoyer.io/deploy/${{ secrets.ENVOYER }}

Provide feedback