Spaces:
Configuration error
Configuration error
Download src/queries/analytics/sessions/getSessionDataProperties.ts from SreejithSHR/umami: direct link, hf CLI and curl.
- Browser
- Download file 1.75 kB
-
https://huggingface.co/spaces/SreejithSHR/umami/resolve/main/src/queries/analytics/sessions/getSessionDataProperties.ts
- Command line
-
hf download hf://spaces/SreejithSHR/umami/src/queries/analytics/sessions/getSessionDataProperties.ts
-
curl -L -o getSessionDataProperties.ts https://huggingface.co/spaces/SreejithSHR/umami/resolve/main/src/queries/analytics/sessions/getSessionDataProperties.ts
1.75 kB
| import prisma from 'lib/prisma'; | |
| import clickhouse from 'lib/clickhouse'; | |
| import { CLICKHOUSE, PRISMA, runQuery } from 'lib/db'; | |
| import { QueryFilters, WebsiteEventData } from 'lib/types'; | |
| export async function getSessionDataProperties( | |
| ...args: [websiteId: string, filters: QueryFilters & { propertyName?: string }] | |
| ): Promise<WebsiteEventData[]> { | |
| return runQuery({ | |
| [PRISMA]: () => relationalQuery(...args), | |
| [CLICKHOUSE]: () => clickhouseQuery(...args), | |
| }); | |
| } | |
| async function relationalQuery( | |
| websiteId: string, | |
| filters: QueryFilters & { propertyName?: string }, | |
| ) { | |
| const { rawQuery, parseFilters } = prisma; | |
| const { filterQuery, params } = await parseFilters(websiteId, filters, { | |
| columns: { propertyName: 'data_key' }, | |
| }); | |
| return rawQuery( | |
| ` | |
| select | |
| data_key as "propertyName", | |
| count(*) as "total" | |
| from session_data | |
| where website_id = {{websiteId::uuid}} | |
| and created_at between {{startDate}} and {{endDate}} | |
| ${filterQuery} | |
| group by data_key | |
| order by 2 desc | |
| limit 500 | |
| `, | |
| params, | |
| ); | |
| } | |
| async function clickhouseQuery( | |
| websiteId: string, | |
| filters: QueryFilters & { propertyName?: string }, | |
| ): Promise<{ propertyName: string; total: number }[]> { | |
| const { rawQuery, parseFilters } = clickhouse; | |
| const { filterQuery, params } = await parseFilters(websiteId, filters, { | |
| columns: { propertyName: 'data_key' }, | |
| }); | |
| return rawQuery( | |
| ` | |
| select | |
| data_key as propertyName, | |
| count(*) as total | |
| from session_data final | |
| where website_id = {websiteId:UUID} | |
| and created_at between {startDate:DateTime64} and {endDate:DateTime64} | |
| ${filterQuery} | |
| group by data_key | |
| order by 2 desc | |
| limit 500 | |
| `, | |
| params, | |
| ); | |
| } | |