use time_03::{format_description, OffsetDateTime, PrimitiveDateTime};
use tokio_postgres::types::{Date, Timestamp};
use crate::types::test_type;
#[tokio::test]
async fn test_primitive_date_time_params() {
fn make_check(time: &str) -> (Option<PrimitiveDateTime>, &str) {
let format =
format_description::parse("'[year]-[month]-[day] [hour]:[minute]:[second]'").unwrap();
(Some(PrimitiveDateTime::parse(time, &format).unwrap()), time)
}
test_type(
"TIMESTAMP",
&[
make_check("'1970-01-01 00:00:00'"), make_check("'1965-09-25 11:19:33'"), make_check("'2010-02-09 23:11:45'"), (None, "NULL"),
],
)
.await;
}
#[tokio::test]
async fn test_with_special_primitive_date_time_params() {
fn make_check(time: &str) -> (Timestamp<PrimitiveDateTime>, &str) {
let format =
format_description::parse("'[year]-[month]-[day] [hour]:[minute]:[second]'").unwrap();
(
Timestamp::Value(PrimitiveDateTime::parse(time, &format).unwrap()),
time,
)
}
test_type(
"TIMESTAMP",
&[
make_check("'1970-01-01 00:00:00'"), make_check("'1965-09-25 11:19:33'"), make_check("'2010-02-09 23:11:45'"), (Timestamp::PosInfinity, "'infinity'"),
(Timestamp::NegInfinity, "'-infinity'"),
],
)
.await;
}
#[tokio::test]
async fn test_offset_date_time_params() {
fn make_check(time: &str) -> (Option<OffsetDateTime>, &str) {
let format =
format_description::parse("'[year]-[month]-[day] [hour]:[minute]:[second] [offset_hour sign:mandatory][offset_minute]'").unwrap();
(Some(OffsetDateTime::parse(time, &format).unwrap()), time)
}
test_type(
"TIMESTAMP WITH TIME ZONE",
&[
make_check("'1970-01-01 00:00:00 +0000'"), make_check("'1965-09-25 11:19:33 +0000'"), make_check("'2010-02-09 23:11:45 +0000'"), (None, "NULL"),
],
)
.await;
}
#[tokio::test]
async fn test_with_special_offset_date_time_params() {
fn make_check(time: &str) -> (Timestamp<OffsetDateTime>, &str) {
let format =
format_description::parse("'[year]-[month]-[day] [hour]:[minute]:[second] [offset_hour sign:mandatory][offset_minute]'").unwrap();
(
Timestamp::Value(OffsetDateTime::parse(time, &format).unwrap()),
time,
)
}
test_type(
"TIMESTAMP WITH TIME ZONE",
&[
make_check("'1970-01-01 00:00:00 +0000'"), make_check("'1965-09-25 11:19:33 +0000'"), make_check("'2010-02-09 23:11:45 +0000'"), (Timestamp::PosInfinity, "'infinity'"),
(Timestamp::NegInfinity, "'-infinity'"),
],
)
.await;
}
#[tokio::test]
async fn test_date_params() {
fn make_check(date: &str) -> (Option<time_03::Date>, &str) {
let format = format_description::parse("'[year]-[month]-[day]'").unwrap();
(Some(time_03::Date::parse(date, &format).unwrap()), date)
}
test_type(
"DATE",
&[
make_check("'1970-01-01'"),
make_check("'1965-09-25'"),
make_check("'2010-02-09'"),
(None, "NULL"),
],
)
.await;
}
#[tokio::test]
async fn test_with_special_date_params() {
fn make_check(date: &str) -> (Date<time_03::Date>, &str) {
let format = format_description::parse("'[year]-[month]-[day]'").unwrap();
(
Date::Value(time_03::Date::parse(date, &format).unwrap()),
date,
)
}
test_type(
"DATE",
&[
make_check("'1970-01-01'"),
make_check("'1965-09-25'"),
make_check("'2010-02-09'"),
(Date::PosInfinity, "'infinity'"),
(Date::NegInfinity, "'-infinity'"),
],
)
.await;
}
#[tokio::test]
async fn test_time_params() {
fn make_check(time: &str) -> (Option<time_03::Time>, &str) {
let format = format_description::parse("'[hour]:[minute]:[second]'").unwrap();
(Some(time_03::Time::parse(time, &format).unwrap()), time)
}
test_type(
"TIME",
&[
make_check("'00:00:00'"), make_check("'11:19:33'"), make_check("'23:11:45'"), (None, "NULL"),
],
)
.await;
}