#![cfg(all(test, feature = "mysql"))]
use crate::error::BaseError;
use serde_json::Value;
#[cfg(all(test, feature = "mysql"))]
#[derive(Debug, Clone)]
#[cfg_attr(test, derive(PartialEq))]
#[allow(dead_code)] pub(crate) enum SqlParam {
Null,
Bool(bool),
Int(i64),
Uint(u64),
Float(f64),
String(String),
DateTime(chrono::NaiveDateTime),
Bytes(Vec<u8>),
Json(serde_json::Value),
}
#[cfg(all(test, feature = "mysql"))]
impl SqlParam {
pub(super) fn from_json(value: &Value) -> Result<Self, BaseError> {
match value {
Value::Null => Ok(SqlParam::Null),
Value::Bool(b) => Ok(SqlParam::Bool(*b)),
Value::Number(n) => {
if let Some(i) = n.as_i64() {
Ok(SqlParam::Int(i))
} else if let Some(u) = n.as_u64() {
Ok(SqlParam::Uint(u))
} else if let Some(f) = n.as_f64() {
Ok(SqlParam::Float(f))
} else {
Err(BaseError::DatabaseQueryFailed(
yang_db::DbError::QueryError(format!("不支持的数字类型: {}", n)),
))
}
}
Value::String(s) => {
if let Ok(dt) = chrono::NaiveDateTime::parse_from_str(s, "%Y-%m-%dT%H:%M:%S")
.or_else(|_| chrono::NaiveDateTime::parse_from_str(s, "%Y-%m-%d %H:%M:%S"))
.or_else(|_| chrono::NaiveDateTime::parse_from_str(s, "%Y-%m-%dT%H:%M:%S%.f"))
{
return Ok(SqlParam::DateTime(dt));
}
Ok(SqlParam::String(s.clone()))
}
Value::Array(_) => Ok(SqlParam::Json(value.clone())),
Value::Object(_) => Ok(SqlParam::Json(value.clone())),
}
}
}