title: PHPUnit Database Testing
body: <p>I am using PHPUnit to test insertion of objects via my storage object. Each domain object has a added and lastmodified timestamp, that is handled by the storage object automatically. I can using PHPUnits DB extensions method assertDataSetsEqual and passing as XML data set as below shows. The problem is added and lastmodified cannot be hardcoded into the XML dataset as this will change all the time automatically, can I tell PHPUnit to ignore these cols? or compare the tables output another way (not XML) where I can ignore these columns?</p>
  
  <p>Test</p>
  
  <pre><code>$user = new Social_User();
  $user-&gt;setFk_mswuserId(10);
  $user-&gt;setFirstName('Gavin');
  
  $store = new Storage();
  $store-&gt;save($user);
  
  $xml_dataset = $this-&gt;createFlatXMLDataSet('after-new.xml');
  $this-&gt;assertDataSetsEqual($xml_dataset, $this-&gt;getConnection()-&gt;createDataSet());
  </code></pre>
  
  <p>XML Dataset</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;dataset&gt;
              &lt;user id="1" password="NULL" ip="0" added="0" authenticated="0" lat="0" lon="0" avatar="0" fk_mswuserId="1" timezoneoffset="0" firstName="Ben" lastName="Freeston" deleted="0" lastModified="0" /&gt;
              &lt;user id="2" password="NULL" ip="0" added="0" authenticated="0" lat="0" lon="0" avatar="0" fk_mswuserId="10" timezoneoffset="0" firstName="Gavin" lastName="Cooper" deleted="0" lastModified="0"/&gt;
  &lt;/dataset&gt;
  </code></pre>