BLUE

Navigation

Breadcrumbs

/ / var / www / gtechmarathon2026.bitkit.dk / httpdocs / node_modules / drizzle-orm / sql / functions

Create

Upload

Tip: You can also drag & drop files anywhere on this page to upload.

Edit File Size: 4.57 KB

/var/www/gtechmarathon2026.bitkit.dk/httpdocs/node_modules/drizzle-orm/sql/functions/aggregate.js.map

Text Base64

{"version":3,"sources":["../../../src/sql/functions/aggregate.ts"],"sourcesContent":["import { type AnyColumn, Column } from '~/column.ts';\nimport { is } from '~/entity.ts';\nimport { type SQL, sql, type SQLWrapper } from '../sql.ts';\n\n/**\n * Returns the number of values in `expression`.\n *\n * ## Examples\n *\n * ```ts\n * // Number employees with null values\n * db.select({ value: count() }).from(employees)\n * // Number of employees where `name` is not null\n * db.select({ value: count(employees.name) }).from(employees)\n * ```\n *\n * @see countDistinct to get the number of non-duplicate values in `expression`\n */\nexport function count(expression?: SQLWrapper): SQL<number> {\n\treturn sql`count(${expression || sql.raw('*')})`.mapWith(Number);\n}\n\n/**\n * Returns the number of non-duplicate values in `expression`.\n *\n * ## Examples\n *\n * ```ts\n * // Number of employees where `name` is distinct\n * db.select({ value: countDistinct(employees.name) }).from(employees)\n * ```\n *\n * @see count to get the number of values in `expression`, including duplicates\n */\nexport function countDistinct(expression: SQLWrapper): SQL<number> {\n\treturn sql`count(distinct ${expression})`.mapWith(Number);\n}\n\n/**\n * Returns the average (arithmetic mean) of all non-null values in `expression`.\n *\n * ## Examples\n *\n * ```ts\n * // Average salary of an employee\n * db.select({ value: avg(employees.salary) }).from(employees)\n * ```\n *\n * @see avgDistinct to get the average of all non-null and non-duplicate values in `expression`\n */\nexport function avg(expression: SQLWrapper): SQL<string | null> {\n\treturn sql`avg(${expression})`.mapWith(String);\n}\n\n/**\n * Returns the average (arithmetic mean) of all non-null and non-duplicate values in `expression`.\n *\n * ## Examples\n *\n * ```ts\n * // Average salary of an employee where `salary` is distinct\n * db.select({ value: avgDistinct(employees.salary) }).from(employees)\n * ```\n *\n * @see avg to get the average of all non-null values in `expression`, including duplicates\n */\nexport function avgDistinct(expression: SQLWrapper): SQL<string | null> {\n\treturn sql`avg(distinct ${expression})`.mapWith(String);\n}\n\n/**\n * Returns the sum of all non-null values in `expression`.\n *\n * ## Examples\n *\n * ```ts\n * // Sum of every employee's salary\n * db.select({ value: sum(employees.salary) }).from(employees)\n * ```\n *\n * @see sumDistinct to get the sum of all non-null and non-duplicate values in `expression`\n */\nexport function sum(expression: SQLWrapper): SQL<string | null> {\n\treturn sql`sum(${expression})`.mapWith(String);\n}\n\n/**\n * Returns the sum of all non-null and non-duplicate values in `expression`.\n *\n * ## Examples\n *\n * ```ts\n * // Sum of every employee's salary where `salary` is distinct (no duplicates)\n * db.select({ value: sumDistinct(employees.salary) }).from(employees)\n * ```\n *\n * @see sum to get the sum of all non-null values in `expression`, including duplicates\n */\nexport function sumDistinct(expression: SQLWrapper): SQL<string | null> {\n\treturn sql`sum(distinct ${expression})`.mapWith(String);\n}\n\n/**\n * Returns the maximum value in `expression`.\n *\n * ## Examples\n *\n * ```ts\n * // The employee with the highest salary\n * db.select({ value: max(employees.salary) }).from(employees)\n * ```\n */\nexport function max<T extends SQLWrapper>(expression: T): SQL<(T extends AnyColumn ? T['_']['data'] : string) | null> {\n\treturn sql`max(${expression})`.mapWith(is(expression, Column) ? expression : String) as any;\n}\n\n/**\n * Returns the minimum value in `expression`.\n *\n * ## Examples\n *\n * ```ts\n * // The employee with the lowest salary\n * db.select({ value: min(employees.salary) }).from(employees)\n * ```\n */\nexport function min<T extends SQLWrapper>(expression: T): SQL<(T extends AnyColumn ? T['_']['data'] : string) | null> {\n\treturn sql`min(${expression})`.mapWith(is(expression, Column) ? expression : String) as any;\n}\n"],"mappings":"AAAA,SAAyB,cAAc;AACvC,SAAS,UAAU;AACnB,SAAmB,WAA4B;AAgBxC,SAAS,MAAM,YAAsC;AAC3D,SAAO,YAAY,cAAc,IAAI,IAAI,GAAG,CAAC,IAAI,QAAQ,MAAM;AAChE;AAcO,SAAS,cAAc,YAAqC;AAClE,SAAO,qBAAqB,UAAU,IAAI,QAAQ,MAAM;AACzD;AAcO,SAAS,IAAI,YAA4C;AAC/D,SAAO,UAAU,UAAU,IAAI,QAAQ,MAAM;AAC9C;AAcO,SAAS,YAAY,YAA4C;AACvE,SAAO,mBAAmB,UAAU,IAAI,QAAQ,MAAM;AACvD;AAcO,SAAS,IAAI,YAA4C;AAC/D,SAAO,UAAU,UAAU,IAAI,QAAQ,MAAM;AAC9C;AAcO,SAAS,YAAY,YAA4C;AACvE,SAAO,mBAAmB,UAAU,IAAI,QAAQ,MAAM;AACvD;AAYO,SAAS,IAA0B,YAA4E;AACrH,SAAO,UAAU,UAAU,IAAI,QAAQ,GAAG,YAAY,MAAM,IAAI,aAAa,MAAM;AACpF;AAYO,SAAS,IAA0B,YAA4E;AACrH,SAAO,UAAU,UAAU,IAAI,QAAQ,GAAG,YAAY,MAAM,IAAI,aAAa,MAAM;AACpF;","names":[]}

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Directory Contents

Dirs: 0 × Files: 18

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
aggregate.cjs	2.35 KB	lrw-r--r--	2025-07-10 12:54:56	Edit Download recursive recursive
aggregate.cjs.map	4.65 KB	lrw-r--r--	2025-07-10 12:54:59	Edit Download recursive recursive
aggregate.d.cts	3.18 KB	lrw-r--r--	2025-07-10 12:54:58	Edit Download recursive recursive
aggregate.d.ts	3.18 KB	lrw-r--r--	2025-07-10 12:55:00	Edit Download recursive recursive
aggregate.js	1.00 KB	lrw-r--r--	2025-07-10 12:54:59	Edit Download recursive recursive
aggregate.js.map	4.57 KB	lrw-r--r--	2025-07-10 12:54:59	Edit Download recursive recursive
index.cjs	1.20 KB	lrw-r--r--	2025-07-10 12:54:58	Edit Download recursive recursive
index.cjs.map	232 B	lrw-r--r--	2025-07-10 12:54:59	Edit Download recursive recursive
index.d.cts	63 B	lrw-r--r--	2025-07-10 12:54:59	Edit Download recursive recursive
index.d.ts	61 B	lrw-r--r--	2025-07-10 12:55:00	Edit Download recursive recursive
index.js	94 B	lrw-r--r--	2025-07-10 12:54:59	Edit Download recursive recursive
index.js.map	193 B	lrw-r--r--	2025-07-10 12:54:59	Edit Download recursive recursive
vector.cjs	2.48 KB	lrw-r--r--	2025-07-10 12:54:58	Edit Download recursive recursive
vector.cjs.map	6.50 KB	lrw-r--r--	2025-07-10 12:55:00	Edit Download recursive recursive
vector.d.cts	4.43 KB	lrw-r--r--	2025-07-10 12:54:59	Edit Download recursive recursive
vector.d.ts	4.43 KB	lrw-r--r--	2025-07-10 12:55:00	Edit Download recursive recursive
vector.js	1.17 KB	lrw-r--r--	2025-07-10 12:54:59	Edit Download recursive recursive
vector.js.map	6.42 KB	lrw-r--r--	2025-07-10 12:55:00	Edit Download recursive recursive