import { PrismaClient } from '@prisma/client'

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

const prismaInstance = globalForPrisma.prisma ?? new PrismaClient()

if (!globalForPrisma.prisma) {
  const dmmf = (prismaInstance as any)._dmmf || (prismaInstance as any)._engine?.dmmf
  
  let modelsWithDeletedAt: string[] = []
  
  if (dmmf?.datamodel?.models) {
    modelsWithDeletedAt = dmmf.datamodel.models
      .filter((model: any) => model.fields.some((field: any) => field.name === 'deleted_at'))
      .map((model: any) => model.name)
  }

  prismaInstance.$use(async (params, next) => {
    if (
      params.model &&
      modelsWithDeletedAt.includes(params.model) &&
      ['findFirst', 'findMany', 'findUnique', 'count', 'aggregate', 'groupBy'].includes(params.action)
    ) {
      params.args = params.args || {}
      params.args.where = params.args.where
        ? { ...params.args.where, deleted_at: null }
        : { deleted_at: null }
    }
    return next(params)
  })
}

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

export const prisma = prismaInstance