Options
All
  • Public
  • Public/Protected
  • All
Menu

Class ConditionBuilder

Used for building conditions. The conditions can be used with WHERE and ON clauses.

Hierarchy

  • ConditionBuilder

Index

Methods

aggregateComp

and

comp

  • A comparison operation.

    Parameters

    • op: string

      The comparison operator, as a string: $eq, $neq, $lt, $lte, $gt, $gte, $like, $notLike, $is, $isnt.

    • prop: string

      The name of a fully-qualified property in a query in the form <table-alias>.<property>.

    • propOrParamName: string

      Either a fully-qualified property, or a parameter name preceded by a colon (e.g. :someParameter).

    • Optional param: any

      A replacement value if propOrParamName is a parameter name.

    Returns ParameterizedCondition

eq

gt

gte

in

inComp

  • inComp(op: string, prop: string, propsOrParamBaseName: string | string[], params?: any[]): ParameterizedCondition
  • A IN (IN or NOT IN) comparison operation.

    Parameters

    • op: string

      The comparison operator, as a string: $in, $notIn.

    • prop: string

      The name of a fully-qualified property in a query in the form <table-alias>.<property>.

    • propsOrParamBaseName: string | string[]

      Either a fully-qualified property, or a parameter name preceded by a colon (e.g. :someParameter). If a parameter name is provided, it's used a base name. Each property is parameterized, and the parameter names are suffixed with _# (e.g. :param_0, :param_1, ..., :param_n).

    • Optional params: any[]

      An array of replacement values if propOrParamName is a parameter name.

    Returns ParameterizedCondition

isNotNull

isNull

like

lt

lte

neq

notIn

notLike

or

Generated using TypeDoc