Aaroned Comments - Answer Overflow

Aaroned

•Created by Titan on 4/8/2024 in #help

Insert returning api to match select columns

@Titan Here is a possible conversion function

type TrueKeys<T extends Record<string, boolean>> = {
  [K in keyof T]: T[K] extends true ? K : never
}[keyof T]

function getSelectColumns<
  TQueryColumns extends Record<string, boolean>,
  TKeys extends TrueKeys<TQueryColumns>,
  TTableColumns extends Record<TKeys, unknown>
>(queryColumns: TQueryColumns, tableColumns: TTableColumns) {
  const keys = Object.keys(tableColumns) as TKeys[]
  return keys
    .filter(key => queryColumns[key])
    .reduce(
      (acc, key) => ({ ...acc, [key]: tableColumns[key] }),
      {} as { -readonly [Key in TKeys]: TTableColumns[Key] }
    )
}

const queryColumns = {
  id: true,
} as const

const selectColumns = getSelectColumns(
  queryColumns,
  getTableColumns(tables.organisation)
)

const selectResult = await db
  .select(selectColumns)
  .from(tables.organisation)
const queryResult = await db.query.organisation.findMany({
  columns: queryColumns,
})

type TrueKeys<T extends Record<string, boolean>> = {
  [K in keyof T]: T[K] extends true ? K : never
}[keyof T]

function getSelectColumns<
  TQueryColumns extends Record<string, boolean>,
  TKeys extends TrueKeys<TQueryColumns>,
  TTableColumns extends Record<TKeys, unknown>
>(queryColumns: TQueryColumns, tableColumns: TTableColumns) {
  const keys = Object.keys(tableColumns) as TKeys[]
  return keys
    .filter(key => queryColumns[key])
    .reduce(
      (acc, key) => ({ ...acc, [key]: tableColumns[key] }),
      {} as { -readonly [Key in TKeys]: TTableColumns[Key] }
    )
}

const queryColumns = {
  id: true,
} as const

const selectColumns = getSelectColumns(
  queryColumns,
  getTableColumns(tables.organisation)
)

const selectResult = await db
  .select(selectColumns)
  .from(tables.organisation)
const queryResult = await db.query.organisation.findMany({
  columns: queryColumns,
})

8 replies

DTDrizzle Team

•Created by AuroPick on 4/7/2024 in #help

Query API relation null type

Yes chat media relations is correct

4 replies

DTDrizzle Team

•Created by Titan on 4/8/2024 in #help

Insert returning api to match select columns

I think you will need to write an automatic mapping function SelectColumnsToReturningColumns, but I think you should be able to get the values needed for returning columns from getTableColumns

8 replies

DTDrizzle Team

•Created by Titan on 4/8/2024 in #help

Insert returning api to match select columns

@Titan you could possibly create a conversion function that utilises both getTableColumns(table) (https://orm.drizzle.team/docs/goodies#get-typed-table-columns) and maybe also InferSelectModel<typeof table> (https://orm.drizzle.team/docs/goodies#type-api)

8 replies

DTDrizzle Team

•Created by Martin Carlsson on 4/9/2024 in #help

Is relationships only for .findMany() and .findFirst()

@Martin Carlsson yes that's correct

3 replies

DTDrizzle Team

•Created by DiamondDragon on 4/7/2024 in #help

Missing nested where clause

@DiamondDragon https://www.sqlite.org/optoverview.html this is a good page for understanding SQLite (ie. Turso libsql) query optimization and indexes. SQLite does NOT automatically create indexes on foreign keys, so if you are not sure, that is generally a good place to start. Another helpful tool for optimisation is EXPLAIN QUERY PLAN https://www.sqlite.org/eqp.html this can be run through the Turso CLI db shell command. (You will need to first obtain the SQL of the Drizzle query by using .toSQL() at the end of the query) You really want to avoid TABLE SCANS as each row is read in a table scan and counts to the Turso Rows Read quota. By adding appropriate indexes that SQLite can use for your query, the query engine will use INDEX SCANS and avoid TABLE SCANS. See also https://turso.tech/blog/tips-for-maximizing-your-turso-billing-allowances-48a0fca163e9

23 replies

DTDrizzle Team