PHPUnit DatabaseTest Example

database-test-case.php

<?php

use PHPUnit\Framework\TestCase;


class DatabaseTest extends TestCase {

    private static $dbConnection;

    public static function setUpBeforeClass() : void {
        self::$dbConnection = DbConnectionFactory::create();
    }
    
    public function setUp() : void {
        self::$dbConnection->query('START TRANSACTION');
        
        // load databse records here
    }
    
    public function tearDown() : void {
        self::$dbConnection->query('ROLLBACK');
    }
    
    public static function tearDownAfterClass() : void {
        self::$dbConnection->close();
    }

    public function testSomethingWithTheDatabase() : void {
        $subject = new SystemUnderTest(self::$dbConnection);
        
        $subject->doSomething();
        
        // assert database records expected
    }

}