desktop/src-tauri/crates/core/tests/kilo_incremental_v12.rs

Comment 1, line 1

//! Kilo V12 incremental SQLite tests use schema fingerprints, stable message.id keys

//! and time_updated processing positions, compared with Codex/Pi JSONL tests:

//! - Repeated rows in the processed window with identical key/revision do not add usage.

//! - New messages contribute incrementally, without replaying the entire database.

//! - Increased time_updated and changed tokens replace values by source_revision without conflict.

//! - Completion replaces partial with final under the same key.

//! - Schema fingerprint changes reset processing positions and reread without duplication.

//! - Database recreation rescans without duplicate usage or loss of stored history.

//!

//! Data is synthetic using the real sample DDL, with manually calculated values.

/// Synthetic time base; each step adds 1_000_000 ms, beyond the 60-second overlap window.

/// Insert one assistant; Null tokens means no usage and finish is optional.

// Replay two unchanged rows in the 60-second overlap: same key/content/revision is unchanged,

// without added usage. SQLite does not skip solely on byte length; see incremental rules.

// Empty replay adds no usage; the data revision must not move backwards.

// Append beyond the overlap window; the new row contributes once and old rereads remain unchanged.

// Unsynchronized source snapshots remain visible as mismatch; detail events determine totals.

// Update an existing row with a higher time_updated revision and reduced token values.

// finish=stop, completed total and increased time_updated replace the same key as final.

// Modify the persisted schema fingerprint to simulate evolution and trigger a complete reread.

// Identical old key/revision/content is unchanged on full reread, without additions or conflict.

// Recreate at the same path; rereads preserve history and deduplicate the same instance/key.

// File identity includes creation time and first-sample fingerprint; when creation time is absent,

// same-shape recreation matches the old stream identity without a new instance contribution.