import { type ISchema } from "https://deno.land/x/pg_mem@2.7.0/index.ts";
Methods
many(query: QueryOrAst): any[]
Execute a query and return many results
none(query: QueryOrAst): void
Execute a query without results
one(query: QueryOrAst): any
Execute a query with a single result
declareTable(table: Schema): IMemoryTable
Another way to create tables (equivalent to "create table" queries")
query(text: QueryOrAst): QueryResult
Execute a query
queries(text: QueryOrAst): Iterable<QueryResult>
Progressively executes a query, yielding results until the end of enumeration (or an exception)
getTable(table: string): IMemoryTable
Get a table in this db to inspect it
getTable(table: string, nullIfNotFound?: boolean): IMemoryTable | null
registerFunction(fn: FunctionDefinition, orReplace?: boolean): this
Register a function
registerOperator(fn: OperatorDefinition): this
Register a binary operator
registerEquivalentType(type: IEquivalentType): IType
Register a simple type, which is equivalent to another
Database migration, node-sqlite flavor ⚠ Only working when runnin nodejs !
interceptQueries(interceptor: QueryInterceptor): ISubscription
Intecept queries. If your interceptor returns an array, then the query will not be executed. The given result will be returned instead.