restq 0.9.1

Compacting SQL query into a URL suitable for rest api calls
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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76

/// StmtData, this contains both statement and the data
use crate::{ast::parser::utils::bytes_to_chars, ast::Statement, CsvRows};
use parser::parse_statement_chars;
pub use parser::{parse_header, parse_select_chars};
use std::io::{BufRead, BufReader, Read};

mod parser;

/// Contains both the statement commands and the data
pub struct StmtData<R>
where
    R: Read + Send + Sync,
{
    pub header: Statement,
    pub body: BufReader<R>,
}

impl<R> StmtData<R>
where
    R: Read + Send + Sync,
{
    pub fn from_reader(reader: R) -> Result<Self, crate::Error> {
        let mut bufread = BufReader::new(reader);
        let mut first_line = vec![];
        let _header_len = bufread.read_until(b'\n', &mut first_line)?;

        let header_input = bytes_to_chars(&first_line);
        let statement = parse_statement_chars(&header_input)?;

        Ok(StmtData {
            header: statement,
            body: bufread,
        })
    }

    pub fn statement(&self) -> Statement {
        self.header.clone()
    }

    /// consume self and return as csv rows iterator
    pub fn rows_iter(self) -> Option<CsvRows<R>> {
        match self.header {
            Statement::Select(_) => None,
            Statement::Delete(_) => None,
            Statement::AlterTable(_) => None,
            Statement::DropTable(_) => None,
            Statement::Update(_) => None,
            Statement::Create(_) => Some(CsvRows::new(self.body)),
            Statement::Insert(_) => Some(CsvRows::new(self.body)),
            Statement::BulkDelete(_) => Some(CsvRows::new(self.body)),
            Statement::BulkUpdate(_) => Some(CsvRows::new(self.body)),
        }
    }
}

#[cfg(test)]
mod tests {
    use super::*;
    use crate::ast::Value;

    #[test]
    fn test_csv_data() {
        let data = "PUT /product{*product_id:s32,@name:text,description:text,updated:utc,created_by(users):u32,@is_active:bool}\n\
            1,go pro,a slightly used go pro, 2019-10-31 10:10:10\n\
            2,shovel,a slightly used shovel, 2019-11-11 11:11:11\n\
            ";

        let csv_data =
            StmtData::from_reader(data.as_bytes()).expect("must be valid");

        let rows: Vec<Vec<Value>> =
            csv_data.rows_iter().expect("must have iterator").collect();
        println!("rows: {:#?}", rows);
        assert_eq!(rows.len(), 2);
    }
}