Add local dev setup & Fix CI DB connection #115

	name: CI

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

	permissions:
	contents: read

	jobs:
	test:
	runs-on: ubuntu-latest
	strategy:
	matrix:
	ruby-version: [2.6, 2.7, 3.0]
	services:
	postgres:
	image: postgres:15
	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
	cache-version: 1
	- name: Install Library Dependencies
	run: sudo apt-get install libpq-dev
	- name: Setup Database
	env:
	PGHOST: localhost
	PGPORT: 5432
	PGUSER: postgres
	PGPASSWORD: postgres
	run: \|
	cat <<EOF > config/database.yml
	test:
	adapter: postgresql
	encoding: unicode
	pool: 20
	database: prodder__blog_prod
	migration_user: prodder
	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