FM / functions

/opt/canhelp/node_modules/drizzle-orm/sql/functions/

/opt/canhelp/node_modules/drizzle-orm/sql/functions

Name	Size	Mode	Actions
aggregate.cjs	2408	0644	edit dl rm
aggregate.cjs.map	4758	0644	edit dl rm
aggregate.d.cts	3260	0644	edit dl rm
aggregate.d.ts	3258	0644	edit dl rm
aggregate.js	1028	0644	edit dl rm
aggregate.js.map	4683	0644	edit dl rm
index.cjs	1229	0644	edit dl rm
index.cjs.map	232	0644	edit dl rm
index.d.cts	63	0644	edit dl rm
index.d.ts	61	0644	edit dl rm
index.js	94	0644	edit dl rm
index.js.map	193	0644	edit dl rm
vector.cjs	2544	0644	edit dl rm
vector.cjs.map	6654	0644	edit dl rm
vector.d.cts	4540	0644	edit dl rm
vector.d.ts	4537	0644	edit dl rm
vector.js	1200	0644	edit dl rm
vector.js.map	6579	0644	edit dl rm

Edit: /opt/canhelp/node_modules/drizzle-orm/sql/functions/aggregate.d.cts (3260B)

import { type AnyColumn } from "../../column.cjs";
import { type SQL, type SQLWrapper } from "../sql.cjs";
/**
 * Returns the number of values in `expression`.
 *
 * ## Examples
 *
 * ```ts
 * // Number employees with null values
 * db.select({ value: count() }).from(employees)
 * // Number of employees where `name` is not null
 * db.select({ value: count(employees.name) }).from(employees)
 * ```
 *
 * @see countDistinct to get the number of non-duplicate values in `expression`
 */
export declare function count(expression?: SQLWrapper): SQL<number>;
/**
 * Returns the number of non-duplicate values in `expression`.
 *
 * ## Examples
 *
 * ```ts
 * // Number of employees where `name` is distinct
 * db.select({ value: countDistinct(employees.name) }).from(employees)
 * ```
 *
 * @see count to get the number of values in `expression`, including duplicates
 */
export declare function countDistinct(expression: SQLWrapper): SQL<number>;
/**
 * Returns the average (arithmetic mean) of all non-null values in `expression`.
 *
 * ## Examples
 *
 * ```ts
 * // Average salary of an employee
 * db.select({ value: avg(employees.salary) }).from(employees)
 * ```
 *
 * @see avgDistinct to get the average of all non-null and non-duplicate values in `expression`
 */
export declare function avg(expression: SQLWrapper): SQL<string | null>;
/**
 * Returns the average (arithmetic mean) of all non-null and non-duplicate values in `expression`.
 *
 * ## Examples
 *
 * ```ts
 * // Average salary of an employee where `salary` is distinct
 * db.select({ value: avgDistinct(employees.salary) }).from(employees)
 * ```
 *
 * @see avg to get the average of all non-null values in `expression`, including duplicates
 */
export declare function avgDistinct(expression: SQLWrapper): SQL<string | null>;
/**
 * Returns the sum of all non-null values in `expression`.
 *
 * ## Examples
 *
 * ```ts
 * // Sum of every employee's salary
 * db.select({ value: sum(employees.salary) }).from(employees)
 * ```
 *
 * @see sumDistinct to get the sum of all non-null and non-duplicate values in `expression`
 */
export declare function sum(expression: SQLWrapper): SQL<string | null>;
/**
 * Returns the sum of all non-null and non-duplicate values in `expression`.
 *
 * ## Examples
 *
 * ```ts
 * // Sum of every employee's salary where `salary` is distinct (no duplicates)
 * db.select({ value: sumDistinct(employees.salary) }).from(employees)
 * ```
 *
 * @see sum to get the sum of all non-null values in `expression`, including duplicates
 */
export declare function sumDistinct(expression: SQLWrapper): SQL<string | null>;
/**
 * Returns the maximum value in `expression`.
 *
 * ## Examples
 *
 * ```ts
 * // The employee with the highest salary
 * db.select({ value: max(employees.salary) }).from(employees)
 * ```
 */
export declare function max<T extends SQLWrapper>(expression: T): SQL<(T extends AnyColumn ? T['_']['data'] : string) | null>;
/**
 * Returns the minimum value in `expression`.
 *
 * ## Examples
 *
 * ```ts
 * // The employee with the lowest salary
 * db.select({ value: min(employees.salary) }).from(employees)
 * ```
 */
export declare function min<T extends SQLWrapper>(expression: T): SQL<(T extends AnyColumn ? T['_']['data'] : string) | null>;

import { type AnyColumn } from "../../column.cjs"; import { type SQL, type SQLWrapper } from "../sql.cjs"; /** * Returns the number of values in `expression`. * * ## Examples * * ```ts * // Number employees with null values * db.select({ value: count() }).from(employees) * // Number of employees where `name` is not null * db.select({ value: count(employees.name) }).from(employees) * ``` * * @see countDistinct to get the number of non-duplicate values in `expression` */ export declare function count(expression?: SQLWrapper): SQL; /** * Returns the number of non-duplicate values in `expression`. * * ## Examples * * ```ts * // Number of employees where `name` is distinct * db.select({ value: countDistinct(employees.name) }).from(employees) * ``` * * @see count to get the number of values in `expression`, including duplicates */ export declare function countDistinct(expression: SQLWrapper): SQL; /** * Returns the average (arithmetic mean) of all non-null values in `expression`. * * ## Examples * * ```ts * // Average salary of an employee * db.select({ value: avg(employees.salary) }).from(employees) * ``` * * @see avgDistinct to get the average of all non-null and non-duplicate values in `expression` */ export declare function avg(expression: SQLWrapper): SQL; /** * Returns the average (arithmetic mean) of all non-null and non-duplicate values in `expression`. * * ## Examples * * ```ts * // Average salary of an employee where `salary` is distinct * db.select({ value: avgDistinct(employees.salary) }).from(employees) * ``` * * @see avg to get the average of all non-null values in `expression`, including duplicates */ export declare function avgDistinct(expression: SQLWrapper): SQL; /** * Returns the sum of all non-null values in `expression`. * * ## Examples * * ```ts * // Sum of every employee's salary * db.select({ value: sum(employees.salary) }).from(employees) * ``` * * @see sumDistinct to get the sum of all non-null and non-duplicate values in `expression` */ export declare function sum(expression: SQLWrapper): SQL; /** * Returns the sum of all non-null and non-duplicate values in `expression`. * * ## Examples * * ```ts * // Sum of every employee's salary where `salary` is distinct (no duplicates) * db.select({ value: sumDistinct(employees.salary) }).from(employees) * ``` * * @see sum to get the sum of all non-null values in `expression`, including duplicates */ export declare function sumDistinct(expression: SQLWrapper): SQL; /** * Returns the maximum value in `expression`. * * ## Examples * * ```ts * // The employee with the highest salary * db.select({ value: max(employees.salary) }).from(employees) * ``` */ export declare function max(expression: T): SQL<(T extends AnyColumn ? T['_']['data'] : string) | null>; /** * Returns the minimum value in `expression`. * * ## Examples * * ```ts * // The employee with the lowest salary * db.select({ value: min(employees.salary) }).from(employees) * ``` */ export declare function min(expression: T): SQL<(T extends AnyColumn ? T['_']['data'] : string) | null>;