README

👁 Continuous Integration
👁 Coverage Status

DBUnit

An alternative to phpunit/dbunit.
Supports PDO Drivers but currently only tested with MySQL.

Installation

Use Composer:

composer require --dev hjerichen/dbunit

Usage

Use the trait MySQLTestCaseTrait in PHPUnit Test Cases to test with MySQL, or build an abstract DatabaseTestCase class for your Test classes.

<?php

use HJerichen\DBUnit\Dataset\Attribute\DatasetForExpected
use HJerichen\DBUnit\Dataset\Attribute\DatasetForSetup
use HJerichen\DBUnit\Dataset\Dataset;
use HJerichen\DBUnit\Dataset\DatasetArray;
use HJerichen\DBUnit\MySQLTestCaseTrait;
use PHPUnit\Framework\ExpectationFailedException;
use PHPUnit\Framework\TestCase;
use SebastianBergmann\Comparator\ComparisonFailure;

class MySQLTest extends TestCase
{
 use MySQLTestCaseTrait;

 private PDO $database;

 protected function getDatabase(): PDO
 {
 if (!isset($this->database)) {
 $this->database = new PDO(MYSQL_DSN, MYSQL_USER, MYSQL_PASS);
 }
 return $this->database;
 }

 protected function getDatasetForSetup(): Dataset
 {
 return $this->getDatasetForSetupFromAttribute() ?? new DatasetArray([
 'product' => [
 ['id' => 1, 'ean' => '123', 'stock' => 0],
 ['id' => 2, 'ean' => '456', 'stock' => 10],
 ]
 ]);
 }

 /* TESTS */

 public function testImportAndCompare(): void
 {
 $expected = new DatasetArray([
 'product' => [
 ['id' => 1, 'ean' => '123', 'stock' => 0],
 ['id' => 2, 'ean' => '456', 'stock' => 10],
 ]
 ]);
 $this->assertDatasetEqualsCurrentOne($expected);
 }

 #[DatasetForSetup([
 'product' => [
 ['id' => 1, 'ean' => '123', 'stock' => 0],
 ],
 ])]
 #[DatasetForExpected([
 'product' => [
 ['id' => 1, 'ean' => '123', 'stock' => 0],
 ],
 ])]
 public function testImportAndCompare2(): void
 {
 $expected = $this->getDatasetForExpectedFromAttribute();
 $this->assertDatasetEqualsCurrentOne($expected);
 }
 
 private function assertDatasetEqualsCurrentOne(DatasetArray $expected):void{
 try {
 $this->assertDatasetEqualsCurrent($expected);
 } catch (ComparisonFailure $failure) {
 throw new ExpectationFailedException($failure->getMessage(), $failure);
 }
 }
}

Datasets

Supported Datasets are:
DatasetArray (also via test method attribute)
DatasetYaml

License and authors

This project is free and under the MIT Licence. Responsible for this project is Heiko Jerichen (heiko@jerichen.de).