ganit-core 0.4.0

Spreadsheet formula engine — parser and evaluator for Excel-compatible formulas
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

use super::super::switch_fn;
use crate::eval::{Context, EvalCtx, Registry};
use crate::parser::ast::{Expr, Span};
use crate::types::Value;

fn span() -> Span { Span::new(0, 1) }

fn run(args: Vec<Expr>) -> Value {
    let reg = Registry::new();
    let mut ctx = EvalCtx::new(Context::empty(), &reg);
    switch_fn(&args, &mut ctx)
}

#[test]
fn matches_first_case() {
    let args = vec![
        Expr::Number(1.0, span()),
        Expr::Number(1.0, span()),
        Expr::Text("one".to_string(), span()),
        Expr::Number(2.0, span()),
        Expr::Text("two".to_string(), span()),
    ];
    assert_eq!(run(args), Value::Text("one".to_string()));
}

#[test]
fn matches_second_case() {
    let args = vec![
        Expr::Number(2.0, span()),
        Expr::Number(1.0, span()),
        Expr::Text("one".to_string(), span()),
        Expr::Number(2.0, span()),
        Expr::Text("two".to_string(), span()),
    ];
    assert_eq!(run(args), Value::Text("two".to_string()));
}

#[test]
fn uses_default_when_no_match() {
    // SWITCH(3, 1, "one", 2, "two", "other") — odd remaining count = has default
    let args = vec![
        Expr::Number(3.0, span()),
        Expr::Number(1.0, span()),
        Expr::Text("one".to_string(), span()),
        Expr::Number(2.0, span()),
        Expr::Text("two".to_string(), span()),
        Expr::Text("other".to_string(), span()),
    ];
    assert_eq!(run(args), Value::Text("other".to_string()));
}