desktop/src-tauri/crates/core/src/retention.rs

Comment 1, line 1

//! Detail cutoff is today's start in the selected timezone minus D-1 days; archive expired days

//! with timezone/field/source versions and block ordinary additions. Size includes DB/WAL/SHM/backups.

/// Increment when archive field meanings change; archived rows retain the version used.

/// Detail retention in local days, including today: 7–3650.

/// Diagnostic retention in days.

/// Hard maximum local-day retention for usage/quotas/diagnostics; None adds no extra limit.

/// Keep details on or after this local cutoff day.

/// Archive expired daily summaries and delete expired details in one transaction.

// Persist an increasing cleanup floor; restart/longer retention cannot restore deleted data through ordinary rescans.

// 1. Find expired local days with details.

// 2. Recompute each day before archiving; retain timezone/field/source-selection versions.

// Publish the aggregate generation atomically with the transaction.

// 3. Delete expired details; logical SQLite deletion does not guarantee physical erasure.

// 4. Apply diagnostic retention.

// 5. Apply hard maximum retention to daily summaries and quota snapshots.

// Native intervals cannot be split proportionally; unknown starts/cross-cutoff aggregates cannot satisfy the hard limit.

/// Storage size: main DB, WAL, SHM and backup-directory files.