objection을(를) 3.x에서 4.x로 업그레이드하기
objection 3.9.1과 4.0.0의 공개 API를 TypeScript 타입에서 자동으로 비교한 결과입니다. 시그니처 변경은 호환성이 깨질 가능성이 있다는 뜻이며 확정은 아닙니다.
요약
| 삭제된 import 경로 | 0 |
|---|---|
| 삭제된 export | 24 |
| 변경된 시그니처 | 28 |
| 삭제된 클래스·인터페이스 멤버 | 7 |
| 변경된 클래스·인터페이스 멤버 | 256 |
| 새로 지원 중단됨 | 0 |
| 요구 사항 변경 (engines, peer 의존성) | 3 |
| 새 export | 23 |
삭제된 export
| import | export | kind | 이전 |
|---|---|---|---|
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] |
변경된 시그니처
| export | 이전 | 이후 |
|---|---|---|
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 |
삭제된 클래스·인터페이스 멤버
| member | import | 이전 |
|---|---|---|
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 |
변경된 클래스·인터페이스 멤버
| member | 이전 | 이후 |
|---|---|---|
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 |
새로 지원 중단됨
감지되지 않았습니다.
요구 사항 변경 (engines, peer 의존성)
| 이전 | 이후 | |
|---|---|---|
engines.node | >=14.0.0 | ^20.19.0 || >=22.12.0 |
peerDependencies.knex | >=2.3.0 <4 | ^3.3.0 |
peerDependencies.typescript | — | >=5.8 |
새 export (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 |
이 데이터를 AI 에이전트에 제공하세요
Vigia는 무료 MCP 서버입니다. 코딩 에이전트가 코드를 작성하기 전에 버전, 호환성을 깨는 변경, 취약점을 확인합니다. 가입도 API 키도 필요 없습니다.
claude mcp add --transport http vigia https://vigia.coredls.cloud/mcp
Cursor에 추가VS Code에 추가★ GitHub에서 스타 누르기
그 밖의 MCP 클라이언트
{ "mcpServers": { "vigia": { "url": "https://vigia.coredls.cloud/mcp" } } }에이전트 스킬(SKILL.md): 에이전트에게 Vigia를 언제 쓸지 알려 줍니다 · 풀 리퀘스트용 GitHub Action
자주 묻는 질문
objection을(를) 3에서 4(으)로 업그레이드할 때 호환성이 깨지는 변경은 무엇인가요?
objection 3.9.1과 4.0.0 사이에서 Vigia는 삭제된 export 24개, 변경된 시그니처 28개, 삭제되거나 변경된 클래스·인터페이스 멤버 263개를 찾았습니다.
objection 4에서 지원 중단된 것은 무엇인가요?
objection 4.0.0에서 export 또는 멤버 0개가 새로 지원 중단으로 표시되었습니다.
에이전트용
GET https://vigia.coredls.cloud/v1/packages/npm/objection/upgrade?from=3.9.1&to=4.0.0