Table of Contents

Class SqliteSnapshotStore

Namespace
Excalibur.EventSourcing.Sqlite
Assembly
Excalibur.EventSourcing.Sqlite.dll

SQLite implementation of ISnapshotStore.

public sealed class SqliteSnapshotStore : ISnapshotStore
Inheritance
SqliteSnapshotStore
Implements
Inherited Members

Remarks

Stores snapshots as binary blobs in SQLite. Auto-creates the table on first use. Uses UPSERT (INSERT OR REPLACE) to maintain one snapshot per aggregate.

Constructors

SqliteSnapshotStore(string, ILogger<SqliteSnapshotStore>, ITenantContext, IOptions<TenantContextOptions>, string)

Initializes a new instance of the SqliteSnapshotStore class.

public SqliteSnapshotStore(string connectionString, ILogger<SqliteSnapshotStore> logger, ITenantContext tenantContext, IOptions<TenantContextOptions> tenantContextOptions, string table = "Snapshots")

Parameters

connectionString string

The SQLite connection string.

logger ILogger<SqliteSnapshotStore>

The logger instance.

tenantContext ITenantContext

The ambient tenant context. Required: this store partitions rows by tenant, and it resolves that partition from here, so there is no state in which the partition is undecided. A single-tenant host receives the framework default context and operates as the one canonical tenant.

tenantContextOptions IOptions<TenantContextOptions>

The tenant-context options; its RequireTenant (set by AddMultiTenancy()) selects the deployment mode for the startup schema handshake, which decides whether legacy untenanted rows may be converged onto the single-tenant identity.

table string

The snapshot table name. Default: "Snapshots".

Methods

DeleteSnapshotsAsync(string, string, CancellationToken)

Deletes all snapshots for an aggregate.

public ValueTask DeleteSnapshotsAsync(string aggregateId, string aggregateType, CancellationToken cancellationToken)

Parameters

aggregateId string

The aggregate identifier.

aggregateType string

The aggregate type name.

cancellationToken CancellationToken

Cancellation token.

Returns

ValueTask

A task that represents the asynchronous delete operation.

DeleteSnapshotsOlderThanAsync(string, string, long, CancellationToken)

Deletes snapshots older than a specified version.

public ValueTask DeleteSnapshotsOlderThanAsync(string aggregateId, string aggregateType, long olderThanVersion, CancellationToken cancellationToken)

Parameters

aggregateId string

The aggregate identifier.

aggregateType string

The aggregate type name.

olderThanVersion long

Delete snapshots with version less than this value.

cancellationToken CancellationToken

Cancellation token.

Returns

ValueTask

A task that represents the asynchronous delete operation.

GetLatestSnapshotAsync(string, string, CancellationToken)

Gets the latest snapshot for an aggregate.

public ValueTask<ISnapshot?> GetLatestSnapshotAsync(string aggregateId, string aggregateType, CancellationToken cancellationToken)

Parameters

aggregateId string

The aggregate identifier.

aggregateType string

The aggregate type name.

cancellationToken CancellationToken

Cancellation token.

Returns

ValueTask<ISnapshot>

The latest snapshot, or null if no snapshot exists.

Remarks

Confined to the ambient tenant established for this store instance: a snapshot stored under another tenant for this aggregateId is reported as not found, the same as one that was never taken.

SaveSnapshotAsync(ISnapshot, CancellationToken)

Saves a snapshot for an aggregate, keeping the highest version stored for it.

public ValueTask SaveSnapshotAsync(ISnapshot snapshot, CancellationToken cancellationToken)

Parameters

snapshot ISnapshot

The snapshot to save.

cancellationToken CancellationToken

Cancellation token.

Returns

ValueTask

A task that represents the asynchronous save operation.

Remarks

Total. Every well-formed snapshot is an acceptable argument. There is no version, payload size, or identifier shape a caller must avoid, and no state of the store in which a save is illegal.

Monotone upsert, scoped to the interval since the last deletion. After SaveSnapshotAsync returns normally, the version readable for (aggregateId, aggregateType) within the ambient tenant is at least the version passed. A save carrying a version lower than or equal to the stored one is a successful no-op. Monotonicity does NOT hold across a deletion: DeleteSnapshotsAsync, DeleteSnapshotsOlderThanAsync and provider-level expiry all remove stored versions, after which a save may legitimately make a LOWER version readable than was readable before. Saves and deletions on the same key are not ordered with respect to one another, so a save superseded by a concurrent deletion has not dropped a snapshot. A caller that requires a specific version to be readable must re-read it; a normal return does not entitle the caller to infer which version is readable now, only that the store established one at least as high at the moment it completed. A store that returns normally having neither stored the snapshot nor established that is in violation; unresolvable contention is reported as ConcurrencyException, never as success.

Modifies only its own key. No other aggregate, aggregate type, or tenant is observably affected.

Faults. Throws only for an invalid argument, for cancellation, or for an infrastructure failure that prevented the store from establishing the outcome above. Implementations MUST NOT report a lost race as a fault, and MUST NOT return normally having neither stored the snapshot nor established that a version at least as high is stored — a silent drop reports success for a snapshot nobody holds.

Exceptions

ConcurrencyException

May be thrown by an implementation that retries a contended write when it exhausts its attempts without either storing the snapshot or establishing that a version at least as high is already stored. This is the infrastructure-failure case above, reported in the abstraction's own currency: the outcome is UNKNOWN, which is why it is a fault rather than the successful no-op that a proven supersede produces. Implementations that write without retrying cannot reach this state and do not throw it.