odict 3.3.0

A blazingly-fast dictionary file format for human languages
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

use sea_query::{
    InsertStatement, MysqlQueryBuilder, PostgresQueryBuilder, SqliteQueryBuilder,
    TableCreateStatement,
};

pub struct SQLBuilder {
    dialect: SQLDialect,
    schema: Vec<TableCreateStatement>,
    queries: Vec<InsertStatement>,
}

impl SQLBuilder {
    pub fn new(dialect: SQLDialect) -> Self {
        SQLBuilder {
            dialect,
            schema: Vec::new(),
            queries: Vec::new(),
        }
    }

    pub fn add_table(&mut self, cmd: &TableCreateStatement) {
        self.schema.push(cmd.to_owned());
    }

    pub fn add_insert(&mut self, cmd: &InsertStatement) {
        self.queries.push(cmd.to_owned());
    }

    pub fn build(&self) -> crate::Result<String> {
        let mut tables = self
            .schema
            .iter()
            .map(|cmd| match self.dialect {
                SQLDialect::Postgres => cmd.to_string(PostgresQueryBuilder),
                SQLDialect::MySQL => cmd.to_string(MysqlQueryBuilder),
                SQLDialect::SQLite => cmd.to_string(SqliteQueryBuilder),
            })
            .collect::<Vec<String>>();

        let mut queries = self
            .queries
            .iter()
            .map(|cmd| match self.dialect {
                SQLDialect::Postgres => cmd.to_string(PostgresQueryBuilder),
                SQLDialect::MySQL => cmd.to_string(MysqlQueryBuilder),
                SQLDialect::SQLite => cmd.to_string(SqliteQueryBuilder),
            })
            .collect::<Vec<String>>();

        tables.append(&mut queries);

        Ok(tables.join(";\n"))
    }
}

pub enum SQLDialect {
    Postgres,
    MySQL,
    SQLite,
}