db_dsl 0.3.3

A simple DSL for creating database objects.
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

use crate::{Column, SqlUp};

#[derive(Clone, Debug, Default)]
pub enum DataType {
    #[default]
    String,
    UUID,
    Text,
    Int,
    BigInt,
    Bool,
    Bits(usize),
    Float,
    Double,
    Decimal(usize, usize),
    Reference(String),
    Date,
    Datetime,
}

impl DataType {
    pub fn column(&self, name: &str) -> Column {
        Column {
            name: name.to_string(),
            data_type: Some(self.clone()),
            options: None,
        }
    }
}

impl SqlUp for DataType {
    fn sqlite_up(&self) -> Option<String> {
        let str = match self {
            DataType::UUID => "STRING".to_string(),
            DataType::String => "STRING".to_string(),
            DataType::Text => "TEXT".to_string(),
            DataType::Int => "INTEGER".to_string(),
            DataType::BigInt => "BIGINT".to_string(),
            DataType::Bool => "BOOLEAN".to_string(),
            DataType::Bits(size) => format!("BIT({})", size),
            DataType::Float => "FLOAT".to_string(),
            DataType::Double => "DOUBLE".to_string(),
            DataType::Decimal(precision, scale) => format!("DECIMAL({}, {})", precision, scale),
            DataType::Date => "DATE".to_string(),
            DataType::Datetime => "DATETIME".to_string(),
            // TODO: support all reference types
            DataType::Reference(table) => format!("BIGINT REFERENCES {}", table),
        };
        Some(str)
    }
}