Skip to main content

Version: Next

SqliteConnection

SQLite database connection using the better-sqlite3 driver.

Hierarchy

BaseSqliteConnection
- SqliteConnection

Constructors

constructor

new SqliteConnection(config, options, type): SqliteConnection

Inherited from BaseSqliteConnection.constructor
Parameters
- config: Configuration<IDatabaseDriver<Connection>, EntityManager<IDatabaseDriver<Connection>>>
- optionaloptions: ConnectionOptions
- type: ConnectionType = 'write'
Returns SqliteConnection

Methods

inheritedbegin

begin(options): Promise<ControlledTransaction<any, any>>

Inherited from BaseSqliteConnection.begin
Begins a new transaction or creates a savepoint if a transaction context already exists.
Parameters
- options: { ctx?: ControlledTransaction<any, any>; eventBroadcaster?: TransactionEventBroadcaster; isolationLevel?: IsolationLevel; loggerContext?: LogContext; readOnly?: boolean } = {}
Returns Promise<ControlledTransaction<any, any>>

inheritedcheckConnection

checkConnection(): Promise<{ ok: true } | { error?: Error; ok: false; reason: string }>

Inherited from BaseSqliteConnection.checkConnection
Are we connected to the database
Returns Promise<{ ok: true } | { error?: Error; ok: false; reason: string }>

inheritedclose

close(force): Promise<void>

Inherited from BaseSqliteConnection.close
Closes the database connection (aka disconnect)
Parameters
- optionalforce: boolean
Returns Promise<void>

inheritedcommit

commit(ctx, eventBroadcaster, loggerContext): Promise<void>

Inherited from BaseSqliteConnection.commit
Commits the transaction or releases the savepoint.
Parameters
- ctx: ControlledTransaction<any, any>
- optionaleventBroadcaster: TransactionEventBroadcaster
- optionalloggerContext: LogContext
Returns Promise<void>

inheritedconnect

connect(options): Promise<void>

Inherited from BaseSqliteConnection.connect
Establishes the database connection and runs the onConnect hook.
Parameters
- optionaloptions: { skipOnConnect?: boolean }
Returns Promise<void>

inheritedcreateKysely

createKysely(): MaybePromise<void>

Inherited from BaseSqliteConnection.createKysely
Initializes the Kysely client from driver options or a user-provided Kysely instance.
Returns MaybePromise<void>

createKyselyDialect

createKyselyDialect(options): Dialect

Overrides BaseSqliteConnection.createKyselyDialect
Creates a Kysely dialect instance with driver-specific configuration.
Parameters
- options: Dictionary
Returns Dialect

inheritedensureConnection

ensureConnection(): Promise<void>

Inherited from BaseSqliteConnection.ensureConnection
Ensure the connection exists, this is used to support lazy connect when using new MikroORM() instead of the async init method.
Returns Promise<void>

inheritedexecute

execute<T>(query, params, method, ctx, loggerContext): Promise<T>

Inherited from BaseSqliteConnection.execute
Executes a SQL query and returns the result based on the method: 'all' for rows, 'get' for single row, 'run' for affected count.
Parameters
- query: string | RawQueryFragment<string> | NativeQueryBuilder
- params: readonly unknown[] = []
- method: get | all | run = 'all'
- optionalctx: any
- optionalloggerContext: LoggingOptions
Returns Promise<T>

executeDump

executeDump(dump): Promise<void>

Overrides BaseSqliteConnection.executeDump
Execute raw SQL queries, handy from running schema dump loaded from a file. This method doesn't support transactions, as opposed to orm.schema.execute(), which is used internally.
Parameters
- dump: string
Returns Promise<void>

inheritedgetClient

getClient<T>(): Kysely<T>

Inherited from BaseSqliteConnection.getClient
Returns the underlying Kysely client, creating it synchronously if needed.
Returns Kysely<T>

inheritedgetConnectionOptions

getConnectionOptions(): ConnectionConfig

Inherited from BaseSqliteConnection.getConnectionOptions
Parses and returns the resolved connection configuration (host, port, user, etc.).
Returns ConnectionConfig

inheritedgetPlatform

getPlatform(): Platform

Inherited from BaseSqliteConnection.getPlatform
Returns the platform abstraction for this connection.
Returns Platform

inheritedinitClient

initClient(): Promise<void>

Inherited from BaseSqliteConnection.initClient
Ensures the Kysely client is initialized, creating it asynchronously if needed.
Returns Promise<void>

inheritedisConnected

isConnected(): Promise<boolean>

Inherited from BaseSqliteConnection.isConnected
Are we connected to the database
Returns Promise<boolean>

inheritedrollback

rollback(ctx, eventBroadcaster, loggerContext): Promise<void>

Inherited from BaseSqliteConnection.rollback
Rolls back the transaction or rolls back to the savepoint.
Parameters
- ctx: ControlledTransaction<any, any>
- optionaleventBroadcaster: TransactionEventBroadcaster
- optionalloggerContext: LogContext
Returns Promise<void>

inheritedsetMetadata

setMetadata(metadata): void

Inherited from BaseSqliteConnection.setMetadata
Sets the metadata storage on this connection.
Parameters
- metadata: MetadataStorage
Returns void

inheritedsetPlatform

setPlatform(platform): void

Inherited from BaseSqliteConnection.setPlatform
Sets the platform abstraction on this connection.
Parameters
- platform: Platform
Returns void

inheritedstream

stream<T>(query, params, ctx, loggerContext): AsyncIterableIterator<T, any, any>

Inherited from BaseSqliteConnection.stream
Executes a SQL query and returns an async iterable that yields results row by row.
Parameters
- query: string | RawQueryFragment<string> | NativeQueryBuilder
- params: readonly unknown[] = []
- optionalctx: Kysely<any>
- optionalloggerContext: LoggingOptions
Returns AsyncIterableIterator<T, any, any>

inheritedtransactional

transactional<T>(cb, options): Promise<T>

Inherited from BaseSqliteConnection.transactional
Executes a callback within a transaction, committing on success and rolling back on error.
Parameters
- cb: (trx) => Promise<T>
- options: { ctx?: ControlledTransaction<any, []>; eventBroadcaster?: TransactionEventBroadcaster; isolationLevel?: IsolationLevel; loggerContext?: LogContext; readOnly?: boolean } = {}
Returns Promise<T>