CI/CD

Create a table on the database to store configuration (#122) #126

	name: CI/CD

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

	env:
	TEST_ENVIRONMENT: "True"
	DATABASE_USER: postgres
	DATABASE_PASS: postgres
	DATABASE_HOST: localhost
	DATABASE_PORT: 5432
	DATABASE_NAME: postgres

	jobs:
	run-tests:
	runs-on: ubuntu-latest

	services:
	postgres:
	image: pgvector/pgvector:pg16
	env:
	POSTGRES_HOST_AUTH_METHOD: trust
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432

	steps:
	- name: Check out code
	uses: actions/checkout@v4

	- name: Set up Python 3.11
	uses: actions/setup-python@v5
	with:
	python-version: "3.11"

	- name: Poetry Install
	uses: knowsuchagency/poetry-install@v2

	- name: Create Tables
	run: \|
	PGPASSWORD=${{env.DATABASE_PASSWORD}} psql -U ${{env.DATABASE_USER}} -d ${{env.DATABASE_NAME}} -h ${{env.DATABASE_HOST}} -a -f ${{github.workspace}}/database_scripts/postgres.sql

	- name: Run pytest
	run: poetry run pytest

	- name: Ruff
	uses: chartboost/ruff-action@v1
	with:
	changed-files: 'true'

Provide feedback