Function getProfileWithEvents

packages/db/src/services/profile.service.ts:473–499

(
  projectId: string,
  profileId: string,
  eventLimit = 10
)

}

export async function getProfileWithEvents(
  projectId: string,
  profileId: string,
  eventLimit = 10
): Promise<{
  profile: IClickhouseProfile | null;
  recent_events: IClickhouseEvent[];
}> {
  const [profiles, recent_events] = await Promise.all([
    chQuery<IClickhouseProfile>(`
      SELECT ${PROFILE_COLUMNS}
      FROM ${TABLE_NAMES.profiles} FINAL
      WHERE project_id = ${sqlstring.escape(projectId)} AND id = ${sqlstring.escape(profileId)}
      LIMIT 1
    `),
    clix(ch)
      .select<IClickhouseEvent>([])
      .from(TABLE_NAMES.events)
      .where('project_id', '=', projectId)
      .where('profile_id', '=', profileId)
      .orderBy('created_at', 'DESC')
      .limit(eventLimit)
      .execute(),
  ]);

  return { profile: profiles[0] ?? null, recent_events };
}

export function getProfileSessionsCore(
  projectId: string,