sql2csv 0.3.1

Export SQL query to csv file
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

use serde::Deserialize;
use std::{fs, path::PathBuf};
use structopt::StructOpt;

fn main() {
    let opt = Opt::from_args();

    dbg!(&opt);

    let sql = match read_header_sql(&opt.input) {
        Some(sql) => sql,
        None => return,
    };

    if let Err(err) = sql2csv::export(&opt.db, opt.out, &sql.sql, &sql.header) {
        eprintln!("Export Error: {}", err);
    }
}

fn read_header_sql(input: &Input) -> Option<Sql> {
    match input {
        Input::File { file } => {
            let file_content = fs::read_to_string(file).ok()?;
            toml::from_str(&file_content).ok()
        }
        Input::Inline(sql) => Some(sql.clone()),
    }
}

#[derive(StructOpt, Debug)]
#[structopt(name = "sql2csv")]
struct Opt {
    #[structopt(long)]
    db: String,
    #[structopt(long, parse(from_os_str))]
    out: PathBuf,
    #[structopt(subcommand)]
    input: Input,
}

#[derive(StructOpt, Debug)]
enum Input {
    File {
        #[structopt(long)]
        file: String,
    },
    Inline(Sql),
}

#[derive(StructOpt, Debug, Deserialize, Clone)]
struct Sql {
    #[structopt(long)]
    header: String,
    #[structopt(long)]
    sql: String,
}