diesel/pg/expression/
date_and_time.rs

Help
1use crate::expression::{Expression, ValidGrouping};
2use crate::pg::Pg;
3use crate::query_builder::*;
4use crate::result::QueryResult;
5use crate::sql_types::{is_nullable, Date, Nullable, SqlType, Timestamp, Timestamptz, VarChar};
6
7/// Marker trait for types which are valid in `AT TIME ZONE` expressions
8pub trait DateTimeLike {}
9impl DateTimeLike for Date {}
10impl DateTimeLike for Timestamp {}
11impl DateTimeLike for Timestamptz {}
12impl<T> DateTimeLike for Nullable<T> where T: SqlType<IsNull = is_nullable::NotNull> + DateTimeLike {}
13#[derive(Debug, Copy, Clone, QueryId, ValidGrouping)]
14pub struct AtTimeZone<Ts, Tz> {
15    timestamp: Ts,
16    timezone: Tz,
17}
18
19impl<Ts, Tz> AtTimeZone<Ts, Tz> {
20    pub fn new(timestamp: Ts, timezone: Tz) -> Self {
21        AtTimeZone {
22            timestamp: timestamp,
23            timezone: timezone,
24        }
25    }
26}
27
28impl<Ts, Tz> Expression for AtTimeZone<Ts, Tz>
29where
30    Ts: Expression,
31    Ts::SqlType: DateTimeLike,
32    Tz: Expression<SqlType = VarChar>,
33{
34    type SqlType = Timestamp;
35}
36
37impl<Ts, Tz> QueryFragment<Pg> for AtTimeZone<Ts, Tz>
38where
39    Ts: QueryFragment<Pg>,
40    Tz: QueryFragment<Pg>,
41{
42    fn walk_ast<'b>(&'b self, mut out: AstPass<'_, 'b, Pg>) -> QueryResult<()> {
43        self.timestamp.walk_ast(out.reborrow())?;
44        out.push_sql(" AT TIME ZONE ");
45        self.timezone.walk_ast(out.reborrow())?;
46        Ok(())
47    }
48}
49
50impl_selectable_expression!(AtTimeZone<Ts, Tz>);
diesel/pg/expression/date_and_time.rs

diesel/pg/expression/
date_and_time.rs
