name: Migrate DB
on:
  workflow_dispatch:
  push:
    branches:
      - main
    paths:
      - "packages/db/drizzle/**"
jobs:
  migrate:
    name: 🗃️ Migrate DB
    runs-on: ubuntu-latest
    env:
      DATABASE_URL:  ${{ secrets.DATABASE_URL }}
      DATABASE_AUTH_TOKEN:  ${{ secrets.DATABASE_AUTH_TOKEN }}
    steps:
      - name: ⬇️ Checkout repo
        uses: actions/checkout@v6

      - name: Set up pnpm
        uses: pnpm/action-setup@v4

      - name: ⎔ Setup node
        uses: actions/setup-node@v6
        with:
          node-version: 24
          cache: "pnpm"

      - name: 🦕 Install deno
        uses: denoland/setup-deno@v2
        with:
          deno-version: v2.x

      - name: 📥 Download deps
        run: pnpm install

      - name: 🗃️ Run migrations
        run: pnpm migrate
        working-directory: ./packages/db