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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95

// Copyright Materialize, Inc. and contributors. All rights reserved.
//
// Use of this software is governed by the Business Source License
// included in the LICENSE file.
//
// As of the Change Date specified in that file, in accordance with
// the Business Source License, use of this software will be governed
// by the Apache License, Version 2.0.

use chrono::NaiveTime;
use mz_ore::cast::CastLossy;
use mz_repr::adt::interval::{Interval, USECS_PER_DAY};
use mz_repr::strconv;
use num::traits::CheckedNeg;

use crate::EvalError;

sqlfunc!(
    #[sqlname = "interval_to_text"]
    #[preserves_uniqueness = true]
    #[inverse = to_unary!(super::CastStringToInterval)]
    fn cast_interval_to_string(a: Interval) -> String {
        let mut buf = String::new();
        strconv::format_interval(&mut buf, a);
        buf
    }
);

sqlfunc!(
    #[sqlname = "interval_to_time"]
    #[preserves_uniqueness = false]
    #[inverse = to_unary!(super::CastTimeToInterval)]
    fn cast_interval_to_time(i: Interval) -> NaiveTime {
        // Modeled after the PostgreSQL implementation:
        // https://github.com/postgres/postgres/blob/6a1ea02c491d16474a6214603dce40b5b122d4d1/src/backend/utils/adt/date.c#L2003-L2027
        let mut result = i.micros % *USECS_PER_DAY;
        if result < 0 {
            result += *USECS_PER_DAY;
        }

        let i = Interval::new(0, 0, result);

        let hours: u32 = i
            .hours()
            .try_into()
            .expect("interval is positive and hours() returns a value in the range [-24, 24]");
        let minutes: u32 = i
            .minutes()
            .try_into()
            .expect("interval is positive and minutes() returns a value in the range [-60, 60]");
        let seconds: u32 = i64::cast_lossy(i.seconds::<f64>()).try_into().expect(
            "interval is positive and seconds() returns a value in the range [-60.0, 60.0]",
        );
        let nanoseconds: u32 =
            i.nanoseconds().try_into().expect(
                "interval is positive and nanoseconds() returns a value in the range [-1_000_000_000, 1_000_000_000]",
            );

        NaiveTime::from_hms_nano_opt(hours, minutes, seconds, nanoseconds).unwrap()
    }
);

sqlfunc!(
    #[sqlname = "-"]
    #[preserves_uniqueness = true]
    #[inverse = to_unary!(super::NegInterval)]
    fn neg_interval(i: Interval) -> Result<Interval, EvalError> {
        i.checked_neg()
            .ok_or(EvalError::IntervalOutOfRange(i.to_string().into()))
    }
);

sqlfunc!(
    #[sqlname = "justify_days"]
    fn justify_days(i: Interval) -> Result<Interval, EvalError> {
        i.justify_days()
            .map_err(|_| EvalError::IntervalOutOfRange(i.to_string().into()))
    }
);

sqlfunc!(
    #[sqlname = "justify_hours"]
    fn justify_hours(i: Interval) -> Result<Interval, EvalError> {
        i.justify_hours()
            .map_err(|_| EvalError::IntervalOutOfRange(i.to_string().into()))
    }
);

sqlfunc!(
    #[sqlname = "justify_interval"]
    fn justify_interval(i: Interval) -> Result<Interval, EvalError> {
        i.justify_interval()
            .map_err(|_| EvalError::IntervalOutOfRange(i.to_string().into()))
    }
);