Memperbarui objection dari 3.x ke 4.x
Perbandingan API publik objection 3.9.1 dan 4.0.0, dihitung otomatis dari tipe TypeScript-nya. Tanda tangan yang berubah adalah kemungkinan perubahan tidak kompatibel, bukan kepastian.
Ringkasan
| Jalur impor yang dihapus | 0 |
|---|---|
| Ekspor yang dihapus | 24 |
| Tanda tangan yang berubah | 28 |
| Anggota kelas atau antarmuka yang dihapus | 7 |
| Anggota kelas atau antarmuka yang berubah | 256 |
| Baru ditandai usang | 0 |
| Perubahan persyaratan (engines, dependensi peer) | 3 |
| Ekspor baru | 23 |
Ekspor yang dihapus
| import | export | kind | Sebelum |
|---|---|---|---|
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] |
Tanda tangan yang berubah
| export | Sebelum | Sesudah |
|---|---|---|
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 |
Anggota kelas atau antarmuka yang dihapus
| member | import | Sebelum |
|---|---|---|
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 |
Anggota kelas atau antarmuka yang berubah
| member | Sebelum | Sesudah |
|---|---|---|
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 |
Baru ditandai usang
Tidak ada yang terdeteksi.
Perubahan persyaratan (engines, dependensi peer)
| Sebelum | Sesudah | |
|---|---|---|
engines.node | >=14.0.0 | ^20.19.0 || >=22.12.0 |
peerDependencies.knex | >=2.3.0 <4 | ^3.3.0 |
peerDependencies.typescript | — | >=5.8 |
Ekspor baru (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 |
Berikan fakta ini ke agen AI Anda
Vigia adalah server MCP gratis: agen coding Anda memeriksa versi, perubahan yang merusak kompatibilitas, dan kerentanan sebelum menulis kode. Tanpa pendaftaran, tanpa kunci API.
claude mcp add --transport http vigia https://vigia.coredls.cloud/mcp
Tambahkan ke CursorTambahkan ke VS Code★ Bintang di GitHub
Klien MCP lainnya
{ "mcpServers": { "vigia": { "url": "https://vigia.coredls.cloud/mcp" } } }Skill agen (SKILL.md): memberi tahu agen kapan memakai Vigia · GitHub Action untuk pull request
Pertanyaan umum
Apa saja perubahan tidak kompatibel saat memperbarui objection dari 3 ke 4?
Antara objection 3.9.1 dan 4.0.0, Vigia menemukan 24 ekspor yang dihapus, 28 tanda tangan yang berubah, dan 263 anggota kelas atau antarmuka yang dihapus atau berubah.
Apa yang ditandai usang di objection 4?
0 ekspor atau anggota baru ditandai usang di objection 4.0.0.
Untuk agen
GET https://vigia.coredls.cloud/v1/packages/npm/objection/upgrade?from=3.9.1&to=4.0.0