1mod 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
13pub 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 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
59pub 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#[derive(Debug, Clone, PartialEq, Eq)]
71pub struct MigrationStatus {
72 pub name: String,
74 pub applied: bool,
76}
77
78pub 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}