use derive_more::{Deref, Display, From, Into};
use diesel::backend::Backend;
use diesel::deserialize::{self as de, FromSql, FromSqlRow};
use diesel::expression::AsExpression;
use diesel::serialize::{self as ser, IsNull, Output, ToSql};
use diesel::sql_types::Text;
use diesel::sqlite::Sqlite;
use jiff::Zoned;
use serde::{Deserialize, Serialize};
use std::str::FromStr;
#[derive(
FromSqlRow, AsExpression, Clone, Debug, Deref, Display, From, Into, Deserialize, Serialize,
)]
#[diesel(sql_type = Text)]
pub struct db_Zoned(Zoned);
impl db_Zoned {
pub fn now() -> Self {
Self(Zoned::now())
}
}
impl FromSql<Text, Sqlite> for db_Zoned {
fn from_sql(bytes: <Sqlite as Backend>::RawValue<'_>) -> de::Result<Self> {
let value = <String as FromSql<Text, Sqlite>>::from_sql(bytes)?;
Ok(db_Zoned(Zoned::from_str(value.as_str())?))
}
}
impl ToSql<Text, Sqlite> for db_Zoned
where
String: ToSql<Text, Sqlite>,
{
fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> ser::Result {
out.set_value(self.to_string());
Ok(IsNull::No)
}
}