tegdb 0.5.0

The name TegridyDB (short for TegDB) is inspired by the Tegridy Farm in South Park and tries to correct some of the wrong database implementations, such as null support, implicit conversion support, etc.
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

//! Test edge cases and error handling for arithmetic expressions

mod test_helpers {
    include!("../common/test_helpers.rs");
}
use test_helpers::run_with_both_backends;

use tegdb::Database;

#[test]
fn test_arithmetic_error_handling() {
    run_with_both_backends("arithmetic_error_handling", |db_path| {
        let mut db = Database::open(db_path).expect("Failed to open database");

        // Create test table
        db.execute("CREATE TABLE test (id INTEGER PRIMARY KEY, value INTEGER)")
            .expect("Failed to create table");

        db.execute("INSERT INTO test (id, value) VALUES (1, 10)")
            .expect("Failed to insert data");

        // Test division by zero
        let result = db.execute("UPDATE test SET value = value / 0 WHERE id = 1");
        assert!(result.is_err(), "Should fail on division by zero");

        // Test reference to non-existent column
        let result = db.execute("UPDATE test SET value = nonexistent + 5 WHERE id = 1");
        assert!(result.is_err(), "Should fail on non-existent column");

        Ok(())
    })
    .expect("Test failed");
}

#[test]
fn test_operator_precedence() {
    run_with_both_backends("operator_precedence", |db_path| {
        let mut db = Database::open(db_path).expect("Failed to open database");

        // Create test table
        db.execute("CREATE TABLE test (id INTEGER PRIMARY KEY, value INTEGER)")
            .expect("Failed to create table");

        db.execute("INSERT INTO test (id, value) VALUES (1, 2)")
            .expect("Failed to insert data");

        // Test that multiplication has higher precedence than addition
        // 2 + 3 * 4 should be 2 + 12 = 14, not (2 + 3) * 4 = 20
        db.execute("UPDATE test SET value = value + 3 * 4 WHERE id = 1")
            .expect("Failed to update");

        let result = db
            .query("SELECT value FROM test WHERE id = 1")
            .expect("Failed to query");

        if let Some(row) = result.rows().first() {
            if let Some(value) = row.first() {
                assert_eq!(*value, tegdb::SqlValue::Integer(14)); // 2 + (3 * 4) = 14
            }
        }

        // Reset value
        db.execute("UPDATE test SET value = 2 WHERE id = 1")
            .expect("Failed to reset");

        // Test that division has higher precedence than subtraction
        // 10 - 6 / 2 should be 10 - 3 = 7, not (10 - 6) / 2 = 2
        db.execute("UPDATE test SET value = 10 - 6 / value WHERE id = 1")
            .expect("Failed to update");

        let result = db
            .query("SELECT value FROM test WHERE id = 1")
            .expect("Failed to query");

        if let Some(row) = result.rows().first() {
            if let Some(value) = row.first() {
                assert_eq!(*value, tegdb::SqlValue::Integer(7)); // 10 - (6 / 2) = 7
            }
        }

        Ok(())
    })
    .expect("Test failed");
}

#[test]
fn test_text_concatenation() {
    run_with_both_backends("text_concatenation", |db_path| {
        let mut db = Database::open(db_path).expect("Failed to open database");

        // Create test table
        db.execute("CREATE TABLE test (id INTEGER PRIMARY KEY, text1 TEXT(32), text2 TEXT(32))")
            .expect("Failed to create table");

        db.execute("INSERT INTO test (id, text1, text2) VALUES (1, 'Hello', 'World')")
            .expect("Failed to insert data");

        // Test text concatenation with +
        db.execute("UPDATE test SET text1 = text1 + ' ' + text2 WHERE id = 1")
            .expect("Failed to update");

        let result = db
            .query("SELECT text1 FROM test WHERE id = 1")
            .expect("Failed to query");

        if let Some(row) = result.rows().first() {
            if let Some(value) = row.first() {
                assert_eq!(*value, tegdb::SqlValue::Text("Hello World".to_string()));
            }
        }

        Ok(())
    })
    .expect("Test failed");
}