ci.yml

name: CI/CD Pipeline

on:
  push:
    branches: [ main, develop ]
  pull_request:
    branches: [ main ]

jobs:
  lint-and-test:
    runs-on: ubuntu-latest

    services:
      postgres:
        image: postgres:15
        env:
          POSTGRES_USER: approvals_user
          POSTGRES_PASSWORD: approvals_password
          POSTGRES_DB: approvals_db_test
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        ports:
          - 5432:5432

    steps:
    - name: Checkout code
      uses: actions/checkout@v4

    - name: Setup Node.js
      uses: actions/setup-node@v4
      with:
        node-version: '18'
        cache: 'npm'

    - name: Install dependencies
      run: npm ci

    - name: Generate Prisma client
      run: npx prisma generate

    - name: Run linter
      run: npm run lint

    - name: Check formatting
      run: npm run format:check

    - name: Type check
      run: npm run type-check

    - name: Run database migrations
      run: npx prisma migrate deploy
      env:
        DATABASE_URL: postgresql://approvals_user:approvals_password@localhost:5432/approvals_db_test

    - name: Run tests
      run: npm test
      env:
        DATABASE_URL: postgresql://approvals_user:approvals_password@localhost:5432/approvals_db_test
        NEXTAUTH_SECRET: test-secret
        NEXTAUTH_URL: http://localhost:3000

    - name: Build application
      run: npm run build
      env:
        DATABASE_URL: postgresql://approvals_user:approvals_password@localhost:5432/approvals_db_test
        NEXTAUTH_SECRET: test-secret
        NEXTAUTH_URL: http://localhost:3000