Function testFromSingle

test/typings/test-d/select-from.test-d.ts:5–115

(db: Kysely<Database>)

import { expectType, expectError } from 'tsd'

async function testFromSingle(db: Kysely<Database>) {
  // Single table
  const [r1] = await db.selectFrom('person').selectAll().execute()

  expectType<{
    id: number
    first_name: string
    last_name: string | null
    age: number
    gender: 'male' | 'female' | 'other'
    modified_at: Date
    marital_status: 'single' | 'married' | 'divorced' | 'widowed' | null
    deleted_at: Date | null
  }>(r1)

  // Table with alias
  const [r2] = await db.selectFrom('pet as p').select('p.species').execute()
  expectType<{ species: 'dog' | 'cat' }>(r2)

  // Subquery
  const [r3] = await db
    .selectFrom(db.selectFrom('movie').select('movie.stars as strs').as('m'))
    .selectAll()
    .execute()
  expectType<{ strs: number }>(r3)

  // Subquery factory
  const [r4] = await db
    .selectFrom((eb) =>
      eb.selectFrom('movie').select('movie.stars as strs').as('m'),
    )
    .selectAll('m')
    .execute()
  expectType<{ strs: number }>(r4)

  // Subquery factory list
  const [r4_2] = await db
    .selectFrom([
      (eb) => eb.selectFrom('movie').select('movie.stars as strs').as('m'),
      (eb) => eb.selectFrom('pet').select('id').as('p'),
    ])
    .selectAll(['m', 'p'])
    .execute()
  expectType<{ strs: number; id: string }>(r4_2)

  // Table with schema
  const [r5] = await db
    .selectFrom('some_schema.movie')
    .select('stars')
    .execute()
  expectType<{ stars: number }>(r5)

  // Table with schema and alias
  const [r6] = await db
    .selectFrom('some_schema.movie as m')
    .select('m.stars')
    .execute()
  expectType<{ stars: number }>(r6)