/
opt
/
canhelp
/
node_modules
/
kysely
/
dist
/
esm
/
query-builder
/
/opt/canhelp/node_modules/kysely/dist/esm/query-builder
mkdir
upload
Name
Size
Mode
Actions
aggregate-function-builder.d.ts
13602
0644
edit
dl
rm
aggregate-function-builder.js
7666
0644
edit
dl
rm
case-builder.d.ts
6689
0644
edit
dl
rm
case-builder.js
2563
0644
edit
dl
rm
cte-builder.d.ts
802
0644
edit
dl
rm
cte-builder.js
961
0644
edit
dl
rm
delete-query-builder.d.ts
47443
0644
edit
dl
rm
delete-query-builder.js
15843
0644
edit
dl
rm
delete-result.d.ts
116
0644
edit
dl
rm
delete-result.js
183
0644
edit
dl
rm
function-module.d.ts
23521
0644
edit
dl
rm
function-module.js
2299
0644
edit
dl
rm
having-interface.d.ts
953
0644
edit
dl
rm
having-interface.js
61
0644
edit
dl
rm
insert-query-builder.d.ts
40215
0644
edit
dl
rm
insert-query-builder.js
35726
0644
edit
dl
rm
insert-result.d.ts
1735
0644
edit
dl
rm
insert-result.js
1783
0644
edit
dl
rm
join-builder.d.ts
1773
0644
edit
dl
rm
join-builder.js
1583
0644
edit
dl
rm
json-path-builder.d.ts
9545
0644
edit
dl
rm
json-path-builder.js
5817
0644
edit
dl
rm
merge-query-builder.d.ts
37025
0644
edit
dl
rm
merge-query-builder.js
20065
0644
edit
dl
rm
merge-result.d.ts
139
0644
edit
dl
rm
merge-result.js
181
0644
edit
dl
rm
no-result-error.d.ts
478
0644
edit
dl
rm
no-result-error.js
384
0644
edit
dl
rm
on-conflict-builder.d.ts
25573
0644
edit
dl
rm
on-conflict-builder.js
8116
0644
edit
dl
rm
order-by-interface.d.ts
4883
0644
edit
dl
rm
order-by-interface.js
63
0644
edit
dl
rm
order-by-item-builder.d.ts
1372
0644
edit
dl
rm
order-by-item-builder.js
2132
0644
edit
dl
rm
output-interface.d.ts
5477
0644
edit
dl
rm
output-interface.js
61
0644
edit
dl
rm
over-builder.d.ts
3755
0644
edit
dl
rm
over-builder.js
1239
0644
edit
dl
rm
returning-interface.d.ts
3496
0644
edit
dl
rm
returning-interface.js
64
0644
edit
dl
rm
select-query-builder-expression.d.ts
962
0644
edit
dl
rm
select-query-builder-expression.js
76
0644
edit
dl
rm
select-query-builder.d.ts
78467
0644
edit
dl
rm
select-query-builder.js
13062
0644
edit
dl
rm
update-query-builder.d.ts
50254
0644
edit
dl
rm
update-query-builder.js
16441
0644
edit
dl
rm
update-result.d.ts
497
0644
edit
dl
rm
update-result.js
572
0644
edit
dl
rm
where-interface.d.ts
10814
0644
edit
dl
rm
where-interface.js
60
0644
edit
dl
rm
Edit:
/opt/canhelp/node_modules/kysely/dist/esm/query-builder/over-builder.d.ts
(3755B)
import type { Expression } from '../expression/expression.js'; import type { OperationNodeSource } from '../operation-node/operation-node-source.js'; import { OverNode } from '../operation-node/over-node.js'; import { type DirectedOrderByStringReference, type OrderByExpression, type OrderByModifiers } from '../parser/order-by-parser.js'; import { type PartitionByExpression } from '../parser/partition-by-parser.js'; import type { OrderByInterface } from './order-by-interface.js'; export declare class OverBuilder<DB, TB extends keyof DB> implements OrderByInterface<DB, TB, {}>, OperationNodeSource { #private; constructor(props: OverBuilderProps); /** * Adds an `order by` clause or item inside the `over` function. * * ```ts * const result = await db * .selectFrom('person') * .select( * (eb) => eb.fn.avg<number>('age').over( * ob => ob.orderBy('first_name', 'asc').orderBy('last_name', 'asc') * ).as('average_age') * ) * .execute() * ``` * * The generated SQL (PostgreSQL): * * ```sql * select avg("age") over(order by "first_name" asc, "last_name" asc) as "average_age" * from "person" * ``` */ orderBy<OE extends OrderByExpression<DB, TB, {}>>(expr: OE, modifiers?: OrderByModifiers): OverBuilder<DB, TB>; /** * @deprecated It does ~2-2.6x more compile-time instantiations compared to multiple chained `orderBy(expr, modifiers?)` calls (in `order by` clauses with reasonable item counts), and has broken autocompletion. */ orderBy<OE extends OrderByExpression<DB, TB, {}> | DirectedOrderByStringReference<DB, TB, {}>>(exprs: ReadonlyArray<OE>): OverBuilder<DB, TB>; /** * @deprecated It does ~2.9x more compile-time instantiations compared to a `orderBy(expr, direction)` call. */ orderBy<OE extends DirectedOrderByStringReference<DB, TB, {}>>(expr: OE): OverBuilder<DB, TB>; /** * @deprecated Use `orderBy(expr, (ob) => ...)` instead. */ orderBy<OE extends OrderByExpression<DB, TB, {}>>(expr: OE, modifiers: Expression<any>): OverBuilder<DB, TB>; /** * Clears the `order by` clause from the query. * * See {@link orderBy} for adding an `order by` clause or item to a query. * * ### Examples * * ```ts * const query = db * .selectFrom('person') * .selectAll() * .orderBy('id', 'desc') * * const results = await query * .clearOrderBy() * .execute() * ``` * * The generated SQL (PostgreSQL): * * ```sql * select * from "person" * ``` */ clearOrderBy(): OverBuilder<DB, TB>; /** * Adds partition by clause item/s inside the over function. * * ```ts * const result = await db * .selectFrom('person') * .select( * (eb) => eb.fn.avg<number>('age').over( * ob => ob.partitionBy(['last_name', 'first_name']) * ).as('average_age') * ) * .execute() * ``` * * The generated SQL (PostgreSQL): * * ```sql * select avg("age") over(partition by "last_name", "first_name") as "average_age" * from "person" * ``` */ partitionBy(partitionBy: ReadonlyArray<PartitionByExpression<DB, TB>>): OverBuilder<DB, TB>; partitionBy<PE extends PartitionByExpression<DB, TB>>(partitionBy: PE): OverBuilder<DB, TB>; /** * Simply calls the provided function passing `this` as the only argument. `$call` returns * what the provided function returns. */ $call<T>(func: (qb: this) => T): T; toOperationNode(): OverNode; } export interface OverBuilderProps { readonly overNode: OverNode; }
Save
cmd:
run