Class MySQLSqlBuilder

Compiles Toshihiko query structures into MySQL statements.

compile* methods return parameterized SQL plus placeholder values. make* methods format those statements into strings for compatibility and logging.

Constructors

constructor

new MySQLSqlBuilder(): MySQLSqlBuilder

Returns MySQLSqlBuilder

Methods

compileArrayWhere

compileArrayWhere(
    model: MySQLModel,
    condition: readonly Readonly<Record<string, DataValue>>[],
    logic?: string,
): MySQLStatement
Compiles an array of condition objects joined with AND or OR.
Parameters
- model: MySQLModel
- condition: readonly Readonly<Record<string, DataValue>>[]
- logic: string = 'AND'
Returns MySQLStatement
- Defined in mysql-adapter/src/sql-builder.ts:122

compileDelete

compileDelete(model: MySQLModel, options?: MySQLQueryOptions): MySQLStatement
Compiles a parameterized DELETE statement.
Parameters
- model: MySQLModel
- options: MySQLQueryOptions = {}
Returns MySQLStatement
- Defined in mysql-adapter/src/sql-builder.ts:384

compileFieldWhere

compileFieldWhere(
    model: MySQLModel,
    key: string,
    condition: DataValue,
    logic?: string,
): MySQLStatement
Compiles one logical field condition.
Parameters
- model: MySQLModel
- key: string
- condition: DataValue
- logic: string = 'AND'
Returns MySQLStatement
- Defined in mysql-adapter/src/sql-builder.ts:53

compileFind

compileFind(model: MySQLModel, options?: MySQLQueryOptions): MySQLStatement
Compiles a parameterized SELECT statement.
Parameters
- model: MySQLModel
- options: MySQLQueryOptions = {}
Returns MySQLStatement
- Defined in mysql-adapter/src/sql-builder.ts:310

compileSet

compileSet(model: MySQLModel, update: DataRow): MySQLStatement
Compiles logical update values into parameterized assignments.
Parameters
- model: MySQLModel
- update: DataRow
Returns MySQLStatement
- Defined in mysql-adapter/src/sql-builder.ts:264

compileSql

compileSql(
    type: string,
    model: MySQLModel,
    options?: MySQLQueryOptions,
): MySQLStatement
Compiles the parameterized statement selected by an operation name.
Parameters
- type: string
- model: MySQLModel
- options: MySQLQueryOptions = {}
Returns MySQLStatement
- Defined in mysql-adapter/src/sql-builder.ts:425

compileUpdate

compileUpdate(model: MySQLModel, options?: MySQLQueryOptions): MySQLStatement
Compiles a parameterized UPDATE statement.
Parameters
- model: MySQLModel
- options: MySQLQueryOptions = {}
Returns MySQLStatement
- Defined in mysql-adapter/src/sql-builder.ts:349

compileValue

compileValue(field: MySQLField, value: DataValue): MySQLStatement
Restores one application value and produces a placeholder statement.
Parameters
- field: MySQLField
- value: DataValue
Returns MySQLStatement
- Defined in mysql-adapter/src/sql-builder.ts:289

compileWhere

compileWhere(
    model: MySQLModel,
    condition:
        | Readonly<Record<string, DataValue>>
        | readonly Readonly<Record<string, DataValue>>[],
    logic?: string,
): MySQLStatement
Recursively compiles a complete Toshihiko condition.
Parameters
- model: MySQLModel
- condition:
  | Readonly<Record<string, DataValue>>
  | readonly Readonly<Record<string, DataValue>>[]
- logic: string = 'AND'
Returns MySQLStatement
- Defined in mysql-adapter/src/sql-builder.ts:157

makeArrayWhere

makeArrayWhere(
    model: MySQLModel,
    condition: readonly Readonly<Record<string, DataValue>>[],
    logic?: string,
): string
Formats an array of condition objects as SQL text.
Parameters
- model: MySQLModel
- condition: readonly Readonly<Record<string, DataValue>>[]
- logic: string = 'AND'
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:144

makeDelete

makeDelete(model: MySQLModel, options?: MySQLQueryOptions): string
Formats a complete DELETE statement.
Parameters
- model: MySQLModel
- options: MySQLQueryOptions = {}
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:375

makeFieldWhere

makeFieldWhere(
    model: MySQLModel,
    key: string,
    condition: DataValue,
    logic?: string,
): string
Formats one logical field condition as SQL text.
Parameters
- model: MySQLModel
- key: string
- condition: DataValue
- logic: string = 'AND'
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:108

makeFind

makeFind(model: MySQLModel, options?: MySQLQueryOptions): string
Formats a complete SELECT statement.
Parameters
- model: MySQLModel
- options: MySQLQueryOptions = {}
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:301

makeIndex

makeIndex(_model: MySQLModel, index?: string): string
Formats an optional quoted FORCE INDEX clause.
Parameters
- _model: MySQLModel
- Optionalindex: string
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:243

makeLimit

makeLimit(_model: MySQLModel, limit: readonly (string | number)[]): string
Formats one or two normalized values as a MySQL limit body.
Parameters
- _model: MySQLModel
- limit: readonly (string | number)[]
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:231

makeOrder

makeOrder(
model: MySQLModel,
order: readonly Readonly<Record<string, number>>[],
): string
Formats normalized order entries with quoted storage column names.
Parameters
- model: MySQLModel
- order: readonly Readonly<Record<string, number>>[]
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:210

makeSet

makeSet(model: MySQLModel, update: DataRow): string
Formats logical update values as a SQL assignment list.
Parameters
- model: MySQLModel
- update: DataRow
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:252

makeSql

makeSql(type: string, model: MySQLModel, options?: MySQLQueryOptions): string
Formats the statement selected by an operation name.
Parameters
- type: string
- model: MySQLModel
- options: MySQLQueryOptions = {}
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:412

makeUpdate

makeUpdate(model: MySQLModel, options?: MySQLQueryOptions): string
Formats a complete UPDATE statement.
Parameters
- model: MySQLModel
- options: MySQLQueryOptions = {}
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:340

makeWhere

makeWhere(
    model: MySQLModel,
    condition:
        | Readonly<Record<string, DataValue>>
        | readonly Readonly<Record<string, DataValue>>[],
    logic?: string,
): string
Formats a complete Toshihiko condition as SQL text.
Parameters
- model: MySQLModel
- condition:
  | Readonly<Record<string, DataValue>>
  | readonly Readonly<Record<string, DataValue>>[]
- logic: string = 'AND'
Returns string
- Defined in mysql-adapter/src/sql-builder.ts:197

Class MySQLSqlBuilder

Index

Constructors

Methods

Constructors

constructor

Returns MySQLSqlBuilder

Methods

compileArrayWhere

Parameters

Returns MySQLStatement

compileDelete

Parameters

Returns MySQLStatement

compileFieldWhere

Parameters

Returns MySQLStatement

compileFind

Parameters

Returns MySQLStatement

compileSet

Parameters

Returns MySQLStatement

compileSql

Parameters

Returns MySQLStatement

compileUpdate

Parameters

Returns MySQLStatement

compileValue

Parameters

Returns MySQLStatement

compileWhere

Parameters

Returns MySQLStatement

makeArrayWhere

Parameters

Returns string

makeDelete

Parameters

Returns string

makeFieldWhere

Parameters

Returns string

makeFind

Parameters

Returns string

makeIndex

Parameters

Returns string

makeLimit

Parameters

Returns string

makeOrder

Parameters

Returns string

makeSet

Parameters

Returns string

makeSql

Parameters

Returns string

makeUpdate

Parameters

Returns string

makeWhere

Parameters

Returns string

Settings

On This Page