Class WhereSqlBuilder

Constructors

constructor

new WhereSqlBuilder(dialect: AbstractDialect): WhereSqlBuilder
Parameters
- dialect: AbstractDialect
Returns WhereSqlBuilder
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:117

Methods

[allKeysExist]

"[allKeysExist]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:706

[anyKeyExists]

"[anyKeyExists]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:684

`Protected`[between]

"[between]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:424

`Protected`[contained]

"[contained]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:480

`Protected`[contains]

"[contains]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:451

`Protected`[endsWith]

"[endsWith]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:556

`Protected`[in]

"[in]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:353

`Protected`[is]

"[is]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:395

`Protected`[isNot]

"[isNot]"(
    ...args: [
        left: unknown,
        leftDataType: NormalizedDataType,
        operator: symbol,
        right: unknown,
        rightDataType: NormalizedDataType,
        options: FormatWhereOptions,
    ],
): string
Parameters
- ...args: [
      left: unknown,
      leftDataType: NormalizedDataType,
      operator: symbol,
      right: unknown,
      rightDataType: NormalizedDataType,
      options: FormatWhereOptions,
  ]
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:391

`Protected`[notBetween]

"[notBetween]"(
    ...args: [
        left: unknown,
        leftDataType: NormalizedDataType,
        operator: symbol,
        right: unknown,
        rightDataType: NormalizedDataType,
        options: FormatWhereOptions,
    ],
): string
Parameters
- ...args: [
      left: unknown,
      leftDataType: NormalizedDataType,
      operator: symbol,
      right: unknown,
      rightDataType: NormalizedDataType,
      options: FormatWhereOptions,
  ]
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:420

`Protected`[notEndsWith]

"[notEndsWith]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:576

`Protected`[notIn]

"[notIn]"(
    ...args: [
        left: unknown,
        leftDataType: NormalizedDataType,
        operator: symbol,
        right: unknown,
        rightDataType: NormalizedDataType,
        options: FormatWhereOptions,
    ],
): string
Parameters
- ...args: [
      left: unknown,
      leftDataType: NormalizedDataType,
      operator: symbol,
      right: unknown,
      rightDataType: NormalizedDataType,
      options: FormatWhereOptions,
  ]
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:349

`Protected`[notStartsWith]

"[notStartsWith]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:536

`Protected`[notSubstring]

"[notSubstring]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:616

`Protected`[startsWith]

"[startsWith]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:516

`Protected`[substring]

"[substring]"(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:596

`Protected`formatBinaryOperation

formatBinaryOperation(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:728

formatPojoWhere

formatPojoWhere(pojoWhere: PojoWhere, options?: FormatWhereOptions): string
This method is responsible for transforming a group "left operand" + "operators, right operands" (multiple) into a SQL string.
Parameters
- pojoWhere: PojoWhere
  The representation of the group.
- options: FormatWhereOptions = EMPTY_OBJECT
  Option bag.
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:270

`Protected`formatSubstring

formatSubstring(
    left: unknown,
    leftDataType: undefined | NormalizedDataType,
    operator: symbol,
    right: unknown,
    rightDataType: undefined | NormalizedDataType,
    options: FormatWhereOptions,
    start: boolean,
    end: boolean,
): string
Parameters
- left: unknown
- leftDataType: undefined | NormalizedDataType
- operator: symbol
- right: unknown
- rightDataType: undefined | NormalizedDataType
- options: FormatWhereOptions
- start: boolean
- end: boolean
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:636

formatWhereOptions

formatWhereOptions(where: WhereOptions, options?: FormatWhereOptions): string
Transforms any value accepted by WhereOptions into a SQL string.
Parameters
- where: WhereOptions
- options: FormatWhereOptions = EMPTY_OBJECT
Returns string
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:143

setOperatorKeyword

setOperatorKeyword(op: symbol, keyword: string): void
Parameters
- op: symbol
- keyword: string
Returns void
- Defined in packages/core/src/abstract-dialect/where-sql-builder.ts:133

Class WhereSqlBuilder

Index

Constructors

Methods

Constructors

constructor

Parameters

Returns WhereSqlBuilder

Methods

[allKeysExist]

Parameters

Returns string

[anyKeyExists]

Parameters

Returns string

Protected[between]

Parameters

Returns string

Protected[contained]

Parameters

Returns string

Protected[contains]

Parameters

Returns string

Protected[endsWith]

Parameters

Returns string

Protected[in]

Parameters

Returns string

Protected[is]

Parameters

Returns string

Protected[isNot]

Parameters

Returns string

Protected[notBetween]

Parameters

Returns string

Protected[notEndsWith]

Parameters

Returns string

Protected[notIn]

Parameters

Returns string

Protected[notStartsWith]

Parameters

Returns string

Protected[notSubstring]

Parameters

Returns string

Protected[startsWith]

Parameters

Returns string

Protected[substring]

Parameters

Returns string

ProtectedformatBinaryOperation

Parameters

Returns string

formatPojoWhere

Parameters

Returns string

ProtectedformatSubstring

Parameters

Returns string

formatWhereOptions

Parameters

Returns string

setOperatorKeyword

Parameters

Returns void

Settings

On This Page

`Protected`[between]

`Protected`[contained]

`Protected`[contains]

`Protected`[endsWith]

`Protected`[in]

`Protected`[is]

`Protected`[isNot]

`Protected`[notBetween]

`Protected`[notEndsWith]

`Protected`[notIn]

`Protected`[notStartsWith]

`Protected`[notSubstring]

`Protected`[startsWith]

`Protected`[substring]

`Protected`formatBinaryOperation

`Protected`formatSubstring