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

[..hidden..]

Revision: 2688
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2688&view=rev
Author:   einhverfr
Date:     2009-06-16 16:16:24 +0000 (Tue, 16 Jun 2009)

Log Message:
-----------
Test case updates

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

Modified: trunk/sql/modules/test/Company.sql
===================================================================
--- trunk/sql/modules/test/Company.sql	2009-06-16 05:53:27 UTC (rev 2687)
+++ trunk/sql/modules/test/Company.sql	2009-06-16 16:16:24 UTC (rev 2688)
@@ -50,25 +50,23 @@
 
 INSERT INTO test_result (test_name, success)
 SELECT 'entity__save_notes',
-       entity__save_notes ( currval('entity_id_seq'), 'Test note text', 'Test note subject' );
+       entity__save_notes ( currval('entity_id_seq')::int, 'Test note text', 'Test note subject' ) > 0;
        
 INSERT INTO test_result (test_name, success)
 SELECT 'entity__save_note subject record',
        CASE WHEN subject = 'Test note subject' THEN 't'::bool ELSE 'f'::bool END
        FROM entity_note
-       group by subject, id
-       having id = max(id);
+       WHERE id = currval('note_id_seq');
        
 INSERT INTO test_result(test_name, success)
 SELECT 'eca_save_notes',
-       eca__save_notes( currval('entity_credit_account_id_seq', 'Test note text', 'ECA test note subject') );
+       eca__save_notes( currval('entity_credit_account_id_seq')::int, 'Test note text', 'ECA test note subject' ) > 0;
 
 INSERT INTO test_result (test_name, success)
 SELECT 'eca__save_notes subject record',
        CASE WHEN subject = 'ECA test note subject' THEN 't'::bool ELSE 'f'::bool END
        FROM eca_note
-       group by subject, id
-       HAVING id = max(id);
+       WHERE id = currval('note_id_seq');
 
 
 SELECT * FROM test_result;

Modified: trunk/sql/modules/test/System.sql
===================================================================
--- trunk/sql/modules/test/System.sql	2009-06-16 05:53:27 UTC (rev 2687)
+++ trunk/sql/modules/test/System.sql	2009-06-16 16:16:24 UTC (rev 2688)
@@ -19,6 +19,7 @@
 insert into test_exempt_funcs values ('set_curcfg');
 insert into test_exempt_funcs values ('token_type');
 insert into test_exempt_funcs values ('crosstab');
+insert into test_exempt_funcs values ('concat_colon');
 
 INSERT INTO test_result(test_name, success)
 select 'No overloaded functions in current schema', count(*) = 0

Modified: trunk/t/43-dbtest.t
===================================================================
--- trunk/t/43-dbtest.t	2009-06-16 05:53:27 UTC (rev 2687)
+++ trunk/t/43-dbtest.t	2009-06-16 16:16:24 UTC (rev 2688)
@@ -5,7 +5,7 @@
 	plan skip_all => 'Skipping all.  Told not to test db.';
 }
 else {
-	plan tests => 91;
+	plan tests => 95;
 	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.