Struct ProjectDb 

pub struct ProjectDb { /* private fields */ }

Project database handle.

Implementations

impl ProjectDb

pub fn open(db_path: &Path) -> DbResult<Self>

Open or create a project database at the given path.

pub fn insert_file(&self, file: &FileRecord) -> DbResult<i64>

Insert a new file record. Returns the row id.

pub fn get_file_by_path(&self, path: &str) -> DbResult<Option<FileRecord>>

Get a file record by absolute path.

pub fn update_file_hash(&self, id: i64, hash: &str) -> DbResult<()>

Update the content hash for a file by id.

pub fn list_files(&self) -> DbResult<Vec<FileRecord>>

List all file records ordered by path.

pub fn get_config(&self, key: &str) -> DbResult<Option<String>>

Get a project config value.

pub fn set_config(&self, key: &str, value: &str) -> DbResult<()>

Set a project config value.

pub fn insert_scan_history( &self, total_score: f64, traffic_light: &str, files_scanned: usize, duration_ms: u64, component_scores: &str, ) -> DbResult<i64>

Insert a scan history record. Returns the row id.

pub fn get_previous_component_scores(&self) -> DbResult<Option<String>>

Get the previous scan’s component_scores JSON (most recent scan).

pub fn insert_scan_history_v2( &self, total_score: f64, traffic_light: &str, files_scanned: usize, duration_ms: u64, component_scores: &str, commit_sha: Option<&str>, branch: Option<&str>, ) -> DbResult<(i64, Option<f64>)>

Insert a scan history record with git context and auto-computed delta.

pub fn insert_quality_issue( &self, scan_id: i64, issue_id: &str, file_path: Option<&str>, category: &str, severity: &str, title: &str, attribution: &str, suggestion: Option<&str>, ) -> DbResult<()>

Insert a quality issue record.

pub fn upsert_file( &self, path: &str, relative_path: &str, content_hash: Option<&str>, size: Option<i64>, modified_at: Option<&str>, extension: Option<&str>, is_markdown: bool, ) -> DbResult<()>

Upsert a file record (insert or update by relative_path).

pub fn get_scan_history(&self, limit: usize) -> DbResult<Vec<ScanHistoryRecord>>

Get scan history entries (most recent first, limited).

pub fn index_file_content( &self, relative_path: &str, content: &str, ) -> DbResult<()>

Populate FTS index for a file.

pub fn search_files( &self, query: &str, limit: usize, ) -> DbResult<Vec<SearchResult>>

Search files using FTS5 full-text search.

pub fn clear_fts_index(&self) -> DbResult<()>

Clear the entire FTS index.

pub fn get_file_id_by_relative_path( &self, relative_path: &str, ) -> DbResult<Option<i64>>

Get file ID by relative path.

pub fn insert_classification( &self, file_id: i64, doc_type: &str, subcategory: Option<&str>, confidence: f64, source: &str, ) -> DbResult<i64>

Insert a classification record for a file.

pub fn clear_classifications(&self) -> DbResult<()>

Clear all classifications (before re-scan).

pub fn purge_stale_files( &self, current_paths: &HashSet<String>, ) -> DbResult<usize>

Remove files from DB that are no longer on disk. Accepts a set of relative paths that currently exist. Deletes all files (and their classifications) not in the set.

pub fn insert_user_correction( &self, file_id: i64, doc_type: &str, subcategory: Option<&str>, ) -> DbResult<()>

Insert a user correction and update classification to user source with confidence 1.0.

pub fn delete_classification_for_file(&self, file_id: i64) -> DbResult<()>

Delete classification for a specific file.

pub fn get_classifications(&self) -> DbResult<Vec<ClassificationRecord>>

Get all classifications with file paths (most recent per file).

pub fn set_baseline( &self, name: &str, total_score: f64, commit_sha: Option<&str>, component_scores: Option<&str>, ) -> DbResult<i64>

Create a named baseline from the current score.

pub fn get_active_baseline(&self) -> DbResult<Option<BaselineRecord>>

Get the currently active baseline.

pub fn get_last_n_scores(&self, n: usize) -> DbResult<Vec<f64>>

Return the last N total scores (0.0–1.0) ordered oldest to newest. Used for sparkline visualization in the CLI header.

pub fn bump_baseline(&self) -> DbResult<bool>

Bump (replace) the active baseline with the latest scan data.