Skip to content

armgit / umami

Public Imported from GitHub
0

Umami is a privacy-first web and product analytics platform. Traffic, campaigns, behavior, conversions, and revenue in one place. No cookies, no surveillance, self-hosted or in the cloud.

1.2 KB
Raw Blame
import clickhouse from '@/lib/clickhouse';
import { CLICKHOUSE, PRISMA, runQuery } from '@/lib/db';
import prisma from '@/lib/prisma';

const FUNCTION_NAME = 'getLinkedSessionIds';

export async function getLinkedSessionIds(
  ...args: [websiteId: string, distinctId: string]
): Promise<{ sessionId: string; createdAt: string }[]> {
  return runQuery({
    [PRISMA]: () => relationalQuery(...args),
    [CLICKHOUSE]: () => clickhouseQuery(...args),
  });
}

async function relationalQuery(websiteId: string, distinctId: string) {
  const { rawQuery } = prisma;

  return rawQuery(
    `
    select
      session_id as "sessionId",
      min(created_at) as "createdAt"
    from session_link
    where website_id = {{websiteId::uuid}}
      and distinct_id = {{distinctId}}
    group by session_id
    `,
    { websiteId, distinctId },
    FUNCTION_NAME,
  );
}

async function clickhouseQuery(websiteId: string, distinctId: string) {
  const { rawQuery } = clickhouse;

  return rawQuery(
    `
    select
      session_id as sessionId,
      min(created_at) as createdAt
    from session_link
    where website_id = {websiteId:UUID}
      and distinct_id = {distinctId:String}
    group by session_id
    `,
    { websiteId, distinctId },
    FUNCTION_NAME,
  );
}