elephantry 5.1.1

Object model manager for PostgreSQL
Documentation 
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

impl crate::ToSql for jiff::Zoned {
    fn ty(&self) -> crate::pq::Type {
        crate::pq::types::TIMESTAMPTZ
    }

    /*
     * https://github.com/postgres/postgres/blob/REL_12_0/src/backend/utils/adt/timestamp.c#L756
     */
    fn to_text(&self) -> crate::Result<Option<String>> {
        self.strftime("%F %T%z").to_string().to_text()
    }

    /*
     * https://github.com/postgres/postgres/blob/REL_12_0/src/backend/utils/adt/timestamp.c#L818
     */
    fn to_binary(&self) -> crate::Result<Option<Vec<u8>>> {
        self.with_time_zone(jiff::tz::TimeZone::UTC)
            .datetime()
            .to_binary()
    }
}

impl crate::FromSql for jiff::Zoned {
    /*
     * https://github.com/postgres/postgres/blob/REL_12_0/src/backend/utils/adt/timestamp.c#L386
     */
    fn from_text(ty: &crate::pq::Type, raw: Option<&str>) -> crate::Result<Self> {
        let s = crate::from_sql::not_null(raw)?;

        jiff::Zoned::strptime("%F %T%z", format!("{s}00")).map_err(|_| Self::error(ty, raw))
    }

    /*
     * https://github.com/postgres/postgres/blob/REL_12_0/src/backend/utils/adt/timestamp.c#L784
     */
    fn from_binary(ty: &crate::pq::Type, raw: Option<&[u8]>) -> crate::Result<Self> {
        let civil = jiff::civil::DateTime::from_binary(ty, raw)?;

        civil
            .to_zoned(jiff::tz::TimeZone::UTC)
            .map_err(|_| Self::error(ty, raw))
    }
}

impl crate::entity::Simple for jiff::Zoned {}

#[cfg(test)]
mod test {
    crate::sql_test!(
        timestamptz,
        jiff::Zoned,
        [(
            "'1970-01-01 00:00:00+00'",
            jiff::civil::date(1970, 1, 1)
                .at(0, 0, 0, 0)
                .to_zoned(jiff::tz::TimeZone::UTC)
                .unwrap(),
        )]
    );
}