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))

4 replies

DTDrizzle Team

•Created by vapor on 6/27/2023 in #help

Invalid input for drizzle-kit pg:inspect

upgrading to latest drizzle-kit and drizzle-orm fixed this!

4 replies

DTDrizzle Team

•Created by vapor on 6/7/2023 in #help

Tx Rollback meesage

Thanks !

3 replies

DTDrizzle Team

•Created by vapor on 5/24/2023 in #help

Option filter parameters

great thanks, looks good

11 replies

Gaming

Programming