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

phpunit数据库测试-csv数据集

发布时间：2021-09-27 23:33:01编辑：雪饮阅读（）

 Csv的数据集也就是那种用逗号分隔的数据集，这种数据集不能处理null字段值的能力。

一个csv数据集如：
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"
那么要载入这个数据集需要用到PHPUnit\DbUnit\DataSet\CsvDataSet的实例化
具体的使用如：
MyAppTestsDatabaseTestCase.php:

<?php
use PHPUnit\Framework\TestCase;
use PHPUnit\DbUnit\TestCaseTrait;
use PHPUnit\DbUnit\DataSet\CsvDataSet;
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()
    {
        $dataSet = new CsvDataSet();
        $dataSet->addTable('guestbook', dirname(__FILE__)."/guestbook.csv");
        return $dataSet;
    }
}
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:31:
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: 82 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:29
 
OK, but incomplete, skipped, or risky tests!
Tests: 1, Assertions: 0, Risky: 1.