Patrik Comments - Answer Overflow

.select({
  ...getTableColumns(reviews),
  performance: {
    time: performances.time,
    artist: {
      ...getTableColumns(artists),
    },
    venue: {
      ...getTableColumns(venues),
    },
  },
  reviewer: {
    firstName: users.firstName,
    lastName: users.lastName,
  },
  commentsCount: ctx.db
    .$count(reviewComments, eq(reviewComments.reviewId, reviews.id))
    .as('commentsCount'),
  })
})

.select({
  ...getTableColumns(reviews),
  performance: {
    time: performances.time,
    artist: {
      ...getTableColumns(artists),
    },
    venue: {
      ...getTableColumns(venues),
    },
  },
  reviewer: {
    firstName: users.firstName,
    lastName: users.lastName,
  },
  commentsCount: ctx.db
    .$count(reviewComments, eq(reviewComments.reviewId, reviews.id))
    .as('commentsCount'),
  })
})

23 replies

DTDrizzle Team

•Created by ayyjohn on 12/30/2024 in #help

how to nest select statement to achieve aliased result

im not sure i understood you right but db.select its plain object you can manipulate it how you want

23 replies

DTDrizzle Team

•Created by brynthrax on 12/21/2024 in #help

Nested relation filtering

thx

9 replies

DTDrizzle Team

•Created by brynthrax on 12/21/2024 in #help

Nested relation filtering

so instead of this

await db.query.portfolioFavouritesTable.findMany({
   columns: {},
   with: {
      portfolioCase: {
         columns: {
            id: true,
            slug: true,
            color: true,
            status: true
         },
      },
   },
   where: eq(portfolioFavouritesTable.userUid, userID),
   orderBy: (favs, { desc }) => [desc(favs.createdAt)]
})

await db.query.portfolioFavouritesTable.findMany({
   columns: {},
   with: {
      portfolioCase: {
         columns: {
            id: true,
            slug: true,
            color: true,
            status: true
         },
      },
   },
   where: eq(portfolioFavouritesTable.userUid, userID),
   orderBy: (favs, { desc }) => [desc(favs.createdAt)]
})

we need to use this?

await db
   .select({
      id: portfolioTable.id,
      slug: portfolioTable.slug,
      color: portfolioTable.color,
      status: portfolioTable.status,
   })
   .from(portfolioTable)
   .innerJoin(portfolioFavouritesTable, eq(portfolioFavouritesTable.portfolioId, portfolioTable.id))
   .where(
      and(
         eq(portfolioFavouritesTable.userUid, userID),
         eq(portfolioTable.status, 'published')
      )
   )
   .orderBy(desc(portfolioFavouritesTable.createdAt))

await db
   .select({
      id: portfolioTable.id,
      slug: portfolioTable.slug,
      color: portfolioTable.color,
      status: portfolioTable.status,
   })
   .from(portfolioTable)
   .innerJoin(portfolioFavouritesTable, eq(portfolioFavouritesTable.portfolioId, portfolioTable.id))
   .where(
      and(
         eq(portfolioFavouritesTable.userUid, userID),
         eq(portfolioTable.status, 'published')
      )
   )
   .orderBy(desc(portfolioFavouritesTable.createdAt))