5 releases
0.8.1 | Dec 2, 2022 |
---|---|
0.1.3 | Nov 8, 2022 |
0.1.2 | Nov 3, 2022 |
0.1.1 | Nov 1, 2022 |
0.1.0 | Nov 1, 2022 |
#383 in Date and time
140KB
3K
SLoC
chrono-tz-postgres
A timezone type that can be converted to and from a custom Postgres type. This allows you to use typed timezones in PostgreSQL.
The custom Postgres enum tz
is equivalent to the Rust enum chrono_tz::Tz
. It can be found here.
The version number mirrors chrono-tz
.
chrono-tz-postgres in action
use chrono_tz::Tz;
use chrono_tz_postgres::TzPg;
use postgres::{Client, NoTls};
fn main() -> Result<(), Box<dyn std::error::Error>> {
// We can convert between Tz and TzPg
let tz = Tz::Arctic__Longyearbyen;
let tzpg = TzPg::from(tz);
let tz: Tz = tzpg.into();
println!("{}", tz);
// Tz can be serialized, unlike TzPg
serde_json::to_string(&tz)?;
// but TzPg can interface with Postgres
let mut client = Client::connect("host=localhost user=postgres", NoTls)?;
// timezone the column name, whose type is `tz`
// `tz` is a custom Postgres type
let row = client.query_one("SELECT timezone FROM foo LIMIT 1", &[])?;
let tz: TzPg = row.get(0);
// Convert back to Tz to do more
let tz: Tz = tz.into();
println!("{}", tz);
Ok(())
}
Dependencies
~4.5–6MB
~131K SLoC