Skip to main content
Deno 2 is finally here 🎉️
Learn more
Module

x/pg_mem/interfaces-private.ts>_ISelection

An in memory postgres DB instance for your unit tests
oguimbal/pg-mem
Latest
interface _ISelection
implements _IAlias
import { type _ISelection } from "https://deno.land/x/pg_mem@3.0.3/interfaces-private.ts";

Properties

readonly
optional
debugId: string
readonly
ownerSchema: _ISchema
readonly
db: _IDb
readonly
isExecutionWithNoResult: boolean

Tells if this statement is an execution without any meaningful result ("update" with no "returning", etc...)

readonly
columns: ReadonlyArray<IValue>

Column list (those visible when select *)

Methods

isAggregation(): this is _IAggregation

True when this is an aggregation being built

entropy(t: _Transaction): number

Statistical measure of how many items will be returned by this selection

enumerate(t: _Transaction): Iterable<Row>
hasItem(value: Row, t: _Transaction): boolean

Returns true if the given value is present in this

stats(t: _Transaction): Stats | null
getIndex(...forValue: IValue[]): _IIndex | nil

Gets the index associated with this value (or returns null)

listSelectableIdentities(): Iterable<IValue>

All columns. A bit like .columns`, but including records selections

filter(where: Expr | nil): _ISelection
orderBy(orderBy: OrderByStatement[] | nil): _ISelection
groupBy(grouping: Expr[] | nil): _ISelection
distinct(select?: Expr[]): _ISelection
union(right: _ISelection): _ISelection
getColumn(column: string | ExprRef): IValue
getColumn(column: string | ExprRef, nullIfNotFound?: boolean): IValue | nil
setAlias(alias?: string): _ISelection
isOriginOf(a: IValue): boolean
select(select: (string | SelectedColumn)[]): _ISelection

Select a specific subset

selectAlias(alias: string): _IAlias | nil

Limit selection to a specific alias (in joins)