View source for Automated Testing With Database

===Working with Tables Not Included in the Default Dataset===
What shall we do when it's not possible to define which table is used in a query and so the default dataset isn't enough? Take this method for example:

<syntaxhighlight lang="php">
class Foo
{
	public function bar($limit = null)
	{
		$db = JFactory::getDbo();

		$query = $db->getQuery(true);
		$query->select(array('id', 'title'))
			->from('#__categories');

		$db->setQuery($query, 0, $limit);

		return $db->loadObjectList();
	}
}
</syntaxhighlight>

It has a hard-coded dependency for the categories table and therefore, we have to create this table and insert a test dataset. To do so, we only have to slightly modify our test class:

<syntaxhighlight lang="php">
class FooTest extends TestCaseDatabase()
{
	protected function getDataSet()
	{
		$dataSet = new PHPUnit_Extensions_Database_DataSet_CsvDataSet(',', "'", '\\');

		$dataSet->addTable('jos_categories', JPATH_TEST_DATABASE . '/jos_categories.csv');

		return $dataSet;
	}

	public function testBarAppliesLimit()
	{
		$object = new Foo;

		$this->assertCount(3, $object->bar(3));
	}
}
</syntaxhighlight>

By overriding the ''getDataSet'' method, we can add a table and sample data for ''jos_categories''. In our current test suite, test data is available for all core tables. These are defined as CSV files in the directory ''tests/unit/stubs/database/''.