Class InMemorySQLDatabase

In-memory SQL backend used by tests and local sandboxes.

Implements the SQLDatabase contract with a deliberately limited subset of SQLite-flavored SQL. See the file-level docstring for the exact features supported.

Implements

SQLDatabase

Index

Constructors

Methods

all execute executeQuery executeStatement get prepare run

Constructors

constructor

new InMemorySQLDatabase(): InMemorySQLDatabase

Returns InMemorySQLDatabase

Methods

all

all(
query: string | InMemoryDrizzleQuery,
bindings?: any[],
): Promise<QueryResult<Record<string, unknown>>>
Parameters
- query: string | InMemoryDrizzleQuery
- bindings: any[] = []
Returns Promise<QueryResult<Record<string, unknown>>>
- Defined in src/providers-memory.ts:1337

execute

execute(
query: string | InMemoryDrizzleQuery,
bindings?: any[],
): Promise<QueryResult<Record<string, unknown>>>
Parameters
- query: string | InMemoryDrizzleQuery
- bindings: any[] = []
Returns Promise<QueryResult<Record<string, unknown>>>
- Defined in src/providers-memory.ts:1329

executeQuery

executeQuery(
sql: string,
bindings: any[],
): Promise<QueryResult<Record<string, unknown>>>
Convenience wrapper kept for backwards compatibility. Routes SELECT statements through the emulator and rejects other statement kinds.
Parameters
- sql: string
- bindings: any[]
Returns Promise<QueryResult<Record<string, unknown>>>
- Defined in src/providers-memory.ts:1402

executeStatement

executeStatement(
sql: string,
bindings: any[],
): Promise<QueryResult<Record<string, unknown>>>
Dispatches to the correct handler based on the SQL statement kind. Public so the prepared-statement wrapper can target it directly.
Parameters
- sql: string
- bindings: any[]
Returns Promise<QueryResult<Record<string, unknown>>>
- Defined in src/providers-memory.ts:1358

get

get(
query: string | InMemoryDrizzleQuery,
bindings?: any[],
): Promise<QueryResult<Record<string, unknown>>>
Parameters
- query: string | InMemoryDrizzleQuery
- bindings: any[] = []
Returns Promise<QueryResult<Record<string, unknown>>>
- Defined in src/providers-memory.ts:1341

prepare

prepare(sql: string): PreparedStatement
Creates a prepared statement
Parameters
- sql: string
Returns PreparedStatement
Implementation of SQLDatabase.prepare
- Defined in src/providers-memory.ts:1325

run

run(
query: string | InMemoryDrizzleQuery,
bindings?: any[],
): Promise<QueryResult<Record<string, unknown>>>
Parameters
- query: string | InMemoryDrizzleQuery
- bindings: any[] = []
Returns Promise<QueryResult<Record<string, unknown>>>
- Defined in src/providers-memory.ts:1333