Skip to main content

capy_db/
lib.rs

1//! SeaORM connection and migration integration.
2
3mod seeds;
4pub use seeds::{SeedContext, SeedFuture, Seeds};
5
6use capy_core::{AppError, DatabaseSettings, Result};
7use sea_orm::{ConnectOptions, Database};
8use std::time::Duration;
9
10pub use sea_orm::DatabaseConnection;
11pub use sea_orm_migration::{MigrationTrait, MigratorTrait};
12
13/// Connect to the configured database, with SQL logging disabled by default.
14pub async fn connect(settings: &DatabaseSettings) -> Result<DatabaseConnection> {
15    settings.validate()?;
16    let in_memory = settings.url.starts_with("sqlite:") && settings.url.contains(":memory:");
17    let max = if in_memory {
18        1
19    } else {
20        settings.max_connections
21    };
22    let mut options = ConnectOptions::new(&settings.url);
23    options
24        .max_connections(max)
25        .min_connections(if in_memory {
26            1
27        } else {
28            settings.min_connections
29        })
30        .connect_timeout(Duration::from_secs(settings.connect_timeout_seconds))
31        .acquire_timeout(Duration::from_secs(settings.acquire_timeout_seconds))
32        .idle_timeout(Duration::from_secs(settings.idle_timeout_seconds))
33        .sqlx_logging(false);
34    // SeaORM maps connect_timeout and acquire_timeout to the same SQLx option.
35    // Bound startup independently so a separate acquire policy remains effective.
36    let db = tokio::time::timeout(
37        Duration::from_secs(settings.connect_timeout_seconds),
38        Database::connect(options),
39    )
40    .await
41    .map_err(|_| {
42        AppError::DatabaseConnection(sea_orm::DbErr::ConnectionAcquire(
43            sea_orm::ConnAcquireErr::Timeout,
44        ))
45    })?
46    .map_err(AppError::DatabaseConnection)?;
47    tracing::info!(
48        database = if settings.url.starts_with("sqlite:") {
49            "SQLite"
50        } else {
51            "PostgreSQL"
52        },
53        pool_max = max,
54        "database connected"
55    );
56    Ok(db)
57}
58
59/// Default migrator for applications that have no migrations yet.
60pub struct NoMigrations;
61
62#[sea_orm_migration::async_trait::async_trait]
63impl MigratorTrait for NoMigrations {
64    fn migrations() -> Vec<Box<dyn MigrationTrait>> {
65        Vec::new()
66    }
67}
68
69/// A migration's name and current database status.
70#[derive(Debug, Clone, PartialEq, Eq)]
71pub struct MigrationStatus {
72    /// Stable name used in the SeaORM migration ledger.
73    pub name: String,
74    /// Whether this migration has been applied.
75    pub applied: bool,
76}
77
78/// List applied and pending migrations using SeaORM's native migration ledger.
79pub async fn status<M: MigratorTrait>(db: &DatabaseConnection) -> Result<Vec<MigrationStatus>> {
80    use sea_orm_migration::MigrationStatus as Status;
81    Ok(M::get_migration_with_status(db)
82        .await?
83        .into_iter()
84        .map(|migration| MigrationStatus {
85            name: migration.name().to_owned(),
86            applied: migration.status() == Status::Applied,
87        })
88        .collect())
89}