Function try_eval

nodedb-query/src/functions/datetime.rs:8–179

(name: &str, args: &[Value])

use nodedb_types::Value;

pub(super) fn try_eval(name: &str, args: &[Value]) -> Option<Value> {
    let v = match name {
        "now" | "current_timestamp" => {
            let dt = nodedb_types::NdbDateTime::now();
            Value::DateTime(dt)
        }
        "datetime" | "to_datetime" => args
            .first()
            .and_then(|v| match v {
                Value::String(s) => {
                    nodedb_types::NdbDateTime::parse(s).map(|dt| Value::String(dt.to_iso8601()))
                }
                Value::Integer(micros) => Some(Value::String(
                    nodedb_types::NdbDateTime::from_micros(*micros).to_iso8601(),
                )),
                Value::Float(f) => Some(Value::String(
                    nodedb_types::NdbDateTime::from_micros(*f as i64).to_iso8601(),
                )),
                Value::DateTime(dt) | Value::NaiveDateTime(dt) => {
                    Some(Value::String(dt.to_iso8601()))
                }
                _ => None,
            })
            .unwrap_or(Value::Null),
        "unix_secs" | "epoch_secs" => args
            .first()
            .and_then(|v| v.as_str())
            .and_then(nodedb_types::NdbDateTime::parse)
            .map_or(Value::Null, |dt| Value::Integer(dt.unix_secs())),
        "unix_millis" | "epoch_millis" => args
            .first()
            .and_then(|v| v.as_str())
            .and_then(nodedb_types::NdbDateTime::parse)
            .map_or(Value::Null, |dt| Value::Integer(dt.unix_millis())),
        "extract" | "date_part" => {
            let part = args.first().and_then(|v| v.as_str()).unwrap_or("");
            let dt = args
                .get(1)
                .and_then(|v| v.as_str())
                .and_then(nodedb_types::NdbDateTime::parse);
            match dt {
                Some(dt) => {
                    let c = dt.components();
                    let val: i64 = match part.to_lowercase().as_str() {
                        "year" | "y" => c.year as i64,
                        "month" | "mon" => c.month as i64,
                        "day" | "d" => c.day as i64,
                        "hour" | "h" => c.hour as i64,
                        "minute" | "min" | "m" => c.minute as i64,
                        "second" | "sec" | "s" => c.second as i64,
                        "microsecond" | "us" => c.microsecond as i64,
                        "epoch" => dt.unix_secs(),
                        "dow" | "dayofweek" => {
                            let days = dt.micros / 86_400_000_000;
                            (days + 4) % 7
                        }
                        _ => return Some(Value::Null),
                    };