Prisma SQLite Bulk Insert or Update

prisma-sqlite-bulk.js

const domains = ['google.com','github.com','instagram.com'];

/*** Method 1 ***/
const upsertManyDomains = domains.map((post) =>
    prisma.domains.upsert({
      where: { domain: post.trim() },
      create: {
        domain: post.trim(),
      },
      update: {
        domain: post.trim(),
        status: "success",
      },
    }),
 );

Promise.all(upsertManyDomains);


/*** Method 2 ***/
let upsertManyDomains = [];
  for (const post of domains) {
    upsertManyDomains.push(
      prisma.domains.upsert({
        where: {
          domain: post.trim(),
        },
        update: {
          domain: post.trim(),
          status: "success",
        },
        create: {
          domain: post.trim(),
        },
      })
    );
  }
  await prisma.$transaction(upsertManyDomains);