Interface SQLBuilderConditionsPort

interface SQLBuilderConditionsPort {
    add(
        conjunction: SQLBuilderConditionConjunction,
        ...args: SQLBuilderConditionInputPattern,
    ): SQLBuilderConditionsPort;
    and(...args: SQLBuilderConditionInputPattern): SQLBuilderConditionsPort;
    or(...args: SQLBuilderConditionInputPattern): SQLBuilderConditionsPort;
    toSQL(
        input?: SQLBuilderToSQLInputOptions,
    ): [null | string, SQLBuilderBindingValue[]];
}

Implemented by

SQLBuilderConditions

Index

Methods

add and or toSQL

Methods

add

add(
conjunction: SQLBuilderConditionConjunction,
...args: SQLBuilderConditionInputPattern,
): SQLBuilderConditionsPort
Parameters
- conjunction: SQLBuilderConditionConjunction
- ...args: SQLBuilderConditionInputPattern
Returns SQLBuilderConditionsPort
- Defined in types.ts:142

and

and(...args: SQLBuilderConditionInputPattern): SQLBuilderConditionsPort

Add and condition.

conditions
  .and('gender', 'male')
  .and('age', '>= ', 20)
// sql: (`gender` = ?) AND (`age` >= ?)
// bindings: ['male', 20]

Parameters

...args: SQLBuilderConditionInputPattern

Returns SQLBuilderConditionsPort

or

or(...args: SQLBuilderConditionInputPattern): SQLBuilderConditionsPort

Add or condition.

conditions
 .and('gender', 'male')
 .or('age', '>=', 20)
// sql: (`gender` = ?) OR (`age` >= ?)
// bindings: ['male', 20]

Parameters

...args: SQLBuilderConditionInputPattern

Returns SQLBuilderConditionsPort

toSQL

toSQL(
input?: SQLBuilderToSQLInputOptions,
): [null | string, SQLBuilderBindingValue[]]
Generate SQL and Binding Values.
```
const [sql, bindings] = conditions.toSQL()
```
Parameters
- Optionalinput: SQLBuilderToSQLInputOptions
Returns [null | string, SQLBuilderBindingValue[]]
- Defined in types.ts:155