README

描述

在使用DbUnit时，一个挑战是编写在数据集修改后仍然有效的测试。随着应用程序的增长，新的测试可能需要修改数据集。直接从测试中访问数据集通常是解决问题的好方法。

此外观允许这样做，而无需查询数据库以避免减慢测试速度。它简单地接收一个PHPUnit\DbUnit\DataSet\ITable实例，这是DbUnit存储用于在每次测试之前填充数据库的数据集的地方。然后它提供允许更精确访问数据的方法，以便使测试代码更简洁。

安装

composer require bendamqui/dbunit-table

基本设置示例

use PHPUnit\Framework\TestCase;
use Bendamqui\DbUnit\FixtureUtil;

class DbUnitUsersTest extends TestCase
{
    /**
     * @var FixtureUtil
     */
    private $users_table;
    
    /**
        * @var array 
    */
    private $data = [];
    
    /**
     * @var YourApp
     */
    private $app;    

    public function setUp()
    {
        parent::setUp();                
        $this->users_table = new FixtureUtil($this->data);
    }   
}

示例

以下是一些基本示例，说明如何利用外观编写在数据集更改时仍然有效的测试，同时保持代码清洁并避免不必要的数据库调用。

public function testGetAllUsers()
{
	$expected = $this->users_table->getRowCount();
	$response = $this->app->get('users');
	$this->assertCount($expected, $response);
}

public function testPendingUserCannotLogIn()
{
	$pending_users = $this->users_table->getWhere(['status' => 'pending']);
	foreach ($pending_users as $user) {
		$response = $this->app->post('login', ['email' => $user['email'], 'pass' => $user['pass']]);
		$this->assertEquals(401, $response->getCode(), 'Pending user should not be able to log in.');
	}
	$this->assertGreaterThan(0, count($pending_users));
}

public function testCannotUpdateUserWithAnInvalidEmail()
{
	// Get a valid payload to update a user and override the email field. 
	$payload = $this->users_table->get(['email' => 'invalid_email']);
	$response = $this->app->put('user', $payload);
	$this->assertEquals(422, $response->getCode(), 'User update with invalid email should receive a bad request response');
}	

API