Struct LoudnessDatabase 

pub struct LoudnessDatabase { /* private fields */ }

SQLite database for track loudness metadata

Implementations

impl LoudnessDatabase

pub fn open<P: AsRef<Path>>(path: P) -> Result<Self, String>

Open or create the loudness database

pub fn in_memory() -> Result<Self, String>

Create an in-memory database (for testing)

pub fn upsert(&self, track: &TrackLoudness) -> Result<(), String>

Insert or update a track’s loudness data

pub fn get(&self, file_path: &str) -> Result<Option<TrackLoudness>, String>

Get loudness data for a track by file path

pub fn get_fresh( &self, file_path: &str, ) -> Result<Option<TrackLoudness>, String>

Get loudness data only when the cached record is still fresh.

This centralizes the cache-hit contract used by both HTTP analysis handlers and playback loading: scan version, file mtime, and file size must all still match before a record may skip EBU R128 analysis.

pub fn needs_scan(&self, file_path: &str) -> Result<bool, String>

Check if a track needs scanning (not in DB, outdated version, or file changed)

FIX for Defect 40: Also check file mtime and size for change detection. This handles the case where a file is replaced but keeps the same path.

pub fn get_outdated_tracks(&self) -> Result<Vec<String>, String>

Get all tracks that need rescanning

pub fn batch_upsert(&self, tracks: &[TrackLoudness]) -> Result<usize, String>

Batch insert multiple tracks (for initial scan)

pub fn set_album_gain( &self, track_ids: &[&str], album_gain_db: f64, ) -> Result<(), String>

Update album gain for multiple tracks (same album)

FIX for Defect 41: Wrap in transaction for atomicity. If any update fails or process crashes, all changes are rolled back.

pub fn delete(&self, file_path: &str) -> Result<bool, String>

Delete a track from the database

pub fn stats(&self) -> Result<DatabaseStats, String>

Get database statistics

pub fn path(&self) -> &Path

Get database path