Interface IQueryBuilder

The Query Builder interface for building queries for the IDatabaseTable.

interface IQueryBuilder {
    getQuery(): IDatabaseTableQuery;
    limit(limit): IQueryBuilder;
    offset(offset): IQueryBuilder;
    orderBy(order): IQueryBuilder;
    where(operator, value): IQueryBuilder;
    where(operator, value): IQueryBuilder;
    where(operator, value): IQueryBuilder;
}

Index

Methods

getQuery limit offset orderBy where

Methods

getQuery

getQuery(): IDatabaseTableQuery
Gets the query.

Returns IDatabaseTableQuery
The query: IDatabaseTableQuery.

limit

limit(limit): IQueryBuilder
Adds a limit to the query.
Parameters
- limit: number
  The limit for the query.
Returns IQueryBuilder
A QueryBuilder instance with a limit added.

Throws
an SDKClientError with the code SDKClientErrorCodes.QueryBuilderInvalidArgument if the limit is not a positive number.

offset

offset(offset): IQueryBuilder
Adds an offset to the query.
Parameters
- offset: number
  The offset for the query.
Returns IQueryBuilder
A QueryBuilder instance with an offset added.

Throws
an SDKClientError with the code SDKClientErrorCodes.QueryBuilderInvalidArgument and a descriptive message if the offset is not a positive number.

orderBy

orderBy(order): IQueryBuilder
Adds an order by clause to the query.
Parameters
- order: "asc" | "desc"
  The order for the order by clause, either 'asc' or 'desc'.
Returns IQueryBuilder
A QueryBuilder instance with an order by clause added.

Throws
an SDKClientError with the code SDKClientErrorCodes.QueryBuilderInvalidArgument if the order is not 'asc' or 'desc'.

where

where(operator, value): IQueryBuilder
A where clause with basic operators and a single value.
Parameters
- operator: "==" | "!=" | ">" | "<" | "<=" | ">="
  A basic operator.
- value: SupportedIndexType
  A single value.
Returns IQueryBuilder
A QueryBuilder instance with a where clause added.
where(operator, value): IQueryBuilder
A where clause with 'in' or 'not-in' the given values.
Parameters
- operator: "in" | "not-in"
  An 'in' or 'not-in' operator.
- value: SupportedIndexType[]
  An array of values.
Returns IQueryBuilder
A QueryBuilder instance with a where clause added.
where(operator, value): IQueryBuilder
A where clause with 'between' the given values.
Parameters
- operator: "between"
  A 'between' operator.
- value: [SupportedIndexType, SupportedIndexType]
  An array of two values.
Returns IQueryBuilder
A QueryBuilder instance with a where clause added.

Generated using TypeDoc