Struct Database 

pub struct Database { /* private fields */ }

SQLite database for scan and build caching.

Implementations

impl Database

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

Open or create a database at the given path.

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

Begin a transaction.

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

Commit the current transaction.

pub fn store_package(&self, pkgpath: &str, index: &ScanIndex) -> Result<i64>

Store a package from scan results.

pub fn store_scan_pkgpath( &self, pkgpath: &str, indexes: &[ScanIndex], ) -> Result<()>

Store scan results for a pkgpath.

pub fn get_package_by_name(&self, pkgname: &str) -> Result<Option<PackageRow>>

Get package by name.

pub fn get_package_id(&self, pkgname: &str) -> Result<Option<i64>>

Get package ID by name.

pub fn get_pkgname(&self, package_id: i64) -> Result<String>

Get pkgname by package ID.

pub fn get_packages_by_path(&self, pkgpath: &str) -> Result<Vec<PackageRow>>

Get packages by pkgpath.

pub fn is_pkgpath_scanned(&self, pkgpath: &str) -> Result<bool>

Check if pkgpath is scanned.

pub fn get_scanned_pkgpaths(&self) -> Result<HashSet<String>>

Get all scanned pkgpaths.

pub fn get_unscanned_dependencies(&self) -> Result<HashSet<String>>

Get pkgpaths that are referenced as dependencies but haven’t been scanned yet. These are dependencies that were discovered during scanning but the scan was interrupted before they could be processed.

pub fn count_packages(&self) -> Result<i64>

Count of scanned packages.

pub fn count_scan(&self) -> Result<i64>

Count of scanned pkgpaths.

pub fn get_all_packages(&self) -> Result<Vec<PackageRow>>

Get all packages (lightweight).

pub fn get_buildable_packages(&self) -> Result<Vec<PackageRow>>

Get all buildable packages (no skip/fail reason).

pub fn get_full_scan_index(&self, package_id: i64) -> Result<ScanIndex>

Load full ScanIndex for a package.

pub fn get_all_scan_indexes(&self) -> Result<Vec<(i64, ScanIndex)>>

Load all ScanIndex data in one query.

pub fn get_scan_index_by_name(&self, pkgname: &str) -> Result<Option<ScanIndex>>

Load full ScanIndex by pkgname.

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

Clear all scan data.

pub fn store_resolved_dependencies_batch( &self, deps: &[(i64, i64)], ) -> Result<()>

Store resolved dependencies in batch.

pub fn get_transitive_reverse_deps(&self, package_id: i64) -> Result<Vec<i64>>

Get all transitive reverse dependencies using recursive CTE.

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

Clear all resolved dependencies.

pub fn store_build_result( &self, package_id: i64, result: &BuildResult, ) -> Result<()>

Store a build result by package ID.

pub fn store_build_by_name(&self, result: &BuildResult) -> Result<()>

Store a build result by pkgname.

pub fn get_build_result(&self, package_id: i64) -> Result<Option<BuildResult>>

Get build result for a package.

pub fn count_build(&self) -> Result<i64>

Count of build results.

pub fn delete_build_by_name(&self, pkgname: &str) -> Result<bool>

Delete build result for a pkgname.

pub fn delete_build_by_pkgpath(&self, pkgpath: &str) -> Result<usize>

Delete build results by pkgpath.

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

Clear all build results.

pub fn get_all_build_results(&self) -> Result<Vec<BuildResult>>

Get all build results from the database.

pub fn count_breaks_for_failed(&self) -> Result<HashMap<String, usize>>

Count how many packages are broken by each failed package. Returns a map from pkgname to the count of packages that depend on it.

pub fn get_total_build_duration(&self) -> Result<Duration>

Get total build duration from all builds.

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

Get pre-failed packages (those with skip_reason or fail_reason but no build result). Returns (pkgname, pkgpath, reason).

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

Get packages without build results that depend on failed packages. Returns (pkgname, pkgpath, failed_deps) where failed_deps is comma-separated. Excludes packages that have skip_reason or fail_reason (they’re pre-failed). Only lists root failures (direct failures), not indirect failures.

pub fn mark_failure_cascade( &self, package_id: i64, reason: &str, duration: Duration, ) -> Result<usize>

Mark a package and all its transitive reverse dependencies as failed. Returns the count of packages marked.

pub fn full_scan_complete(&self) -> bool

Check if a full tree scan has been completed.

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

Mark a full tree scan as complete.

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

Clear the full tree scan complete marker.

pub fn store_pkgsrc_env(&self, env: &PkgsrcEnv) -> Result<()>

Store the pkgsrc environment to the database. Errors if already present as this should only ever be done once.

pub fn load_pkgsrc_env(&self) -> Result<PkgsrcEnv>

Load the pkgsrc environment from the database.

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

Get all package names with successful build outcomes.

pub fn execute_raw(&self, sql: &str) -> Result<()>

Execute arbitrary SQL and print results.