# Interface ISQLiteStatement<T>

Minimal interface for better-sqlite3 Statement. Compatible with the better-sqlite3 package API.

interface ISQLiteStatement<T = unknown> {
run(...params: unknown[]): ISQLiteRunResult;
get(...params: unknown[]): T | undefined;
all(...params: unknown[]): T[];
}

#### Type Parameters

- T = unknown

- Defined in packages/nexus-agents/src/core/types/database-types.ts:18

##### Index

### Methods

run
get
all

## Methods

### run

- run(...params: unknown[]): ISQLiteRunResult

  Execute the statement with the given parameters. Returns information about changes made.

  #### Parameters

  - ...params: unknown[]

  #### Returns ISQLiteRunResult

  - Defined in packages/nexus-agents/src/core/types/database-types.ts:23

### get

- get(...params: unknown[]): T | undefined

  Get a single row matching the statement. Returns undefined if no match.

  #### Parameters

  - ...params: unknown[]

  #### Returns T | undefined

  - Defined in packages/nexus-agents/src/core/types/database-types.ts:29

### all

- all(...params: unknown[]): T[]

  Get all rows matching the statement.

  #### Parameters

  - ...params: unknown[]

  #### Returns T[]

  - Defined in packages/nexus-agents/src/core/types/database-types.ts:34