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.
<?php
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;
}
}