Struct Database 

pub struct Database { /* private fields */ }

MorphArch database wrapper.

Holds the SQLite connection and provides all database operations. Migration runs automatically on creation.

Implementations

impl Database

pub fn open(path: &Path) -> Result<Self>

Opens (or creates) the database at the specified file path.

After opening the connection:

• WAL mode is enabled (for concurrent reads)
• Required tables are created (CREATE IF NOT EXISTS)
• migration (drift_json column) is applied

pub fn begin_transaction(&self) -> Result<()>

Begins an explicit transaction. Call commit_transaction() when done. All inserts between begin/commit are batched into a single fsync.

pub fn commit_transaction(&self) -> Result<()>

Commits the current transaction (flushes all batched writes).

pub fn clear_all_graph_snapshots(&self) -> Result<()>

Clears all graph data before a scan operation.

pub fn insert_commit(&self, commit: &CommitInfo) -> Result<()>

Inserts a single commit into the database (INSERT OR REPLACE — idempotent).

pub fn list_commits(&self) -> Result<Vec<CommitInfo>>

Lists all commits in descending timestamp order.

pub fn commit_count(&self) -> Result<usize>

Returns the total number of commits in the database.

pub fn insert_graph_snapshot(&self, snapshot: &GraphSnapshot) -> Result<()>

Saves a graph snapshot as JSON to the database.

The GraphSnapshot struct is serialized with serde_json and written to the snapshot_json column. node_count and edge_count are also stored as denormalized columns for fast queries.

pub fn list_recent_graphs( &self, limit: usize, ) -> Result<Vec<(String, String, i64, usize, usize)>>

Lists the last N graph snapshots with commit information.

JOINs with the commits table to include commit message and timestamp. Results are in descending timestamp order.

Returns

Vec<(commit_hash, message_first_line, timestamp, node_count, edge_count)>

pub fn graph_snapshot_count(&self) -> Result<usize>

Returns the total number of graph snapshots in the database.

pub fn get_graph_snapshot( &self, commit_hash: &str, ) -> Result<Option<GraphSnapshot>>

Retrieves a graph snapshot for a specific commit hash.

Deserializes from JSON and returns the full GraphSnapshot. If drift info exists, the drift field will be populated.

Returns

• Ok(Some(snapshot)): Snapshot found
• Ok(None): No snapshot for this commit

pub fn list_drift_trend( &self, limit: usize, ) -> Result<Vec<(String, String, usize, usize, Option<u8>, i64)>>

Lists drift trend data for the last N commits.

Returns snapshots with drift scores in timestamp order. Each row: commit_hash, message, node count, edge count, drift score, delta from previous commit.

Returns

Vec<(commit_hash, message, nodes, edges, drift_total, timestamp)>

pub fn update_drift_score( &self, commit_hash: &str, drift: &DriftScore, ) -> Result<()>

Updates the drift score for a specific commit.

Updates the drift_json column of an existing graph snapshot. Only drift info is added if the snapshot already exists.

pub fn get_latest_scanned_commit(&self) -> Result<Option<String>>

Returns the commit hash of the most recently scanned commit.

Used for incremental scanning — only scan commits newer than this. Returns None if no snapshots exist in the database.

pub fn get_recent_snapshots(&self, limit: usize) -> Result<Vec<GraphSnapshot>>

Loads the last N graph snapshots with full JSON deserialization.

Returns snapshots in newest → oldest order for use in the TUI timeline. Each snapshot contains the full GraphSnapshot struct (nodes, edges, drift).

pub fn get_sampled_snapshots( &self, target_count: usize, ) -> Result<Vec<GraphSnapshot>>

Loads graph snapshots sampled evenly across the full history.

When the DB contains more snapshots than target_count, this method picks snapshots at evenly spaced intervals so the TUI timeline covers the entire commit history instead of just the most recent N.

The first (newest) and last (oldest) snapshots are always included.

Returns snapshots in newest-first order (consistent with get_recent_snapshots).

pub fn get_commit_messages_for_snapshots( &self, snapshots: &[GraphSnapshot], ) -> Result<Vec<(String, String, i64)>>

Retrieves commit message info for the given snapshot list.

Returns (hash, first_line_of_message, timestamp) tuples for display in the timeline widget. Preserves snapshot order.