systemprompt-database 0.59.0

PostgreSQL infrastructure for systemprompt.io AI governance. SQLx-backed pool, generic repository traits, and compile-time query verification. Part of the systemprompt.io AI governance pipeline.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33

//! Database lifecycle: extension schema installation, migrations, and
//! connection/schema validation.
//!
//! Re-exports the schema installers, the [`MigrationService`] and its result
//! and status types, and the standalone validation helpers
//! ([`validate_database_connection`], [`validate_write_pool_is_primary`],
//! [`validate_table_exists`], [`validate_column_exists`]).
//!
//! Copyright (c) systemprompt.io — Business Source License 1.1.
//! See <https://systemprompt.io> for licensing details.

mod installation;
mod migrations;
mod validation;

pub use installation::{
    BOOTSTRAP_ADVISORY_LOCK_KEY, BootstrapLockGuard, DeferredForeignKey, ExpensiveStatement,
    FkDeferralError, ForeignKeyDrift, HOT_TABLES, MigrationCost, OrphanMigrationLedger,
    SchemaInstallReport, SchemaResidue, SplitCreateTable, UndeclaredTable, audit_migration_cost,
    audit_one, audit_schema_residue, check_migration_references, install_extension_schemas,
    install_extension_schemas_full, install_extension_schemas_with_config,
    split_create_table_foreign_keys,
};
pub use migrations::{
    AppliedMigration, BaselineStamp, ChecksumDrift, ExtensionMigrationStatus, FreshnessCheck,
    MarkAppliedOutcome, MigrationConfig, MigrationResult, MigrationService, MigrationStatus,
    OrphanedMigration, PendingMigration, RepairResult, SlotCollision, TombstonedSlot,
    is_retirement,
};
pub use validation::{
    ReplicaStatus, replica_status, validate_column_exists, validate_database_connection,
    validate_table_exists, validate_write_pool_is_primary,
};