Function getTelemetryPageview

src/server/model/telemetry.ts:177–202

(
  telemetryId: string,
  filters: BaseQueryFilters
)

export { delTelemetryCache };

export async function getTelemetryPageview(
  telemetryId: string,
  filters: BaseQueryFilters
) {
  const { timezone = 'utc', unit = 'day' } = filters;
  const { filterQuery, joinSession, params } = await parseTelemetryFilters(
    telemetryId,
    {
      ...filters,
    }
  );

  return prisma.$queryRaw`
    select
      ${getDateQuery('"TelemetryEvent"."createdAt"', unit, timezone)} x,
      count(1) y
    from "TelemetryEvent"
      ${joinSession}
    where "TelemetryEvent"."telemetryId" = ${params.telemetryId}
      and "TelemetryEvent"."createdAt" between ${
        params.startDate
      }::timestamptz and ${params.endDate}::timestamptz
      ${filterQuery}
    group by 1
  `;
}

export async function getTelemetrySession(
  telemetryId: string,