SF.net SVN: ledger-smb:[2593] trunk/sql/modules/test

[..hidden..]

Revision: 2593
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2593&view=rev
Author:   einhverfr
Date:     2009-05-08 20:05:16 +0000 (Fri, 08 May 2009)

Log Message:
-----------
Committing test case fixes

Modified Paths:
--------------
    trunk/sql/modules/test/Payment.sql
    trunk/sql/modules/test/Voucher.sql

Modified: trunk/sql/modules/test/Payment.sql
===================================================================
--- trunk/sql/modules/test/Payment.sql	2009-05-08 18:20:06 UTC (rev 2592)
+++ trunk/sql/modules/test/Payment.sql	2009-05-08 20:05:16 UTC (rev 2593)
@@ -21,8 +21,8 @@
 INSERT INTO person(first_name, last_name, entity_id, id)
 VALUES ('test', 'test', -100, -100);
 
-INSERT INTO entity_employee(entity_id, person_id)
-VALUES (-100, -100);
+INSERT INTO entity_employee(entity_id)
+VALUES (-100);
 
 INSERT INTO chart (accno, description, charttype, category, link)
 VALUES ('00001', 'testing', 'A', 'L', 'AP');

Modified: trunk/sql/modules/test/Voucher.sql
===================================================================
--- trunk/sql/modules/test/Voucher.sql	2009-05-08 18:20:06 UTC (rev 2592)
+++ trunk/sql/modules/test/Voucher.sql	2009-05-08 20:05:16 UTC (rev 2593)
@@ -10,6 +10,8 @@
 INSERT INTO entity_credit_account (entity_id, id, meta_number, entity_class) 
 values (-3, -1, 'Test', 1);
 
+INSERT INTO entity_employee(entity_id) values (-3);
+
 INSERT INTO chart (id, accno, description, link)
 VALUES ('-5', '-21111', 'Testing AP', 'AP');
 
@@ -41,7 +43,7 @@
 
 -- Adding the test for empty batch sproc
 
-insert into batch (batch_class_id, control_code, description, default_date, created_by) values (1, 'EMPTYBATCHTEST', 'EMPTY BATCH TEST', '2009-01-01', -3);
+insert into batch (batch_class_id, control_code, description, default_date, created_by) values (1, 'EMPTYBATCHTEST1', 'EMPTY BATCH TEST', '2009-01-01', -3);
 
 INSERT INTO test_result (test_name, success)
 SELECT 'Empty Batch Detected', count(*) = 1


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