kstool 0.3.4

A tools crate used by KunoiSayami's projects
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

#[cfg(feature = "jiff")]
pub mod jiff_impl;

#[cfg(feature = "jiff-export")]
pub use jiff;

pub mod prelude {
    pub use super::time::{get_current_duration, get_current_timestamp};
}

pub mod time {
    use std::time::Duration;

    pub fn get_current_timestamp() -> u128 {
        get_current_duration().as_millis()
    }

    pub fn get_current_second() -> u64 {
        get_current_duration().as_secs()
    }

    pub fn get_current_duration() -> Duration {
        let start = std::time::SystemTime::now();
        start
            .duration_since(std::time::UNIX_EPOCH)
            .expect("Time went backwards")
    }

    #[cfg(feature = "jiff")]
    pub use super::jiff_impl::*;
}

#[cfg(feature = "sqlx")]
pub mod sqlx {
    use sqlx::SqliteConnection;

    pub async fn update_database_version(
        conn: &mut SqliteConnection,
        table_name: &'static str,
        version: &'static str,
    ) -> Result<(), sqlx::Error> {
        sqlx::query(&format!(
            r#"UPDATE "{}" SET "value" = ? WHERE "key" = 'version'"#,
            table_name
        ))
        .bind(version)
        .execute(conn)
        .await
        .map(|_| ())
    }

    pub async fn insert_database_version(
        conn: &mut SqliteConnection,
        table_name: &'static str,
        version: &'static str,
    ) -> Result<(), sqlx::Error> {
        sqlx::query(&format!(
            r#"INSERT INTO "{}" VALUES ("version", ?)"#,
            table_name
        ))
        .bind(version)
        .execute(conn)
        .await
        .map(|_| ())
    }

    pub async fn check_database(
        conn: &mut SqliteConnection,
        table_name: &'static str,
    ) -> Result<bool, sqlx::Error> {
        sqlx::query_as(
            r#"SELECT COUNT(*) FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'meta';"#,
        )
        .bind(table_name)
        .fetch_one(conn)
        .await
        .map(|(count,): (i32,)| count > 0)
    }
}

#[cfg(test)]
mod tests {
    use super::prelude::*;

    #[test]
    fn test_get_current_timestamp() {
        get_current_timestamp();
    }
}