csvpp 0.6.1

Compile csv++ source code to a target spreadsheet format
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

//! # `DateTime`
//!
//! How we handle dates and times (or both together).  This is mostly a wrapper around `chrono` but
//! it's important that we handle timezones and parsing uniformly across the app.
mod display;
mod try_from;

#[derive(Clone, Debug, PartialEq, serde::Deserialize, serde::Serialize)]
pub enum DateTime {
    Date(chrono::NaiveDate),
    DateAndTime(chrono::NaiveDateTime),
    Time(chrono::NaiveTime),
}

fn date_epoch() -> chrono::NaiveDate {
    chrono::NaiveDate::from_ymd_opt(1900, 1, 1).unwrap()
}

impl DateTime {
    /// Kinda odd but Excel references Dates as days since January 1, 1900 (we don't support other
    /// use-cases (for now))
    pub(crate) fn distance_from_epoch(&self) -> i64 {
        match self {
            Self::Date(d) => d.signed_duration_since(date_epoch()).num_days(),
            // TODO: nothing uses these... but this is kinda a footgun, we should implement it
            _ => unimplemented!(),
        }
    }
}

#[cfg(test)]
mod tests {
    use super::*;

    #[test]
    fn distance_from_epoch_date() {
        assert_eq!(
            DateTime::Date(chrono::NaiveDate::from_ymd_opt(2012, 10, 22).unwrap())
                .distance_from_epoch(),
            41202
        );
    }
}