Class SqliteStrictEntityQueryBuilder<TInstance>

Type Parameters

TInstance extends object

Index

Constructors

Methods

whereColumn andWhereColumn orWhereColumn groupByColumns orderByColumn limit offset page pageSize toSQL all first allAsync firstAsync toQueryBuilder

Constructors

constructor

new SqliteStrictEntityQueryBuilder<TInstance extends object>(
    builder: SqliteQueryBuilder,
    table: string,
    availableColumns: Set<string>,
    alias: string | undefined,
): SqliteStrictEntityQueryBuilder<TInstance>
Type Parameters
- TInstance extends object
Parameters
- builder: SqliteQueryBuilder
- table: string
- availableColumns: Set<string>
- alias: string | undefined
Returns SqliteStrictEntityQueryBuilder<TInstance>
- Defined in sqlite-adapter/sqlite-reflector.ts:2049

Methods

whereColumn

whereColumn(
    column: Extract<keyof TInstance, string>,
    operator?: "=" | "!=" | "<>" | "<" | "<=" | ">" | ">=" | "LIKE",
    value: QueryValue,
): this
Parameters
- column: Extract<keyof TInstance, string>
- operator: "=" | "!=" | "<>" | "<" | "<=" | ">" | ">=" | "LIKE" = "="
- value: QueryValue
Returns this
- Defined in sqlite-adapter/sqlite-reflector.ts:2056

andWhereColumn

andWhereColumn(
    column: Extract<keyof TInstance, string>,
    operator?: "=" | "!=" | "<>" | "<" | "<=" | ">" | ">=" | "LIKE",
    value: QueryValue,
): this
Parameters
- column: Extract<keyof TInstance, string>
- operator: "=" | "!=" | "<>" | "<" | "<=" | ">" | ">=" | "LIKE" = "="
- value: QueryValue
Returns this
- Defined in sqlite-adapter/sqlite-reflector.ts:2066

orWhereColumn

orWhereColumn(
    column: Extract<keyof TInstance, string>,
    operator?: "=" | "!=" | "<>" | "<" | "<=" | ">" | ">=" | "LIKE",
    value: QueryValue,
): this
Parameters
- column: Extract<keyof TInstance, string>
- operator: "=" | "!=" | "<>" | "<" | "<=" | ">" | ">=" | "LIKE" = "="
- value: QueryValue
Returns this
- Defined in sqlite-adapter/sqlite-reflector.ts:2076

groupByColumns

groupByColumns(columns: Extract<keyof TInstance, string>[]): this
Parameters
- columns: Extract<keyof TInstance, string>[]
Returns this
- Defined in sqlite-adapter/sqlite-reflector.ts:2086

orderByColumn

orderByColumn(
column: Extract<keyof TInstance, string>,
direction?: QueryOrderDirection,
): this
Parameters
- column: Extract<keyof TInstance, string>
- direction: QueryOrderDirection = "ASC"
Returns this
- Defined in sqlite-adapter/sqlite-reflector.ts:2095

limit

limit(value: number): this
Parameters
- value: number
Returns this
- Defined in sqlite-adapter/sqlite-reflector.ts:2100

offset

offset(value: number): this
Parameters
- value: number
Returns this
- Defined in sqlite-adapter/sqlite-reflector.ts:2105

pageSize

pageSize(value: number): this
Parameters
- value: number
Returns this
- Defined in sqlite-adapter/sqlite-reflector.ts:2115

toSQL

toSQL(): QueryBuildResult
Returns QueryBuildResult
- Defined in sqlite-adapter/sqlite-reflector.ts:2120

all

all<TRow extends Record<string, unknown> = Record<string, unknown>>(): TRow[]
Type Parameters
- TRow extends Record<string, unknown> = Record<string, unknown>
Returns TRow[]
- Defined in sqlite-adapter/sqlite-reflector.ts:2124

first

first<TRow extends Record<string, unknown> = Record<string, unknown>>():
| TRow
| undefined
Type Parameters
- TRow extends Record<string, unknown> = Record<string, unknown>
Returns TRow | undefined
- Defined in sqlite-adapter/sqlite-reflector.ts:2128

allAsync

allAsync<TRow extends Record<string, unknown> = Record<string, unknown>>(): Promise<
TRow[],
>
Type Parameters
- TRow extends Record<string, unknown> = Record<string, unknown>
Returns Promise<TRow[]>
- Defined in sqlite-adapter/sqlite-reflector.ts:2132

firstAsync

firstAsync<TRow extends Record<string, unknown> = Record<string, unknown>>(): Promise<
TRow
| undefined,
>
Type Parameters
- TRow extends Record<string, unknown> = Record<string, unknown>
Returns Promise<TRow | undefined>
- Defined in sqlite-adapter/sqlite-reflector.ts:2136

toQueryBuilder

toQueryBuilder(): SqliteQueryBuilder
Returns SqliteQueryBuilder
- Defined in sqlite-adapter/sqlite-reflector.ts:2140

Class SqliteStrictEntityQueryBuilder<TInstance>

Type Parameters

Index

Constructors

Methods

Constructors

constructor

Type Parameters

Parameters

Returns SqliteStrictEntityQueryBuilder<TInstance>

Methods

whereColumn

Parameters

Returns this

andWhereColumn

Parameters

Returns this

orWhereColumn

Parameters

Returns this

groupByColumns

Parameters

Returns this

orderByColumn

Parameters

Returns this

limit

Parameters

Returns this

offset

Parameters

Returns this

page

Parameters

Returns this

pageSize

Parameters

Returns this

toSQL

Returns QueryBuildResult

all

Type Parameters

Returns TRow[]

first

Type Parameters

Returns TRow | undefined

allAsync

Type Parameters

Returns Promise<TRow[]>

firstAsync

Type Parameters

Returns Promise<TRow | undefined>

toQueryBuilder

Returns SqliteQueryBuilder

Settings

On This Page