#chrono #duration #diesel #time

diesel-chrono-duration

Adds chrono::Duration support to the diesel

3 releases (stable)

1.1.0 Dec 5, 2023
1.0.0 Jun 15, 2019
0.1.0 Feb 16, 2018

#141 in Date and time

Download history 22/week @ 2024-02-19 6/week @ 2024-02-26 5/week @ 2024-03-11 60/week @ 2024-04-01

65 downloads per month

MIT license

7KB

diesel-chrono-duration

CI MIT licensed

This crate adds support for the chrono::Duration type into the diesel ORM.

Why

Diesel crate has a policy of including only such type implementations which can be represented as is in the SQL types. chrono::Duration does not have a direct 1-to-1 mapping in both the SQLite and PostgreSQL.

How

The chrono::Duration type stores its value as i64 number. This is exactly 8 bytes and such types are BigInteger and BigInt. So, the ToSql and FromSql traits implementation simply uses chrono::Duration's inner i64 value.

Usage

To implement this we added ChronoDurationProxy type which is just a strong type as defined as:

pub struct ChronoDurationProxy(pub chrono::Duration);

In your table model you use it instead of chrono::Duration:

extern crate diesel_chrono_duration;

use diesel_chrono_duration::ChronoDurationProxy;

#[derive(Debug, Clone, Queryable, Insertable)]
#[table_name = "sometable"]
pub struct SomeTable {
    /// The ID of the record in the table.
    pub id: i32,
    /// Some duration
    pub duration: ChronoDurationProxy,
}

Later, when you want to use it's value as chrono::Duration you have these options:

  • *duration returns a reference to the inner chrono::Duration object. It is done by the Deref trait.
  • &duration also returns a reference to the inner chrono::Duration object. It is done by the AsRef trait.
  • duration.0 as in usual rust.

Contribute

The project is very simple and small but all contributions are "please make a contribution". Thanks in advance.

License

This project is licensed under the MIT license.

Dependencies

~3.5MB
~69K SLoC