Drizzle Team•11mo ago

unionAll gives TypeError: leftSelect.getSelectedFields is not a function

I'm trying to query 2 collections in the same query as the amount of collections might grow over time that I will check against I would want a scalable way and also use drizzles built in features, so I tryed this: Note I'm using Payload CMS, so I don't have access to the schema files directly, actually got no clue if its db.schema or db.tables I should use. Running these queries separately works great, just when I add unionAll I get:

[15:34:20] ERROR (payload): TypeError: leftSelect.getSelectedFields is not a function
    at /Users/livog/Documents/Projects/Payload.CMS/node_modules/.pnpm/[email protected][email protected]/node_modules/src/pg-core/query-builders/select.ts:677:42

[15:34:20] ERROR (payload): TypeError: leftSelect.getSelectedFields is not a function
    at /Users/livog/Documents/Projects/Payload.CMS/node_modules/.pnpm/[email protected][email protected]/node_modules/src/pg-core/query-builders/select.ts:677:42

Code:

const db = payload?.db
const drizzle = payload?.db?.drizzle

if (!payload || !db || !drizzle || collectionsToCheck.length === 0) return false // This will be checked server side or we don't support it without drizzle.
const rows = await unionAll(
    // @ts-ignore
    ...collectionsToCheck.map(collection => {
      const andCondtions = [eq(db.schema[collection]['path'], path)]
      if (currentCollection !== collection) {
        andCondtions.push(ne(db.schema[collection]['id'], currentDocId))
      }
      return drizzle
        .select({ id: db.schema[collection]['id'], path: db.schema[collection]['path'] })
        .from(db.tables[collection])
        .where(
          // @ts-ignore // Todo: type checking
          and(...andCondtions)
        )
    })
  )

const db = payload?.db
const drizzle = payload?.db?.drizzle

if (!payload || !db || !drizzle || collectionsToCheck.length === 0) return false // This will be checked server side or we don't support it without drizzle.
const rows = await unionAll(
    // @ts-ignore
    ...collectionsToCheck.map(collection => {
      const andCondtions = [eq(db.schema[collection]['path'], path)]
      if (currentCollection !== collection) {
        andCondtions.push(ne(db.schema[collection]['id'], currentDocId))
      }
      return drizzle
        .select({ id: db.schema[collection]['id'], path: db.schema[collection]['path'] })
        .from(db.tables[collection])
        .where(
          // @ts-ignore // Todo: type checking
          and(...andCondtions)
        )
    })
  )

This is the documentation that I looked at which I feel like I replicated: https://orm.drizzle.team/docs/set-operations#union-all Any help is super appreciated!

Set Operations - Drizzle ORM

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

1 Reply

Angelelz•11mo ago

unionAll accepts queries that you want to unite. I would create the query array outside of the unionAll call trying to let TS infer the types for you. Even then, I'm not sure this approach will satisfy the compiler

Gaming

Programming

unionAll gives TypeError: leftSelect.getSelectedFields is not a function