Class: SQLiteAdapter
Defined in: packages/pesa/src/db/sqlite.ts:14
SQLite event store adapter powered by better-sqlite3.
This is the default adapter — zero configuration, no network required.
The database file is created at ./pesa.db if it doesn't exist.
For serverless / edge workloads, swap to LibSQLAdapter (@borapesa/libsql) which targets Turso.
Implements
Constructors
Constructor
new SQLiteAdapter(dbPath?): SQLiteAdapter;Defined in: packages/pesa/src/db/sqlite.ts:18
Parameters
| Parameter | Type | Default value |
|---|---|---|
dbPath | string | './pesa.db' |
Returns
SQLiteAdapter
Methods
getEvent()
getEvent(id): Promise<PaymentEvent | null>;Defined in: packages/pesa/src/db/sqlite.ts:67
Retrieve a single event by its UUID.
Parameters
| Parameter | Type |
|---|---|
id | string |
Returns
Promise<PaymentEvent | null>
Implementation of
getEventsByOrderId()
getEventsByOrderId(orderId): Promise<PaymentEvent[]>;Defined in: packages/pesa/src/db/sqlite.ts:83
Retrieve all events for a given provider order ID.
Parameters
| Parameter | Type |
|---|---|
orderId | string |
Returns
Promise<PaymentEvent[]>
Implementation of
PesaDatabaseAdapter.getEventsByOrderId
getEventsByReference()
getEventsByReference(reference): Promise<PaymentEvent[]>;Defined in: packages/pesa/src/db/sqlite.ts:75
Retrieve all events for a given merchant reference.
Parameters
| Parameter | Type |
|---|---|
reference | string |
Returns
Promise<PaymentEvent[]>
Implementation of
PesaDatabaseAdapter.getEventsByReference
saveEvent()
saveEvent(event): Promise<void>;Defined in: packages/pesa/src/db/sqlite.ts:46
Persist a verified PaymentEvent.
Parameters
| Parameter | Type |
|---|---|
event | PaymentEvent |
Returns
Promise<void>