Interface SQLBuilderConditionsPort

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

Methods

Add and condition.

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

Add or condition.

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

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:139