uorm 0.9.3

use crate::error::DbError;
use chrono::{DateTime, NaiveDate, NaiveDateTime, NaiveTime, Utc};
use rust_decimal::Decimal;
use std::collections::HashMap;

#[derive(Debug, Clone, PartialEq)]
pub enum Value {
    Null,
    Bool(bool),
    Char(char),
    Str(String),
    I8(i8),
    I16(i16),
    I32(i32),
    I64(i64),
    I128(i128),
    U8(u8),
    U16(u16),
    U32(u32),
    U64(u64),
    U128(u128),
    F32(f32),
    F64(f64),
    Bytes(Vec<u8>),
    /// 不带时区的日期
    Date(NaiveDate),

    /// 不带日期的时间
    Time(NaiveTime),

    /// 不带时区的日期时间
    DateTime(NaiveDateTime),

    /// UTC 日期时间
    DateTimeUtc(DateTime<Utc>),

    /// 任意精度十进制数
    Decimal(Decimal),

    /// 有序值列表（如数组、元组）
    List(Vec<Value>),

    /// 键值映射（如结构体、JSON 对象）
    Map(HashMap<String, Value>),
}

/// 任何能转换为 Value 的类型
pub trait ToValue {
    fn to_value(&self) -> Value;
}

/// 任何能从 Value 还原的类型
pub trait FromValue: Sized {
    fn from_value(v: Value) -> Result<Self, DbError>;
}

// --- 基础类型的宏实现 ---
macro_rules! impl_to_value_primitive {
    ($rust_type:ty, $variant:ident) => {
        impl ToValue for $rust_type {
            fn to_value(&self) -> Value {
                Value::$variant(self.clone())
            }
        }
    };
}

macro_rules! impl_from_value_int {
    ($rust_type:ty) => {
        impl FromValue for $rust_type {
            fn from_value(v: Value) -> Result<Self, DbError> {
                match v {
                    Value::I8(n) => <$rust_type>::try_from(n).map_err(|_| {
                        DbError::TypeMismatch(format!(
                            "Value {} out of range for {}",
                            n,
                            stringify!($rust_type)
                        ))
                    }),
                    Value::I16(n) => <$rust_type>::try_from(n).map_err(|_| {
                        DbError::TypeMismatch(format!(
                            "Value {} out of range for {}",
                            n,
                            stringify!($rust_type)
                        ))
                    }),
                    Value::I32(n) => <$rust_type>::try_from(n).map_err(|_| {
                        DbError::TypeMismatch(format!(
                            "Value {} out of range for {}",
                            n,
                            stringify!($rust_type)
                        ))
                    }),
                    Value::I64(n) => <$rust_type>::try_from(n).map_err(|_| {
                        DbError::TypeMismatch(format!(
                            "Value {} out of range for {}",
                            n,
                            stringify!($rust_type)
                        ))
                    }),
                    Value::I128(n) => <$rust_type>::try_from(n).map_err(|_| {
                        DbError::TypeMismatch(format!(
                            "Value {} out of range for {}",
                            n,
                            stringify!($rust_type)
                        ))
                    }),
                    Value::U8(n) => <$rust_type>::try_from(n).map_err(|_| {
                        DbError::TypeMismatch(format!(
                            "Value {} out of range for {}",
                            n,
                            stringify!($rust_type)
                        ))
                    }),
                    Value::U16(n) => <$rust_type>::try_from(n).map_err(|_| {
                        DbError::TypeMismatch(format!(
                            "Value {} out of range for {}",
                            n,
                            stringify!($rust_type)
                        ))
                    }),
                    Value::U32(n) => <$rust_type>::try_from(n).map_err(|_| {
                        DbError::TypeMismatch(format!(
                            "Value {} out of range for {}",
                            n,
                            stringify!($rust_type)
                        ))
                    }),
                    Value::U64(n) => <$rust_type>::try_from(n).map_err(|_| {
                        DbError::TypeMismatch(format!(
                            "Value {} out of range for {}",
                            n,
                            stringify!($rust_type)
                        ))
                    }),
                    Value::U128(n) => <$rust_type>::try_from(n).map_err(|_| {
                        DbError::TypeMismatch(format!(
                            "Value {} out of range for {}",
                            n,
                            stringify!($rust_type)
                        ))
                    }),
                    Value::Bytes(b) => {
                        let s = String::from_utf8(b.clone())
                            .map_err(|e| DbError::TypeMismatch(format!("Invalid UTF-8 bytes: {}", e)))?;
                        s.parse::<$rust_type>().map_err(|e| {
                            DbError::TypeMismatch(format!(
                                "Cannot parse bytes {:?} as {}: {}",
                                b,
                                stringify!($rust_type),
                                e
                            ))
                        })
                    },
                    Value::Str(s) => s.parse::<$rust_type>().map_err(|e| {
                        DbError::TypeMismatch(format!(
                            "Cannot parse string {:?} as {}: {}",
                            s,
                            stringify!($rust_type),
                            e
                        ))
                    }),
                    _ => Err(DbError::TypeMismatch(format!(
                        "Expected numeric value, got {:?}",
                        v
                    ))),
                }
            }
        }
    };
}

// bool 类型的特殊处理
impl_to_value_primitive!(bool, Bool);
impl FromValue for bool {
    fn from_value(v: Value) -> Result<Self, DbError> {
        match v {
            Value::Bool(b) => Ok(b),
            // 生产级增强：支持从整数 0/1 转换
            Value::I32(1) => Ok(true),
            Value::I32(0) => Ok(false),
            Value::I64(1) => Ok(true),
            Value::I64(0) => Ok(false),
            // 生产级增强：支持从字符串 "true"/"false" 转换
            Value::Str(s) if s.to_lowercase() == "true" => Ok(true),
            Value::Str(s) if s.to_lowercase() == "false" => Ok(false),
            _ => Err(DbError::TypeMismatch(format!("Expected Bool, got {:?}", v))),
        }
    }
}

// char 类型的特殊处理
impl_to_value_primitive!(char, Char);
impl FromValue for char {
    fn from_value(v: Value) -> Result<Self, DbError> {
        if let Value::Char(val) = v {
            Ok(val)
        } else {
            Err(DbError::TypeMismatch(format!("Expected Char, got {:?}", v)))
        }
    }
}

// string 类型的特殊处理
impl_to_value_primitive!(String, Str);
impl FromValue for String {
    fn from_value(v: Value) -> Result<Self, DbError> {
        match v {
            Value::Str(s) => Ok(s),
            Value::Bytes(b) => String::from_utf8(b)
                .map_err(|e| DbError::TypeMismatch(format!("Invalid UTF-8 bytes: {}", e))),
            Value::Date(d) => Ok(d.to_string()),
            Value::Time(t) => Ok(t.to_string()),
            Value::DateTime(dt) => Ok(dt.to_string()),
            Value::DateTimeUtc(dt) => Ok(dt.to_string()),
            Value::I64(n) => Ok(n.to_string()),
            Value::I32(n) => Ok(n.to_string()),
            Value::F64(n) => Ok(n.to_string()),
            Value::Decimal(d) => Ok(d.to_string()),
            _ => Err(DbError::TypeMismatch(format!(
                "Expected Str or Bytes, got {:?}",
                v
            ))),
        }
    }
}
impl ToValue for &str {
    fn to_value(&self) -> Value {
        Value::Str(self.to_string())
    }
}

// 批量实现基础类型
impl_to_value_primitive!(i8, I8);
impl_to_value_primitive!(i16, I16);
impl_to_value_primitive!(i32, I32);
impl_to_value_primitive!(i64, I64);
impl_to_value_primitive!(i128, I128);
impl_to_value_primitive!(u8, U8);
impl_to_value_primitive!(u16, U16);
impl_to_value_primitive!(u32, U32);
impl_to_value_primitive!(u64, U64);
impl_to_value_primitive!(u128, U128);

impl_from_value_int!(i8);
impl_from_value_int!(i16);
impl_from_value_int!(i32);
impl_from_value_int!(i64);
impl_from_value_int!(i128);
impl_from_value_int!(u8);
impl_from_value_int!(u16);
impl_from_value_int!(u32);
impl_from_value_int!(u64);
impl_from_value_int!(u128);

// float 类型的特殊处理
impl_to_value_primitive!(f32, F32);
impl FromValue for f32 {
    fn from_value(v: Value) -> Result<Self, DbError> {
        if let Value::F32(val) = v {
            Ok(val)
        } else if let Value::F64(val) = v {
            Ok(val as f32)
        } else {
            Err(DbError::TypeMismatch(format!("Expected F32, got {:?}", v)))
        }
    }
}

// double 类型的特殊处理
impl_to_value_primitive!(f64, F64);
impl FromValue for f64 {
    fn from_value(v: Value) -> Result<Self, DbError> {
        if let Value::F64(val) = v {
            Ok(val)
        } else if let Value::F32(val) = v {
            Ok(val as f64)
        } else {
            Err(DbError::TypeMismatch(format!("Expected F64, got {:?}", v)))
        }
    }
}

// 允许 Value 作为参数传入
impl ToValue for Value {
    fn to_value(&self) -> Value {
        self.clone()
    }
}

// 允许 Value 作为结果返回
impl FromValue for Value {
    fn from_value(v: Value) -> Result<Self, DbError> {
        Ok(v)
    }
}

// 为 unit 类型 () 实现 FromValue，使函数可返回 Result<()>
impl FromValue for () {
    fn from_value(_v: Value) -> Result<Self, DbError> {
        Ok(())
    }
}

impl ToValue for () {
    fn to_value(&self) -> Value {
        Value::Null
    }
}

// 引用的通用实现
impl<T> ToValue for &T
where
    T: ToValue + ?Sized,
{
    fn to_value(&self) -> Value {
        (**self).to_value()
    }
}

// 可选类型
impl<T: ToValue> ToValue for Option<T> {
    fn to_value(&self) -> Value {
        match self {
            Some(v) => v.to_value(),
            None => Value::Null,
        }
    }
}
impl<T: FromValue> FromValue for Option<T> {
    fn from_value(v: Value) -> Result<Self, DbError> {
        match v {
            Value::Null => Ok(None),
            Value::List(l) => {
                if let Ok(v) = T::from_value(Value::List(l.clone())) {
                    return Ok(Some(v));
                }
                if l.is_empty() {
                    return Ok(None);
                }
                let first = l.into_iter().next().unwrap();
                Ok(Some(T::from_value(first)?))
            }
            _ => Ok(Some(T::from_value(v)?)),
        }
    }
}

// 向量
impl<T: ToValue> ToValue for Vec<T> {
    fn to_value(&self) -> Value {
        Value::List(self.iter().map(|v| v.to_value()).collect())
    }
}
impl<T: FromValue> FromValue for Vec<T> {
    fn from_value(v: Value) -> Result<Self, DbError> {
        match v {
            Value::List(l) => l.into_iter().map(T::from_value).collect(),
            _ => Err(DbError::TypeMismatch(format!("Expected List, got {:?}", v))),
        }
    }
}

// 哈希映射
impl<T: ToValue> ToValue for HashMap<String, T> {
    fn to_value(&self) -> Value {
        let mut map = HashMap::new();
        for (k, v) in self {
            map.insert(k.clone(), v.to_value());
        }
        Value::Map(map)
    }
}
impl<T: FromValue> FromValue for HashMap<String, T> {
    fn from_value(v: Value) -> Result<Self, DbError> {
        match v {
            Value::Map(m) => {
                let mut out = HashMap::new();
                for (k, val) in m {
                    out.insert(k, T::from_value(val)?);
                }
                Ok(out)
            }
            _ => Err(DbError::TypeMismatch(format!("Expected Map, got {:?}", v))),
        }
    }
}