sqlpage 0.43.0

Build data user interfaces entirely in SQL. A web server that takes .sql files and formats the query result using pre-made configurable professional-looking components.
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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124

use serde::de::Error;
use std::borrow::Cow;
use std::mem;

#[derive(Debug, serde::Serialize, PartialEq, Clone)]
#[serde(untagged)]
pub enum SingleOrVec {
    Single(String),
    Vec(Vec<String>),
}

impl<'de> serde::Deserialize<'de> for SingleOrVec {
    fn deserialize<D>(deserializer: D) -> Result<Self, D::Error>
    where
        D: serde::Deserializer<'de>,
    {
        let value = serde_json::Value::deserialize(deserializer)?;
        match value {
            serde_json::Value::String(s) => Ok(SingleOrVec::Single(s)),
            serde_json::Value::Array(values) => {
                let mut strings = Vec::with_capacity(values.len());
                for (idx, item) in values.into_iter().enumerate() {
                    match item {
                        serde_json::Value::String(s) => strings.push(s),
                        other => {
                            return Err(D::Error::custom(format!(
                                "expected an array of strings, but item at index {idx} is {other}"
                            )))
                        }
                    }
                }
                Ok(SingleOrVec::Vec(strings))
            }
            other => Err(D::Error::custom(format!(
                "expected a string or an array of strings, but found {other}"
            ))),
        }
    }
}

impl std::fmt::Display for SingleOrVec {
    fn fmt(&self, f: &mut std::fmt::Formatter<'_>) -> std::fmt::Result {
        match self {
            SingleOrVec::Single(x) => write!(f, "{x}"),
            SingleOrVec::Vec(v) => {
                write!(f, "[")?;
                let mut it = v.iter();
                if let Some(first) = it.next() {
                    write!(f, "{first}")?;
                }
                for item in it {
                    write!(f, ", {item}")?;
                }
                write!(f, "]")
            }
        }
    }
}

impl SingleOrVec {
    pub(crate) fn merge(&mut self, other: Self) {
        match (self, other) {
            (Self::Single(old), Self::Single(new)) => *old = new,
            (old, mut new) => {
                let mut v = old.take_vec();
                v.extend_from_slice(&new.take_vec());
                *old = Self::Vec(v);
            }
        }
    }

    fn take_vec(&mut self) -> Vec<String> {
        match self {
            SingleOrVec::Single(x) => vec![mem::take(x)],
            SingleOrVec::Vec(v) => mem::take(v),
        }
    }

    #[must_use]
    pub fn as_json_str(&self) -> Cow<'_, str> {
        match self {
            SingleOrVec::Single(x) => Cow::Borrowed(x),
            SingleOrVec::Vec(v) => Cow::Owned(serde_json::to_string(v).unwrap()),
        }
    }
}

#[cfg(test)]
mod single_or_vec_tests {
    use super::SingleOrVec;

    #[test]
    fn deserializes_string_and_array_values() {
        let single: SingleOrVec = serde_json::from_str(r#""hello""#).unwrap();
        assert_eq!(single, SingleOrVec::Single("hello".to_string()));
        let array: SingleOrVec = serde_json::from_str(r#"["a","b"]"#).unwrap();
        assert_eq!(
            array,
            SingleOrVec::Vec(vec!["a".to_string(), "b".to_string()])
        );
    }

    #[test]
    fn rejects_non_string_items() {
        let err = serde_json::from_str::<SingleOrVec>(r#"["a", 1]"#).unwrap_err();
        assert!(
            err.to_string()
                .contains("expected an array of strings, but item at index 1 is 1"),
            "{err}"
        );
    }

    #[test]
    fn displays_single_value() {
        let single = SingleOrVec::Single("hello".to_string());
        assert_eq!(single.to_string(), "hello");
    }

    #[test]
    fn displays_array_values() {
        let array = SingleOrVec::Vec(vec!["a".to_string(), "b".to_string()]);
        assert_eq!(array.to_string(), "[a, b]");
    }
}