use chrono::{DateTime, NaiveDate, NaiveDateTime};
use crate::column_types::models::ColumnType;
use crate::write_sql::constants::{CURSOR_TIMESTAMP_FORMAT, NAIVE_TIMESTAMP_FORMATS};
pub fn cursor_text(text: &str, column_type: &ColumnType) -> Result<String, String> {
let zoned = DateTime::parse_from_rfc3339(text);
let naive = NAIVE_TIMESTAMP_FORMATS
.iter()
.find_map(|format| match NaiveDateTime::parse_from_str(text, format) {
Ok(time) => Some(time),
Err(_) => None,
})
.or_else(|| match NaiveDate::parse_from_str(text, "%Y-%m-%d") {
Ok(date) => date.and_hms_opt(0, 0, 0),
Err(_) => None,
});
let unreadable = || format!("{text:?} is not an RFC 3339 timestamp or a date");
match (column_type, zoned, naive) {
(ColumnType::TimestampTz, Ok(time), _) => Ok(format!(
"{}+00",
time.naive_utc().format(CURSOR_TIMESTAMP_FORMAT)
)),
(ColumnType::TimestampTz, Err(_), Some(time)) => {
Ok(format!("{}+00", time.format(CURSOR_TIMESTAMP_FORMAT)))
}
(ColumnType::TimestampNtz, Ok(time), _) if time.offset().local_minus_utc() != 0 => {
Err(format!(
"{text:?} has a UTC offset, but the cursor is a timestamp without a time zone; give the wall-clock time without an offset"
))
}
(ColumnType::TimestampNtz, Ok(time), _) => Ok(time
.naive_local()
.format(CURSOR_TIMESTAMP_FORMAT)
.to_string()),
(ColumnType::TimestampNtz, Err(_), Some(time)) => {
Ok(time.format(CURSOR_TIMESTAMP_FORMAT).to_string())
}
(ColumnType::Date, _, _) => match NaiveDate::parse_from_str(text, "%Y-%m-%d") {
Ok(date) => Ok(date.format("%Y-%m-%d").to_string()),
Err(_) => Err(format!(
"{text:?} is not a date (YYYY-MM-DD), which a date cursor needs"
)),
},
(ColumnType::TimestampTz | ColumnType::TimestampNtz, Err(_), None) => Err(unreadable()),
_ => Ok(text.to_owned()),
}
}