--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/m-toolbox/classes/tests/database/@ltpda_objmeta_table/test_objmeta_submitted.m	Wed Nov 23 19:22:13 2011 +0100
@@ -0,0 +1,66 @@
+%
+% DESCRIPTION: Tests that the metadata 'submitted' of a database
+%              works for a ltpda object.
+%
+% CHECKS:      - Check that we get only one connection from the used
+%                repository PLIST
+%              - Check that the metadata was set with a submit PLIST
+%              - Check that the metadata was set with a submit structure
+%
+% VERSION:     $Id: test_objmeta_submitted.m,v 1.4 2011/05/24 19:09:55 ingo Exp $
+%
+function varargout = test_objmeta_submitted(varargin)
+  
+  utp = varargin{1};
+  
+  if ~utp.testRunner.skipRepoTests()
+    
+    dbTable    = 'objmeta';
+    tableField = 'submitted';
+    
+    % Check that the metadata was set with a submit PLIST
+    try
+      for nn = 1:numel(utp.objIds)
+        
+        % get 'submitted' from the objmeta table
+        val = utp.getTableEntry(dbTable, tableField, utp.objIds(nn));
+        
+        % Check that we get only one result for the query
+        assert(numel(val)==1)
+        
+        % Check that the difference betwen the submitted time and the
+        % current time is not larger than one hour.
+        sTime = val{1};
+        cTime = time();
+        dTime = cTime - sTime;
+        assert(abs(dTime.utc_epoch_milli) <= 60 * 60 * 1000, sprintf('The time difference between submittion-time and checking time is larger than one hour (%d)', double(dTime)))
+      end
+    catch Me
+      throw(Me);
+    end
+    
+    % Check that the metadata was set with a submit structure
+    try
+      for nn = 1:numel(utp.objIdsStruct)
+        
+        % get 'submitted' from the objmeta table
+        val = utp.getTableEntry(dbTable, tableField, utp.objIdsStruct(nn));
+        
+        assert(numel(val)==1)
+        
+        % Check that the difference betwen the submitted time and the
+        % current time is not larger than one hour. 
+        sTime = val{1};
+        cTime = time();
+        dTime = cTime - sTime;
+        assert(abs(dTime.utc_epoch_milli) <= 60 * 60 * 1000, sprintf('The time difference between submittion-time and checking time is larger than one hour (%d)', double(dTime)))
+      end
+    catch Me
+      throw(Me);
+    end
+    
+    varargout{1} = sprintf('Test the field ''%s'' of the database table ''%s'' with the database %s ', tableField, dbTable, utp.testRunner.repositoryPlist.find('database'));
+  else
+    varargout{1} = 'Skip database test';
+  end
+end