Graphorin API reference v0.15.1

---

Graphorin API reference / @graphorin/store-sqlite / / SqliteSessionStore

Class: SqliteSessionStore

Defined in: packages/store-sqlite/src/session-store.ts:29

Stable

Default SessionStore implementation. Owns:

• sessions rows.
• agents_registry rows.
• session_handoffs rows.
• session_workflow_runs mapping.
• session_audit lifecycle rows.

Per DEC-147, the actual session_messages rows live in @graphorin/store-sqlite's MemoryStore (single source of truth).

Implements

• SessionStoreExt

Constructors

Constructor

new SqliteSessionStore(conn): SqliteSessionStore;

Defined in: packages/store-sqlite/src/session-store.ts:31

Parameters

Parameter	Type
conn	SqliteConnection

Returns

SqliteSessionStore

Methods

appendAuditEntry()

appendAuditEntry(entry): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:203

Append a session-lifecycle audit row.

Parameters

Parameter	Type
entry	SessionAuditEntry

Returns

Promise<void>

Implementation of

SessionStoreExt.appendAuditEntry

---

appendHandoff()

appendHandoff(sessionId, record): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:135

Parameters

Parameter	Type
sessionId	string
record	HandoffRecord

Returns

Promise<void>

Implementation of

SessionStoreExt.appendHandoff

---

attachWorkflowRun()

attachWorkflowRun(run): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:168

Parameters

Parameter	Type
run	SessionWorkflowRun

Returns

Promise<void>

Implementation of

SessionStoreExt.attachWorkflowRun

---

closeSession()

closeSession(sessionId, closedAt): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:90

Parameters

Parameter	Type
sessionId	string
closedAt	string

Returns

Promise<void>

Implementation of

SessionStoreExt.closeSession

---

createSession()

createSession(metadata): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:35

Parameters

Parameter	Type
metadata	SessionMetadata

Returns

Promise<void>

Implementation of

SessionStoreExt.createSession

---

deleteAgent()

deleteAgent(agentId): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:117

Hard-delete an agent. Used by AgentRegistry.delete(...).

Parameters

Parameter	Type
agentId	string

Returns

Promise<void>

Implementation of

SessionStoreExt.deleteAgent

---

deleteSession()

deleteSession(sessionId): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:238

Hard-delete a session + its handoffs / workflow runs / audit rows.

Parameters

Parameter	Type
sessionId	string

Returns

Promise<void>

Implementation of

SessionStoreExt.deleteSession

---

getSession()

getSession(sessionId): Promise<
  | SessionMetadata
| null>;

Defined in: packages/store-sqlite/src/session-store.ts:52

Parameters

Parameter	Type
sessionId	string

Returns

Promise< | SessionMetadata | null>

Implementation of

SessionStoreExt.getSession

---

listAgents()

listAgents(): Promise<readonly AgentRegistryEntry[]>;

Defined in: packages/store-sqlite/src/session-store.ts:128

List all known agents (including retired ones).

Returns

Promise&lt;readonly AgentRegistryEntry[]&gt;

Implementation of

SessionStoreExt.listAgents

---

listAuditEntries()

listAuditEntries(sessionId, opts?): Promise<readonly SessionAuditEntry[]>;

Defined in: packages/store-sqlite/src/session-store.ts:220

List recent audit rows for a session, newest-first.

Parameters

Parameter	Type
sessionId	string
opts	{ limit?: number; }
opts.limit?	number

Returns

Promise&lt;readonly SessionAuditEntry[]&gt;

Implementation of

SessionStoreExt.listAuditEntries

---

listHandoffs()

listHandoffs(sessionId): Promise<readonly HandoffRecord[]>;

Defined in: packages/store-sqlite/src/session-store.ts:160

Parameters

Parameter	Type
sessionId	string

Returns

Promise&lt;readonly HandoffRecord[]&gt;

Implementation of

SessionStoreExt.listHandoffs

---

listSessions()

listSessions(scope): Promise<readonly SessionMetadata[]>;

Defined in: packages/store-sqlite/src/session-store.ts:57

Parameters

Parameter	Type
scope	Pick<SessionScope, "userId" | "agentId">

Returns

Promise&lt;readonly SessionMetadata[]&gt;

Implementation of

SessionStoreExt.listSessions

---

listWorkflowRuns()

listWorkflowRuns(sessionId): Promise<readonly SessionWorkflowRun[]>;

Defined in: packages/store-sqlite/src/session-store.ts:187

Parameters

Parameter	Type
sessionId	string

Returns

Promise&lt;readonly SessionWorkflowRun[]&gt;

Implementation of

SessionStoreExt.listWorkflowRuns

---

pruneAuditEntries()

pruneAuditEntries(beforeEpochMs): Promise<number>;

Defined in: packages/store-sqlite/src/session-store.ts:232

Delete audit rows older than the supplied epoch ms.

Parameters

Parameter	Type
beforeEpochMs	number

Returns

Promise&lt;number&gt;

Implementation of

SessionStoreExt.pruneAuditEntries

---

pruneSessions()

pruneSessions(opts): Promise<number>;

Defined in: packages/store-sqlite/src/session-store.ts:245

Retention sweep - delete every session matching the policy.

Parameters

Parameter	Type
opts	{ beforeEpochMs?: number; closedOnly?: boolean; }
opts.beforeEpochMs?	number
opts.closedOnly?	boolean

Returns

Promise&lt;number&gt;

Implementation of

SessionStoreExt.pruneSessions

---

registerAgent()

registerAgent(entry): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:97

Parameters

Parameter	Type
entry	AgentRegistryEntry

Returns

Promise&lt;void&gt;

Implementation of

SessionStoreExt.registerAgent

---

resolveAgent()

resolveAgent(agentId): Promise<
  | AgentRegistryEntry
| null>;

Defined in: packages/store-sqlite/src/session-store.ts:121

Parameters

Parameter	Type
agentId	string

Returns

Promise< | AgentRegistryEntry | null>

Implementation of

SessionStoreExt.resolveAgent

---

retireAgent()

retireAgent(agentId, retiredAt): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:110

Parameters

Parameter	Type
agentId	string
retiredAt	string

Returns

Promise&lt;void&gt;

Implementation of

SessionStoreExt.retireAgent

---

updateSession()

updateSession(sessionId, patch): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:73

Parameters

Parameter	Type
sessionId	string
patch	Partial<SessionMetadata>

Returns

Promise&lt;void&gt;

Implementation of

SessionStoreExt.updateSession

---

updateWorkflowRunStatus()

updateWorkflowRunStatus(
   sessionId, 
   workflowId, 
   threadId, 
status): Promise<void>;

Defined in: packages/store-sqlite/src/session-store.ts:175

Update the status of a workflow attachment.

Parameters

Parameter	Type
sessionId	string
workflowId	string
threadId	string
status	"running" | "suspended" | "completed" | "failed"

Returns

Promise&lt;void&gt;

Implementation of

SessionStoreExt.updateWorkflowRunStatus