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
95
96
97
98
99
100
101
102
103
104
105
106

use crate::database::lib::Database;
use crate::database::lib::DatabaseType;
use crate::database::DB;
use crate::{error::LunaOrmError, LunaOrmResult};

use sqlx::any::AnyConnectOptions;
use sqlx::sqlite::{SqliteConnectOptions, SqliteJournalMode, SqlitePool, SqliteSynchronous};
use sqlx::AnyPool;

use std::fs;
use std::path::Path;
use std::str::FromStr;

use crate::command_executor::CommandExecutor;
use crate::sql_executor::SqlExecutor;
use crate::sql_generator::DefaultSqlGenerator;

use path_absolutize::*;

pub struct SqliteLocalConfig {
    pub work_dir: String,
    pub db_file: String,
}

impl SqliteLocalConfig {
    pub fn new(work_dir: &str, db_file: &str) -> Self {
        Self {
            work_dir: work_dir.to_string(),
            db_file: db_file.to_string(),
        }
    }
}

pub struct SqliteDatabase {
    database_type: DatabaseType,
    pool: AnyPool,
    sql_generator: DefaultSqlGenerator,
}

impl SqlExecutor for SqliteDatabase {
    fn get_pool(&self) -> LunaOrmResult<&AnyPool> {
        Ok(&self.pool)
    }
}

impl CommandExecutor for SqliteDatabase {
    type G = DefaultSqlGenerator;

    fn get_generator(&self) -> &Self::G {
        &self.sql_generator
    }
}

impl Database for SqliteDatabase {
    fn get_type(&self) -> &DatabaseType {
        &self.database_type
    }
}

impl From<SqliteDatabase> for DB<SqliteDatabase> {
    fn from(value: SqliteDatabase) -> Self {
        Self(value)
    }
}

impl SqliteDatabase {
    pub async fn init_local_sqlite(workspace_dir: &str, db_file: &str) -> LunaOrmResult<AnyPool> {
        let workspace = Path::new(workspace_dir);
        let workspace_absolute = workspace
            .absolutize()
            .map_err(|_e| LunaOrmError::DatabaseInitFail("workdir absolute fail".to_string()))?;

        fs::create_dir_all(&workspace_absolute)
            .map_err(|_e| LunaOrmError::DatabaseInitFail("create dir fail".to_string()))?;
        let db_file_path = workspace_absolute.join(db_file);
        {
            let options = SqliteConnectOptions::new()
                .filename(db_file_path.clone())
                .synchronous(SqliteSynchronous::Full)
                .journal_mode(SqliteJournalMode::Wal)
                .create_if_missing(true);
            let _ = SqlitePool::connect_with(options).await.map_err(|_e| {
                LunaOrmError::DatabaseInitFail("create is missing fail".to_string())
            })?;
        }

        sqlx::any::install_default_drivers();
        let url = format!("sqlite:{}", db_file_path.to_str().unwrap());
        let any_options = AnyConnectOptions::from_str(&url).unwrap();
        let any_pool = AnyPool::connect_with(any_options)
            .await
            .map_err(|_e| LunaOrmError::DatabaseInitFail("init pool fail".to_string()))?;
        return Ok(any_pool);
    }

    pub async fn build(config: SqliteLocalConfig) -> LunaOrmResult<Self> {
        let pool = SqliteDatabase::init_local_sqlite(&config.work_dir, &config.db_file).await?;
        let generator = DefaultSqlGenerator::new();
        let database = SqliteDatabase {
            database_type: DatabaseType::SqliteLocal,
            pool,
            sql_generator: generator,
        };
        return Ok(database);
    }
}