echo/.github/workflows/migrate-db.yml at 7a601a535f7b8dbcfac994f3614d67e401c64f23 · Merit-Systems/echo · 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
name: Migrate Database

on:
  workflow_dispatch:
  push:
    branches: [master, production]
    paths:
      - 'echo-control/prisma/**'

jobs:
  migrate-staging:
    if: github.ref == 'refs/heads/master'
    runs-on: ubuntu-latest

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

      - name: Install pnpm
        uses: pnpm/action-setup@v2
        with:
          version: 10.11.0

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

      - name: Install dependencies
        run: pnpm install --frozen-lockfile --filter echo-control
        working-directory: ./echo-control

      - name: Run Prisma migrate deploy (Staging)
        run: pnpm run prisma:migrate-deploy
        working-directory: ./echo-control
        env:
          DATABASE_URL: ${{ secrets.STAGING_DB_URL }}

  migrate-production:
    if: github.ref == 'refs/heads/production'
    runs-on: ubuntu-latest

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

      - name: Install pnpm
        uses: pnpm/action-setup@v2
        with:
          version: 10.11.0

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

      - name: Install dependencies
        run: pnpm install --frozen-lockfile --filter echo-control
        working-directory: ./echo-control

      - name: Run Prisma migrate deploy (Production)
        run: pnpm run prisma:migrate-deploy
        working-directory: ./echo-control
        env:
          DATABASE_URL: ${{ secrets.PRODUCTION_DB_URL }}