Function getStats

app/src/server/api/routers/usage.router.ts:128–164

(
  baseQuery: SelectQueryBuilder<
    DB & {
      ul: UsageLog;
    },
    "ul",
    unknown
  >,
)

});

export function getStats(
  baseQuery: SelectQueryBuilder<
    DB & {
      ul: UsageLog;
    },
    "ul",
    unknown
  >,
) {
  return baseQuery
    .select(({ fn }) => [
      fn.sum(sql<number>`ul."cost"`).as("cost"),
      fn
        .sum(sql<number>`case when ul.type = 'TRAINING' then ul.cost else 0 end`)
        .as("totalTrainingSpend"),
      fn
        .sum(sql<number>`case when ul.type != 'TRAINING' then ul.cost else 0 end`)
        .as("totalInferenceSpend"),
      fn
        .sum(
          sql<number>`case when ul.type != 'TRAINING' AND ul.type != 'CACHE_HIT' then ul."inputTokens" else 0 end`,
        )
        .as("totalInputTokens"),
      fn
        .sum(
          sql<number>`case when ul.type != 'TRAINING' AND ul.type != 'CACHE_HIT' then ul."outputTokens" else 0 end`,
        )
        .as("totalOutputTokens"),
      fn
        .sum(
          sql<number>`case when ul.type = 'TRAINING' then ul."inputTokens" + ul."outputTokens" else 0 end`,
        )
        .as("totalTrainingTokens"),
      fn.count("ul.id").as("numQueries"),
    ])
    .executeTakeFirst();
}