Function testKyselyAnySelects

test/typings/test-d/kysely-any.test-d.ts:9–57

(db: Kysely<any>)

import { expectType } from 'tsd'

async function testKyselyAnySelects(db: Kysely<any>) {
  const r1 = await db.selectFrom('foo').select('bar').execute()
  expectType<{ bar: any }[]>(r1)

  const r2 = await db.selectFrom('foo').select(['bar', 'baz']).execute()
  expectType<{ bar: any; baz: any }[]>(r2)

  const r3 = await db.selectFrom('foo').select('foo.bar').execute()
  expectType<{ bar: any }[]>(r3)

  const r4 = await db
    .selectFrom('foo')
    .select(['spam', 'foo.bar', 'foo.baz'])
    .execute()
  expectType<{ spam: any; bar: any; baz: any }[]>(r4)

  const r5 = await db
    .selectFrom(['foo1', 'foo2'])
    .select(['spam', 'foo1.bar', 'foo2.baz', 'doesnotexists.fux'])
    .execute()
  expectType<{ spam: any; bar: any; baz: any; fux: any }[]>(r5)

  const r6 = await db
    .selectFrom('foo')
    .select((eb) => [
      eb.lit(1).as('baz'),
      eb.ref('foo.bar').as('bar'),
      eb
        .selectFrom('bar')
        .select('spam')
        .whereRef('foo.id', '=', 'bar.id')
        .as('spam'),
    ])
    .executeTakeFirstOrThrow()
  expectType<{ bar: any; spam: any; baz: 1 }>(r6)

  const table: 'foo' | 'bar' = Math.random() > 0.5 ? 'foo' : 'bar'
  const r7 = await db.selectFrom(table).select('baz').executeTakeFirstOrThrow()
  expectType<{ baz: any }>(r7)

  const r8 = await db.selectFrom('foo as f').select('bar').execute()
  expectType<{ bar: any }[]>(r8)

  const r9 = await db
    .selectFrom(['foo1 as f1', 'foo2 as f2'])
    .select(['spam', 'f1.bar', 'f2.baz', 'doesnotexists.fux'])
    .execute()
  expectType<{ spam: any; bar: any; baz: any; fux: any }[]>(r9)
}

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