Nâng cấp objection từ 3.x lên 4.x
So sánh API công khai của objection 3.9.1 và 4.0.0, được tính tự động từ kiểu TypeScript. Chữ ký thay đổi là thay đổi có thể không tương thích, không phải điều chắc chắn.
Tóm tắt
| Đường dẫn import bị xóa | 0 |
|---|---|
| Export bị xóa | 24 |
| Chữ ký thay đổi | 28 |
| Thành viên lớp hoặc interface bị xóa | 7 |
| Thành viên lớp hoặc interface thay đổi | 256 |
| Mới bị ngừng hỗ trợ | 0 |
| Thay đổi yêu cầu (engines, phụ thuộc peer) | 3 |
| Export mới | 23 |
Export bị xóa
| import | export | kind | Trước |
|---|---|---|---|
objection | X | type | Promise<T> |
objection | Trim | type | S extends ` ${infer R}` | `
${infer R}` | `\r${infer R}` | `\t${infer R}` ? Trim<R> : S extends `${infer L} ` | `${infer L}
` | `${infer L}\r` | `${infer L}\t` ? Trim<L> : S |
objection | ItemType | type | T extends unknown[] ? T[number] : T |
objection | CountChar | type | S extends `${string}${C}${infer R}` ? CountChar<R, C, [...N, 0]> : N["length"] |
objection | SplitList | type | S extends `${infer Head},${infer Rest}` ? IsBalanced<`${Acc}${Head}`> extends true ? SplitList<Rest, "", [...Out, `${Acc}${Head}`]> : SplitList<Rest, `${Acc}${Head},`, Out> : [...Out, `${Acc}${S}`] |
objection | WithGraph | type | [keyof T] extends [never] ? M : WithGraphRelations<M, T, FetchedRelations<M, T>> |
objection | IsBalanced | type | CountChar<S, "[", []> extends CountChar<S, "]", []> ? CountChar<S, "(", []> extends CountChar<S, ")", []> ? true : false : false |
objection | Whitespace | type | " " | "\n" | "\r" | "\t" |
objection | RelationName | type | Trim<S> extends `${infer Name}(${string})` ? RelationName<Name> : Trim<S> extends infer Name extends string ? Name extends "" | "*" | `^${string}` | `${string} ${string}` | `${string}
${string}` | `${string}\r${string}` | `${string}\t${string}` ? never : string extends Name ? never : Name : never |
objection | RelationNode | type | [Name] extends [never] ? {} : { [K in Name]: Children; } |
objection | ReturningMethod | interface | interface |
objection | ParseRelationList | type | L extends [infer H extends string, ...infer T extends string[]] ? ParseRelationList<T, Acc & ParseRelationString<H>> : Acc |
objection | PartialModelProps | type | { [K in Exclude<NonFunctionPropertyNames<T>, "QueryBuilderType">]?: (Exclude<T[K], undefined> extends Model | Model[] ? never : any) | undefined; } |
objection | WithGraphProperty | type | [keyof T] extends [never] ? P : P extends (infer I)[] ? WithGraph<I, T>[] : P extends Model ? WithGraph<P, T> : P |
objection | ParseRelationObject | type | string extends keyof E ? {} : { [K in keyof E as K extends `$${string}` ? never : false extends E[K] ? never : E[K] extends { $relation: any; } ? never : K]: E[K] extends object ? ParseRelationObject<E[K]> : {}; } |
objection | ParseRelationString | type | Trim<S> extends `[${infer Inner}]` ? ParseRelationList<SplitList<Inner, "", []>, {}> : Trim<S> extends `${infer Head}.${infer Rest}` ? IsBalanced<Head> extends true ? RelationNode<RelationName<Head>, ParseRelationString<Rest>> : {} : RelationNode<RelationName<S>, {}> |
objection | InsertableGraphField | type | NonNullable<F> extends (infer I extends Model)[] ? (InsertableGraphReference | InsertableGraph<I>)[] : NonNullable<F> extends infer I extends Model ? InsertableGraphReference | InsertableGraph<I> | Extract<F, null> : never |
objection | RelationPropertyNames | type | { [K in keyof M]-?: NonNullable<M[K]> extends Model | Model[] ? K : never; }[keyof M] |
objection | InsertablePropertyNames | type | Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType"> extends RelationPropertyNames<M> ? never : Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType"> |
objection | TypedRelationMappingFor | type | NonNullable<T> extends (infer I extends Model)[] ? TypedRelationMapping<I, HasManyRelationType | ManyToManyRelationType> : NonNullable<T> extends infer I extends Model ? TypedRelationMapping<I, BelongsToOneRelationType | HasOneRelationType | HasOneThroughRelationType> : never |
objection | InsertableGraphReference | type | { '#dbRef': any; } | { '#ref': string; } |
objection | TypedModelClassSpecifier | type | string | ModelConstructor<M> | (() => ModelConstructor<M>) |
objection | WithGraphModelQueryBuilder | type | M extends unknown ? WithGraph<M, ParseRelationExpression<E>>["QueryBuilderType"] : never |
objection | OptionalInsertPropertyNames | type | { [K in keyof M]-?: {} extends Pick<M, K> ? K : null extends M[K] ? K : typeof generated extends keyof NonNullable<M[K]> ? K : never; }[keyof M] |
Chữ ký thay đổi
| export | Trước | Sau |
|---|---|---|
objection · DBError | any | class |
objection · DataError | any | class |
objection · Insertable | { [K in Exclude<Exclude<Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType">, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]: any; } & { [K in Extract<Exclude<Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType">, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]?: any; } | { [K in Exclude<Exclude<Exclude<NonFunctionPropertyNames<M>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]: any; } & { [K in Extract<Exclude<Exclude<NonFunctionPropertyNames<M>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]?: any; } |
objection · ModelProps | { [K in keyof T]?: (Exclude<T[K], undefined> extends Model ? never : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? never : K : T[K] extends Function ? never : K) | undefined; }[keyof T] extends "QueryBuilderType" | undefined ? never : { [K in keyof T]?: (Exclude<T[K], undefined> extends Model ? never : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? never : K : T[K] extends Function ? never : K) | undefined; }[keyof T] | Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`> extends RelationPropertyNames<T> ? never : Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`> |
objection · ModelObject | { [P in Exclude<NonFunctionPropertyNames<T>, "QueryBuilderType">]: T[P]; } | { [P in Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`>]: T[P]; } |
objection · ModelRelations | { [K in keyof T]?: (Exclude<T[K], undefined> extends Model ? K : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? K : never : never) | undefined; }[keyof T] extends undefined ? never : { [K in keyof T]?: (Exclude<T[K], undefined> extends Model ? K : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? K : never : never) | undefined; }[keyof T] | { [K in keyof T]-?: HasModels<NonNullable<T[K]>> extends true ? K : never; }[keyof T] |
objection · WithResultKind | [R] extends [M[]] ? ArrayQueryBuilder<NQB> : [R] extends [Page<M>] ? PageQueryBuilder<NQB> : [R] extends [object | undefined] ? [R] extends [M] ? SingleQueryBuilder<NQB> : [R] extends [M | undefined] ? MaybeSingleQueryBuilder<NQB> : QB : QB | [R] extends [ExtractedRows] ? Rebind<QB, M, WithGraphResult<R, T>, unknown> : [R] extends [M[]] ? ArrayQueryBuilder<NQB> : [R] extends [Page<M>] ? PageQueryBuilder<NQB> : [R] extends [object | undefined] ? [R] extends [M] ? SingleQueryBuilder<NQB> : [R] extends [M | undefined] ? MaybeSingleQueryBuilder<NQB> : Rebind<QB, M, WithGraphResult<R, T>, unknown> : QB |
objection · AnyQueryBuilder | QueryBuilder<any, any> | QueryBuilder<any, any, any> |
objection · InsertableGraph | { [K in Exclude<Exclude<Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType">, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]: any; } & { [K in Extract<Exclude<Exclude<NonFunctionPropertyNames<M>, "QueryBuilderType">, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]?: any; } & Omit<GraphParameters, "#dbRef" | "#ref"> & { [K in RelationPropertyNames<M>]?: InsertableGraphField<M[K]> | undefined; } | { [K in Exclude<Exclude<Exclude<NonFunctionPropertyNames<M>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]: any; } & { [K in Extract<Exclude<Exclude<NonFunctionPropertyNames<M>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<M>>, OptionalInsertPropertyNames<M>>]?: any; } & Omit<GraphParameters, "#dbRef" | "#ref"> & { [K in RelationPropertyNames<M>]?: InsertableGraphField<M[K]> | undefined; } |
objection · PageQueryBuilder | T["PageQueryBuilderType"] | QB["~page"] |
objection · ArrayQueryBuilder | T["ArrayQueryBuilderType"] | QB["~array"] |
objection · DataPropertyNames | NonFunctionPropertyNames<T> extends "QueryBuilderType" ? never : NonFunctionPropertyNames<T> | NonFunctionPropertyNames<T> extends ModelTypeMembers | `$${string}` ? never : NonFunctionPropertyNames<T> |
objection · PartialModelGraph | T extends any ? { [K in Exclude<NonFunctionPropertyNames<T>, "QueryBuilderType">]?: (null extends T[K] ? PartialModelGraphField<NonNullable<T[K]>> | null : PartialModelGraphField<T[K]>) | undefined; } : never | T extends any ? { [K in Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`>]?: (null extends T[K] ? PartialModelGraphField<NonNullable<T[K]>> | null : PartialModelGraphField<T[K]>) | undefined; } : never |
objection · NumberQueryBuilder | T["NumberQueryBuilderType"] | QB["~number"] |
objection · PartialModelObject | { [K in Exclude<NonFunctionPropertyNames<T>, "QueryBuilderType">]?: (Exclude<T[K], undefined> extends Model ? T[K] | PartialModelObject<Exclude<T[K], undefined>> : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? I[] | PartialModelObject<I>[] : any : NonNullable<T[K]> extends Model ? any : any) | undefined; } | { [K in Exclude<NonFunctionPropertyNames<T>, ModelTypeMembers | `$${string}`>]?: (Exclude<T[K], undefined> extends Model ? T[K] | PartialModelObject<Exclude<T[K], undefined>> : Exclude<T[K], undefined> extends (infer I)[] ? I extends Model ? I[] | PartialModelObject<I>[] : any : NonNullable<T[K]> extends Model ? any : any) | undefined; } |
objection · RelateQueryBuilder | { returning: RelateReturningMethod<ModelType<QB>>; } & NumberQueryBuilder<QB> | { returning: RelateReturningMethod<ModelType<NQB>>; } & NQB |
objection · SingleQueryBuilder | T["SingleQueryBuilderType"] | QB["~single"] |
objection · CheckViolationError | any | class |
objection · RelatedQueryBuilder | T extends Model ? SingleQueryBuilder<QueryBuilderType<T>> : T extends (infer I)[] ? I extends Model ? QueryBuilderType<I> : never : never | T extends Model ? MaybeSingleQueryBuilder<QueryBuilderType<T>> : T extends (infer I)[] ? I extends Model ? QueryBuilderType<I> : never : never |
objection · UniqueViolationError | any | class |
objection · NotNullViolationError | any | class |
objection · WithGraphQueryBuilder | [keyof ParseRelationExpression<E>] extends [never] ? QB : QB extends unknown ? 0 extends 1 & ModelType<QB> ? QB : [FetchedRelations<ModelType<QB>, ParseRelationExpression<E>>] extends [never] ? QB : WithResultKind<QB, WithGraph<ModelType<QB>, ParseRelationExpression<E>>["QueryBuilderType"], ModelType<QB>, ResultType<QB>> : never | [keyof ParseRelationExpression<E>] extends [never] ? QB : QB extends unknown ? 0 extends 1 & ModelType<QB> ? QB : [FetchedRelations<ModelType<QB>, ParseRelationExpression<E>>] extends [never] ? QB : WithResultKind<QB, KeepExtra<WithGraph<ModelType<QB>, ParseRelationExpression<E>>["QueryBuilderType"], ExtraType<QB>>, ModelType<QB>, ResultType<QB>, ParseRelationExpression<E>> : never |
objection · MaybeSingleQueryBuilder | QB["MaybeSingleQueryBuilderType"] | QB["~maybeSingle"] |
objection · ParseRelationExpression | string extends E ? {} : E extends string ? ParseRelationString<E> : ParseRelationObject<E> | [E] extends [never] ? {} : string extends E ? {} : E extends string ? ParseRelationString<E> : ParseRelationObject<E> |
objection · ConstraintViolationError | any | class |
objection · ForeignKeyViolationError | any | class |
objection · NonFunctionPropertyNames | { [K in keyof T]: T[K] extends Function ? never : K; }[keyof T] | { [K in keyof T]-?: T[K] extends Function ? never : K; }[keyof T] |
objection · WithGraphTreeQueryBuilder | [keyof T] extends [never] ? QB : QB extends unknown ? 0 extends 1 & ModelType<QB> ? QB : [FetchedRelations<ModelType<QB>, T>] extends [never] ? QB : WithResultKind<QB, WithGraph<ModelType<QB>, T>["QueryBuilderType"], ModelType<QB>, ResultType<QB>> : never | [keyof T] extends [never] ? QB : QB extends unknown ? 0 extends 1 & ModelType<QB> ? QB : [FetchedRelations<ModelType<QB>, T>] extends [never] ? QB : WithResultKind<QB, KeepExtra<WithGraph<ModelType<QB>, T>["QueryBuilderType"], ExtraType<QB>>, ModelType<QB>, ResultType<QB>, T> : never |
Thành viên lớp hoặc interface bị xóa
| member | import | Trước |
|---|---|---|
QueryBuilder.skipUndefined | objection | (): QueryBuilder<M, R> |
QueryBuilder.PageQueryBuilderType | objection | QueryBuilder<M, Page<M>> |
QueryBuilder.ArrayQueryBuilderType | objection | QueryBuilder<M, M[]> |
QueryBuilder.NumberQueryBuilderType | objection | QueryBuilder<M, number> |
QueryBuilder.SingleQueryBuilderType | objection | QueryBuilder<M, M> |
QueryBuilder.MaybeSingleQueryBuilderType | objection | QueryBuilder<M, M | undefined> |
InsertGraphOptions.allowMarkers | objection | boolean | undefined |
Thành viên lớp hoặc interface thay đổi
| member | Trước | Sau |
|---|---|---|
Model.$query | (trxOrKnex?: any): QueryBuilder<Model, Model> | (trxOrKnex?: any): QueryBuilder<Model, Model, unknown> |
Model.toJSON | (opt?: ToJsonOptions | undefined): ModelObject<Model> | (opt?: ToJsonOptions | undefined): ModelJson<Model> |
Model.$toJson | (opt?: ToJsonOptions | undefined): ModelObject<Model> | (opt?: ToJsonOptions | undefined): ModelJson<Model> |
Model.$fetchGraph | <const E extends RelationExpression<Model>>(expression: E, options?: FetchGraphOptions | undefined): SingleQueryBuilder<WithGraph<Model, ParseRelationExpression<E>>["QueryBuilderType"]> | <const E extends RelationExpression<Model>>(expression: E, options?: FetchGraphOptions | undefined): QueryBuilder<WithGraph<Model, ParseRelationExpression<E>>, WithGraph<Model, ParseRelationExpression<E>>, unknown> |
Model.static query | <M extends Model>(this: ConstructorType<M, PrototypeType<M>>, trxOrKnex?: any): QueryBuilderType<M> | <M extends Model, C = unknown, K = unknown>(this: ConstructorType<M, PrototypeType<M>>, trxOrKnex?: any): QueryBuilderType<M> |
Model.$setDatabaseJson | (json: object): Model | (json: object, options?: DatabaseJsonOptions | undefined): Model |
Model.QueryBuilderType | QueryBuilder<Model, Model[]> | QueryBuilder<Model, Model[], unknown> |
Model.static afterFind | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, Model | Model[] | undefined>): any |
Model.static beforeFind | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
Model.static fetchGraph | <M extends Model, const E extends RelationExpression<M> = string>(this: ConstructorType<M, PrototypeType<M>>, modelOrObject: PartialModelObject<M>, expression: E, options?: FetchGraphOptions | undefined): SingleQueryBuilder<WithGraphModelQueryBuilder<M, E>> | <M extends Model, const E extends Relati… | <M extends Model, const E extends RelationExpression<M> = string>(this: ConstructorType<M, PrototypeType<M>>, modelOrObject: PartialModelObject<M>, expression: E, options?: FetchGraphOptions | undefined): Rebind<QueryBuilderType<M>, WithGraph<M, ParseRelationExpression<E>>, WithGraph<M, ParseRelatio… |
Model.static jsonSchema | JSONSchema | { readonly $id?: string | undefined; readonly $ref?: string | undefined; readonly $schema?: string | undefined; readonly $comment?: string | undefined; readonly $defs?: { readonly [x: string]: boolean | any; } | undefined; readonly type?: string | readonly string[] | undefined; readonly enum?: reado… |
Model.$parseDatabaseJson | (json: Pojo): Pojo | (json: Pojo, options?: DatabaseJsonOptions | undefined): Pojo |
Model.static afterDelete | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, number | Model | Model[] | undefined>): any |
Model.static afterInsert | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, Model | Model[]>): any |
Model.static afterUpdate | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, number | Model | Model[] | undefined>): any |
Model.static beforeDelete | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
Model.static beforeInsert | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
Model.static beforeUpdate | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
Model.static relatedQuery | <M extends Model, K extends keyof M>(this: ConstructorType<M, PrototypeType<M>>, relationName: K, trxOrKnex?: any): ArrayRelatedQueryBuilder<M[K]> | <RM extends Model>(relationName: string, trxOrKnex?: any): QueryBuilderType<RM> | <M extends Model, K extends keyof M, C = unknown>(this: ConstructorType<M, PrototypeType<M>>, relationName: K, trxOrKnex?: any): ArrayRelatedQueryBuilder<M[K]> | <RM extends Model>(relationName: string, trxOrKnex?: any): QueryBuilderType<RM> |
Model.static fromDatabaseJson | <M extends Model>(this: ConstructorType<M, PrototypeType<M>>, json: object): M | <M extends Model>(this: ConstructorType<M, PrototypeType<M>>, json: object, options?: DatabaseJsonOptions | undefined): M |
Model.static virtualAttributes | string[] | readonly string[] |
ModelClass.afterFind | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, Model | Model[] | undefined>): any |
ModelClass.beforeFind | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
ModelClass.fetchGraph | <const E extends RelationExpression<M>>(modelOrObject: PartialModelObject<M>, expression: E, options?: FetchGraphOptions | undefined): SingleQueryBuilder<WithGraphModelQueryBuilder<M, E>> | <const E extends RelationExpression<M>>(modelOrObject: PartialModelObject<M>[], expression: E, options?: Fetch… | <const E extends RelationExpression<M>>(modelOrObject: PartialModelObject<M>, expression: E, options?: FetchGraphOptions | undefined): Rebind<QueryBuilderType<M>, WithGraph<M, ParseRelationExpression<E>>, WithGraph<M, ParseRelationExpression<E>>, unknown> | <const E extends RelationExpression<M>>(mo… |
ModelClass.jsonSchema | JSONSchema | { readonly $id?: string | undefined; readonly $ref?: string | undefined; readonly $schema?: string | undefined; readonly $comment?: string | undefined; readonly $defs?: { readonly [x: string]: boolean | any; } | undefined; readonly type?: string | readonly string[] | undefined; readonly enum?: reado… |
ModelClass.afterDelete | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, number | Model | Model[] | undefined>): any |
ModelClass.afterInsert | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, Model | Model[]>): any |
ModelClass.afterUpdate | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, number | Model | Model[] | undefined>): any |
ModelClass.beforeDelete | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
ModelClass.beforeInsert | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
ModelClass.beforeUpdate | (args: StaticHookArguments<any, any>): any | (args: StaticHookArguments<any, undefined>): any |
ModelClass.fromDatabaseJson | (json: object): M | (json: object, options?: DatabaseJsonOptions | undefined): M |
ModelClass.virtualAttributes | string[] | readonly string[] |
QueryBuilder.as | (alias: string): QueryBuilder<M, R> | (alias: string): QueryBuilder<M, R, X> |
QueryBuilder.avg | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.del | (): QueryBuilder<M, number> | (): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> |
QueryBuilder.for | (ids: any): QueryBuilder<M, R> | (ids: any): QueryBuilder<M, R, X> |
QueryBuilder.max | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.min | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.sum | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.from | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R> | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R, X> |
QueryBuilder.into | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R> | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R, X> |
QueryBuilder.join | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.none | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.page | (page: number, pageSize: number): QueryBuilder<M, Page<M>> | (page: number, pageSize: number): QueryBuilder<M, Page<M>, unknown> |
QueryBuilder.with | (alias: string, expr: any): QueryBuilder<M, R> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R> | (alias: string, expr: any): QueryBuilder<M, R, X> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R, X> |
QueryBuilder.alias | (arg: string): QueryBuilder<M, R> | (arg: string): QueryBuilder<M, R, X> |
QueryBuilder.clear | (selector: string | RegExp): QueryBuilder<M, R> | (selector: string | RegExp): QueryBuilder<M, R, X> |
QueryBuilder.clone | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.count | (column?: any, options?: { as: string; } | undefined): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: string | string[]; }): QueryBuilder<M, R> | (...columns: any[]): QueryBuilder<M, R> | (column?: any, options?: { as: string; } | undefined): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: string | string[]; }): QueryBuilder<M, R, X> | (...columns: any[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const A extends string… |
QueryBuilder.debug | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.limit | (limit: number, options?: boolean | { skipBinding?: boolean | undefined; } | undefined): QueryBuilder<M, R> | (limit: number, options?: boolean | { skipBinding?: boolean | undefined; } | undefined): QueryBuilder<M, R, X> |
QueryBuilder.merge | (merge?: string[] | PartialModelObject<M> | undefined): QueryBuilder<M, R> | (merge?: string[] | PartialModelPatch<M> | undefined): QueryBuilder<M, R, X> |
QueryBuilder.patch | (update: PartialModelObject<M>): QueryBuilder<M, number> | (): QueryBuilder<M, number> | (update: PartialModelPatch<M>): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> | (): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> |
QueryBuilder.range | (): QueryBuilder<M, Page<M>> | (start: number, end: number): QueryBuilder<M, Page<M>> | (): QueryBuilder<M, Page<M>, unknown> | (start: number, end: number): QueryBuilder<M, Page<M>, unknown> |
QueryBuilder.table | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R> | (table: any, options?: { only?: boolean | undefined; } | undefined): QueryBuilder<M, R, X> |
QueryBuilder.union | (arg1: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (arg1: QBOrCallback<QueryBuilder<M, R>>, arg2: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (arg1: QBOrCallback<QueryBuilder<M, R>>, arg2: QBOrCallback<QueryBuilder<M, R>… | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, arg2: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, arg2: QBOrCallback<… |
QueryBuilder.where | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.castTo | <MC extends Model>(modelClass: ModelConstructor<MC>): QueryBuilderType<MC> | <R>(): QueryBuilder<M, R> | <MC extends Model>(modelClass: ModelConstructor<MC>): QueryBuilderType<MC> | <R>(): QueryBuilder<M, R, X> |
QueryBuilder.column | <QBP extends QueryBuilder<M, R>>(...columns: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }… | <QBP extends QueryBuilder<M, R, X>, const C extends readonly [unknown, ...unknown[]]>(...columns: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>>(columns… |
QueryBuilder.delete | (): QueryBuilder<M, number> | (): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> |
QueryBuilder.except | (...callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R>>[]): QueryBuilder<M, R> | (callbackOrBuilder: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R>>[], wrap?: boolean | undefined): QueryBuilder<M, R> | (...callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R, X>>[]): QueryBuilder<M, R, X> | (callbackOrBuilder: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R, X>>[], wrap?: boolean | undefined): QueryBuilde… |
QueryBuilder.having | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.ignore | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.insert | (insert: PartialModelObject<M>): QueryBuilder<M, M> | (insert: PartialModelObject<M>[]): QueryBuilder<M, M[]> | (): QueryBuilder<M, M> | (insert: PartialModelRow<M>): QueryBuilder<M, M, unknown> | (insert: PartialModelRow<M>[]): QueryBuilder<M, M[], unknown> | (): QueryBuilder<M, M, unknown> |
QueryBuilder.modify | (modifier: Modifier<QueryBuilder<M, R>> | Modifier<QueryBuilder<M, R>>[], ...args: any[]): QueryBuilder<M, R> | (modifier: ModifyArg<QueryBuilder<M, R, X>> | ModifyArg<QueryBuilder<M, R, X>>[], ...args: any[]): QueryBuilder<M, R, X> |
QueryBuilder.noWait | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.offset | (offset: number, options?: boolean | { skipBinding?: boolean | undefined; } | undefined): QueryBuilder<M, R> | (offset: number, options?: boolean | { skipBinding?: boolean | undefined; } | undefined): QueryBuilder<M, R, X> |
QueryBuilder.reject | (arg: any): QueryBuilder<M, R> | (arg: any): QueryBuilder<M, R, X> |
QueryBuilder.relate | (ids: any): RelateQueryBuilder<QueryBuilder<M, R>> | (ids: any): RelateQueryBuilder<WriteQueryBuilder<QueryBuilder<M, R, X>, M, R>> |
QueryBuilder.select | <QBP extends QueryBuilder<M, R>>(...columns: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }… | <QBP extends QueryBuilder<M, R, X>, const C extends readonly [unknown, ...unknown[]]>(...columns: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>>(columns… |
QueryBuilder.update | (update: PartialModelObject<M>): QueryBuilder<M, number> | (): QueryBuilder<M, number> | (update: PartialModelRow<M>): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> | (): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> |
QueryBuilder.columns | <QBP extends QueryBuilder<M, R>>(...columns: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }… | <QBP extends QueryBuilder<M, R, X>, const C extends readonly [unknown, ...unknown[]]>(...columns: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>>(columns… |
QueryBuilder.context | (context: object): QueryBuilder<M, R> | (): QueryContext | (context: object): QueryBuilder<M, R, X> | (): QueryContext |
QueryBuilder.findOne | <QBP extends QueryBuilder<M, M | undefined>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefin… | <QBP extends QueryBuilder<M, M | undefined, unknown>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, M | und… |
QueryBuilder.fromRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.groupBy | (...columns: any[]): QueryBuilder<M, R> | (columns: any[]): QueryBuilder<M, R> | (...columns: any[]): QueryBuilder<M, R, X> | (columns: any[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends readonly unknown[] = []>(...columns: never): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends readonly unknown[] = []>(columns: never)… |
QueryBuilder.joinRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.jsonSet | <QBP extends QueryBuilder<M, R>>(column: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[key… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, path: string, value: any, alias?: string | undefined): QueryBuilder<M, R, X> | (column: any,… |
QueryBuilder.onBuild | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.onError | (cb: OnErrorCallback<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: OnErrorCallback<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.orWhere | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.orderBy | (column: any, order?: OrderByDirection | undefined, nulls?: OrderByNulls | undefined): QueryBuilder<M, R> | (columns: any[]): QueryBuilder<M, R> | (column: any, order?: OrderByDirection | undefined, nulls?: OrderByNulls | undefined): QueryBuilder<M, R, X> | (columns: any[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, order?: OrderByDirection | undefined, nulls?: OrderByNulls | und… |
QueryBuilder.resolve | (arg: any): QueryBuilder<M, R> | (arg: any): QueryBuilder<M, R, X> |
QueryBuilder.timeout | (ms: number, options?: TimeoutOptions | undefined): QueryBuilder<M, R> | (ms: number, options?: TimeoutOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.whereIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.aliasFor | (modelClassOrTableName: string | AnyModelConstructor): string | null | (modelClassOrTableName: string | AnyModelConstructor, alias: string): QueryBuilder<M, R> | (modelClassOrTableName: string | AnyModelConstructor): string | null | (modelClassOrTableName: string | AnyModelConstructor, alias: string): QueryBuilder<M, R, X> |
QueryBuilder.andWhere | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.distinct | <QBP extends QueryBuilder<M, R>>(...columns: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }… | <QBP extends QueryBuilder<M, R, X>, const C extends readonly [unknown, ...unknown[]]>(...columns: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>>(columns… |
QueryBuilder.findById | (id: any): QueryBuilder<M, M | undefined> | (id: any): QueryBuilder<M, M | undefined, unknown> |
QueryBuilder.forShare | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.havingIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.leftJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.orHaving | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.runAfter | (cb: RunAfterCallback<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: RunAfterCallback<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.unionAll | (arg1: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (arg1: QBOrCallback<QueryBuilder<M, R>>, arg2: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (arg1: QBOrCallback<QueryBuilder<M, R>>, arg2: QBOrCallback<QueryBuilder<M, R>… | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, arg2: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (arg1: QBOrCallback<QueryBuilder<M, R, X>>, arg2: QBOrCallback<… |
QueryBuilder.unrelate | (): QueryBuilder<M, number> | (): WriteQueryBuilder<QueryBuilder<M, R, X>, M, R> |
QueryBuilder.whereNot | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.whereRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.andHaving | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.crossJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.decrement | (column: string, amount?: number | undefined): QueryBuilder<M, R> | (column: string, amount?: number | undefined): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, amount?: number | undefined): QueryBuilder<M, R, X> |
QueryBuilder.findByIds | (ids: any[]): QueryBuilder<M, R> | (ids: any[]): QueryBuilder<M, R, X> |
QueryBuilder.forUpdate | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.havingRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.increment | (column: string, amount?: number | undefined): QueryBuilder<M, R> | (column: string, amount?: number | undefined): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, amount?: number | undefined): QueryBuilder<M, R, X> |
QueryBuilder.innerJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.intersect | (...callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R>>[]): QueryBuilder<M, R> | (callbackOrBuilder: QBOrCallback<QueryBuilder<M, R>>, wrap?: boolean | undefined): QueryBuilder<M, R> | (callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R>>[], wrap?: boolean | undefined): QueryBuilder<M, R> | (...callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R, X>>[]): QueryBuilder<M, R, X> | (callbackOrBuilder: QBOrCallback<QueryBuilder<M, R, X>>, wrap?: boolean | undefined): QueryBuilder<M, R, X> | (callbacksOrBuilders: QBOrCallback<QueryBuilder<M, R, X>>[], wrap?: boolean | undefined): QueryBuilde… |
QueryBuilder.modifiers | (modifiers: Modifiers<AnyQueryBuilder>): QueryBuilder<M, R> | (): QueryBuilder<M, R> | <const O extends Modifiers>(modifiers: O): QueryBuilder<M, R, X> | (): QueryBuilder<M, R, X> |
QueryBuilder.orWhereIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.outerJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.patchById | (id: any, update: PartialModelObject<M>): QueryBuilder<M, number> | (id: any, update: PartialModelPatch<M>): WriteQueryBuilder<QueryBuilder<M, M | undefined, unknown>, M, M | undefined> |
QueryBuilder.returning | <QB extends AnyQueryBuilder>(this: QB, ...args: ReturningArgs): QB extends NumberQueryBuilder<QB> ? ArrayQueryBuilder<QB> : QB | (...args: ReturningArgs): 0 extends 1 & R ? any : [R] extends [number] ? QueryBuilder<M, M[], unknown> : [R] extends [readonly unknown[] | Page<unknown>] ? QueryBuilder<M, R, X> : ReturningWrites<QueryBuilder<M, R, X>, M, WrittenRows<M, R>> & QueryBuilder<M, R, X> |
QueryBuilder.rightJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.runBefore | (cb: RunBeforeCallback<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: RunBeforeCallback<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.whereLike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.whereNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.withGraph | <const E extends RelationExpression<M>>(expr: E, options?: WithGraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R>, ParseRelationExpression<E>> | <const E extends RelationExpression<M>>(expr: E, options?: WithGraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R, X>, ParseRelationExpression<E>> |
QueryBuilder.allowGraph | (expr: RelationExpression<M>): QueryBuilder<M, R> | (expr: RelationExpression<M>): QueryBuilder<M, R, X> |
QueryBuilder.clearOrder | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.clearWhere | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.connection | (arg: any): QueryBuilder<M, R> | (arg: any): QueryBuilder<M, R, X> |
QueryBuilder.deleteById | (id: any): QueryBuilder<M, number> | (id: any): WriteQueryBuilder<QueryBuilder<M, M | undefined, unknown>, M, M | undefined> |
QueryBuilder.distinctOn | <QBP extends QueryBuilder<M, R>>(...columns: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }… | (...columns: any[]): QueryBuilder<M, R, X> | (columns: any[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends readonly unknown[] = []>(...columns: never): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends readonly unknown[] = []>(columns: never)… |
QueryBuilder.groupByRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.havingNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.jsonInsert | <QBP extends QueryBuilder<M, R>>(column: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[key… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, path: string, value: any, alias?: string | undefined): QueryBuilder<M, R, X> | (column: any,… |
QueryBuilder.jsonRemove | <QBP extends QueryBuilder<M, R>>(column: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[key… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, path: string, alias?: string | undefined): QueryBuilder<M, R, X> | (column: any, path: strin… |
QueryBuilder.onConflict | (column?: any): QueryBuilder<M, R> | (column?: any): QueryBuilder<M, R, X> |
QueryBuilder.orHavingIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.orWhereNot | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.orWhereRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.orderByRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.skipLocked | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.updateById | (id: any, update: PartialModelObject<M>): QueryBuilder<M, number> | (id: any, update: PartialModelRow<M>): WriteQueryBuilder<QueryBuilder<M, M | undefined, unknown>, M, M | undefined> |
QueryBuilder.whereILike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.whereNotIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.withSchema | (arg: string): QueryBuilder<M, R> | (arg: string): QueryBuilder<M, R, X> |
QueryBuilder.andWhereNot | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.andWhereRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.avgDistinct | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.clearSelect | (): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>>(): ClearSelectQueryBuilder<QBP> |
QueryBuilder.constructor | <M extends Model, R = M[]>(modelClass: ModelConstructor<M>): QueryBuilder<M, R> | <M extends Model, R = M[], X = unknown>(modelClass: ModelConstructor<M>): QueryBuilder<M, R, X> |
QueryBuilder.forKeyShare | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.havingNotIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.joinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.jsonExtract | <QBP extends QueryBuilder<M, R>>(column: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[key… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const A extends string = string>(column: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, path: string, alias?: A | undefined, singleValue?: boolean … |
QueryBuilder.modifyGraph | <M extends Model>(expr: RelationExpression<M>, modifier: Modifier<QueryBuilderType<M>>): QueryBuilder<M, R> | <M extends Model>(expr: RelationExpression<M>, modifier: Modifier<QueryBuilderType<M>>): QueryBuilder<M, R, X> |
QueryBuilder.onBuildKnex | (cb: OnBuildKnexCallback<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: OnBuildKnexCallback<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.orHavingRaw | (sql: string, ...bindings: any[]): QueryBuilder<M, R> | (sql: string, ...bindings: any[]): QueryBuilder<M, R, X> |
QueryBuilder.orWhereLike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.orWhereNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.sumDistinct | (column: any): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: any; }): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QBP | <QBP extends QueryBuilder<M, R, X>, const O extends object = {}>(aliasToColumnDict: never): QBP |
QueryBuilder.transacting | (arg: any): QueryBuilder<M, R> | (arg: any): QueryBuilder<M, R, X> |
QueryBuilder.whereColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.whereExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.withWrapped | (alias: string, expr: any): QueryBuilder<M, R> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R> | (alias: string, expr: any): QueryBuilder<M, R, X> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R, X> |
QueryBuilder.andWhereLike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.clearContext | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.havingExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.orHavingNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.orWhereILike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.orWhereNotIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.whereBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.whereNotNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.whereWrapped | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.andWhereILike | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const O extends Operator = string>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: O, expr: any): QueryBuilder<M, R, X> | <QBP extends Quer… |
QueryBuilder.countDistinct | (column?: any, options?: { as: string; } | undefined): QueryBuilder<M, R> | (aliasToColumnDict: { [alias: string]: string | string[]; }): QueryBuilder<M, R> | (...columns: any[]): QueryBuilder<M, R> | (column?: any, options?: { as: string; } | undefined): QueryBuilder<M, R, X> | (aliasToColumnDict: { [alias: string]: string | string[]; }): QueryBuilder<M, R, X> | (...columns: any[]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const A extends string… |
QueryBuilder.emptyInstance | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.fullOuterJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.havingBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.havingNotNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.havingWrapped | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> |
QueryBuilder.leftOuterJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.orHavingNotIn | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, expr: any): QueryBuilder<M, R, X> | (col: any, expr: readonly any[]): QueryBuilder<M, R, X> | (… |
QueryBuilder.orWhereColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.orWhereExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.patchAndFetch | (update: PartialModelObject<M>): QueryBuilder<M, M> | (update: PartialModelPatch<M>): QueryBuilder<M, M, unknown> |
QueryBuilder.whereJsonPath | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, jsonPath: string, operator: string, value: any): QueryBuilder<M, R, X> | (col: any, jsonPath: s… |
QueryBuilder.withRecursive | (alias: string, expr: any): QueryBuilder<M, R> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R> | (alias: string, expr: any): QueryBuilder<M, R, X> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R, X> |
QueryBuilder.andWhereColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.clearWithGraph | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.forNoKeyUpdate | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.insertAndFetch | (insert: PartialModelObject<M>): QueryBuilder<M, M> | (insert: PartialModelObject<M>[]): QueryBuilder<M, M[]> | (): QueryBuilder<M, M> | (insert: PartialModelRow<M>): QueryBuilder<M, M, unknown> | (insert: PartialModelRow<M>[]): QueryBuilder<M, M[], unknown> | (): QueryBuilder<M, M, unknown> |
QueryBuilder.orHavingExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.orWhereBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.orWhereNotNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.rightOuterJoin | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R> | (table: any, raw:… | (table: any, leftCol: any, op: string, rightCol: any): QueryBuilder<M, R, X> | (table: any, leftCol: any, rightCol: any): QueryBuilder<M, R, X> | (table: any, cb: CallbackVoid<Knex.JoinClause>): QueryBuilder<M, R, X> | (table: any, columns: { [leftCol: string]: any; }): QueryBuilder<M, R, X> | (tabl… |
QueryBuilder.updateAndFetch | (update: PartialModelObject<M>): QueryBuilder<M, M> | (update: PartialModelRow<M>): QueryBuilder<M, M, unknown> |
QueryBuilder.whereComposite | (column: any[], op: string, expr: readonly any[]): QueryBuilder<M, R> | (column: any, expr: any): QueryBuilder<M, R> | (column: any, op: string, expr: any): QueryBuilder<M, R> | (column: any[], expr: readonly any[]): QueryBuilder<M, R> | (column: any[], qb: AnyQueryBuilder): QueryBuilder<M, R> | (column: any[], op: string, expr: readonly any[]): QueryBuilder<M, R, X> | (column: any, expr: any): QueryBuilder<M, R, X> | (column: any, op: string, expr: any): QueryBuilder<M, R, X> | (column: any[], expr: readonly any[]): QueryBuilder<M, R, X> | (column: any[], qb: AnyQueryBuilder): QueryBuilder… |
QueryBuilder.whereNotColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.whereNotExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.andWhereBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.clearAllowGraph | (): QueryBuilder<M, R> | (): QueryBuilder<M, R, X> |
QueryBuilder.havingNotExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.leftJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.orHavingBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.orHavingNotNull | (column: any): QueryBuilder<M, R> | (column: any): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonPath | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, jsonPath: string, operator: string, value: any): QueryBuilder<M, R, X> | (col: any, jsonPath: s… |
QueryBuilder.throwIfNotFound | (arg?: any): R extends Model | undefined ? QueryBuilder<M, M> : QueryBuilder<M, R> | (arg?: any): R extends Model | undefined ? QueryBuilder<M, M, unknown> : QueryBuilder<M, R, X> |
QueryBuilder.whereJsonHasAll | (fieldExpression: string, keys: string | string[]): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, keys: string | string[]): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonHasAny | (fieldExpression: string, keys: string | string[]): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, keys: string | string[]): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.whereNotBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.withGraphJoined | <const E extends RelationExpression<M>>(expr: E, options?: GraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R>, ParseRelationExpression<E>> | <const E extends RelationExpression<M>>(expr: E, options?: GraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R, X>, ParseRelationExpression<E>> |
QueryBuilder.andWhereJsonPath | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, jsonPath: string, operator: string, value: any): QueryBuilder<M, R, X> | (col: any, jsonPath: s… |
QueryBuilder.havingNotBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.innerJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.orWhereNotColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.orWhereNotExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.outerJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.rightJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.whereInComposite | (column: any, expr: readonly any[]): QueryBuilder<M, R> | (column: any, qb: AnyQueryBuilder): QueryBuilder<M, R> | (column: any[], expr: readonly any[][]): QueryBuilder<M, R> | (column: any[], qb: AnyQueryBuilder): QueryBuilder<M, R> | (column: any, expr: readonly any[]): QueryBuilder<M, R, X> | (column: any, qb: AnyQueryBuilder): QueryBuilder<M, R, X> | (column: any[], expr: readonly any[][]): QueryBuilder<M, R, X> | (column: any[], qb: AnyQueryBuilder): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends … |
QueryBuilder.whereJsonIsArray | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.withGraphFetched | <const E extends RelationExpression<M>>(expr: E, options?: GraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R>, ParseRelationExpression<E>> | <const E extends RelationExpression<M>>(expr: E, options?: GraphOptions | undefined): WithGraphTreeQueryBuilder<QueryBuilder<M, R, X>, ParseRelationExpression<E>> |
QueryBuilder.withMaterialized | (alias: string, expr: any): QueryBuilder<M, R> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R> | (alias: string, expr: any): QueryBuilder<M, R, X> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R, X> |
QueryBuilder.andWhereNotColumn | <QBP extends QueryBuilder<M, R>>(col1: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof… | <QBP extends QueryBuilder<M, R, X>, const C extends string = never, const D extends string = never>(col1: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, op: string, col2: any): QueryBuilder<M, R, X> | <QBP extends Q… |
QueryBuilder.orHavingNotExists | (cb: CallbackVoid<QueryBuilder<M, R>>): QueryBuilder<M, R> | (raw: any): QueryBuilder<M, R> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R> | (cb: CallbackVoid<QueryBuilder<M, R, X>>): QueryBuilder<M, R, X> | (raw: any): QueryBuilder<M, R, X> | <QBA extends AnyQueryBuilder>(qb: QBA): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonHasAll | (fieldExpression: string, keys: string | string[]): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, keys: string | string[]): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonHasAny | (fieldExpression: string, keys: string | string[]): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, keys: string | string[]): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.orWhereNotBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.patchAndFetchById | (id: any, update: PartialModelObject<M>): QueryBuilder<M, M> | (id: any, update: PartialModelPatch<M>): QueryBuilder<M, M, unknown> |
QueryBuilder.whereJsonIsObject | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonNotArray | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.andWhereJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.andWhereNotBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.orHavingNotBetween | (column: any, range: [any, any]): QueryBuilder<M, R> | (column: any, range: [any, any]): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(column: never, range: [any, any]): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonIsArray | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.updateAndFetchById | (id: any, update: PartialModelObject<M>): QueryBuilder<M, M> | (id: any, update: PartialModelRow<M>): QueryBuilder<M, M, unknown> |
QueryBuilder.whereJsonNotObject | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.whereNotJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonIsObject | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonNotArray | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.whereNotInComposite | (column: any, expr: readonly any[]): QueryBuilder<M, R> | (column: any, qb: AnyQueryBuilder): QueryBuilder<M, R> | (column: any[], expr: readonly any[][]): QueryBuilder<M, R> | (column: any[], qb: AnyQueryBuilder): QueryBuilder<M, R> | (column: any, expr: readonly any[]): QueryBuilder<M, R, X> | (column: any, qb: AnyQueryBuilder): QueryBuilder<M, R, X> | (column: any[], expr: readonly any[][]): QueryBuilder<M, R, X> | (column: any[], qb: AnyQueryBuilder): QueryBuilder<M, R, X> | <QBP extends QueryBuilder<M, R, X>, const C extends … |
QueryBuilder.withNotMaterialized | (alias: string, expr: any): QueryBuilder<M, R> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R> | (alias: string, expr: any): QueryBuilder<M, R, X> | (alias: string, columns: string[], expr: any): QueryBuilder<M, R, X> |
QueryBuilder.andWhereJsonSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.fullOuterJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.leftOuterJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonNotObject | (fieldExpression: string): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string): QueryBuilder<M, R, X> |
QueryBuilder.orWhereNotJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonNotSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.andWhereNotJsonObject | <QBP extends QueryBuilder<M, R>>(col: Exclude<{ [K in keyof ModelType<QBP>]?: (Exclude<ModelType<QBP>[K], undefined> extends Model ? never : Exclude<ModelType<QBP>[K], undefined> extends (infer I)[] ? I extends Model ? never : K : ModelType<QBP>[K] extends Function ? never : K) | undefined; }[keyof … | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(col: Exclude<Exclude<NonFunctionPropertyNames<ModelType<QBP>>, ModelTypeMembers | `$${string}`>, RelationPropertyNames<ModelType<QBP>>>, value: any): QueryBuilder<M, R, X> | (col: any, value: any): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.rightOuterJoinRelated | (expr: RelationExpression<M>, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const E extends RelationExpression<ModelType<QBP>> = never>(expr: E, opt?: JoinRelatedOptions | undefined): QueryBuilder<M, R, X> |
QueryBuilder.andWhereJsonSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonNotSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.whereJsonNotSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.andWhereJsonNotSubsetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.orWhereJsonNotSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
QueryBuilder.andWhereJsonNotSupersetOf | (fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R> | <QBP extends QueryBuilder<M, R, X>, const C extends string = never>(fieldExpression: string, jsonObjectOrFieldExpression: JsonObjectOrFieldExpression): QueryBuilder<M, R, X> |
ColumnNameMappers.format | (json: Pojo): Pojo | (json: Pojo, isFieldExpression?: ((key: string) => boolean) | undefined): Pojo |
StaticHookArguments.result | R | undefined | R |
Mới bị ngừng hỗ trợ
Không phát hiện.
Thay đổi yêu cầu (engines, phụ thuộc peer)
| Trước | Sau | |
|---|---|---|
engines.node | >=14.0.0 | ^20.19.0 || >=22.12.0 |
peerDependencies.knex | >=2.3.0 <4 | ^3.3.0 |
peerDependencies.typescript | — | >=5.8 |
Export mới (23)
| import | export | kind |
|---|---|---|
objection | asArray | variable |
objection | ExtraType | type |
objection | FromModel | type |
objection | ModelJson | type |
objection | wrapError | function |
objection | ColumnName | type |
objection | QueryExtra | interface |
objection | TypeConfig | interface |
objection | JoinAliases | interface |
objection | SelectedBrand | type |
objection | ExtractedBrand | type |
objection | FromJSONSchema | type |
objection | AsArrayFunction | interface |
objection | PartialModelRow | type |
objection | ReturningWrites | interface |
objection | WhereLikeMethod | interface |
objection | JsonColumnFormat | type |
objection | ModifyJoinMethod | interface |
objection | ClearSelectMethod | interface |
objection | PartialModelPatch | type |
objection | ReadonlyJSONSchema | type |
objection | DatabaseJsonOptions | interface |
objection | BelongsToManyRelationType | interface |
Cung cấp dữ liệu này cho tác tử AI của bạn
Vigia là máy chủ MCP miễn phí: tác tử lập trình của bạn kiểm tra phiên bản, thay đổi phá vỡ tương thích và lỗ hổng trước khi viết mã. Không cần đăng ký, không cần khóa API.
claude mcp add --transport http vigia https://vigia.coredls.cloud/mcp
Thêm vào CursorThêm vào VS Code★ Gắn sao trên GitHub
Mọi ứng dụng MCP khác
{ "mcpServers": { "vigia": { "url": "https://vigia.coredls.cloud/mcp" } } }Kỹ năng cho tác tử (SKILL.md): cho tác tử biết khi nào dùng Vigia · GitHub Action cho pull request
Câu hỏi thường gặp
Nâng cấp objection từ 3 lên 4 có những thay đổi không tương thích nào?
Giữa objection 3.9.1 và 4.0.0, Vigia tìm thấy 24 export bị xóa, 28 chữ ký thay đổi và 263 thành viên lớp hoặc interface bị xóa hay thay đổi.
Những gì bị ngừng hỗ trợ trong objection 4?
0 export hoặc thành viên mới bị đánh dấu ngừng hỗ trợ trong objection 4.0.0.
Dành cho tác tử
GET https://vigia.coredls.cloud/v1/packages/npm/objection/upgrade?from=3.9.1&to=4.0.0