How to type a function with column key of table

I can't get this to type correctly. I want

field

field

field

field to be a column of

table

table

table

table, but typescript keeps saying

Type 'Field' cannot be used to index type 'TTable'

Type 'Field' cannot be used to index type 'TTable'

Type 'Field' cannot be used to index type 'TTable'

Type 'Field' cannot be used to index type 'TTable'. What's the best way to do this?

type GetColumnKeys<TTable extends Table> = keyof {
  [K in keyof TTable as K extends keyof TTable['_']['columns'] ? K : never]: true
}

async function getOptions<
  TTable extends Table,
  Field extends GetColumnKeys<TTable>
>(table: TTable, field: Field) {
  const column = table[field]
  const result = await drizzleDb
    .selectDistinct({
      option: column
    })
    .from(table)
    .orderBy(column)
  return result.map((i) => String(i.option))
}

type GetColumnKeys<TTable extends Table> = keyof {
  [K in keyof TTable as K extends keyof TTable['_']['columns'] ? K : never]: true
}

async function getOptions<
  TTable extends Table,
  Field extends GetColumnKeys<TTable>
>(table: TTable, field: Field) {
  const column = table[field]
  const result = await drizzleDb
    .selectDistinct({
      option: column
    })
    .from(table)
    .orderBy(column)
  return result.map((i) => String(i.option))
}

type GetColumnKeys<TTable extends Table> = keyof {
  [K in keyof TTable as K extends keyof TTable['_']['columns'] ? K : never]: true
}

async function getOptions<
  TTable extends Table,
  Field extends GetColumnKeys<TTable>
>(table: TTable, field: Field) {
  const column = table[field]
  const result = await drizzleDb
    .selectDistinct({
      option: column
    })
    .from(table)
    .orderBy(column)
  return result.map((i) => String(i.option))
}

type GetColumnKeys<TTable extends Table> = keyof {
  [K in keyof TTable as K extends keyof TTable['_']['columns'] ? K : never]: true
}

async function getOptions<
  TTable extends Table,
  Field extends GetColumnKeys<TTable>
>(table: TTable, field: Field) {
  const column = table[field]
  const result = await drizzleDb
    .selectDistinct({
      option: column
    })
    .from(table)
    .orderBy(column)
  return result.map((i) => String(i.option))
}

How to type a function with column key of table

Similar Threads

Similar Threads

Similar Threads