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
|
use yaml_rust::yaml;
use std::borrow::Cow;
pub struct Yaml<'a>(pub Cow<'a, yaml::Yaml>);
// impl<'a, Y> From<Y> for Yaml<'a>
// where Y: Into<yaml_rust::Yaml>
// {
// fn from(yaml: Y) -> Self {
// Self(Cow::from(yaml))
// }
// }
// impl From<
impl<'a> rusqlite::ToSql for Yaml<'a> {
fn to_sql(&self) -> rusqlite::Result<rusqlite::types::ToSqlOutput<'_>> {
use rusqlite::types::ToSqlOutput;
let sql_output = match *self.0 {
yaml::Yaml::Real(_) => match self.0.as_f64() {
Some(v) => ToSqlOutput::from(v),
None => ToSqlOutput::from(rusqlite::types::Null),
},
yaml::Yaml::Integer(_) => match self.0.as_i64() {
Some(v) => ToSqlOutput::from(v),
None => ToSqlOutput::from(rusqlite::types::Null),
},
yaml::Yaml::String(_) => match self.0.as_str() {
Some(v) => ToSqlOutput::from(v),
None => ToSqlOutput::from(rusqlite::types::Null),
},
yaml::Yaml::Boolean(_) => match self.0.as_bool() {
Some(v) => ToSqlOutput::from(v),
None => ToSqlOutput::from(rusqlite::types::Null),
},
yaml::Yaml::Array(_) => ToSqlOutput::from(rusqlite::types::Null),
yaml::Yaml::Hash(_) => ToSqlOutput::from(rusqlite::types::Null),
yaml::Yaml::Alias(_) => ToSqlOutput::from(rusqlite::types::Null),
yaml::Yaml::Null => ToSqlOutput::from(rusqlite::types::Null),
yaml::Yaml::BadValue => ToSqlOutput::from(rusqlite::types::Null),
};
Ok(sql_output)
}
}
impl<'a> rusqlite::types::FromSql for Yaml<'a> {
fn column_result(
value: rusqlite::types::ValueRef<'_>,
) -> rusqlite::types::FromSqlResult<Self> {
use rusqlite::types::ValueRef;
match value {
ValueRef::Integer(i) => Ok(
Yaml(Cow::Owned(yaml_rust::Yaml::Integer(i))),
),
ValueRef::Real(f) =>
Ok(Yaml(Cow::Owned(yaml_rust::Yaml::Real(f.to_string())))),
ValueRef::Text(_) => {
let s = value.as_str()?;
Ok(Yaml(Cow::Owned(yaml_rust::Yaml::String(s.to_owned()))))
}
ValueRef::Blob(_) => {
// TODO: How should we handle blobs? Parsing as string might not
// make the most sense.
let b = value.as_str()?;
Ok(Yaml(Cow::Owned(yaml_rust::Yaml::String(b.to_owned()))))
}
ValueRef::Null => Ok(Yaml(Cow::Owned(yaml_rust::Yaml::Null))),
}
}
}
|