update-database.yml

name: Update database

on:
  push:
    paths:
      - 'apps/keystone/migrations/**'
  workflow_dispatch:

jobs:
  update-database:
    runs-on: ubuntu-latest
    if: github.ref == 'refs/heads/main'
    env:
      DATABASE_URL: ${{ secrets.DATABASE_URL }}
    steps:
      -
        name: Checkout public
        uses: actions/checkout@v3
      -
        name: Set up Node
        uses: actions/setup-node@v3
        with:
          node-version: 16
      -
        name: Install dependencies
        run: npm ci --force
      -
        name: Update prisma
        working-directory: ./apps/keystone/
        run: npx keystone prisma migrate deploy
        env:
          SESSION_SECRET: ${{ secrets.SESSION_SECRET }}