Class OINODbSqlOrder

Class for ordering select results on a number of columns.

Index

Constructors

Methods

isEmpty toSql parse

Constructors

constructor

new OINODbSqlOrder(
column_or_array: string | string[],
descending_or_array: boolean | boolean[],
): OINODbSqlOrder
Constructor for OINODbSqlOrder.
Parameters
- column_or_array: string | string[]
  single or array of columns to order on
- descending_or_array: boolean | boolean[]
  single or array of booleans if ordes is descending
Returns OINODbSqlOrder
- Defined in db/src/OINODbSqlParams.ts:202

Methods

isEmpty

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

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

toSql

toSql(dataModel: OINODbDataModel): string
Print order 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:257

`Static`parse

parse(orderString: string): OINODbSqlOrder
Constructor for OINODbSqlOrder as parser of http parameter.

Supports comma separated list of column orders formatted as :
- column - order by column in ascending order
- column ASC|DESC - order by single either ascending or descending order
- column+|- - order by single either ascending or descending order
Parameters
- orderString: string
  string representation of order from HTTP-request
Returns OINODbSqlOrder
- Defined in db/src/OINODbSqlParams.ts:226