ci_cd.yml

name: CI/CD
on:
  push:
    branches:
      - '*'

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'