Class UpdateBuilder

UpdateBuilder class for building UPDATE queries

Index

Constructors

Methods

build buildPartial buildWithOperations buildBatch

Constructors

constructor

new UpdateBuilder(options?: UpdateBuilderOptions): UpdateBuilder
Parameters
- options: UpdateBuilderOptions = {}
Returns UpdateBuilder
- Defined in query-builders/update-builder.ts:30

Methods

build

build(
    tableName: string,
    values: Record<string, unknown>,
    where: WhereOptions,
): UpdateQueryResult
Build an UPDATE query
Parameters
- tableName: string
- values: Record<string, unknown>
- where: WhereOptions
Returns UpdateQueryResult
- Defined in query-builders/update-builder.ts:40

buildPartial

buildPartial(
    tableName: string,
    values: Record<string, unknown>,
    where: WhereOptions,
    fields?: string[],
): UpdateQueryResult
Build a partial UPDATE query (only specified fields)
Parameters
- tableName: string
- values: Record<string, unknown>
- where: WhereOptions
- Optionalfields: string[]
Returns UpdateQueryResult
- Defined in query-builders/update-builder.ts:95

buildWithOperations

buildWithOperations(
    tableName: string,
    operations: Record<
        string,
        { op: "+"
        | "-"
        | "*"
        | "/"
        | "SET"; value: number },
    >,
    where: WhereOptions,
): UpdateQueryResult
Build an UPDATE query with increment/decrement operations
Parameters
- tableName: string
- operations: Record<string, { op: "+" | "-" | "*" | "/" | "SET"; value: number }>
- where: WhereOptions
Returns UpdateQueryResult
- Defined in query-builders/update-builder.ts:119

buildBatch

buildBatch(
tableName: string,
records: { values: Record<string, unknown>; where: WhereOptions }[],
): UpdateQueryResult[]
Build a batch UPDATE query (for bulk updates)
Parameters
- tableName: string
- records: { values: Record<string, unknown>; where: WhereOptions }[]
Returns UpdateQueryResult[]
- Defined in query-builders/update-builder.ts:175