summaryrefslogtreecommitdiff
path: root/test/baseline/cmd-select.test
diff options
context:
space:
mode:
authorMartin Michlmayr <tbm@cyrius.com>2012-03-25 14:11:59 +0100
committerMartin Michlmayr <tbm@cyrius.com>2012-03-25 14:11:59 +0100
commit8962d9c904d5630b508ca2b10f2bf66e7f32a30b (patch)
tree98d35d154607222d9df3ffcc12ac633fec60dbd0 /test/baseline/cmd-select.test
parenta47625be3571262f0c36324d6793c55645172dc1 (diff)
downloadfork-ledger-8962d9c904d5630b508ca2b10f2bf66e7f32a30b.tar.gz
fork-ledger-8962d9c904d5630b508ca2b10f2bf66e7f32a30b.tar.bz2
fork-ledger-8962d9c904d5630b508ca2b10f2bf66e7f32a30b.zip
Add more baseline tests
Diffstat (limited to 'test/baseline/cmd-select.test')
-rw-r--r--test/baseline/cmd-select.test62
1 files changed, 62 insertions, 0 deletions
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
+