use chrono::{DateTime, FixedOffset, Utc};
pub const UTC_OFFSET: FixedOffset = {
match FixedOffset::east_opt(0) {
Some(offset) => offset,
None => panic!("UTC offset is always valid"),
}
};
#[inline]
pub fn to_db_datetime(dt: DateTime<Utc>) -> DateTime<FixedOffset> {
dt.with_timezone(&UTC_OFFSET)
}
#[inline]
pub fn to_db_datetime_opt(dt: Option<DateTime<Utc>>) -> Option<DateTime<FixedOffset>> {
dt.map(|d| d.with_timezone(&UTC_OFFSET))
}
#[inline]
pub fn from_db_datetime(dt: DateTime<FixedOffset>) -> DateTime<Utc> {
dt.with_timezone(&Utc)
}
#[inline]
pub fn from_db_datetime_opt(dt: Option<DateTime<FixedOffset>>) -> Option<DateTime<Utc>> {
dt.map(|d| d.with_timezone(&Utc))
}
#[cfg(test)]
mod tests {
use super::*;
use chrono::TimeZone;
#[test]
fn test_utc_offset_is_valid() {
assert_eq!(UTC_OFFSET, FixedOffset::east_opt(0).unwrap());
}
#[test]
fn test_to_db_datetime() {
let now = Utc::now();
let converted = to_db_datetime(now);
assert_eq!(now.timestamp(), converted.timestamp());
assert_eq!(converted.timezone().local_minus_utc(), 0);
}
#[test]
fn test_to_db_datetime_opt_some() {
let now = Utc::now();
let converted = to_db_datetime_opt(Some(now));
assert!(converted.is_some());
let converted = converted.unwrap();
assert_eq!(now.timestamp(), converted.timestamp());
}
#[test]
fn test_to_db_datetime_opt_none() {
let converted = to_db_datetime_opt(None);
assert!(converted.is_none());
}
#[test]
fn test_from_db_datetime() {
let fixed_dt = FixedOffset::east_opt(0)
.unwrap()
.with_ymd_and_hms(2025, 1, 1, 12, 0, 0)
.unwrap();
let converted = from_db_datetime(fixed_dt);
assert_eq!(fixed_dt.timestamp(), converted.timestamp());
}
#[test]
fn test_from_db_datetime_opt_some() {
let fixed_dt = FixedOffset::east_opt(0)
.unwrap()
.with_ymd_and_hms(2025, 1, 1, 12, 0, 0)
.unwrap();
let converted = from_db_datetime_opt(Some(fixed_dt));
assert!(converted.is_some());
let converted = converted.unwrap();
assert_eq!(fixed_dt.timestamp(), converted.timestamp());
}
#[test]
fn test_from_db_datetime_opt_none() {
let converted = from_db_datetime_opt(None);
assert!(converted.is_none());
}
#[test]
fn test_roundtrip_conversion() {
let now = Utc::now();
let to_db = to_db_datetime(now);
let back_to_utc = from_db_datetime(to_db);
assert_eq!(now.timestamp(), back_to_utc.timestamp());
assert_eq!(
now.timestamp_subsec_nanos(),
back_to_utc.timestamp_subsec_nanos()
);
}
}