PHPUnit 和 MySQL 截断错误
I am getting a headache with PHPUnit's behavior of always running TRUNCATE
prior to inserting fixtures without first setting foreign key checks off:
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
Basically, PHPUnit tries to truncate a table before it inserts fixtures. How do I tell it to SET FOREIGN_KEY_CHECKS=0;
?
I found the answer it seems. I ended up overriding some methods by extending a class.
<?php
/**
* Disables foreign key checks temporarily.
*/
class TruncateOperation extends PHPUnit_Extensions_Database_Operation_Truncate
{
public function execute(PHPUnit_Extensions_Database_DB_IDatabaseConnection $connection, PHPUnit_Extensions_Database_DataSet_IDataSet $dataSet)
{
$connection->getConnection()->query("SET foreign_key_checks = 0");
parent::execute($connection, $dataSet);
$connection->getConnection()->query("SET foreign_key_checks = 1");
}
}
Then example usage:
class FooTest extends PHPUnit_Extensions_Database_TestCase
{
public function getSetUpOperation()
{
$cascadeTruncates = true; // If you want cascading truncates, false otherwise. If unsure choose false.
return new PHPUnit_Extensions_Database_Operation_Composite(array(
new TruncateOperation($cascadeTruncates),
PHPUnit_Extensions_Database_Operation_Factory::INSERT()
));
}
}
So I'm effectively disabling foreign key checks and setting them back if they were ever set. Obviously you should make a base class that has this functionality and you extend it rather than PHPUnit's TestCase.
相关文章