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

use serde::{Deserialize, Serialize};
use sqlparser::ast as sql;
use std::fmt;

/// coarse value from the parsing
/// this is close to the json values
///
/// TODO: include Integer variant
#[derive(Debug, PartialEq, Clone, Serialize, Deserialize)]
pub enum Value {
    Null,
    String(String),
    Number(f64),
    Bool(bool),
}

/// if string is empty use the default value in the underlying database
impl Into<sql::Value> for &Value {
    fn into(self) -> sql::Value {
        match self {
            Value::Null => sql::Value::Null,
            Value::String(v) => {
                if v.is_empty() {
                    sql::Value::Null
                } else {
                    sql::Value::SingleQuotedString(v.to_string())
                }
            }
            Value::Number(v) => sql::Value::Number(format!("{}", v), false),
            Value::Bool(v) => sql::Value::Boolean(*v),
        }
    }
}

impl fmt::Display for Value {
    fn fmt(&self, f: &mut fmt::Formatter) -> fmt::Result {
        match self {
            Value::Null => write!(f, "null"),
            Value::String(v) => write!(f, "'{}'", v),
            Value::Number(v) => write!(f, "{}", v),
            Value::Bool(v) => write!(f, "{}", v),
        }
    }
}