1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113

use sqlx_core::column::Column;
use sqlx_core::decode::Decode;
use sqlx_core::error::BoxDynError;
use sqlx_core::mssql::{Mssql, MssqlRow, MssqlValue, MssqlValueRef};
use sqlx_core::row::Row;
use sqlx_core::type_info::TypeInfo;
use sqlx_core::types::BigDecimal;
use sqlx_core::value::ValueRef;

use crate::convert::{JsonCodec, RefJsonCodec, ResultCodec};
use serde_json::{json, Value};

impl<'r> JsonCodec for sqlx_core::mssql::MssqlValueRef<'r> {
    fn try_to_json(self) -> crate::Result<serde_json::Value> {
        //TODO batter way to match type replace use string match
        let type_string = self.type_info().name().to_owned();
        match type_string.as_str() {
            "NULL" => {
                return Ok(serde_json::Value::Null);
            }
            "TINYINT" => {
                let r: Option<i8> = Decode::<'_, Mssql>::decode(self).into_result()?;
                return Ok(json!(r));
            }
            "SMALLINT" => {
                let r: Option<i16> = Decode::<'_, Mssql>::decode(self).into_result()?;
                return Ok(json!(r));
            }
            "INT" => {
                let r: Option<i32> = Decode::<'_, Mssql>::decode(self).into_result()?;
                return Ok(json!(r));
            }
            "BIGINT" => {
                let r: Option<i64> = Decode::<'_, Mssql>::decode(self).into_result()?;
                return Ok(json!(r));
            }
            "REAL" => {
                let r: Option<f32> = Decode::<'_, Mssql>::decode(self).into_result()?;
                return Ok(json!(r));
            }
            "FLOAT" => {
                let r: Option<f64> = Decode::<'_, Mssql>::decode(self).into_result()?;
                return Ok(json!(r));
            }

            "VARCHAR" | "NVARCHAR" | "BIGVARCHAR" | "CHAR" | "BIGCHAR" | "NCHAR" => {
                let r: Option<String> = Decode::<'_, Mssql>::decode(self).into_result()?;
                return Ok(json!(r));
            }

            //TODO convert types
            // "NEWDECIMAL" => {
            //     let r: Result<BigDecimal, BoxDynError> = Decode::<'_, Mssql>::decode(self);
            //     if r.is_err() {
            //         return Err(crate::Error::from(r.err().unwrap().to_string()));
            //     }
            //     return Ok(serde_json::Value::from(r.unwrap().to_string()));
            // }
            // "DATE" => {
            //     let r: Result<chrono::NaiveDate, BoxDynError> = Decode::<'_, Mssql>::decode(self);
            //     if r.is_err() {
            //         return Err(crate::Error::from(r.err().unwrap().to_string()));
            //     }
            //     let t = serde_json::to_value(&r.unwrap());
            //     return Ok(t.unwrap_or(serde_json::Value::Null));
            // }
            // "TIME" => {
            //     let r: Result<chrono::NaiveTime, BoxDynError> = Decode::<'_, Mssql>::decode(self);
            //     if r.is_err() {
            //         return Err(crate::Error::from(r.err().unwrap().to_string()));
            //     }
            //     let t = serde_json::to_value(&r.unwrap());
            //     return Ok(t.unwrap_or(serde_json::Value::Null));
            // }
            // "DATETIME" => {
            //     let r: Result<chrono::NaiveDateTime, BoxDynError> = Decode::<'_, Mssql>::decode(self);
            //     if r.is_err() {
            //         return Err(crate::Error::from(r.err().unwrap().to_string()));
            //     }
            //     let t = serde_json::to_value(&r.unwrap());
            //     return Ok(t.unwrap_or(serde_json::Value::Null));
            // }
            // "TIMESTAMP" => {
            //     let r: Result<chrono::NaiveDateTime, BoxDynError> = Decode::<'_, Mssql>::decode(self);
            //     if r.is_err() {
            //         return Err(crate::Error::from(r.err().unwrap().to_string()));
            //     }
            //     let t = serde_json::to_value(&r.unwrap());
            //     return Ok(t.unwrap_or(serde_json::Value::Null));
            // }
            // you can use already supported types to decode this
            _ => return Err(crate::Error::from(format!("un support database type for:{:?}!", type_string))),
        }
    }
}


impl RefJsonCodec for Vec<MssqlRow> {
    fn try_to_json(&self) -> crate::Result<serde_json::Value> {
        let mut arr = Vec::with_capacity(self.len());
        for row in self {
            let mut m = serde_json::Map::new();
            let columns = row.columns();
            for x in columns {
                let key = x.name();
                let v: MssqlValueRef = row.try_get_raw(key).into_result()?;
                m.insert(key.to_owned(), v.try_to_json()?);
            }
            arr.push(serde_json::Value::Object(m));
        }
        Ok(serde_json::Value::from(arr))
    }
}