truecalc-core 7.1.0

Formula engine with exact Google Sheets semantics — stateless, embeddable evaluator
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

use super::super::query_fn;
use super::{employees, num, table, text};
use crate::types::Value;

#[test]
fn where_equality_on_text() {
    let result = query_fn(&[employees(), text("select Col1 where Col2 = 'Eng'"), num(1.0)]);
    assert_eq!(
        result,
        Value::Array(vec![Value::Array(vec![text("Name")]), Value::Array(vec![text("Alice")]), Value::Array(vec![text("Bob")])])
    );
}

#[test]
fn where_greater_than_numeric() {
    let result = query_fn(&[employees(), text("select Col1 where Col3 > 150"), num(1.0)]);
    assert_eq!(
        result,
        Value::Array(vec![Value::Array(vec![text("Name")]), Value::Array(vec![text("Bob")]), Value::Array(vec![text("Eve")])])
    );
}

#[test]
fn where_not_equal_both_spellings() {
    let ne1 = query_fn(&[employees(), text("select Col1 where Col2 != 'Eng'"), num(1.0)]);
    let ne2 = query_fn(&[employees(), text("select Col1 where Col2 <> 'Eng'"), num(1.0)]);
    assert_eq!(ne1, ne2);
    assert_eq!(
        ne1,
        Value::Array(vec![
            Value::Array(vec![text("Name")]),
            Value::Array(vec![text("Carol")]),
            Value::Array(vec![text("Dave")]),
            Value::Array(vec![text("Eve")]),
        ])
    );
}

#[test]
fn where_and_combines_conditions() {
    let result = query_fn(&[employees(), text("select Col1 where Col2 = 'Eng' and Col3 > 150"), num(1.0)]);
    assert_eq!(result, Value::Array(vec![Value::Array(vec![text("Name")]), Value::Array(vec![text("Bob")])]));
}

#[test]
fn where_or_combines_conditions() {
    let result = query_fn(&[employees(), text("select Col1 where Col2 = 'HR' or Col2 = 'Sales'"), num(1.0)]);
    assert_eq!(
        result,
        Value::Array(vec![
            Value::Array(vec![text("Name")]),
            Value::Array(vec![text("Carol")]),
            Value::Array(vec![text("Dave")]),
            Value::Array(vec![text("Eve")]),
        ])
    );
}

#[test]
fn where_is_null_and_is_not_null() {
    let data = table(vec![
        vec![text("Name"), text("Score")],
        vec![text("Alice"), num(10.0)],
        vec![text("Bob"), Value::Empty],
        vec![text("Carol"), num(20.0)],
    ]);

    let is_null = query_fn(&[data.clone(), text("select Col1 where Col2 is null"), num(1.0)]);
    assert_eq!(is_null, Value::Array(vec![Value::Array(vec![text("Name")]), Value::Array(vec![text("Bob")])]));

    let is_not_null = query_fn(&[data, text("select Col1 where Col2 is not null"), num(1.0)]);
    assert_eq!(
        is_not_null,
        Value::Array(vec![Value::Array(vec![text("Name")]), Value::Array(vec![text("Alice")]), Value::Array(vec![text("Carol")])])
    );
}

#[test]
fn where_text_literal_containing_operator_characters() {
    // The quoted RHS literal itself contains '<', '>', and '!' characters —
    // the operator scan must not mistake those for the real comparison
    // operator and must not scan past the quoted region at all.
    let data = table(vec![
        vec![text("Name"), text("Note")],
        vec![text("Alice"), text("A<B")],
        vec![text("Bob"), text("C>D")],
        vec![text("Carol"), text("E!=F")],
        vec![text("Dave"), text("plain")],
    ]);

    let lt = query_fn(&[data.clone(), text("select Col1 where Col2 = 'A<B'"), num(1.0)]);
    assert_eq!(lt, Value::Array(vec![Value::Array(vec![text("Name")]), Value::Array(vec![text("Alice")])]));

    let gt = query_fn(&[data.clone(), text("select Col1 where Col2 = 'C>D'"), num(1.0)]);
    assert_eq!(gt, Value::Array(vec![Value::Array(vec![text("Name")]), Value::Array(vec![text("Bob")])]));

    let ne = query_fn(&[data, text("select Col1 where Col2 = 'E!=F'"), num(1.0)]);
    assert_eq!(ne, Value::Array(vec![Value::Array(vec![text("Name")]), Value::Array(vec![text("Carol")])]));
}