Kysely•13mo ago

How to return last inserted ID ?

export async function createCommands(deviceId: number, commands: string[]) {
  return db
    .insertInto("commands")
    .values(commands.map((c) => ({ deviceId, content: c })))
    .returning("id")
    .executeTakeFirstOrThrow()
}

export async function createCommands(deviceId: number, commands: string[]) {
  return db
    .insertInto("commands")
    .values(commands.map((c) => ({ deviceId, content: c })))
    .returning("id")
    .executeTakeFirstOrThrow()
}

For this example, how do I only return the last inserted ID ?

3 Replies

koskimas•13mo ago

Did you try reading the documentation?

bun•13mo ago

yes, many times, didn't find anything specifically regarding last inserted id @koskimas i understood that by default postgres doesn't do that but how do i make it do that ?

koskimas•13mo ago

The ~third sentence here https://kysely-org.github.io/kysely-apidoc/classes/Kysely.html#insertInto The ~fift sentence here https://kysely-org.github.io/kysely-apidoc/classes/InsertQueryBuilder.html#values This example on the site https://kysely.dev/docs/examples/INSERT/returning-data

Gaming

Programming

How to return last inserted ID ?