onConflictDoNothing does not exist on planetscale client

i am getting an "Property onConflictDoNothing does not exist on type" on the following script....

export async function lookupNationalitySeed(client: DbClient) {
  await client.insert(lookupNationality).values(
    data.map((nationality) => ({
      id: ulid(),
      name: nationality,
      slug: paramCase(nationality),
    })),
  ).onConflictDoNothing()
}

export async function lookupNationalitySeed(client: DbClient) {
  await client.insert(lookupNationality).values(
    data.map((nationality) => ({
      id: ulid(),
      name: nationality,
      slug: paramCase(nationality),
    })),
  ).onConflictDoNothing()
}

the client is a type of

PlanetScaleDatabase<typeof schema>

PlanetScaleDatabase<typeof schema>

the only typesafe method i get is

onDuplicateKeyUpdate

onDuplicateKeyUpdate

BinaryArtifexOP•7/29/23, 11:05 AM

oh hang on....is this what im looking for? this doesn't appear to be in the docs....

Monk•8/14/23, 2:42 AM

Did this .ignore() end up being what you were looking for @frostyghostman ? Just ran into this myself.

Josh•8/25/23, 4:46 PM

bumping this, i just ran into it aswell.

MMonk Did this .ignore() end up being what you were looking for @frostyghostman ? Jus...

Josh•8/25/23, 4:51 PM

ignore does indeed work. It just adds the keyword to the sql query, with more info on it found here

Stack Overflow

"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After some research, my options appear to be the use of either:

ON DUPLICAT...

BinaryArtifexOP•8/30/23, 8:33 PM

oh nice, forgot i even asked this and went back to ask again and found my original question answered haha