artis 0.2.13

Artis is a SQL library
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

use std::{collections::HashMap, fmt::Display};

use crate::raw;

pub type Mapping = HashMap<&'static str, &'static str>;

#[derive(Debug, Clone, PartialEq, Eq)]
// 考虑多字段索引
pub enum IndexMeta {
    Index(String),
    Unique(String),
}

impl IndexMeta {
    pub fn name(&self, t: &str) -> String {
        match self {
            IndexMeta::Index(v) => raw!("idx_{}_{}", t, v),
            IndexMeta::Unique(v) => raw!("unq_{}_{}", t, v),
        }
    }

    pub fn column(&self) -> String {
        let raw = match self {
            IndexMeta::Index(v) => v,
            IndexMeta::Unique(v) => v,
        };
        raw.into()
    }
}

#[derive(Debug, Clone)]
pub enum Adjust {
    Add,
    Drop,
    Alter,
}

#[derive(Debug, Default, Clone)]
pub struct ColumeMeta {
    pub name: String,    // 字段
    pub size: usize,     // 大小
    pub colume: String,  // 类型
    pub nullable: bool,  // 是否为空
    pub default: String, // 默认值
    pub comment: String, // 注释
    pub increment: bool, // 自增
}

impl PartialEq for ColumeMeta {
    fn eq(&self, other: &Self) -> bool {
        if self.name != other.name
            || self.nullable != other.nullable
            || self.default.trim_matches('\'') != other.default.trim_matches('\'')
        {
            return false;
        }
        let colume = format!("{}({})", self.colume, self.size);
        if self.size != 0 && colume != other.colume {
            return false;
        }
        other.colume.starts_with(&self.colume)
    }
}

impl Display for ColumeMeta {
    fn fmt(&self, f: &mut std::fmt::Formatter<'_>) -> std::fmt::Result {
        write!(f, "{} {}", self.name, self.colume)?;
        if self.size != 0 {
            write!(f, "({})", self.size)?;
        }
        if !self.nullable {
            write!(f, " {}", "NOT NULL")?;
        }
        if !self.default.is_empty() {
            write!(f, " DEFAULT {}", self.default)?;
        }
        Ok(())
    }
}

#[derive(Debug, Clone, Default)]
pub struct TableMeta {
    pub name: String,             // 表名
    pub primary: String,          // 主键字段  考虑复合主键
    pub indexs: Vec<IndexMeta>,   // 索引
    pub columes: Vec<ColumeMeta>, // 字段
}

// impl TableMeta {
//     pub fn into_raw(&self) -> String {
//         let columes: Vec<_> = self.columes.iter().map(|v| v.to_string()).collect();
//         raw!("CREATE TABLE {} ({})", self.name, columes.join(","))
//     }
// }