From 8962d9c904d5630b508ca2b10f2bf66e7f32a30b Mon Sep 17 00:00:00 2001 From: Martin Michlmayr Date: Sun, 25 Mar 2012 14:11:59 +0100 Subject: Add more baseline tests --- test/baseline/cmd-select.test | 62 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 62 insertions(+) create mode 100644 test/baseline/cmd-select.test (limited to 'test/baseline/cmd-select.test') diff --git a/test/baseline/cmd-select.test b/test/baseline/cmd-select.test new file mode 100644 index 00000000..c8ce7008 --- /dev/null +++ b/test/baseline/cmd-select.test @@ -0,0 +1,62 @@ +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 + -- cgit v1.2.3