mssql-tds 0.1.0

Rust implementation of the TDS (Tabular Data Stream) protocol for SQL Server
Documentation 
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

// Copyright (c) Microsoft Corporation.
// Licensed under the MIT License.

use core::fmt;
use std::fmt::Debug;

/// SQL Server `json` column value stored as UTF-8 bytes.
#[derive(PartialEq, Clone)]
pub struct SqlJson {
    /// UTF-8 encoded bytes representing a JSON string.
    pub bytes: Vec<u8>,
}

impl SqlJson {
    /// Converts the underlying UTF-8 bytes to a Rust `String`.
    pub fn as_string(&self) -> String {
        String::from_utf8(self.bytes.clone()).unwrap()
    }

    /// Creates a `SqlJson` from raw UTF-8 bytes.
    pub fn new(bytes: Vec<u8>) -> Self {
        Self { bytes }
    }
}

impl Debug for SqlJson {
    fn fmt(&self, f: &mut fmt::Formatter) -> fmt::Result {
        write!(f, "Json: {}", self.as_string())
    }
}

impl From<String> for SqlJson {
    fn from(value: String) -> Self {
        Self::new(value.into_bytes())
    }
}

#[cfg(test)]
mod tests {
    use super::*;

    #[test]
    fn test_sql_json_new() {
        let json_bytes = br#"{"key": "value"}"#.to_vec();
        let json = SqlJson::new(json_bytes.clone());
        assert_eq!(json.bytes, json_bytes);
    }

    #[test]
    fn test_sql_json_as_string() {
        let json_str = r#"{"name": "test", "value": 123}"#;
        let json = SqlJson::new(json_str.as_bytes().to_vec());
        assert_eq!(json.as_string(), json_str);
    }

    #[test]
    fn test_sql_json_from_string() {
        let json_str = r#"{"array": [1, 2, 3]}"#.to_string();
        let json = SqlJson::from(json_str.clone());
        assert_eq!(json.as_string(), json_str);
    }

    #[test]
    fn test_sql_json_debug_format() {
        let json_str = r#"{"test": true}"#;
        let json = SqlJson::new(json_str.as_bytes().to_vec());
        let debug_output = format!("{json:?}");
        assert!(debug_output.contains("Json:"));
        assert!(debug_output.contains(json_str));
    }

    #[test]
    fn test_sql_json_equality() {
        let json1 = SqlJson::new(br#"{"a": 1}"#.to_vec());
        let json2 = SqlJson::new(br#"{"a": 1}"#.to_vec());
        let json3 = SqlJson::new(br#"{"b": 2}"#.to_vec());

        assert_eq!(json1, json2);
        assert_ne!(json1, json3);
    }

    #[test]
    fn test_sql_json_clone() {
        let json = SqlJson::new(br#"{"cloned": "data"}"#.to_vec());
        let cloned = json.clone();
        assert_eq!(json, cloned);
        assert_eq!(json.as_string(), cloned.as_string());
    }

    #[test]
    fn test_sql_json_empty() {
        let json = SqlJson::new(Vec::new());
        assert_eq!(json.as_string(), "");
        assert_eq!(json.bytes.len(), 0);
    }

    #[test]
    fn test_sql_json_complex() {
        let complex_json =
            r#"{"nested": {"array": [{"id": 1}, {"id": 2}]}, "null": null, "bool": true}"#;
        let json = SqlJson::from(complex_json.to_string());
        assert_eq!(json.as_string(), complex_json);
    }
}