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

[..hidden..]

Revision: 2891
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2891&view=rev
Author:   einhverfr
Date:     2010-02-14 01:24:22 +0000 (Sun, 14 Feb 2010)

Log Message:
-----------
Cleanup to ledgersmb-blue.css

Modified Paths:
--------------
    trunk/css/ledgersmb-blue.css
    trunk/sql/modules/test/Base.sql
    trunk/t/43-dbtest.t

Added Paths:
-----------
    trunk/sql/modules/test/EndOfYear.sql

Modified: trunk/css/ledgersmb-blue.css
===================================================================
--- trunk/css/ledgersmb-blue.css	2010-02-12 05:20:26 UTC (rev 2890)
+++ trunk/css/ledgersmb-blue.css	2010-02-14 01:24:22 UTC (rev 2891)
@@ -1,3 +1,4 @@
+/*
 Below is the result of your feedback form.  It was submitted by
 Eduard Rozenberg (..hidden..) on Thursday, August 18, 2005 at 15:41:32
 ---------------------------------------------------------------------------
@@ -13,7 +14,8 @@
 
 ================
 
-/* stylesheet for ledger-smb */
+stylesheet for ledger-smb 
+*/
 
 /* general stuff */
 A:link { color: #a0522d; text-decoration: none; }

Modified: trunk/sql/modules/test/Base.sql
===================================================================
--- trunk/sql/modules/test/Base.sql	2010-02-12 05:20:26 UTC (rev 2890)
+++ trunk/sql/modules/test/Base.sql	2010-02-14 01:24:22 UTC (rev 2891)
@@ -8,6 +8,12 @@
 INSERT INTO account(id, accno, description, category, heading, contra)
 values (-1000, '-1000000000', 'Test cases only', 'A', (select id from account_heading WHERE accno  = '000000000000000000000'), false);
 
+INSERT INTO account(id, accno, description, category, heading, contra)
+values (-1001, '-1000000001', 'Test cases only', 'A', (select id from account_heading WHERE accno  = '000000000000000000000'), false);
+
+INSERT INTO account(id, accno, description, category, heading, contra)
+values (-1002, '-1000000002', 'Test cases only', 'A', (select id from account_heading WHERE accno  = '000000000000000000000'), false);
+
 CREATE OR REPLACE FUNCTION test_get_account_id(in_accno text) returns int as
 $$ 
 SELECT id FROM chart WHERE accno = $1; 

Added: trunk/sql/modules/test/EndOfYear.sql
===================================================================
--- trunk/sql/modules/test/EndOfYear.sql	                        (rev 0)
+++ trunk/sql/modules/test/EndOfYear.sql	2010-02-14 01:24:22 UTC (rev 2891)
@@ -0,0 +1,29 @@
+BEGIN;
+\i Base.sql
+
+DELETE FROM account_checkpoint;
+DELETE FROM yearend;
+
+INSERT INTO gl (id, reference, description, transdate, approved)  
+values (-1000, 'test', 'test', '20020-01-01', true); -- way in the future.
+INSERT INTO acc_trans (trans_id, account_id, transdate, amount, approved) 
+values (-1000, '-1000', '20020-01-01', '10000', true);
+INSERT INTO acc_trans (trans_id, account_id, transdate, amount, approved) 
+values (-1000, '-1001', '20020-01-01', '-10000', true);
+
+insert into test_result (success, test_name)
+select eoy_close_books('20020-01-01', 'test', 'test', '-1002'), 
+'Close books succeeded';
+
+insert into test_result (success, test_name)
+select amount = 1000, 'Account checkpoint added'
+from account_checkpoint where end_date = '20020-01-01' and account_id = -1000;
+
+SELECT * FROM test_result;
+
+SELECT (select count(*) from test_result where success is true) 
+|| ' tests passed and ' 
+|| (select count(*) from test_result where success is not true) 
+|| ' failed' as message;
+
+ROLLBACK;

Modified: trunk/t/43-dbtest.t
===================================================================
--- trunk/t/43-dbtest.t	2010-02-12 05:20:26 UTC (rev 2890)
+++ trunk/t/43-dbtest.t	2010-02-14 01:24:22 UTC (rev 2891)
@@ -5,7 +5,7 @@
 	plan skip_all => 'Skipping all.  Told not to test db.';
 }
 else {
-	plan tests => 99;
+	plan tests => 102;
 	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.