hivelore/.github/workflows/ci.yml at develop · hdev-core/hivelore · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
name: CI

on:
  push:
    branches:
      - main
  pull_request:

permissions:
  contents: read

env:
  CI: true
  NEXT_PUBLIC_API_URL: http://localhost:3001
  DATABASE_URL: postgresql://postgres:postgres@127.0.0.1:5432/postgres
  DIRECT_URL: postgresql://postgres:postgres@127.0.0.1:5432/postgres

jobs:
  quality:
    name: Quality
    runs-on: ubuntu-latest
    timeout-minutes: 20
    services:
      postgres:
        image: postgres:16
        env:
          POSTGRES_USER: postgres
          POSTGRES_PASSWORD: postgres
          POSTGRES_DB: postgres
        ports:
          - 5432:5432
        options: >-
          --health-cmd "pg_isready -U postgres -d postgres"
          --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: 22
          cache: npm

      - name: Install dependencies
        run: npm ci

      - name: Format Prisma schema
        run: npm run db:format

      - name: Validate Prisma schema
        run: npm run db:validate

      - name: Generate Prisma Client
        run: npm run db:generate

      - name: Check fresh PostgreSQL migrations
        run: npm run db:migrate:check:fresh
        env:
          TEST_DATABASE_ADMIN_URL: postgresql://postgres:postgres@127.0.0.1:5432/postgres

      - name: Check PostgreSQL migration upgrade from develop
        run: |
          git fetch origin develop --depth=1
          mkdir -p /tmp/hivelore-develop
          git archive origin/develop apps/api/prisma | tar -x -C /tmp/hivelore-develop
          npm run db:migrate:check:upgrade
        env:
          TEST_DATABASE_ADMIN_URL: postgresql://postgres:postgres@127.0.0.1:5432/postgres
          TEST_DATABASE_BASE_PRISMA_SCHEMA: /tmp/hivelore-develop/apps/api/prisma/schema.prisma

      - name: Type-check
        run: npm run typecheck

      - name: Test
        run: npm test
        env:
          NODE_ENV: test
          AUTH_JWT_SECRET: test-only-jwt-secret-with-enough-entropy
          AUTH_REFRESH_SECRET: test-only-refresh-secret-with-enough-entropy
          TEST_DATABASE_ADMIN_URL: postgresql://postgres:postgres@127.0.0.1:5432/postgres

      - name: Lint
        run: npm run lint

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

      - name: Build
        run: npm run build