4 replies

Sqlite insert returning typing help

Been using this lots for PG but trying now with Sqlite. I'm confused by how tog et the returned object after inserting. It's not super clear from the docs:

  const _company = db
    .insert(companies)
    .values({
      id: company.id,
      name: company.name,
    })
    .returning();

  _company.run(); // ???

  const _company = db
    .insert(companies)
    .values({
      id: company.id,
      name: company.name,
    })
    .returning();

  _company.run(); // ???

According to this, I can just use

.returning()

.returning()

but the type for that looks like the table object, not the record that would be returned.

Quering with SQL-like syntax [CRUD] – DrizzleORM

Drizzle ORM | %s

Drizzle Team•3y ago•

4 replies

McLean 25

Sqlite insert returning typing help

Been using this lots for PG but trying now with Sqlite. I'm confused by how tog et the returned object after inserting. It's not super clear from the docs:

  const _company = db
    .insert(companies)
    .values({
      id: company.id,
      name: company.name,
    })
    .returning();

  _company.run(); // ???

  const _company = db
    .insert(companies)
    .values({
      id: company.id,
      name: company.name,
    })
    .returning();

  _company.run(); // ???

According to this, I can just use

.returning()

.returning()

but the type for that looks like the table object, not the record that would be returned.

Quering with SQL-like syntax [CRUD] – DrizzleORM

Drizzle ORM | %s

Sqlite insert returning typing help

Similar Threads

Sqlite insert returning typing help

Similar Threads

Similar Threads

Similar Threads