import { PrismaClient } from "@prisma/client"
import { PrismaPg } from "@prisma/adapter-pg"
import { Pool } from "pg"

const pool = new Pool({ connectionString: process.env.DATABASE_URL })
const db = new PrismaClient({ adapter: new PrismaPg(pool) })

const sketches = [
  "/drops/omt/omt-hoodie-flat.jpg",
  "/drops/omt/omt-hoodie-model.jpg",
  "/drops/omt/omt-sweat-flat.jpg",
  "/drops/omt/omt-sweat-model-1.jpg",
  "/drops/omt/omt-sweat-model-2.jpg",
  "/drops/omt/omt-tshirt-flat.jpg",
  "/drops/omt/omt-tshirt-model-1.jpg",
  "/drops/omt/omt-tshirt-model-2.jpg",
  "/drops/omt/omt-cap-flat.jpg",
  "/drops/omt/omt-cap-model.jpg",
  "/drops/omt/omt-sneakers-flat.jpg",
  "/drops/omt/omt-sneakers-model.jpg",
  "/drops/omt/omt-beanie-flat.jpg",
  "/drops/omt/omt-beanie-model.jpg",
  "/drops/omt/omt-jacket-neo-model.jpg",
  "/drops/omt/omt-holster-flat-1.jpg",
  "/drops/omt/omt-holster-flat-2.jpg",
  "/drops/omt/omt-holster-model-1.jpg",
  "/drops/omt/omt-holster-model-2.jpg",
]

async function main() {
  const all = await db.drop.findMany({ select: { id: true, slug: true, name: true } })
  const drop = all.find((d) => d.slug.includes("omt") || d.name.toUpperCase().includes("O.M.T") || d.name.toUpperCase().includes("OMT"))
  if (!drop) {
    console.error("Drop O.M.T introuvable. Drops existants:", all)
    process.exit(1)
  }
  const updated = await db.drop.update({
    where: { id: drop.id },
    data: { sketches },
  })
  console.log("OK, sketches mis à jour pour", updated.name, "(slug:", updated.slug, ") ->", sketches.length, "images")
}

main()
  .catch((e) => {
    console.error(e)
    process.exit(1)
  })
  .finally(() => db.$disconnect())