Class WhereSqlBuilder

Constructors

constructor

new WhereSqlBuilder(dialect: AbstractDialect): WhereSqlBuilder
Parameters
- dialect: AbstractDialect
Returns WhereSqlBuilder
- Defined in core/lib/abstract-dialect/where-sql-builder.d.ts:13

Methods

[allKeysExist]

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

[anyKeyExists]

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

`Protected`[between]

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

`Protected`[contained]

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

`Protected`[contains]

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

`Protected`[endsWith]

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

`Protected`[in]

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

`Protected`[is]

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

`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 core/lib/abstract-dialect/where-sql-builder.d.ts:31

`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 core/lib/abstract-dialect/where-sql-builder.d.ts:33

`Protected`[notEndsWith]

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

`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 core/lib/abstract-dialect/where-sql-builder.d.ts:29

`Protected`[notStartsWith]

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

`Protected`[notSubstring]

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

`Protected`[startsWith]

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

`Protected`[substring]

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

`Protected`formatBinaryOperation

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

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.
- Optionaloptions: FormatWhereOptions
  Option bag.
Returns string
- Defined in core/lib/abstract-dialect/where-sql-builder.d.ts:28

`Protected`formatSubstring

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

formatWhereOptions

formatWhereOptions(where: WhereOptions, options?: FormatWhereOptions): string
Transforms any value accepted by WhereOptions into a SQL string.
Parameters
- where: WhereOptions
- Optionaloptions: FormatWhereOptions
Returns string
- Defined in core/lib/abstract-dialect/where-sql-builder.d.ts:21

setOperatorKeyword

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

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