import { PrismaClient } from '@prisma/client'
import { PrismaBetterSqlite3 } from '@prisma/adapter-better-sqlite3'
import path from 'path'

const globalForPrisma = globalThis as unknown as {
  prisma: PrismaClient | undefined
}

function createPrismaClient() {
  // Build the database URL for the prisma folder
  const dbPath = path.resolve(process.cwd(), 'prisma', 'dev.db')
  const dbUrl = `file:${dbPath}`

  // Create the Prisma adapter using URL (Prisma 7 style)
  const adapter = new PrismaBetterSqlite3({ url: dbUrl })

  // Create and return the PrismaClient with the adapter
  return new PrismaClient({ adapter })
}

export const prisma = globalForPrisma.prisma ?? createPrismaClient()

if (process.env.NODE_ENV !== 'production') globalForPrisma.prisma = prisma

export default prisma