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

phpunit数据库测试-createXMLDataSet

发布时间：2021-09-27 13:59:15编辑：雪饮阅读（）

 Phpunit使用createXMLDataSet创建数据集比起之前用createFlatXMLDataSet创建数据集将会对于null的处理能力更强，但同时对xml文件的格式有要求，如：

myXmlFixture.xml：
<?xml version="1.0" ?>
<dataset>
    <table name="guestbook">
        <column>id</column>
        <column>content</column>
        <column>user</column>
        <column>created</column>
        <row>
            <value>1</value>
            <value>Hello buddy!</value>
            <value>joe</value>
            <value>2010-04-24 17:15:23</value>
        </row>
        <row>
            <value>2</value>
            <value>I like it!</value>
            <null />
            <value>2010-04-26 12:14:20</value>
        </row>
    </table>
</dataset>
那么具体的createXMLDataSet实例如：
MyAppTestsDatabaseTestCase.php：

<?php
use PHPUnit\Framework\TestCase;
use PHPUnit\DbUnit\TestCaseTrait;

abstract class MyAppTestsDatabaseTestCase 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()
    {
        return $this->createXMLDataSet(dirname(__FILE__).'/myXmlFixture.xml');
    }
}
class MyAppTestsDatabaseTestCaseImplement extends MyAppTestsDatabaseTestCase{
    public function testConnect(){
        $l_conn=$this->getConnection();
        var_dump($l_conn);
    }
}

运行结果如：

 
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\MyAppTestsDatabaseTestCase.php
PHPUnit 7.5.20 by Sebastian Bergmann and contributors.
 
R                                                                   1 / 1 (100%)C:\Users\Administrator\PhpstormProjects\untitled\organizing\tests\MyAppTestsDatabaseTestCase.php:29:
class PHPUnit\DbUnit\Database\DefaultConnection#17 (2) {
 protected $connection =>
 class PDO#15 (0) {
 }
 protected $metaData =>
 class PHPUnit\DbUnit\Database\Metadata\MySQL#19 (4) {
    protected $schemaObjectQuoteChar =>
    string(1) "`"
    protected $pdo =>
    class PDO#15 (0) {
    }
    protected $schema =>
    string(11) "myguestbook"
    protected $truncateCommand =>
    string(8) "TRUNCATE"
 }
}
 
 
Time: 78 ms, Memory: 4.00 MB
 
There was 1 risky test:
 
1) MyAppTestsDatabaseTestCaseImplement::testConnect
This test did not perform any assertions
 
C:\Users\Administrator\PhpstormProjects\untitled\organizing\tests\MyAppTestsDatabaseTestCase.php:27
 
OK, but incomplete, skipped, or risky tests!
Tests: 1, Assertions: 0, Risky: 1.
可以看到这样更加人性化，有专门的column标签以及有专门的row标签和null标签。就和mysql的结构很像了的。