Spaces:
Configuration error
Configuration error
Download src/queries/analytics/getValues.ts from SreejithSHR/umami: direct link, hf CLI and curl.
- Browser
- Download file 2.71 kB
-
https://huggingface.co/spaces/SreejithSHR/umami/resolve/main/src/queries/analytics/getValues.ts
- Command line
-
hf download hf://spaces/SreejithSHR/umami/src/queries/analytics/getValues.ts
-
curl -L -o getValues.ts https://huggingface.co/spaces/SreejithSHR/umami/resolve/main/src/queries/analytics/getValues.ts
2.71 kB
| import prisma from 'lib/prisma'; | |
| import clickhouse from 'lib/clickhouse'; | |
| import { runQuery, CLICKHOUSE, PRISMA } from 'lib/db'; | |
| export async function getValues( | |
| ...args: [websiteId: string, column: string, startDate: Date, endDate: Date, search: string] | |
| ) { | |
| return runQuery({ | |
| [PRISMA]: () => relationalQuery(...args), | |
| [CLICKHOUSE]: () => clickhouseQuery(...args), | |
| }); | |
| } | |
| async function relationalQuery( | |
| websiteId: string, | |
| column: string, | |
| startDate: Date, | |
| endDate: Date, | |
| search: string, | |
| ) { | |
| const { rawQuery, getSearchSQL } = prisma; | |
| const params = {}; | |
| let searchQuery = ''; | |
| if (search) { | |
| if (decodeURIComponent(search).includes(',')) { | |
| searchQuery = `AND (${decodeURIComponent(search) | |
| .split(',') | |
| .slice(0, 5) | |
| .map((value: string, index: number) => { | |
| const key = `search${index}`; | |
| params[key] = value; | |
| return getSearchSQL(column, key).replace('and ', ''); | |
| }) | |
| .join(' OR ')})`; | |
| } else { | |
| searchQuery = getSearchSQL(column); | |
| } | |
| } | |
| return rawQuery( | |
| ` | |
| select ${column} as "value", count(*) | |
| from website_event | |
| inner join session | |
| on session.session_id = website_event.session_id | |
| where website_event.website_id = {{websiteId::uuid}} | |
| and website_event.created_at between {{startDate}} and {{endDate}} | |
| ${searchQuery} | |
| group by 1 | |
| order by 2 desc | |
| limit 10 | |
| `, | |
| { | |
| websiteId, | |
| startDate, | |
| endDate, | |
| search: `%${search}%`, | |
| ...params, | |
| }, | |
| ); | |
| } | |
| async function clickhouseQuery( | |
| websiteId: string, | |
| column: string, | |
| startDate: Date, | |
| endDate: Date, | |
| search: string, | |
| ) { | |
| const { rawQuery, getSearchSQL } = clickhouse; | |
| const params = {}; | |
| let searchQuery = ''; | |
| if (search) { | |
| searchQuery = `and positionCaseInsensitive(${column}, {search:String}) > 0`; | |
| } | |
| if (search) { | |
| if (decodeURIComponent(search).includes(',')) { | |
| searchQuery = `AND (${decodeURIComponent(search) | |
| .split(',') | |
| .slice(0, 5) | |
| .map((value: string, index: number) => { | |
| const key = `search${index}`; | |
| params[key] = value; | |
| return getSearchSQL(column, key).replace('and ', ''); | |
| }) | |
| .join(' OR ')})`; | |
| } else { | |
| searchQuery = getSearchSQL(column); | |
| } | |
| } | |
| return rawQuery( | |
| ` | |
| select ${column} as value, count(*) | |
| from website_event | |
| where website_id = {websiteId:UUID} | |
| and created_at between {startDate:DateTime64} and {endDate:DateTime64} | |
| ${searchQuery} | |
| group by 1 | |
| order by 2 desc | |
| limit 10 | |
| `, | |
| { | |
| websiteId, | |
| startDate, | |
| endDate, | |
| search, | |
| ...params, | |
| }, | |
| ); | |
| } | |