Migrationen & Seeding

// Optionales Feld hinzufügen — immer sicher
bio String?

// Pflichtfeld mit Standardwert hinzufügen — sicher für bestehende Zeilen
role String @default("member")

// Feld umbenennen — @map verwenden, um Datenverlust zu vermeiden
displayName String @map("name")

model User {
  // ... existing fields
  avatarUrl String? // Neues Feld — nullable, daher keine Migrations-Probleme
}

cd apps/boilerplate && npx prisma migrate dev --name add-user-avatar

model Comment {
  id        String   @id @default(uuid())
  content   String   @db.Text
  userId    String
  postId    String
  createdAt DateTime @default(now())
  user      User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  post      BlogPost @relation(fields: [postId], references: [id], onDelete: Cascade)

  @@index([userId])
  @@index([postId])
}

model User {
  // ...
  comments Comment[]
}

model BlogPost {
  // ...
  comments Comment[]
}

import { PrismaClient } from '@prisma/client'

const prisma = new PrismaClient()

async function main() {
  console.log('Seeding database...')

  // Einen Testbenutzer erstellen
  const user = await prisma.user.upsert({
    where: { clerkId: 'user_test_123' },
    update: {},
    create: {
      clerkId: 'user_test_123',
      email: 'test@example.com',
      name: 'Test User',
      tier: 'pro',
      creditBalance: 100.00,
      creditsPerMonth: 100.00,
    },
  })

  console.log(`Created user: ${user.id}`)

  // Eine Subscription erstellen
  await prisma.subscription.upsert({
    where: { userId: user.id },
    update: {},
    create: {
      userId: user.id,
      customerId: 'cus_test_123',
      subscriptionId: 'sub_test_123',
      productId: 'prod_test_123',
      variantId: 'var_test_123',
      status: 'active',
      currentPeriodEnd: new Date(Date.now() + 30 * 24 * 60 * 60 * 1000), // 30 Tage
    },
  })

  console.log('Created subscription')

  // Beispiel-FAQ-Chunks erstellen (für RAG-Tests)
  await prisma.fAQChunk.createMany({
    data: [
      {
        content: 'How do I reset my password? Go to the login page and click "Forgot password?".',
        question: 'How do I reset my password?',
        answer: 'Go to the login page and click "Forgot password?" to receive a reset email.',
        category: 'Getting Started',
      },
      {
        content: 'How do I upgrade my plan? Go to Dashboard > Billing and select a new plan.',
        question: 'How do I upgrade my plan?',
        answer: 'Navigate to Dashboard > Billing and click "Upgrade" on the plan you want.',
        category: 'Billing',
      },
    ],
    skipDuplicates: true,
  })

  console.log('Created FAQ chunks')
  console.log('Seeding complete!')
}

main()
  .catch((e) => {
    console.error('Seeding failed:', e)
    process.exit(1)
  })
  .finally(async () => {
    await prisma.$disconnect()
  })

{
  "prisma": {
    "seed": "npx tsx prisma/seed.ts"
  }
}

cd apps/boilerplate && npx prisma db seed

# Datenbank zurücksetzen (löscht alle Tabellen, wendet Migrationen erneut an, führt Seed aus)
cd apps/boilerplate && npx prisma migrate reset

# Oder Schema pushen und Seed separat ausführen
cd apps/boilerplate && npx prisma db push --force-reset
cd apps/boilerplate && npx prisma db seed