Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PHPUnit Database Extension - How to have an empty dataset?

Tags:

phpunit

dbunit

I want to create a test table that is empty. Using the Example from digitalsandwich, I want something like:

require_once 'PHPUnit/Extensions/Database/TestCase.php';
class BankAccountDBTest extends PHPUnit_Extensions_Database_TestCase
{
    protected $pdo;

    public function __construct()
    {
        $this->pdo = new PDO('sqlite::memory:');
        BankAccount::createTable($this->pdo);
    }

    protected function getConnection()
    {
        return $this->createDefaultDBConnection($this->pdo, 'sqlite');
    }

    protected function getDataSet()
    {
        return $this->createFlatXMLDataSet(dirname(__FILE__).'/_files/empty-seed.xml');
    }

    public function testEmptyTableBehavior() 
    {
        // test stuff
    }
}

Should I be using a different method than createFlatXMLDataSet()? Or???

like image 519
Lance Rushing Avatar asked Oct 01 '09 16:10

Lance Rushing


1 Answers

Ok, I figured it out:

...
require_once 'PHPUnit/Extensions/Database/DataSet/DefaultDataSet.php';
class BankAccountDBTest extends PHPUnit_Extensions_Database_TestCase
{
...
    protected function getDataSet()
    {
        return new PHPUnit_Extensions_Database_DataSet_DefaultDataSet();
    }
like image 91
Lance Rushing Avatar answered Jan 04 '23 11:01

Lance Rushing