PHPUnit 数据库测试

发布于 2024-10-02 09:12:47 字数 1108 浏览 6 评论 0原文

我正在使用 PHPUnit 通过我的存储对象测试对象的插入。每个域对象都有一个添加的和最后修改的时间戳，由存储对象自动处理。我可以使用 PHPUnits DB 扩展方法assertDataSetsEqual 并作为 XML 数据集传递，如下所示。问题已添加，lastmodified 无法硬编码到 XML 数据集中，因为这会一直自动更改，我可以告诉 PHPUnit 忽略这些列吗？或者比较表输出的另一种方式（不是 XML），我可以忽略这些列？

测试

$user = new Social_User();
$user->setFk_mswuserId(10);
$user->setFirstName('Gavin');

$store = new Storage();
$store->save($user);

$xml_dataset = $this->createFlatXMLDataSet('after-new.xml');
$this->assertDataSetsEqual($xml_dataset, $this->getConnection()->createDataSet());

XML 数据集

<?xml version="1.0" encoding="UTF-8"?>
<dataset>
            <user id="1" password="NULL" ip="0" added="0" authenticated="0" lat="0" lon="0" avatar="0" fk_mswuserId="1" timezoneoffset="0" firstName="Ben" lastName="Freeston" deleted="0" lastModified="0" />
            <user id="2" password="NULL" ip="0" added="0" authenticated="0" lat="0" lon="0" avatar="0" fk_mswuserId="10" timezoneoffset="0" firstName="Gavin" lastName="Cooper" deleted="0" lastModified="0"/>
</dataset>

原文

I am using PHPUnit to test insertion of objects via my storage object. Each domain object has a added and lastmodified timestamp, that is handled by the storage object automatically. I can using PHPUnits DB extensions method assertDataSetsEqual and passing as XML data set as below shows. The problem is added and lastmodified cannot be hardcoded into the XML dataset as this will change all the time automatically, can I tell PHPUnit to ignore these cols? or compare the tables output another way (not XML) where I can ignore these columns?

Test

$user = new Social_User();
$user->setFk_mswuserId(10);
$user->setFirstName('Gavin');

$store = new Storage();
$store->save($user);

$xml_dataset = $this->createFlatXMLDataSet('after-new.xml');
$this->assertDataSetsEqual($xml_dataset, $this->getConnection()->createDataSet());

XML Dataset

<?xml version="1.0" encoding="UTF-8"?>
<dataset>
            <user id="1" password="NULL" ip="0" added="0" authenticated="0" lat="0" lon="0" avatar="0" fk_mswuserId="1" timezoneoffset="0" firstName="Ben" lastName="Freeston" deleted="0" lastModified="0" />
            <user id="2" password="NULL" ip="0" added="0" authenticated="0" lat="0" lon="0" avatar="0" fk_mswuserId="10" timezoneoffset="0" firstName="Gavin" lastName="Cooper" deleted="0" lastModified="0"/>
</dataset>

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

失退 2024-10-09 09:12:47

根据

http://www.phpunit.de/ticket/492

这已经是内置的。

另请参阅 M.Lively（DBUnit 主要作者）的这些幻灯片

http://www.slideshare .net/mjlivelyjr/advanced-phpunit-testing

和 B. Eberlei 的 PHPUnit 数据库测试终极指南

~~http://www.phpunit.de/manual/dbunit.txt~~

所以它应该按照以下方式工作

$database_dataset = new PHPUnit_Extensions_Database_DataSet_DataSetFilter ( 
    $this->getConnection()->createDataSet(array('bank_account')), 
    array('bank_account' => array ('date_created')) // excluded
);

According to

http://www.phpunit.de/ticket/492

this is already built-in.

Also see these slides by M.Lively (the main DBUnit author)

http://www.slideshare.net/mjlivelyjr/advanced-phpunit-testing

and B. Eberlei's Ultimate Guide to DB Testing with PHPUnit

~~http://www.phpunit.de/manual/dbunit.txt~~

So it should work along the lines of

$database_dataset = new PHPUnit_Extensions_Database_DataSet_DataSetFilter ( 
    $this->getConnection()->createDataSet(array('bank_account')), 
    array('bank_account' => array ('date_created')) // excluded
);

回复收藏 0 原文

~没有更多了~