vapor Comments - Answer Overflow

vapor

Explore posts from servers

SSolidJS TtRPC DTDrizzle Team

Posts Comments

DTDrizzle Team

•Created by vapor on 8/29/2023 in #help

Having statement to compare sql<number> and number

thx bud

4 replies

DTDrizzle Team

•Created by vapor on 8/29/2023 in #help

Having statement to compare sql<number> and number

it seems like this is maybe a better approach?:

  const query = db
    .select({
      workerUid: workerStatsDaily.workerUid,
      activeInterval: sql<number>`sum(${workerStatsDaily.activeInterval})`,
    })
    .from(workerStatsDaily)
    .where(between(workerStatsDaily.day, input.startDate, input.endDate))
    .groupBy(workerStatsDaily.workerUid)
    .as("query")

  const totalCount = await db
    .select({ count: sql<number>`count(*)` })
    .from(query)
    .where(gt(query.activeInterval, 3600))

  const query = db
    .select({
      workerUid: workerStatsDaily.workerUid,
      activeInterval: sql<number>`sum(${workerStatsDaily.activeInterval})`,
    })
    .from(workerStatsDaily)
    .where(between(workerStatsDaily.day, input.startDate, input.endDate))
    .groupBy(workerStatsDaily.workerUid)
    .as("query")

  const totalCount = await db
    .select({ count: sql<number>`count(*)` })
    .from(query)
    .where(gt(query.activeInterval, 3600))