Saved progress at the end of the loop #149
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: CI | |
| on: | |
| push: | |
| branches: [main, develop] | |
| pull_request: | |
| branches: [main, develop] | |
| env: | |
| NODE_VERSION: '22' | |
| CI: true | |
| jobs: | |
| lint: | |
| name: Lint & Type Check | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| - name: Setup Node.js | |
| uses: actions/setup-node@v4 | |
| with: | |
| node-version: ${{ env.NODE_VERSION }} | |
| cache: 'npm' | |
| - name: Install dependencies | |
| run: npm ci | |
| - name: Type Check | |
| run: npx tsc --noEmit | |
| - name: Validate Translations | |
| run: node scripts/validate-translations.cjs | |
| test: | |
| name: Unit & Integration Tests | |
| runs-on: ubuntu-latest | |
| services: | |
| postgres: | |
| image: postgres:15 | |
| env: | |
| POSTGRES_USER: test | |
| POSTGRES_PASSWORD: test | |
| POSTGRES_DB: polly_test | |
| ports: | |
| - 5432:5432 | |
| options: >- | |
| --health-cmd pg_isready | |
| --health-interval 10s | |
| --health-timeout 5s | |
| --health-retries 5 | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| - name: Setup Node.js | |
| uses: actions/setup-node@v4 | |
| with: | |
| node-version: ${{ env.NODE_VERSION }} | |
| cache: 'npm' | |
| - name: Install dependencies | |
| run: npm ci | |
| - name: Wait for PostgreSQL | |
| run: | | |
| until pg_isready -h localhost -p 5432 -U test; do | |
| echo "Waiting for PostgreSQL..." | |
| sleep 2 | |
| done | |
| - name: Setup test database | |
| env: | |
| DATABASE_URL: postgresql://test:test@localhost:5432/polly_test | |
| run: npm run db:push | |
| - name: Run tests | |
| env: | |
| DATABASE_URL: postgresql://test:test@localhost:5432/polly_test | |
| NODE_ENV: test | |
| run: npx vitest run --reporter=verbose | |
| - name: Run tests with coverage | |
| env: | |
| DATABASE_URL: postgresql://test:test@localhost:5432/polly_test | |
| NODE_ENV: test | |
| run: npx vitest run --coverage || true | |
| - name: Upload coverage reports | |
| uses: codecov/codecov-action@v3 | |
| if: success() | |
| with: | |
| files: ./coverage/lcov.info | |
| fail_ci_if_error: false | |
| build: | |
| name: Build | |
| runs-on: ubuntu-latest | |
| needs: [lint, test] | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| - name: Setup Node.js | |
| uses: actions/setup-node@v4 | |
| with: | |
| node-version: ${{ env.NODE_VERSION }} | |
| cache: 'npm' | |
| - name: Install dependencies | |
| run: npm ci | |
| - name: Build | |
| run: npm run build | |
| e2e: | |
| name: E2E Tests | |
| runs-on: ubuntu-latest | |
| needs: build | |
| if: (github.event_name == 'pull_request' && github.base_ref == 'main') || (github.event_name == 'push' && github.ref_name == 'main') | |
| services: | |
| postgres: | |
| image: postgres:15 | |
| env: | |
| POSTGRES_USER: test | |
| POSTGRES_PASSWORD: test | |
| POSTGRES_DB: polly_e2e | |
| ports: | |
| - 5432:5432 | |
| options: >- | |
| --health-cmd pg_isready | |
| --health-interval 10s | |
| --health-timeout 5s | |
| --health-retries 5 | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| - name: Setup Node.js | |
| uses: actions/setup-node@v4 | |
| with: | |
| node-version: ${{ env.NODE_VERSION }} | |
| cache: 'npm' | |
| - name: Install dependencies | |
| run: npm ci | |
| - name: Install Playwright browsers | |
| run: npx playwright install --with-deps chromium | |
| - name: Wait for PostgreSQL to be ready | |
| run: | | |
| for i in {1..30}; do | |
| if pg_isready -h localhost -p 5432 -U test; then | |
| echo "PostgreSQL is ready!" | |
| break | |
| fi | |
| echo "Waiting for PostgreSQL... attempt $i" | |
| sleep 2 | |
| done | |
| - name: Setup database | |
| env: | |
| DATABASE_URL: postgresql://test:test@localhost:5432/polly_e2e | |
| run: | | |
| npm run db:push | |
| echo "Database schema pushed successfully" | |
| - name: Verify database connection | |
| env: | |
| DATABASE_URL: postgresql://test:test@localhost:5432/polly_e2e | |
| run: | | |
| PGPASSWORD=test psql -h localhost -U test -d polly_e2e -c "SELECT 1 as connection_test;" | |
| echo "Database connection verified" | |
| - name: Build application | |
| run: npm run build | |
| - name: Run E2E tests | |
| env: | |
| DATABASE_URL: postgresql://test:test@localhost:5432/polly_e2e | |
| NODE_ENV: production | |
| SESSION_SECRET: e2e-test-session-secret-minimum-32-characters-long | |
| BASE_URL: http://localhost:5000 | |
| SMTP_ENABLED: false | |
| run: npx playwright test --timeout=60000 | |
| - name: Upload Playwright report | |
| uses: actions/upload-artifact@v4 | |
| if: always() | |
| with: | |
| name: playwright-report | |
| path: playwright-report/ | |
| retention-days: 7 | |
| security: | |
| name: Security Audit | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| - name: Setup Node.js | |
| uses: actions/setup-node@v4 | |
| with: | |
| node-version: ${{ env.NODE_VERSION }} | |
| cache: 'npm' | |
| - name: Install dependencies | |
| run: npm ci | |
| - name: Run npm audit | |
| run: npm audit --audit-level=high || true | |
| - name: Check for known vulnerabilities | |
| run: npx better-npm-audit audit || true |