test/baseline/opt-group-by.test


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

2012-03-20 * Test GBP
    A          -10.00 GBP
    B

2012-03-20 * Test EUR
    A          -10.00 EUR
    B

2012-03-22 * Test GBP
    A          -10.00 GBP
    B

2012-03-22 * Test EUR
    A          -10.00 EUR
    B

2012-03-25 * Test GBP
    A          -10.00 GBP
    B

2012-03-25 * Test EUR
    A          -10.00 EUR
    B

test reg --group-by payee
Test EUR
12-Mar-20 Test EUR              A                        -10.00 EUR   -10.00 EUR
                                B                         10.00 EUR            0
12-Mar-22 Test EUR              A                        -10.00 EUR   -10.00 EUR
                                B                         10.00 EUR            0
12-Mar-25 Test EUR              A                        -10.00 EUR   -10.00 EUR
                                B                         10.00 EUR            0

Test GBP
12-Mar-20 Test GBP              A                        -10.00 GBP   -10.00 GBP
                                B                         10.00 GBP            0
12-Mar-22 Test GBP              A                        -10.00 GBP   -10.00 GBP
                                B                         10.00 GBP            0
12-Mar-25 Test GBP              A                        -10.00 GBP   -10.00 GBP
                                B                         10.00 GBP            0
end test

test reg --group-by commodity
EUR
12-Mar-20 Test EUR              A                        -10.00 EUR   -10.00 EUR
                                B                         10.00 EUR            0
12-Mar-22 Test EUR              A                        -10.00 EUR   -10.00 EUR
                                B                         10.00 EUR            0
12-Mar-25 Test EUR              A                        -10.00 EUR   -10.00 EUR
                                B                         10.00 EUR            0

GBP
12-Mar-20 Test GBP              A                        -10.00 GBP   -10.00 GBP
                                B                         10.00 GBP            0
12-Mar-22 Test GBP              A                        -10.00 GBP   -10.00 GBP
                                B                         10.00 GBP            0
12-Mar-25 Test GBP              A                        -10.00 GBP   -10.00 GBP
                                B                         10.00 GBP            0
end test

test bal --group-by commodity
EUR
          -30.00 EUR  A
           30.00 EUR  B
--------------------
                   0

GBP
          -30.00 GBP  A
           30.00 GBP  B
--------------------
                   0
end test

test bal --group-by payee
Test EUR
          -30.00 EUR  A
           30.00 EUR  B
--------------------
                   0

Test GBP
          -30.00 GBP  A
           30.00 GBP  B
--------------------
                   0
end test

test bal --group-by date
2012/03/20
          -10.00 EUR
          -10.00 GBP  A
           10.00 EUR
           10.00 GBP  B
--------------------
                   0

2012/03/22
          -10.00 EUR
          -10.00 GBP  A
           10.00 EUR
           10.00 GBP  B
--------------------
                   0

2012/03/25
          -10.00 EUR
          -10.00 GBP  A
           10.00 EUR
           10.00 GBP  B
--------------------
                   0
end test