sql-cli 1.67.2

SQL query tool for CSV/JSON with both interactive TUI and non-interactive CLI modes - perfect for exploration and automation
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

use std::error::Error;
use std::fs;
use std::path::PathBuf;

pub struct AppPaths;

impl AppPaths {
    pub fn data_dir() -> Result<PathBuf, Box<dyn Error>> {
        let data_dir = dirs::data_dir()
            .ok_or("Cannot determine data directory")?
            .join("sql-cli");

        fs::create_dir_all(&data_dir)?;
        Ok(data_dir)
    }

    pub fn cache_dir() -> Result<PathBuf, Box<dyn Error>> {
        let cache_dir = dirs::cache_dir()
            .ok_or("Cannot determine cache directory")?
            .join("sql-cli");

        fs::create_dir_all(&cache_dir)?;
        Ok(cache_dir)
    }

    pub fn history_file() -> Result<PathBuf, Box<dyn Error>> {
        Ok(Self::data_dir()?.join("history.json"))
    }

    pub fn schemas_file() -> Result<PathBuf, Box<dyn Error>> {
        Ok(Self::data_dir()?.join("schemas.json"))
    }

    pub fn cache_metadata_file() -> Result<PathBuf, Box<dyn Error>> {
        Ok(Self::cache_dir()?.join("metadata.json"))
    }

    pub fn cache_data_dir() -> Result<PathBuf, Box<dyn Error>> {
        let data_dir = Self::cache_dir()?.join("data");
        fs::create_dir_all(&data_dir)?;
        Ok(data_dir)
    }
}