musq 0.0.4

Musq is an asynchronous SQLite toolkit for Rust.
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

//! Integration tests for musq.

mod support;

#[cfg(test)]
mod tests {
    use musq::{Musq, query, query_scalar};
    use tokio::time::{Duration, Instant, sleep};

    use crate::support::connection;

    #[tokio::test]
    async fn basic_statement_flow() -> anyhow::Result<()> {
        let conn = connection().await?;

        query("CREATE TABLE t (id INTEGER PRIMARY KEY, val TEXT)")
            .execute(&conn)
            .await?;

        let stmt = conn.prepare("INSERT INTO t (val) VALUES (?1)").await?;
        stmt.query().bind("hello").execute(&conn).await?;
        drop(stmt);

        let count: i64 = query_scalar("SELECT COUNT(*) FROM t")
            .fetch_one(&conn)
            .await?;
        assert_eq!(count, 1);

        Ok(())
    }

    #[tokio::test]
    async fn retry_on_busy_lock() -> anyhow::Result<()> {
        let pool = Musq::new().max_connections(2).open_in_memory().await?;
        let c1 = pool.acquire().await?;
        let c2 = pool.acquire().await?;

        query("CREATE TABLE t (val TEXT)").execute(&c1).await?;

        query("BEGIN IMMEDIATE").execute(&c1).await?;

        let start = Instant::now();
        let insert = tokio::spawn(async move {
            query("INSERT INTO t (val) VALUES ('foo')")
                .execute(&c2)
                .await
        });

        sleep(Duration::from_millis(100)).await;
        query("COMMIT").execute(&c1).await?;

        insert.await??;
        assert!(start.elapsed() >= Duration::from_millis(100));

        let conn = pool.acquire().await?;
        let count: i64 = query_scalar("SELECT COUNT(*) FROM t")
            .fetch_one(&conn)
            .await?;
        assert_eq!(count, 1);

        Ok(())
    }
}