Class OINODbSqlFilter

Class for recursively parsing of filters and printing them as SQL conditions. Supports three types of statements

comparison: (field)-lt|le|eq|ge|gt|like(value)
negation: -not(filter)
conjunction/disjunction: (filter)-and|or(filter) Supported conditions are comparisons (<, <=, =, >=, >) and substring match (LIKE).

Index

Constructors

Methods

isEmpty toSql combine parse

Constructors

constructor

new OINODbSqlFilter(
    leftSide: string | OINODbSqlFilter,
    operation: OINODbSqlBooleanOperation | OINODbSqlComparison,
    rightSide: string | OINODbSqlFilter,
): OINODbSqlFilter
Constructor of OINODbSqlFilter
Parameters
- leftSide: string | OINODbSqlFilter
  left side of the filter, either another filter or a column name
- operation: OINODbSqlBooleanOperation | OINODbSqlComparison
  operation of the filter, either OINODbSqlComparison or OINODbSqlBooleanOperation
- rightSide: string | OINODbSqlFilter
  right side of the filter, either another filter or a value
Returns OINODbSqlFilter
- Defined in db/src/OINODbSqlParams.ts:47

Methods

isEmpty

isEmpty(): boolean
Does filter contain any valid conditions.

Returns boolean
- Defined in db/src/OINODbSqlParams.ts:142

toSql

toSql(dataModel: OINODbDataModel): string
Print filter as SQL condition based on the datamodel of the API.
Parameters
- dataModel: OINODbDataModel
  data model (and database) to use for formatting of values
Returns string
- Defined in db/src/OINODbSqlParams.ts:152

`Static`combine

combine(
    leftSide: OINODbSqlFilter,
    operation: OINODbSqlBooleanOperation,
    rightSide: OINODbSqlFilter,
): OINODbSqlFilter
Construct a new OINODbSqlFilter as combination of (boolean and/or) of two filters.
Parameters
- leftSide: OINODbSqlFilter
  left side to combine
- operation: OINODbSqlBooleanOperation
  boolean operation to use in combination
- rightSide: OINODbSqlFilter
  right side to combine
Returns OINODbSqlFilter
- Defined in db/src/OINODbSqlParams.ts:107

`Static`parse

parse(filterString: string): OINODbSqlFilter
Constructor for OINODbSqlFilter as parser of http parameter.

Supports three types of statements:
- comparison: (field)-lt|le|eq|ge|gt|like(value)
- negation: -not(filter)
- conjunction/disjunction: (filter)-and|or(filter)
Parameters
- filterString: string
  string representation of filter from HTTP-request
Returns OINODbSqlFilter
- Defined in db/src/OINODbSqlParams.ts:73