SF.net SVN: ledger-smb:[3391] trunk

[..hidden..]

Revision: 3391
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3391&view=rev
Author:   einhverfr
Date:     2011-06-30 16:24:46 +0000 (Thu, 30 Jun 2011)

Log Message:
-----------
Yet more 1099 tests

Modified Paths:
--------------
    trunk/sql/modules/test/Taxform.sql
    trunk/t/43-dbtest.t

Modified: trunk/sql/modules/test/Taxform.sql
===================================================================
--- trunk/sql/modules/test/Taxform.sql	2011-06-30 16:12:44 UTC (rev 3390)
+++ trunk/sql/modules/test/Taxform.sql	2011-06-30 16:24:46 UTC (rev 3391)
@@ -333,6 +333,44 @@
                                   (date2() + '1 day'::interval)::date);
 
 INSERT INTO test_result(test_name, success)
+SELECT 'inv_sum for test vendor 1, current report is $2000', invoice_sum = 2000
+  FROM tax_form_summary_report(-511, (date1() - '1 day'::interval)::date, 
+                                  (date1() + '1 day'::interval)::date)
+ where meta_number = 'Test account 1';
+
+INSERT INTO test_result(test_name, success)
+SELECT 'inv_sum for test vendor 1, future report is $500', invoice_sum = 500
+  FROM tax_form_summary_report(-511, (date2() - '1 day'::interval)::date, 
+                                  (date2() + '1 day'::interval)::date)
+ where meta_number = 'Test account 1';
+
+INSERT INTO test_result(test_name, success)
+SELECT 'inv_sum for test vendor 2, current report is $1000', acc_sum = 1000
+  FROM tax_form_summary_report(-511, (date1() - '1 day'::interval)::date, 
+                                  (date1() + '1 day'::interval)::date)
+ where meta_number = 'Test account 2';
+
+
+INSERT INTO test_result(test_name, success)
+SELECT 'total_sum for test vendor 1, current report is $4000', total_sum = 4000
+  FROM tax_form_summary_report(-511, (date1() - '1 day'::interval)::date, 
+                                  (date1() + '1 day'::interval)::date)
+ where meta_number = 'Test account 1';
+
+INSERT INTO test_result(test_name, success)
+SELECT 'total_sum for test vendor 1, future report is $1000', total_sum = 1000
+  FROM tax_form_summary_report(-511, (date2() - '1 day'::interval)::date, 
+                                  (date2() + '1 day'::interval)::date)
+ where meta_number = 'Test account 1';
+
+INSERT INTO test_result(test_name, success)
+SELECT 'total_sum for test vendor 2, current report is $2000', total_sum = 2000
+  FROM tax_form_summary_report(-511, (date1() - '1 day'::interval)::date, 
+                                  (date1() + '1 day'::interval)::date)
+ where meta_number = 'Test account 2';
+
+
+INSERT INTO test_result(test_name, success)
 SELECT 'ac_sum for test vendor 1, current report is $2000', acc_sum = 2000
   FROM tax_form_summary_report(-511, (date1() - '1 day'::interval)::date, 
                                   (date1() + '1 day'::interval)::date)

Modified: trunk/t/43-dbtest.t
===================================================================
--- trunk/t/43-dbtest.t	2011-06-30 16:12:44 UTC (rev 3390)
+++ trunk/t/43-dbtest.t	2011-06-30 16:24:46 UTC (rev 3391)
@@ -5,7 +5,7 @@
 	plan skip_all => 'Skipping all.  Told not to test db.';
 }
 else {
-	plan tests => 145;
+	plan tests => 151;
 	if (defined $ENV{LSMB_NEW_DB}){
 		$ENV{PGDATABASE} = $ENV{LSMB_NEW_DB};
 	}


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.