YAML数据集的格式是怎么样的呢？
下面这个文件内容就是YAML的数据集的格式：
guestbook.yml：
guestbook:
-
id: 1
content: "Hello buddy!"
user: "joe"
created: "2010-04-24 17:15:23"
-
id: 2
content: "I like it!"
user:
created: "2010-04-26 12:14:20"
那么在加载YAML数据集的时候需要new下PHPUnit\DbUnit\DataSet\YamlDataSet这个。
实例如下：
MyAppTestsDatabaseTestCase.php：
<?php
use PHPUnit\Framework\TestCase;
use PHPUnit\DbUnit\TestCaseTrait;
use PHPUnit\DbUnit\DataSet\YamlDataSet;
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 new YamlDataSet(dirname(__FILE__).'/guestbook.yml');
}
}
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: 81 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.
没有什么问题，不过我还是更喜欢上篇中的mysql的数据集。
补充下：这个是参考官方文档：https://phpunit.de/manual/6.5/en/database.html
但是官方文档中那个create字段没有双引号包括，我个人这里没有双引号包括，就会报错，所以个人修改为双引号包括了。
另外就是这里YAML数据集的时候某个字段为null，则是这里仅仅有该字段名，而没有字段值，像是上面YAML的第二条表记录数据的user字段就是这样了。