Service provider for tests in need of a Doctrine DBAL connection

v2.0.0 2015-01-20 18:14 UTC


Build Status

This library contains a service provider to be used with a service container for PHPUnit tests.


Extend your test class from Noback\PHPUnitTestServiceContainer\PHPUnit\AbstractTestCaseWithDoctrineDbalConnection. You then need to implement the createSchema() and return an instance of Doctrine\DBAL\Schema\Schema.

For each test method a database connection (of instance Doctrine\DBAL\Connection) will be available. Also the schema returned by createSchema() will be created in the database. The database itself is (by default) an SQLite in-memory database, which will leave no traces on the filesystem.


use Noback\PHPUnitTestServiceContainer\PHPUnit\AbstractTestCaseWithDoctrineDbalConnection;
use Doctrine\DBAL\Schema\Schema;

class StorageTest extends AbstractTestCaseWithDoctrineDbalConnection
     * @test
    public function something()
        $connection = $this->getConnection();

        $connection->insert('some_table', array('some_column' => 'value'));


    protected function createSchema()
        $schema = new Schema();

        $table = $schema->createTable('some_table');

        $table->addColumn('some_column', 'string');

        return $schema;

Read more