summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-11-15 23:57:07 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-11-15 23:57:07 +0000
commitff686b3e857fc34aabf2bb4d444b851df803352c (patch)
tree37f16b8e9d7e444c6e2c7d4b1c530252a95763b6 /sql
parent4548566ebb520679c2b7d9c5e2d786d3b0ea3c98 (diff)
Test case additions, and a few corrections
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2401 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
-rw-r--r--sql/modules/test/Voucher.sql18
1 files changed, 9 insertions, 9 deletions
diff --git a/sql/modules/test/Voucher.sql b/sql/modules/test/Voucher.sql
index f5dd0a95..d749bf09 100644
--- a/sql/modules/test/Voucher.sql
+++ b/sql/modules/test/Voucher.sql
@@ -6,30 +6,30 @@ SELECT 'Batch Created',
batch_create('_TEST', '_TEST', 'payment', '2008-01-01') IS NOT NULL;
INSERT INTO entity (id, name, entity_class, control_code)
-values (-2, 'Test', 1, 'test');
+values (-3, 'Test', 1, 'test');
INSERT INTO entity_credit_account (entity_id, id, meta_number, entity_class)
-values (-2, -1, 'Test', 1);
+values (-3, -1, 'Test', 1);
INSERT INTO chart (id, accno, description, link)
-VALUES ('-1', '-21111', 'Testing AP', 'AP');
+VALUES ('-5', '-21111', 'Testing AP', 'AP');
INSERT INTO ap (id, invnumber, amount, curr, approved, entity_credit_account)
-VALUES (-1, 'test1', '1000', 'USD', false, -1);
+VALUES (-5, 'test1', '1000', 'USD', false, -1);
INSERT INTO acc_trans(trans_id, chart_id, amount, approved)
-values (-1, -1, 1000, true);
+values (-5, -5, 1000, true);
INSERT INTO voucher (trans_id, batch_id, batch_class)
-values (-1, currval('batch_id_seq'), 1);
+values (-5, currval('batch_id_seq'), 1);
INSERT INTO voucher (trans_id, batch_id, batch_class)
-values (-1, currval('batch_id_seq'), 3);
+values (-5, currval('batch_id_seq'), 3);
INSERT INTO voucher (trans_id, batch_id, batch_class)
-values (-1, currval('batch_id_seq'), 3);
+values (-5, currval('batch_id_seq'), 3);
INSERT INTO test_result (test_name, success)
SELECT 'partial payment support', count(*) > 1
-FROM voucher where trans_id = -1 and batch_class = 3;
+FROM voucher where trans_id = -5 and batch_class = 3;
SELECT * FROM test_result;