@reactor/data — postgrestfilterbuilder

@reactor/data

---

@reactor/data / PostgrestFilterBuilder

Class: PostgrestFilterBuilder<T, ResultType>

Defined in: builder.ts:22

PostgrestFilterBuilder provides methods for building filter queries.

Extended by

• PostgrestQueryBuilder

Type Parameters

T

T

ResultType

ResultType = T[]

Constructors

Constructor

new PostgrestFilterBuilder<T, ResultType>(ctx, table): PostgrestFilterBuilder<T, ResultType>

Defined in: builder.ts:39

Parameters

ctx

RequestContext

table

string

Returns

PostgrestFilterBuilder<T, ResultType>

Properties

body?

protected optional body?: unknown

Defined in: builder.ts:37

---

countMode?

protected optional countMode?: CountMode

Defined in: builder.ts:30

---

ctx

protected ctx: RequestContext

Defined in: builder.ts:24

---

customHeaders

protected customHeaders: Record<string, string> = {}

Defined in: builder.ts:32

---

explainMode?

protected optional explainMode?: object

Defined in: builder.ts:34

analyze?

optional analyze?: boolean

buffers?

optional buffers?: boolean

costs?

optional costs?: boolean

verbose?

optional verbose?: boolean

---

filters

protected filters: PendingFilter[] = []

Defined in: builder.ts:26

---

limitValue?

protected optional limitValue?: number

Defined in: builder.ts:28

---

method

protected method: "GET" | "POST" | "PATCH" | "DELETE" = 'GET'

Defined in: builder.ts:36

---

offsetValue?

protected optional offsetValue?: number

Defined in: builder.ts:29

---

orderClauses

protected orderClauses: string[] = []

Defined in: builder.ts:27

---

responseFormat

protected responseFormat: "json" | "csv" = 'json'

Defined in: builder.ts:33

---

resultModifier?

protected optional resultModifier?: "single" | "maybeSingle"

Defined in: builder.ts:35

---

selectColumns

protected selectColumns: string = '*'

Defined in: builder.ts:25

---

signalValue?

protected optional signalValue?: AbortSignal

Defined in: builder.ts:31

---

table

protected table: string

Defined in: builder.ts:23

Methods

abortSignal()

abortSignal(signal): this

Defined in: builder.ts:199

Provide an AbortSignal

Parameters

signal

AbortSignal

Returns

this

---

buildHeaders()

protected buildHeaders(): Record<string, string>

Defined in: builder.ts:264

Returns

Record<string, string>

---

buildUrl()

protected buildUrl(): string

Defined in: builder.ts:233

Returns

string

---

containedBy()

containedBy<K>(column, values): this

Defined in: builder.ts:111

Array contained by

Type Parameters

K

K extends string

Parameters

column

K

values

unknown[]

Returns

this

---

contains()

contains<K>(column, values): this

Defined in: builder.ts:105

Array contains

Type Parameters

K

K extends string

Parameters

column

K

values

unknown[]

Returns

this

---

csv()

csv(): PostgrestFilterBuilder<T, string>

Defined in: builder.ts:205

Return CSV instead of JSON

Returns

PostgrestFilterBuilder<T, string>

---

eq()

eq<K>(column, value): this

Defined in: builder.ts:45

Equal to

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

this

---

execute()

protected execute(): Promise<Result<unknown>>

Defined in: builder.ts:312

Returns

Promise<Result<unknown>>

---

explain()

explain(options?): this

Defined in: builder.ts:211

Return query execution plan

Parameters

options?

analyze?

boolean

buffers?

boolean

costs?

boolean

verbose?

boolean

Returns

this

---

filter()

filter<K>(column, operator, value): this

Defined in: builder.ts:154

Generic filter (escape hatch)

Type Parameters

K

K extends string

Parameters

column

K

operator

FilterOperator

value

FilterValue

Returns

this

---

gt()

gt<K>(column, value): this

Defined in: builder.ts:57

Greater than

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

this

---

gte()

gte<K>(column, value): this

Defined in: builder.ts:63

Greater than or equal

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

this

---

ilike()

ilike<K>(column, pattern): this

Defined in: builder.ts:87

Case-insensitive pattern match (ILIKE)

Type Parameters

K

K extends string

Parameters

column

K

pattern

string

Returns

this

---

in()

in<K>(column, values): this

Defined in: builder.ts:99

In list

Type Parameters

K

K extends string

Parameters

column

K

values

T[K][]

Returns

this

---

is()

is<K>(column, value): this

Defined in: builder.ts:93

Is NULL or boolean

Type Parameters

K

K extends string

Parameters

column

K

value

boolean | null

Returns

this

---

like()

like<K>(column, pattern): this

Defined in: builder.ts:81

Pattern match (LIKE)

Type Parameters

K

K extends string

Parameters

column

K

pattern

string

Returns

this

---

limit()

limit(count, options?): this

Defined in: builder.ts:177

Limit results

Parameters

count

number

options?

foreignTable?

string

Returns

this

---

lt()

lt<K>(column, value): this

Defined in: builder.ts:69

Less than

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

this

---

lte()

lte<K>(column, value): this

Defined in: builder.ts:75

Less than or equal

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

this

---

match()

match(query): this

Defined in: builder.ts:131

Match multiple conditions (shorthand for multiple eq)

Parameters

query

Partial<T>

Returns

this

---

maybeSingle()

maybeSingle(): PostgrestFilterBuilder<T, T | null>

Defined in: builder.ts:228

Execute and return zero or one row

Returns

PostgrestFilterBuilder<T, T | null>

---

neq()

neq<K>(column, value): this

Defined in: builder.ts:51

Not equal to

Type Parameters

K

K extends string

Parameters

column

K

value

T[K]

Returns

this

---

not()

not<K>(column, operator, value): this

Defined in: builder.ts:141

Negate a filter

Type Parameters

K

K extends string

Parameters

column

K

operator

FilterOperator

value

FilterValue

Returns

this

---

or()

or(conditions, options?): this

Defined in: builder.ts:147

OR condition (raw string format)

Parameters

conditions

string

options?

foreignTable?

string

Returns

this

---

order()

order<K>(column, options?): this

Defined in: builder.ts:160

Order results

Type Parameters

K

K extends string

Parameters

column

K

options?

OrderOptions

Returns

this

---

overlaps()

overlaps<K>(column, values): this

Defined in: builder.ts:117

Array overlaps

Type Parameters

K

K extends string

Parameters

column

K

values

unknown[]

Returns

this

---

range()

range(from, to, options?): this

Defined in: builder.ts:187

Offset results (for pagination)

Parameters

from

number

to

number

options?

foreignTable?

string

Returns

this

---

returns()

returns<R>(): PostgrestFilterBuilder<R, R[]>

Defined in: builder.ts:217

Override return type

Type Parameters

R

R

Returns

PostgrestFilterBuilder<R, R[]>

---

single()

single(): PostgrestFilterBuilder<T, T>

Defined in: builder.ts:222

Execute and return exactly one row (throws if not exactly one)

Returns

PostgrestFilterBuilder<T, T>

---

textSearch()

textSearch<K>(column, query, options?): this

Defined in: builder.ts:123

Full-text search

Type Parameters

K

K extends string

Parameters

column

K

query

string

options?

TextSearchOptions

Returns

this

---

then()

then<TResult1, TResult2>(onfulfilled?, _onrejected?): Promise<TResult1 | TResult2>

Defined in: builder.ts:292

Execute the query

Type Parameters

TResult1

TResult1 = Result<ResultType>

TResult2

TResult2 = never

Parameters

onfulfilled?

((value) => TResult1 | PromiseLike<TResult1>) | null

_onrejected?

((reason) => TResult2 | PromiseLike<TResult2>) | null

Returns

Promise<TResult1 | TResult2>

---

throwOnError()

throwOnError(): Promise<ResultType>

Defined in: builder.ts:328

Throw on error instead of returning { data, error }

Returns

Promise<ResultType>