jetdb 0.3.1

Pure Rust library for reading Microsoft Access (.mdb/.accdb) files
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

use crate::format::ColumnType;
use crate::table::ColumnDef;

use super::DdlDialect;

pub struct Mysql;

impl DdlDialect for Mysql {
    fn quote_id(&self, name: &str) -> String {
        format!("`{}`", name.replace('`', "``"))
    }

    fn map_column_type(&self, col: &ColumnDef, is_auto: bool) -> String {
        if is_auto {
            return "INT NOT NULL AUTO_INCREMENT".to_string();
        }
        match col.col_type {
            ColumnType::Boolean => "BOOLEAN".to_string(),
            ColumnType::Byte => "TINYINT UNSIGNED".to_string(),
            ColumnType::Int => "SMALLINT".to_string(),
            ColumnType::Long => "INT".to_string(),
            ColumnType::Money => "DECIMAL(19,4)".to_string(),
            ColumnType::Float => "FLOAT".to_string(),
            ColumnType::Double => "DOUBLE".to_string(),
            ColumnType::Timestamp => "DATETIME".to_string(),
            ColumnType::Binary => format!("VARBINARY({})", col.col_size),
            ColumnType::Text => format!("VARCHAR({})", col.col_size),
            ColumnType::Memo => "LONGTEXT".to_string(),
            ColumnType::Ole => "LONGBLOB".to_string(),
            ColumnType::Guid => "CHAR(36)".to_string(),
            ColumnType::Numeric => format!("DECIMAL({},{})", col.precision, col.scale),
            ColumnType::ComplexType => "INT".to_string(),
            ColumnType::BigInt => "BIGINT".to_string(),
            ColumnType::DateTimeExtended => "DATETIME(6)".to_string(),
            ColumnType::Unknown(_) => "LONGBLOB".to_string(),
        }
    }

    fn auto_increment_absorbs_pk(&self) -> bool {
        false
    }

    fn inline_foreign_keys(&self) -> bool {
        false
    }
}