Add local dev setup & Fix CI DB connection #122

	name: CI

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

	permissions:
	contents: read

	jobs:
	test:
	runs-on: ubuntu-latest
	strategy:
	fail-fast: false
	matrix:
	ruby-version: [2.6, 2.7, 3.0]
	services:
	postgres:
	image: postgres:15-alpine
	ports:
	- 5432:5432
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_HOST_AUTH_METHOD: trust
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	steps:
	- name: Checkout Project
	uses: actions/checkout@v4
	- name: Set up Ruby
	uses: ruby/setup-ruby@v1
	with:
	ruby-version: ${{ matrix.ruby-version }}
	bundler-cache: true
	- name: Install Library Dependencies
	run: \|
	sudo apt update
	sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb\_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
	wget -qO- https://www.postgresql.org/media/keys/ACCC4CF8.asc \| sudo tee /etc/apt/trusted.gpg.d/pgdg.asc &>/dev/null
	sudo apt install -y postgresql-client
	- name: Setup Database
	run: \|
	mkdir -p config
	cat <<EOF > config/database.yml
	test:
	adapter: postgresql
	encoding: unicode
	pool: 20
	database: prodder_test
	EOF
	- name: Test with RSpec
	env:
	PGHOST: localhost
	PGPORT: 5432
	PGUSER: postgres
	PGPASSWORD: postgres
	run: bundle exec rspec
	- name: Test with Cucumber
	env:
	PGHOST: localhost
	PGPORT: 5432
	PGUSER: postgres
	PGPASSWORD: postgres
	run: bundle exec cucumber

Provide feedback