Next.js + Capacitorによるクロスプラットフォームアプリの紹介 – ⑤prismaとDBによるセッション管理

npm install @prisma/client

datasource db {
  provider = "postgresql"
  url      = env("DATASOURCE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model Session {
  id           String   @id @default(uuid())
  userId       Int
  user         User      @relation(fields: [userId], references: [id])
  accessToken  String
  ipAddress    String?
  userAgent    String?
  status       String?
  createdAt    DateTime  @default(now())
  updatedAt    DateTime  @updatedAt
  expiresAt    DateTime?
}

model User {
  id       Int          @id @default(autoincrement())
  email    String       @unique
  sessions Session[]
}

prisma generate

prisma migrate dev --name {migration_name}

prisma migrate deploy

prisma db pull
prisma db push