date-rs 1.6.0

Gregorian calendar date
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

//! Integration with DuckDB.

use duckdb::Result;
use duckdb::types::FromSql;
use duckdb::types::FromSqlError;
use duckdb::types::FromSqlResult;
use duckdb::types::ToSql;
use duckdb::types::ToSqlOutput;
use duckdb::types::ValueRef;

use crate::Date;

impl FromSql for Date {
  fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self> {
    match value {
      ValueRef::Date32(d) => Ok(Self(d)),
      _ => Err(FromSqlError::InvalidType),
    }
  }
}

impl ToSql for Date {
  fn to_sql(&self) -> Result<ToSqlOutput<'_>> {
    Ok(ToSqlOutput::Borrowed(ValueRef::Date32(self.0)))
  }
}

#[cfg(test)]
mod tests {
  use assert2::check;

  use super::*;
  use crate::date;

  #[test]
  fn test_from_sql() -> FromSqlResult<()> {
    let input = ValueRef::Date32(15_451);
    let date = Date::column_result(input)?;
    check!(date == date! { 2012-04-21 });
    Ok(())
  }

  #[test]
  fn test_to_sql() -> Result<()> {
    let dt = date! { 2012-04-21 };
    let output = dt.to_sql()?;
    if let ToSqlOutput::Borrowed(ValueRef::Date32(i)) = output {
      check!(i == 15_451);
    } else {
      check!(false, "Incorrect type");
    }
    Ok(())
  }
}