csvpp 0.4.1

Compile csvpp source code to a target spreadsheet format
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

//! CSV is a particularly nice for testing because we can exihibit language features without yucky
//! things like a binary format (excel) or an API (google sheets)
use csvpp::Template;
mod common;

#[test]
fn write_no_code_section() {
    let s = common::Setup::from_str(
        "write_no_code_section",
        "csv",
        r#"
---
foo,bar,baz
"#,
    );
    let template = Template::compile(&s.runtime).unwrap();
    let target = s.runtime.target().unwrap();
    target.write(&template).unwrap();

    assert_eq!(s.read_output(), "foo,bar,baz\n");
}

#[test]
fn write_variable() {
    let s = common::Setup::from_str(
        "write_variable",
        "csv",
        r#"
foo := 1
---
foo,bar,baz,=foo
"#,
    );
    let template = Template::compile(&s.runtime).unwrap();
    let target = s.runtime.target().unwrap();
    target.write(&template).unwrap();

    assert_eq!(
        s.read_output(),
        r"foo,bar,baz,=1
"
    );
}

#[test]
fn write_expand() {
    let s = common::Setup::from_str(
        "write_expand",
        "csv",
        r#"
commission_charge := 0.65 # the broker charges $0.65 a contract/share

fees := commission_charge * celladjacent(D)
profit := (celladjacent(B) * celladjacent(C)) - fees

---
![[format=bold/halign=center]]Date ,[[f=b]] Purchase ,Price  ,Quantity ,Profit     ,Fees
![[expand=2]]                      ,[[format=bold]]  ,       ,         ,"=profit"  ,"=fees"
"#,
    );

    let template = Template::compile(&s.runtime).unwrap();
    let target = s.runtime.target().unwrap();
    target.write(&template).unwrap();

    assert_eq!(
        s.read_output(),
        "Date,Purchase,Price,Quantity,Profit,Fees
,,,,=((B2 * C2) - (0.65 * D2)),=(0.65 * D2)
,,,,=((B3 * C3) - (0.65 * D3)),=(0.65 * D3)
"
    );
}

#[test]
fn odd_row_widths() {
    let s = common::Setup::from_str(
        "odd_row_widths",
        "csv",
        r#"
var1 := 42

var2 := var1 + 5

fn funky_fun(a, b) a + b

---
[[var=a1]]A1,foo,bar
![[expand=10]],bar,=var2
foo
[[lock]]test,
![[lock]]test1,test2,test3,
"#,
    );

    let template = Template::compile(&s.runtime).unwrap();
    let target = s.runtime.target().unwrap();
    target.write(&template).unwrap();

    assert_eq!(
        s.read_output(),
        "A1,foo,bar,
,bar,=(42 + 5),
,bar,=(42 + 5),
,bar,=(42 + 5),
,bar,=(42 + 5),
,bar,=(42 + 5),
,bar,=(42 + 5),
,bar,=(42 + 5),
,bar,=(42 + 5),
,bar,=(42 + 5),
,bar,=(42 + 5),
foo,,,
test,,,
test1,test2,test3,
"
    );
}