csv-sql 0.4.0

A simple CLI tool to generate SQL tables from CSV files
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

use crate::prelude::*;

fn is_csv_file(file_path: &Path) -> bool {
    file_path.extension().map_or(false, |ext| ext == "csv")
}

fn path_to_string(path: &Path) -> String {
    format!("{}", path.to_str().unwrap_or("invalid path"))
}


pub fn validate_file_paths(paths: &Vec<&Path>) -> Result<(), (Vec<String>, Vec<String>)> {
    let mut ok_paths: Vec<String> = vec![];
    let mut errors: Vec<String> = vec![];

    for path in paths {
        if let Ok(metadata) = fs::metadata(path) {
            if metadata.is_file() {
                if is_csv_file(path) {
                    ok_paths.push(format!("{}", path_to_string(path).on_green()));
                } else {
                    errors.push(format!("{} - not a CSV file", path_to_string(path).on_red()));
                }
            } else {
                errors.push(format!("{} - not a file", path_to_string(path).on_red()));
            }
        } else {
            errors.push(format!("{} - invalid file path", path_to_string(path).on_red()));
        }
    }

    if errors.len() > 0 {
        return Err((ok_paths, errors));
    }

    return Ok(());
}