welds 0.4.23

An async ORM for (postgres, mssql, mysql, sqlite)
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

use crate::Syntax;

pub struct LimitSkipWriter {
    syntax: Syntax,
}

impl LimitSkipWriter {
    pub fn new(syntax: Syntax) -> Self {
        Self { syntax }
    }
    pub fn skiplimit(&self, s: &Option<i64>, l: &Option<i64>) -> Option<String> {
        match self.syntax {
            Syntax::Mysql => MySql::skiplimit(s, l),
            Syntax::Postgres => Postgres::skiplimit(s, l),
            Syntax::Sqlite => Sqlite::skiplimit(s, l),
            Syntax::Mssql => Mssql::skiplimit(s, l),
        }
    }
}

struct Postgres;
impl Postgres {
    fn skiplimit(s: &Option<i64>, l: &Option<i64>) -> Option<String> {
        if s.is_none() && l.is_none() {
            return None;
        }
        let s = s.unwrap_or(0);
        let l = l.unwrap_or(9999999);
        Some(format!("OFFSET {} LIMIT {}", s, l))
    }
}

struct Sqlite;
impl Sqlite {
    fn skiplimit(s: &Option<i64>, l: &Option<i64>) -> Option<String> {
        if s.is_none() && l.is_none() {
            return None;
        }
        let s = s.unwrap_or(0);
        let l = l.unwrap_or(9999999);
        Some(format!("LIMIT {limit} OFFSET {skip} ", limit = l, skip = s))
    }
}

struct Mssql;
impl Mssql {
    fn skiplimit(s: &Option<i64>, l: &Option<i64>) -> Option<String> {
        if s.is_none() && l.is_none() {
            return None;
        }
        let s = s.unwrap_or(0);
        let l = l.unwrap_or(9999999);
        Some(format!("OFFSET {} ROWS FETCH FIRST {} ROWS ONLY", s, l))
    }
}

struct MySql;
impl MySql {
    fn skiplimit(s: &Option<i64>, l: &Option<i64>) -> Option<String> {
        if s.is_none() && l.is_none() {
            return None;
        }
        let s = s.unwrap_or(0);
        let l = l.unwrap_or(9999999);
        Some(format!("LIMIT {}, {}", s, l))
    }
}