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 Sqlite;

impl DdlDialect for Sqlite {
    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 "INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT".to_string();
        }
        match col.col_type {
            ColumnType::Boolean => "INTEGER".to_string(),
            ColumnType::Byte => "INTEGER".to_string(),
            ColumnType::Int => "INTEGER".to_string(),
            ColumnType::Long => "INTEGER".to_string(),
            ColumnType::Money => "NUMERIC".to_string(),
            ColumnType::Float => "REAL".to_string(),
            ColumnType::Double => "REAL".to_string(),
            ColumnType::Timestamp => "TEXT".to_string(),
            ColumnType::Binary => "BLOB".to_string(),
            ColumnType::Text => "TEXT".to_string(),
            ColumnType::Memo => "TEXT".to_string(),
            ColumnType::Ole => "BLOB".to_string(),
            ColumnType::Guid => "TEXT".to_string(),
            ColumnType::Numeric => "NUMERIC".to_string(),
            ColumnType::ComplexType => "INTEGER".to_string(),
            ColumnType::BigInt => "INTEGER".to_string(),
            ColumnType::DateTimeExtended => "TEXT".to_string(),
            ColumnType::Unknown(_) => "BLOB".to_string(),
        }
    }

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

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