7 replies

getViewColumns function? (similar to getTableColumns)

Hello, in a situation where I need to join a view to a table. Here's the gist of my query code:

await db.select().from(myView).innerJoin(myTable, eq(myTable.someId, myView.someId));

await db.select().from(myView).innerJoin(myTable, eq(myTable.someId, myView.someId));

This works, however I'd like to be able to select only the view columns. For tables, we have the help of getTableColumns(), which is defined in the source code as:

export function getTableColumns<T extends Table>(table: T): T['_']['columns'] {
  return table[Table.Symbol.Columns];
}

export function getTableColumns<T extends Table>(table: T): T['_']['columns'] {
  return table[Table.Symbol.Columns];
}

I couldn't find an equivalent for views. So I tried writing my own

getViewColumns()

getViewColumns()

function. Here's my attempt:

import { View } from 'drizzle-orm';

export function getViewColumns<V extends View>(view : V): V['_']['selectedFields'] {
  return view[View.Symbol.SelectedFields]; // error on this line
}

import { View } from 'drizzle-orm';

export function getViewColumns<V extends View>(view : V): V['_']['selectedFields'] {
  return view[View.Symbol.SelectedFields]; // error on this line
}

Which is definitely incorrect, but I'm stuck. Any ideas on how one could write a working

getViewColumns()

getViewColumns()

function? I'm connecting to a PostgreSQL database, and the view is an existing, regular (non-materialized) view, if it makes a difference.

Goodies – DrizzleORM

Drizzle ORM | %s

GitHub

drizzle-orm/drizzle-orm/src/utils.ts at main · drizzle-team/drizzle...

TypeScript ORM that feels like writing SQL. Contribute to drizzle-team/drizzle-orm development by creating an account on GitHub.

Views (WIP) – DrizzleORM

Drizzle ORM | %s

getViewColumns function? (similar to getTableColumns)

Hello, in a situation where I need to join a view to a table. Here's the gist of my query code:

await db.select().from(myView).innerJoin(myTable, eq(myTable.someId, myView.someId));

await db.select().from(myView).innerJoin(myTable, eq(myTable.someId, myView.someId));

This works, however I'd like to be able to select only the view columns. For tables, we have the help of getTableColumns(), which is defined in the source code as:

export function getTableColumns<T extends Table>(table: T): T['_']['columns'] {
  return table[Table.Symbol.Columns];
}

export function getTableColumns<T extends Table>(table: T): T['_']['columns'] {
  return table[Table.Symbol.Columns];
}

I couldn't find an equivalent for views. So I tried writing my own

getViewColumns()

getViewColumns()

function. Here's my attempt:

import { View } from 'drizzle-orm';

export function getViewColumns<V extends View>(view : V): V['_']['selectedFields'] {
  return view[View.Symbol.SelectedFields]; // error on this line
}

import { View } from 'drizzle-orm';

export function getViewColumns<V extends View>(view : V): V['_']['selectedFields'] {
  return view[View.Symbol.SelectedFields]; // error on this line
}

Which is definitely incorrect, but I'm stuck. Any ideas on how one could write a working

getViewColumns()

getViewColumns()

function? I'm connecting to a PostgreSQL database, and the view is an existing, regular (non-materialized) view, if it makes a difference.

Goodies – DrizzleORM

Drizzle ORM | %s

GitHub

drizzle-orm/drizzle-orm/src/utils.ts at main · drizzle-team/drizzle...

TypeScript ORM that feels like writing SQL. Contribute to drizzle-team/drizzle-orm development by creating an account on GitHub.

Views (WIP) – DrizzleORM

Drizzle ORM | %s

getViewColumns function? (similar to getTableColumns)

getViewColumns function? (similar to getTableColumns)

Similar Threads

Similar Threads

Similar Threads