--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/m-toolbox/classes/tests/database/@ltpda_objmeta_table/test_objmeta_created.m	Wed Nov 23 19:22:13 2011 +0100
@@ -0,0 +1,71 @@
+%
+% DESCRIPTION: Tests that the metadata 'created' 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_created.m,v 1.2 2011/05/24 19:09:54 ingo Exp $
+%
+function varargout = test_objmeta_created(varargin)
+  
+  utp = varargin{1};
+  
+  if ~utp.testRunner.skipRepoTests()
+    
+    dbTable    = 'objmeta';
+    tableField = 'created';
+    
+    % Check that the metadata was set with a submit PLIST
+    try
+      for nn = 1:numel(utp.objIds)
+        
+        % get 'created' 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 return value is a time-object.
+        assert(isa(val{1}, 'time'));
+        
+        % Check that the created of the meta table is the same as the
+        % created time of the test objects
+        qTime = val{1}.format('yyyy-mm-dd HH:MM:SS');
+        cTime = utp.testData(nn).created.format('yyyy-mm-dd HH:MM:SS');
+        assert(strcmp(qTime, cTime));
+      end
+    catch Me
+      throw(Me);
+    end
+    
+    % Check that the metadata was set with a submit structure
+    try
+      for nn = 1:numel(utp.objIdsStruct)
+        
+        % get 'created' from the objmeta table
+        val = utp.getTableEntry(dbTable, tableField, utp.objIdsStruct(nn));
+        
+        % Check that we get only one result for the query
+        assert(numel(val)==1)
+        
+        % Check that the return value is a time-object.
+        assert(isa(val{1}, 'time'));
+        
+        % Check that the created of the meta table is the same as the
+        % created time of the test objects
+        qTime = val{1}.format('yyyy-mm-dd HH:MM:SS');
+        cTime = utp.testData(nn).created.format('yyyy-mm-dd HH:MM:SS');
+        assert(strcmp(qTime, cTime));
+      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