remdb 0.3.1

嵌入式内存数据库
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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133

use remdb::sql::{parse_sql_query, QueryParseError};

#[test]
fn test_create_table_parse() {
    let sql =
        "CREATE TABLE products (id UINT32 PRIMARY KEY, name STRING, price FLOAT32, in_stock BOOL);";

    println!("Testing SQL: {}", sql);

    match parse_sql_query(sql) {
        Ok(query) => {
            println!("✓ Successfully parsed query: {:?}", query);
            assert_eq!(query.query_type, remdb::sql::QueryType::CreateTable);
            assert_eq!(query.if_not_exists, false);
        }
        Err(err) => {
            println!("✗ Parse error: {:?}", err);
            // 获取更详细的错误信息
            match err {
                QueryParseError::InvalidSyntax => println!("  Error type: Invalid syntax"),
                QueryParseError::UnsupportedKeyword => {
                    println!("  Error type: Unsupported keyword")
                }
                QueryParseError::InvalidTableName => println!("  Error type: Invalid table name"),
                QueryParseError::InvalidFieldName => println!("  Error type: Invalid field name"),
                QueryParseError::InvalidCondition => println!("  Error type: Invalid condition"),
                QueryParseError::InvalidOperator => println!("  Error type: Invalid operator"),
                QueryParseError::InvalidValue => println!("  Error type: Invalid value"),
                QueryParseError::MissingClause => println!("  Error type: Missing clause"),
            }
            panic!("Failed to parse CREATE TABLE statement");
        }
    }
}

#[test]
fn test_create_table_if_not_exists_parse() {
    let sql =
        "CREATE TABLE IF NOT EXISTS products (id UINT32 PRIMARY KEY, name STRING, price FLOAT32, in_stock BOOL);";

    println!("Testing SQL: {}", sql);

    match parse_sql_query(sql) {
        Ok(query) => {
            println!("✓ Successfully parsed query: {:?}", query);
            assert_eq!(query.query_type, remdb::sql::QueryType::CreateTable);
            assert_eq!(query.if_not_exists, true);
        }
        Err(err) => {
            println!("✗ Parse error: {:?}", err);
            // 获取更详细的错误信息
            match err {
                QueryParseError::InvalidSyntax => println!("  Error type: Invalid syntax"),
                QueryParseError::UnsupportedKeyword => {
                    println!("  Error type: Unsupported keyword")
                }
                QueryParseError::InvalidTableName => println!("  Error type: Invalid table name"),
                QueryParseError::InvalidFieldName => println!("  Error type: Invalid field name"),
                QueryParseError::InvalidCondition => println!("  Error type: Invalid condition"),
                QueryParseError::InvalidOperator => println!("  Error type: Invalid operator"),
                QueryParseError::InvalidValue => println!("  Error type: Invalid value"),
                QueryParseError::MissingClause => println!("  Error type: Missing clause"),
            }
            panic!("Failed to parse CREATE TABLE IF NOT EXISTS statement");
        }
    }
}

#[test]
fn test_update_parse() {
    let sql = "UPDATE products SET price = 9.99, in_stock = true WHERE id = 1;";

    println!("Testing SQL: {}", sql);

    match parse_sql_query(sql) {
        Ok(query) => {
            println!("✓ Successfully parsed query: {:?}", query);
            assert_eq!(query.query_type, remdb::sql::QueryType::Update);
            assert_eq!(query.table_name, "products");
            assert_eq!(query.update_pairs.len(), 2);
            assert_eq!(query.update_pairs[0].0, "price");
            assert_eq!(query.update_pairs[1].0, "in_stock");
        }
        Err(err) => {
            println!("✗ Parse error: {:?}", err);
            // 获取更详细的错误信息
            match err {
                QueryParseError::InvalidSyntax => println!("  Error type: Invalid syntax"),
                QueryParseError::UnsupportedKeyword => {
                    println!("  Error type: Unsupported keyword")
                }
                QueryParseError::InvalidTableName => println!("  Error type: Invalid table name"),
                QueryParseError::InvalidFieldName => println!("  Error type: Invalid field name"),
                QueryParseError::InvalidCondition => println!("  Error type: Invalid condition"),
                QueryParseError::InvalidOperator => println!("  Error type: Invalid operator"),
                QueryParseError::InvalidValue => println!("  Error type: Invalid value"),
                QueryParseError::MissingClause => println!("  Error type: Missing clause"),
            }
            panic!("Failed to parse UPDATE statement");
        }
    }
}

#[test]
fn test_create_checkpoint_parse() {
    let sql = "CREATE CHECKPOINT;";

    println!("Testing SQL: {}", sql);

    match parse_sql_query(sql) {
        Ok(query) => {
            println!("✓ Successfully parsed query: {:?}", query);
            assert_eq!(query.query_type, remdb::sql::QueryType::CreateCheckpoint);
        }
        Err(err) => {
            println!("✗ Parse error: {:?}", err);
            // 获取更详细的错误信息
            match err {
                QueryParseError::InvalidSyntax => println!("  Error type: Invalid syntax"),
                QueryParseError::UnsupportedKeyword => {
                    println!("  Error type: Unsupported keyword")
                }
                QueryParseError::InvalidTableName => println!("  Error type: Invalid table name"),
                QueryParseError::InvalidFieldName => println!("  Error type: Invalid field name"),
                QueryParseError::InvalidCondition => println!("  Error type: Invalid condition"),
                QueryParseError::InvalidOperator => println!("  Error type: Invalid operator"),
                QueryParseError::InvalidValue => println!("  Error type: Invalid value"),
                QueryParseError::MissingClause => println!("  Error type: Missing clause"),
            }
            panic!("Failed to parse CREATE CHECKPOINT statement");
        }
    }
}