models 0.1.3

A migration management library for applications using PostgresSQL, MySQL or SQLite.
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

// | Rust type                     | MySQL                   | Postgres           | SQLite             |
// |-------------------------------|-------------------------|--------------------|--------------------|
// | `chrono::DateTime<Utc>`       | TIMESTAMP               | TIMESTAMPTZ        | DATETIME           |
// | `chrono::DateTime<Local>`     | TIMESTAMP               | TIMESTAMPTZ        | DATETIME           |
// | `chrono::NaiveDateTime`       | DATETIME                | TIMESTAMP          | DATETIME           |
// | `chrono::NaiveDate`           | DATE                    | DATE               | DATETIME           |
// | `chrono::NaiveTime`           | TIME                    | TIME               | DATETIME           |
//
use super::*;
use chrono::{DateTime, Local, NaiveDate, NaiveDateTime, NaiveTime, Utc};
use models_parser::ast::DataType;

impl IntoSQL for DateTime<Utc> {
    fn into_sql() -> DataType {
        match *DIALECT {
            PostgreSQL => DataType::custom("TIMESTAMPTZ"),
            SQLite => DataType::custom("DATETIME"),
            _ => DataType::Timestamp,
        }
    }
}
impl IntoSQL for DateTime<Local> {
    fn into_sql() -> DataType {
        match *DIALECT {
            PostgreSQL => DataType::custom("TIMESTAMPTZ"),
            SQLite => DataType::custom("DATETIME"),
            _ => DataType::Timestamp,
        }
    }
}

impl IntoSQL for NaiveDateTime {
    fn into_sql() -> DataType {
        match *DIALECT {
            PostgreSQL => DataType::Timestamp,
            _ => DataType::custom("DATETIME"),
        }
    }
}

impl IntoSQL for NaiveDate {
    fn into_sql() -> DataType {
        match *DIALECT {
            SQLite => DataType::custom("DATETIME"),
            _ => DataType::Date,
        }
    }
}

impl IntoSQL for NaiveTime {
    fn into_sql() -> DataType {
        match *DIALECT {
            SQLite => DataType::custom("DATETIME"),
            _ => DataType::Time,
        }
    }
}