sequelite 0.2.3

A simple SQLite ORM 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
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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120

use crate::IntoSqlite;

/// The type of a column in a SQLite database.
/// 
/// This is used to determine the type of a column when creating a table.
#[derive(Debug, Clone, Copy, PartialEq)]
pub enum SqliteType {
    Integer,
    Real,
    Text,
    Blob,
    DateTime,
}

impl IntoSqlite for i32 {
    fn into_sqlite(&self) -> String {
        self.to_string()
    }
}

impl IntoSqlite for i64 {
    fn into_sqlite(&self) -> String {
        self.to_string()
    }
}

impl IntoSqlite for f32 {
    fn into_sqlite(&self) -> String {
        self.to_string()
    }
}

impl IntoSqlite for f64 {
    fn into_sqlite(&self) -> String {
        self.to_string()
    }
}

impl IntoSqlite for bool {
    fn into_sqlite(&self) -> String {
        match self {
            true => "1".to_string(),
            false => "0".to_string()
        }
    }
}

impl IntoSqlite for &str {
    fn into_sqlite(&self) -> String {
        format!("'{}'", self)
    }
}

impl IntoSqlite for chrono::NaiveDateTime {
    fn into_sqlite(&self) -> String {
        let date_str = self.format("%F %T").to_string();
        format!("'{}'", date_str)
    }
}

pub struct NowTime;
impl IntoSqlite for NowTime {
    fn into_sqlite(&self) -> String {
        "CURRENT_TIMESTAMP".to_string()
    }
}

impl IntoSqlite for String {
    fn into_sqlite(&self) -> String {
        format!("'{}'", self)
    }
}

impl IntoSqlite for SqliteType {
    fn into_sqlite(&self) -> String {
        match self {
            SqliteType::Integer => "INTEGER".to_string(),
            SqliteType::Text => "TEXT".to_string(),
            SqliteType::Real => "REAL".to_string(),
            SqliteType::Blob => "BLOB".to_string(),
            SqliteType::DateTime => "DATETIME".to_string()
        }
    }
}

impl SqliteType {
    #[allow(clippy::should_implement_trait)]
    pub fn from_str(s: &str) -> Option<SqliteType> {
        match s.to_uppercase().as_str() {
            "INTEGER" => Some(SqliteType::Integer),
            "TEXT" => Some(SqliteType::Text),
            "REAL" => Some(SqliteType::Real),
            "BLOB" => Some(SqliteType::Blob),
            "DATETIME" => Some(SqliteType::DateTime),
            _ => None
        }
    }
}

/// A flag for a column in a SQLite database.
/// 
/// This is used to determine the flags of a column when creating a table.
#[derive(Debug, Clone, PartialEq, Eq)]
pub enum SqliteFlag {
    PrimaryKey,
    NotNull,
    Unique,
    AutoIncrement,
}

impl IntoSqlite for SqliteFlag {
    fn into_sqlite(&self) -> String {
        match self {
            SqliteFlag::PrimaryKey => "PRIMARY KEY".to_string(),
            SqliteFlag::NotNull => "NOT NULL".to_string(),
            SqliteFlag::Unique => "UNIQUE".to_string(),
            SqliteFlag::AutoIncrement => "AUTOINCREMENT".to_string()
        }
    }
}