Function testKyselyAnyUpdates

test/typings/test-d/kysely-any.test-d.ts:94–137

(db: Kysely<any>)

}

async function testKyselyAnyUpdates(db: Kysely<any>) {
  const r1 = await db
    .updateTable('foo')
    .set({ bar: 'baz', spam: 1 })
    .where('foo.eggs', '=', 1)
    .executeTakeFirstOrThrow()
  expectType<UpdateResult>(r1)

  const r2 = await db
    .updateTable('foo as f')
    .set({ bar: 'baz', spam: 1 })
    .where('f.eggs', '=', 1)
    .where('spam', '=', 2)
    .executeTakeFirstOrThrow()
  expectType<UpdateResult>(r2)

  const r3 = await db
    .updateTable('foo')
    .set({ bar: 'baz', spam: 1 })
    .where('foo.eggs', '=', 1)
    .where('spam', '=', 2)
    .returning(['a', 'b'])
    .executeTakeFirstOrThrow()
  expectType<{ a: any; b: any }>(r3)

  const r4 = await db
    .updateTable('foo')
    .set((eb) => ({
      foo: eb('foo.bar', '=', 1),
    }))
    .where('foo.eggs', '=', 1)
    .executeTakeFirstOrThrow()
  expectType<UpdateResult>(r4)

  const table: 'foo' | 'bar' = Math.random() > 0.5 ? 'foo' : 'bar'
  const r5 = await db
    .updateTable(table)
    .set((eb) => ({
      foo: eb('foo.bar', '=', 1),
    }))
    .where('foo.eggs', '=', 1)
    .executeTakeFirstOrThrow()
  expectType<UpdateResult>(r5)
}

async function testKyselyAnyDeletes(db: Kysely<any>) {
  const r1 = await db