oiseau 0.3.0

Super simple SQL helper
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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104

#[cfg(not(feature = "redis"))]
use crate::cache::no_cache::NoCache;
#[cfg(feature = "redis")]
use crate::cache::redis::RedisCache;

use crate::{cache::Cache, config::Configuration};
pub use rusqlite::{Connection, Result};

#[derive(Clone)]
pub struct DataManager<T: Clone + Configuration>(
    pub T,
    #[cfg(feature = "redis")] pub RedisCache,
    #[cfg(not(feature = "redis"))] pub NoCache,
);

impl<T: Clone + Configuration> DataManager<T> {
    /// Obtain a connection to the staging database.
    pub async fn connect(&self) -> Result<Connection> {
        Connection::open(&self.0.db_config().name)
    }

    /// Create a new [`DataManager`] (and init database).
    pub async fn new(config: T) -> Result<Self> {
        let this = Self(
            config.clone(),
            #[cfg(feature = "redis")]
            RedisCache::new().await,
            #[cfg(not(feature = "redis"))]
            NoCache::new().await,
        );

        let conn = this.connect().await?;
        conn.pragma_update(None, "journal_mode", "WAL").unwrap();

        Ok(this)
    }
}

#[macro_export]
macro_rules! sqlite_get {
    ($row:ident->$idx:literal($t:ty)) => {
        $row.get::<usize, $t>($idx).unwrap()
    };

    ($row:ident->$idx:literal($t:ty) default ($default:expr)) => {
        $row.get::<usize, $t>($idx).unwrap_or($default)
    };

    ($row:ident->$idx:ident($t:ty)) => {
        $row.get::<usize, $t>($idx).unwrap()
    };

    ($row:ident->$idx:ident($t:ty) default ($default:expr)) => {
        $row.get::<usize, $t>($idx).unwrap_or($default)
    };
}

#[macro_export]
macro_rules! sqlite_query_row {
    ($conn:expr, $sql:expr, $params:expr, $f:expr) => {{
        let mut query = $conn.prepare($sql).unwrap();
        query.query_row($params, $f)
    }};
}

#[macro_export]
macro_rules! sqlite_query_rows {
    ($conn:expr, $sql:expr, $params:expr, $f:expr) => {{
        let mut query = $conn.prepare($sql).unwrap();

        if let Ok(mut rows) = query.query($params) {
            let mut out = Vec::new();

            while let Some(row) = rows.next().unwrap() {
                out.push($f(&row));
            }

            Ok(out)
        } else {
            Err(Error::Unknown)
        }
    }};
}

#[macro_export]
macro_rules! sqlite_execute {
    ($conn:expr, $sql:expr, $params:expr) => {
        $conn.prepare($sql).unwrap().execute($params)
    };

    ($conn:expr, $sql:expr) => {
        $conn.prepare($sql).unwrap().execute(())
    };
}

#[macro_export]
macro_rules! sqlite_params {
    () => {
        $crate::rparams![]
    };
    ($($params:expr),+ $(,)?) => {
        $crate::rparams![$($params),+]
    };
}