1use crate::{ColumnType, ColumnTypeOf, DatabaseValue, DecodeError, FromDatabaseValue, QueryValue};
2
3#[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}