[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2477] trunk/sql/modules/test/Reconciliation.sql
- Subject: SF.net SVN: ledger-smb:[2477] trunk/sql/modules/test/Reconciliation.sql
- From: ..hidden..
- Date: Thu, 05 Mar 2009 00:16:37 +0000
Revision: 2477
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2477&view=rev
Author: einhverfr
Date: 2009-03-05 00:16:34 +0000 (Thu, 05 Mar 2009)
Log Message:
-----------
Unapproved voucher tests added for cleared balance api
Modified Paths:
--------------
trunk/sql/modules/test/Reconciliation.sql
Modified: trunk/sql/modules/test/Reconciliation.sql
===================================================================
--- trunk/sql/modules/test/Reconciliation.sql 2009-03-04 23:08:13 UTC (rev 2476)
+++ trunk/sql/modules/test/Reconciliation.sql 2009-03-05 00:16:34 UTC (rev 2477)
@@ -54,12 +54,18 @@
SELECT 'Report Submitted', reconciliation__submit_set(currval('cr_report_id_seq')::int, (select as_array(id::int) from cr_report_line where report_id = currval('cr_report_id_seq')::int));
INSERT INTO test_result(test_name, success)
+SELECT 'Cleared balance pre-approval is 10', reconciliation__get_cleared_balance(-201) = 10;
+
+INSERT INTO test_result(test_name, success)
SELECT 'Report Approved', reconciliation__report_approve(currval('cr_report_id_seq')::int) > 0;
INSERT INTO test_result(test_name, success)
SELECT 'Transactions closed', count(*) = 0 FROM acc_trans where chart_id = -200 and cleared is false;
+INSERT INTO test_result(test_name, success)
+SELECT 'Cleared balance post-approval is 130', reconciliation__get_cleared_balance(-201) = 130;
+
SELECT * FROM test_result;
SELECT (select count(*) from test_result where success is true)
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.