sova-db 0.1.1

SeaORM database plugin for Sova (postgres / sqlite / mysql)
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65

//! Db plugin with sqlite (memory / tempfile).
#![cfg(feature = "sqlite")]

use sova_core::{App, TestClient};
use sova_db::{Db, DbPool};
use tempfile::NamedTempFile;

#[tokio::test]
async fn sqlite_memory_install_startup_and_pool() {
    let mut app = App::new();
    app.install(Db::from_env().url("sqlite::memory:"));
    app.with_probes();

    let state = app.run_startup().await.expect("run_startup");
    let pool = state.get::<DbPool>().expect("DbPool in state");
    let conn = pool.get().await.expect("connected");
    conn.ping().await.expect("ping");

    let c = TestClient::tracked(app).unwrap();
    let ready = c.get("/ready").await;
    assert_eq!(ready.status_code().as_u16(), 200);
    let body = String::from_utf8_lossy(ready.body_bytes().unwrap_or(b""));
    assert!(body.contains(r#""status":"ok"#), "body={body}");
    assert!(body.contains("db"), "body={body}");
}

#[tokio::test]
async fn sqlite_tempfile_url() {
    let file = NamedTempFile::new().unwrap();
    let path = file.path().to_string_lossy();
    let url = format!("sqlite://{path}?mode=rwc");

    let mut app = App::new();
    app.install(Db::from_env().url(url));
    let state = app.run_startup().await.expect("run_startup tempfile");
    let pool = state.get::<DbPool>().expect("DbPool");
    pool.get().await.expect("connected").ping().await.unwrap();
}

#[tokio::test]
async fn url_from_toml_when_builder_empty() {
    let file = NamedTempFile::new().unwrap();
    let path = file.path().to_string_lossy();
    let url = format!("sqlite://{path}?mode=rwc");
    let prev = std::env::var("DATABASE_URL").ok();
    std::env::remove_var("DATABASE_URL");

    let mut app = App::new();
    app.configure_from_str(&format!(
        r#"
[db]
url = "{url}"
"#
    ))
    .unwrap();
    app.install(Db::from_env().url(""));
    let state = app.run_startup().await.expect("toml url startup");
    let pool = state.get::<DbPool>().expect("DbPool");
    pool.get().await.expect("connected").ping().await.unwrap();

    match prev {
        Some(v) => std::env::set_var("DATABASE_URL", v),
        None => std::env::remove_var("DATABASE_URL"),
    }
}