dfcbbd169e
A wrong query string was generated by "select account": one ansify_if() too much was listed and justify() was called with the wrong parameters. Bug fix for #744
62 lines
2.4 KiB
Text
62 lines
2.4 KiB
Text
2012-02-28 * Test 1
|
|
E 20.00 EUR
|
|
F
|
|
|
|
2012-02-29 * Test 2
|
|
Test 10.01 EUR
|
|
F
|
|
|
|
2012-03-24 Test 3
|
|
C 30.00 EUR
|
|
D
|
|
|
|
2012-03-25 (test) Test 4
|
|
; Payee: Test 5
|
|
E 40.00 GBP
|
|
F
|
|
|
|
test select "date, account, amount" from posts
|
|
12-Feb-28 E 20.00 EUR
|
|
12-Feb-28 F -20.00 EUR
|
|
12-Feb-29 Test 10.01 EUR
|
|
12-Feb-29 F -10.01 EUR
|
|
12-Mar-24 C 30.00 EUR
|
|
12-Mar-24 D -30.00 EUR
|
|
12-Mar-25 E 40.00 GBP
|
|
12-Mar-25 F -40.00 GBP
|
|
end test
|
|
|
|
test select "date, account, amount from posts where account =~ /^e/"
|
|
12-Feb-28 E 20.00 EUR
|
|
12-Mar-25 E 40.00 GBP
|
|
end test
|
|
|
|
test select "date, account, amount from posts where account =~ /e/"
|
|
12-Feb-28 E 20.00 EUR
|
|
12-Feb-29 Test 10.01 EUR
|
|
12-Mar-25 E 40.00 GBP
|
|
end test
|
|
|
|
; leave out "from posts" since it is the default
|
|
test select "date, account, amount where account =~ /e/"
|
|
12-Feb-28 E 20.00 EUR
|
|
12-Feb-29 Test 10.01 EUR
|
|
12-Mar-25 E 40.00 GBP
|
|
end test
|
|
|
|
test select "date, payee, amount from posts where account =~ /e/ and commodity =~ /GBP/"
|
|
12-Mar-25 Test 5 40.00 GBP
|
|
end test
|
|
|
|
test select "date, payee, amount * 2 from posts where account =~ /e/ and commodity =~ /GBP/"
|
|
12-Mar-25 Test 5 80.00 GBP
|
|
end test
|
|
|
|
test select "date, code, amount from posts where account =~ /e/ and commodity =~ /GBP/"
|
|
12-Mar-25 test 40.00 GBP
|
|
end test
|
|
|
|
test select "date, code * 2, amount from posts where account =~ /e/ and commodity =~ /GBP/"
|
|
12-Mar-25 testtest 40.00 GBP
|
|
end test
|
|
|