sql_reverse 0.1.21

Generate the multiple programming languages structure based on the MySQL/PostgresSQL table structure
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

use crate::error::Result;
use crate::reverse_impl::{clickhouse_impl, mysql_impl, postgres_impl, sqlite_impl};
use tokio::io::AsyncWriteExt;

pub async fn export() -> Result<()> {
    let mysql_default = mysql_impl::FIELD_TYPE.read().unwrap().clone();
    let postgres_default = postgres_impl::FIELD_TYPE.read().unwrap().clone();
    let sqlite_default = sqlite_impl::FIELD_TYPE.read().unwrap().clone();
    let mysql_default = format!("{:#?}", mysql_default);
    let postgres_default = format!("{:#?}", postgres_default);
    let sqlite_default = format!("{:#?}", sqlite_default);
    let mut fs = tokio::fs::File::options()
        .create(true)
        .truncate(true)
        .write(true)
        .open("./default_mysql.json")
        .await?;
    fs.write_all(mysql_default.replace(",\n}", "\n}").as_bytes())
        .await?;
    let mut fs = tokio::fs::File::options()
        .create(true)
        .truncate(true)
        .write(true)
        .open("./default_postgres.json")
        .await?;
    fs.write_all(postgres_default.replace(",\n}", "\n}").as_bytes())
        .await?;

    let mut fs = tokio::fs::File::options()
        .create(true)
        .truncate(true)
        .write(true)
        .open("./default_sqlite.json")
        .await?;
    fs.write_all(sqlite_default.replace(",\n}", "\n}").as_bytes())
        .await?;

    let clickhouse_default = clickhouse_impl::FIELD_TYPE.read().unwrap().clone();
    let clickhouse_default = format!("{:#?}", clickhouse_default);
    let mut fs = tokio::fs::File::options()
        .create(true)
        .truncate(true)
        .write(true)
        .open("./default_clickhouse.json")
        .await?;
    fs.write_all(clickhouse_default.replace(",\n}", "\n}").as_bytes())
        .await?;
    Ok(())
}