您当前的位置： 首页 > 慢生活 > 程序人生 网站首页程序人生

phpunit数据库状态断言（数据是否一致）

发布时间：2021-09-29 17:10:49编辑：雪饮阅读（）

 首先有用于建立于测试方法执行之前的数据集的基境的数据如：

guestbook.csv：
id,content,user,created
1,"Hello buddy!","joe","2010-04-24 17:15:23"
2,"I like it!","nancy","2010-04-26 12:14:20"
这些数据将会创建在mysql中做为基境。
然后有expectedBook.xml：

<?xml version="1.0" ?>
<dataset>
    <guestbook id="1" content="Hello buddy!" user="joe" created="2010-04-24 17:15:23" />
    <guestbook id="2" content="I like it!" user="nancy" created="2010-04-26 12:14:20" />
    <guestbook id="3" content="Hello world!" user="suzy" created="2010-05-01 21:47:08" />
</dataset>

这些数据用来将mysql中数据拿出来与之比较进行断言的数据。

那么有像GuestbookTest.php：

<?php

use PHPUnit\DbUnit\DataSet\CsvDataSet;
use PHPUnit\Framework\TestCase;
use PHPUnit\DbUnit\TestCaseTrait;

class GuestbookTest extends TestCase
{
    use TestCaseTrait;
    static private $pdo = null;
    private $conn = null;
    final public function getConnection()
    {
        if ($this->conn === null) {
            if (self::$pdo == null) {
                self::$pdo = new PDO( $GLOBALS['DB_DSN'], $GLOBALS['DB_USER'], $GLOBALS['DB_PASSWD'] );
            }
            $this->conn = $this->createDefaultDBConnection(self::$pdo, $GLOBALS['DB_DBNAME']);
        }
        return $this->conn;
    }
    public function getDataSet()
    {
        $dataSet = new CsvDataSet();
        $dataSet->addTable('guestbook', dirname(__FILE__)."/guestbook.csv");
        return $dataSet;
    }
    public function testAddEntry()
    {

        $sql="insert into guestbook (content,user,created) VALUES ('Hello world!','suzy','2010-05-01 21:47:08')";
        self::$pdo->exec($sql);

        $queryTable = $this->getConnection()->createQueryTable(
            'guestbook', 'SELECT * FROM guestbook'
        );
        $expectedTable = $this->createFlatXmlDataSet(dirname(__FILE__)."/expectedBook.xml")
            ->getTable("guestbook");
        $this->assertTablesEqual($expectedTable, $queryTable);
    }
}
?>

这种数据表状态断言即是通过的：

C:\Users\Administrator>D:\phpstudy_pro\Extensions\php\php7.3.4nts\php.exe C:\Users\Administrator\PhpstormProjects\untitled\vendor\phpunit\phpunit\phpunit -c C:\Users\Administrator\PhpstormProjects\untitled\organizing\phpunit.xml C:\Users\Administrator\PhpstormProjects\untitled\organizing\tests\GuestbookTest.php
PHPUnit 7.5.20 by Sebastian Bergmann and contributors.
 
.                                                                   1 / 1 (100%)
 
Time: 77 ms, Memory: 4.00 MB
 
OK (1 test, 1 assertion)
那么我只修改下插入数据的user字段值：
GuestbookTest.php：
<?php

use PHPUnit\DbUnit\DataSet\CsvDataSet;
use PHPUnit\Framework\TestCase;
use PHPUnit\DbUnit\TestCaseTrait;

class GuestbookTest extends TestCase
{
    use TestCaseTrait;
    static private $pdo = null;
    private $conn = null;
    final public function getConnection()
    {
        if ($this->conn === null) {
            if (self::$pdo == null) {
                self::$pdo = new PDO( $GLOBALS['DB_DSN'], $GLOBALS['DB_USER'], $GLOBALS['DB_PASSWD'] );
            }
            $this->conn = $this->createDefaultDBConnection(self::$pdo, $GLOBALS['DB_DBNAME']);
        }
        return $this->conn;
    }
    public function getDataSet()
    {
        $dataSet = new CsvDataSet();
        $dataSet->addTable('guestbook', dirname(__FILE__)."/guestbook.csv");
        return $dataSet;
    }
    public function testAddEntry()
    {

        $sql="insert into guestbook (content,user,created) VALUES ('Hello world!','suzy1','2010-05-01 21:47:08')";
        self::$pdo->exec($sql);

        $queryTable = $this->getConnection()->createQueryTable(
            'guestbook', 'SELECT * FROM guestbook'
        );
        $expectedTable = $this->createFlatXmlDataSet(dirname(__FILE__)."/expectedBook.xml")
            ->getTable("guestbook");
        $this->assertTablesEqual($expectedTable, $queryTable);
    }
}
?>

像是这样，则是没有办法通过数据库状态断言测试的：

C:\Users\Administrator>D:\phpstudy_pro\Extensions\php\php7.3.4nts\php.exe C:\Users\Administrator\PhpstormProjects\untitled\vendor\phpunit\phpunit\phpunit -c C:\Users\Administrator\PhpstormProjects\untitled\organizing\phpunit.xml C:\Users\Administrator\PhpstormProjects\untitled\organizing\tests\GuestbookTest.php
PHPUnit 7.5.20 by Sebastian Bergmann and contributors.
 
F                                                                   1 / 1 (100%)
 
Time: 80 ms, Memory: 4.00 MB
 
There was 1 failure:
 
1) GuestbookTest::testAddEntry
Failed asserting that
+----------------------+----------------------+----------------------+----------------------+
| guestbook                                                                                 |
+----------------------+----------------------+----------------------+----------------------+
|          id          |       content        |         user         |       created        |
+----------------------+----------------------+----------------------+----------------------+
|          1           |     Hello buddy!     |         joe          | 2010-04-24 17:15:23 |
+----------------------+----------------------+----------------------+----------------------+
|          2           |      I like it!      |        nancy         | 2010-04-26 12:14:20 |
+----------------------+----------------------+----------------------+----------------------+
|          3           |     Hello world!     |        suzy1         | 2010-05-01 21:47:08 |
+----------------------+----------------------+----------------------+----------------------+
 
 is equal to expected (table diff enabled)
+----------------------+----------------------+----------------------+----------------------+
| guestbook                                                                                 |
+----------------------+----------------------+----------------------+----------------------+
|          id          |       content        |         user         |       created        |
+----------------------+----------------------+----------------------+----------------------+
|          1           |     Hello buddy!     |         joe          | 2010-04-24 17:15:23 |
+----------------------+----------------------+----------------------+----------------------+
|          2           |      I like it!      |        nancy         | 2010-04-26 12:14:20 |
+----------------------+----------------------+----------------------+----------------------+
|          3           |     Hello world!     | 'suzy' != actual 'su | 2010-05-01 21:47:08 |
+----------------------+----------------------+----------------------+----------------------+
 
.
 
C:\Users\Administrator\PhpstormProjects\untitled\vendor\phpunit\dbunit\src\TestCaseTrait.php:78
C:\Users\Administrator\PhpstormProjects\untitled\organizing\tests\GuestbookTest.php:39
 
FAILURES!
Tests: 1, Assertions: 1, Failures: 1.
另外一点就是官方文档有说日期给数据库测试带来了一个特殊的问题，那么尽量避免日期的断言测试。
我们可以通过从断言中省略“ created ”列来避免失败。
比如修复查询表调用：
<?php 
$queryTable = $this->getConnection()->createQueryTable( 
    'guestbook', 'SELECT id, content, user FROM guestbook' 
); 
?>
像是这里查询表调用时候就是省略了created列。
参考文档：https://phpunit.de/manual/6.5/en/database.html