Skip to main content

che_orm/
json.rs

1use crate::{ColumnType, ColumnTypeOf, DatabaseValue, DecodeError, FromDatabaseValue, QueryValue};
2
3/// JSON stored as SQL TEXT and serialized as a JSON value, never as an escaped string.
4#[derive(Debug, Clone, PartialEq, crate::serde::Serialize, crate::serde::Deserialize)]
5#[serde(transparent)]
6pub struct JsonField(pub crate::serde_json::Value);
7
8impl ColumnTypeOf for JsonField {
9    fn column_type() -> ColumnType {
10        ColumnType::Text
11    }
12}
13
14impl QueryValue<JsonField> for JsonField {
15    fn into_query_value(self) -> DatabaseValue {
16        DatabaseValue::Text(self.0.to_string())
17    }
18}
19
20impl FromDatabaseValue for JsonField {
21    fn from_database_value(value: &DatabaseValue) -> Result<Self, DecodeError> {
22        let text = String::from_database_value(value)?;
23        crate::serde_json::from_str(&text)
24            .map(Self)
25            .map_err(|error| DecodeError::InvalidValue(error.to_string()))
26    }
27}
28
29#[cfg(feature = "sqlite")]
30impl crate::rusqlite::types::ToSql for JsonField {
31    fn to_sql(&self) -> crate::rusqlite::Result<crate::rusqlite::types::ToSqlOutput<'_>> {
32        Ok(crate::rusqlite::types::ToSqlOutput::Owned(
33            self.0.to_string().into(),
34        ))
35    }
36}
37
38#[cfg(feature = "sqlite")]
39impl crate::rusqlite::types::FromSql for JsonField {
40    fn column_result(
41        value: crate::rusqlite::types::ValueRef<'_>,
42    ) -> crate::rusqlite::types::FromSqlResult<Self> {
43        crate::serde_json::from_str(value.as_str()?)
44            .map(Self)
45            .map_err(|error| crate::rusqlite::types::FromSqlError::Other(Box::new(error)))
46    }
47}