iridium_server 0.1.12

TDS 7.4 server for Iridium SQL
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
105
106
107
108
109
110

pub mod types;
pub mod utils;
pub mod parser;

pub use types::*;
pub use utils::*;
pub use parser::*;

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

    #[test]
    fn rpc_proc_resolves_by_id() {
        // MS-TDS spec IDs (corrected)
        assert_eq!(RpcProc::from_id(1), Some(RpcProc::CursorOpen));
        assert_eq!(RpcProc::from_id(2), Some(RpcProc::CursorOpen));
        assert_eq!(RpcProc::from_id(3), Some(RpcProc::CursorPrepare)); // sp_cursorprepare
        assert_eq!(RpcProc::from_id(4), Some(RpcProc::CursorExecute)); // sp_cursorexecute
        assert_eq!(RpcProc::from_id(5), Some(RpcProc::CursorPrepExec)); // sp_cursorprepexec
        assert_eq!(RpcProc::from_id(6), Some(RpcProc::CursorUnprepare)); // sp_cursorunprepare
        assert_eq!(RpcProc::from_id(7), Some(RpcProc::CursorFetch));
        assert_eq!(RpcProc::from_id(8), Some(RpcProc::CursorOption)); // sp_cursoroption
        assert_eq!(RpcProc::from_id(9), Some(RpcProc::CursorClose)); // sp_cursorclose
        assert_eq!(RpcProc::from_id(10), Some(RpcProc::ExecuteSql));
        assert_eq!(RpcProc::from_id(11), Some(RpcProc::Prepare)); // sp_prepare
        assert_eq!(RpcProc::from_id(12), Some(RpcProc::Execute)); // sp_execute
        assert_eq!(RpcProc::from_id(13), Some(RpcProc::PrepExec)); // sp_prepexec
        assert_eq!(RpcProc::from_id(14), Some(RpcProc::PrepExecRpc)); // sp_prepexecrpc
        assert_eq!(RpcProc::from_id(15), Some(RpcProc::Unprepare)); // sp_unprepare
        assert_eq!(RpcProc::from_id(42), None);
    }

    #[test]
    fn rpc_proc_resolves_by_name() {
        assert_eq!(RpcProc::from_name("sp_cursor"), Some(RpcProc::CursorOpen));
        assert_eq!(
            RpcProc::from_name("sp_cursoropen"),
            Some(RpcProc::CursorOpen)
        );
        assert_eq!(
            RpcProc::from_name("sp_cursorclose"),
            Some(RpcProc::CursorClose)
        );
        assert_eq!(
            RpcProc::from_name("sp_cursorfetch"),
            Some(RpcProc::CursorFetch)
        );
        assert_eq!(
            RpcProc::from_name("[dbo].[sp_cursorprepare]"),
            Some(RpcProc::CursorPrepare)
        );
        assert_eq!(
            RpcProc::from_name("sp_cursorexecute"),
            Some(RpcProc::CursorExecute)
        );
        assert_eq!(
            RpcProc::from_name("sp_cursorunprepare"),
            Some(RpcProc::CursorUnprepare)
        );
        assert_eq!(
            RpcProc::from_name("sp_cursoroption"),
            Some(RpcProc::CursorOption)
        );
        assert_eq!(
            RpcProc::from_name("sp_executesql"),
            Some(RpcProc::ExecuteSql)
        );
        assert_eq!(RpcProc::from_name("sp_prepexec"), Some(RpcProc::PrepExec));
        assert_eq!(RpcProc::from_name("sp_prepare"), Some(RpcProc::Prepare));
        assert_eq!(RpcProc::from_name("sp_execute"), Some(RpcProc::Execute));
        assert_eq!(RpcProc::from_name("sp_unprepare"), Some(RpcProc::Unprepare));
        assert_eq!(
            RpcProc::from_name("sp_reset_connection"),
            Some(RpcProc::ResetConnection)
        );
        assert_eq!(RpcProc::from_name("sp_help"), None);
    }

    #[test]
    fn rpc_proc_is_cursor() {
        assert!(RpcProc::CursorOpen.is_cursor());
        assert!(RpcProc::CursorClose.is_cursor());
        assert!(RpcProc::CursorFetch.is_cursor());
        assert!(RpcProc::CursorPrepare.is_cursor());
        assert!(RpcProc::CursorExecute.is_cursor());
        assert!(RpcProc::CursorUnprepare.is_cursor());
        assert!(RpcProc::CursorOption.is_cursor());
        assert!(!RpcProc::ExecuteSql.is_cursor());
        assert!(!RpcProc::PrepExec.is_cursor());
        assert!(!RpcProc::Prepare.is_cursor());
        assert!(!RpcProc::Execute.is_cursor());
        assert!(!RpcProc::Unprepare.is_cursor());
        assert!(!RpcProc::ResetConnection.is_cursor());
    }

    #[test]
    fn param_decl_parsing() {
        let decls = parse_param_decl("@x INT, @name NVARCHAR(50)");
        assert_eq!(decls.len(), 2);
        assert_eq!(decls[0], ("@x".to_string(), "INT".to_string()));
        assert_eq!(decls[1], ("@name".to_string(), "NVARCHAR(50)".to_string()));

        let empty = parse_param_decl("");
        assert!(empty.is_empty());

        let single = parse_param_decl("@y INT");
        assert_eq!(single.len(), 1);
    }
}