public function getSetUpOperation()
{
// whether you want cascading truncates
// set false if unsure
$cascadeTruncates = false;
return new PHPUnit_Extensions_Database_Operation_Composite(array(new PHPUnit_Extensions_Database_Operation_MySQL55Truncate($cascadeTruncates), PHPUnit_Extensions_Database_Operation_Factory::INSERT()));
}
private function seedDatabases()
{
foreach (self::$conns as $i => $conn) {
$setUpOperation = \PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT();
$setUpOperation->execute($conn, $this->createXMLDataSet(dirname(__FILE__) . '/multi_seed' . $i . '.xml'));
}
}
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 Operation\MySQLTruncate($cascadeTruncates), \PHPUnit_Extensions_Database_Operation_Factory::INSERT()));
}
protected function getDatabaseTester()
{
$tester = new PHPUnit_Extensions_Database_DefaultTester($this->_conn);
$tester->setSetUpOperation(new PHPUnit_Extensions_Database_Operation_Composite(array(new DB_operation_set_env('foreign_key_checks', 0), PHPUnit_Extensions_Database_Operation_Factory::DELETE_ALL(), new DB_operation_set_env('foreign_key_checks', 1), PHPUnit_Extensions_Database_Operation_Factory::INSERT())));
$tester->setTearDownOperation(PHPUnit_Extensions_Database_Operation_Factory::NONE());
return $tester;
}
/**
* Creates a new default database tester using the given connection.
*
* @param PHPUnit_Extensions_Database_DB_IDatabaseConnection $connection
*/
public function __construct(\PHPUnit_Extensions_Database_DB_IDatabaseConnection $connection)
{
if (!$connection instanceof Connection) {
throw new InvalidArgumentException("Not a valid Zend_Test_PHPUnit_Db_Connection instance, " . get_class($connection) . " given!");
}
$this->connection = $connection;
$this->setUpOperation = new \PHPUnit_Extensions_Database_Operation_Composite(array(new Operation\Truncate(), new Operation\Insert()));
$this->tearDownOperation = \PHPUnit_Extensions_Database_Operation_Factory::NONE();
}
/**
* Tear down operation - Executed when the test is complete
*/
public function tearDown()
{
// Tear down operation
$this->databaseTester->setTearDownOperation(PHPUnit_Extensions_Database_Operation_Factory::TRUNCATE());
$this->databaseTester->setDataSet($this->getDataSet());
$this->databaseTester->onTearDown();
// Garbage collection
unset($this->databaseTester);
}
/**
* @return PHPUnit_Extensions_Database_DefaultTester
*/
protected function getDatabaseTester()
{
$connection = new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($this->pdo, 'sqlite');
$tester = new PHPUnit_Extensions_Database_DefaultTester($connection);
$tester->setSetUpOperation(PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT());
$tester->setTearDownOperation(PHPUnit_Extensions_Database_Operation_Factory::NONE());
$tester->setDataSet(new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__) . '/_files/bank-account-seed.xml'));
return $tester;
}
/**
* Creates a new default database tester using the given connection.
*
* @param PHPUnit_Extensions_Database_DB_IDatabaseConnection $connection
*/
public function __construct(PHPUnit_Extensions_Database_DB_IDatabaseConnection $connection)
{
if (!$connection instanceof Zend_Test_PHPUnit_Db_Connection) {
#require_once "Zend/Test/PHPUnit/Db/Exception.php";
throw new Zend_Test_PHPUnit_Db_Exception("Not a valid Zend_Test_PHPUnit_Db_Connection instance, " . get_class($connection) . " given!");
}
$this->connection = $connection;
$this->setUpOperation = new PHPUnit_Extensions_Database_Operation_Composite(array(new Zend_Test_PHPUnit_Db_Operation_Truncate(), new Zend_Test_PHPUnit_Db_Operation_Insert()));
$this->tearDownOperation = PHPUnit_Extensions_Database_Operation_Factory::NONE();
}
public function applyTo(Database $db)
{
$pdo = $db->getPdo();
$connection = new \PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($pdo, $db->getName());
$databasetester = new \PHPUnit_Extensions_Database_DefaultTester($connection);
$setupoperation = \PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT();
$databasetester->setSetUpOperation($setupoperation);
$databasetester->setDataSet($this->dataset);
$databasetester->onSetUp();
}
protected function getDatabaseTester()
{
$pdo = new PDO('mysql:host=localhost;dbname=c3op', 'root', '');
$connection = new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($pdo, 'c3op');
$tester = new PHPUnit_Extensions_Database_DefaultTester($connection);
$tester->setSetUpOperation(PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT());
$tester->setTearDownOperation(PHPUnit_Extensions_Database_Operation_Factory::NONE());
$tester->setDataSet(new PHPUnit_Extensions_Database_DataSet_FlatXMLDataSet(dirname(__FILE__) . '/fixture/projects_seed.xml'));
return $tester;
}
function __construct()
{
// connect for unit testing framework
$pdo = new PDO('mysql:host=' . HOST . ';dbname=' .
DB_NAME, USERNAME, PASSWORD);
$connection = new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($pdo, 'test');
$tester = new PHPUnit_Extensions_Database_DefaultTester($connection);
$tester->setSetUpOperation(PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT());
$tester->setTearDownOperation(PHPUnit_Extensions_Database_Operation_Factory::NONE());
$tester->setDataSet(new PHPUnit_Extensions_Database_DataSet_FlatXMLDataSet
(dirname(__FILE__).'/../models/files/users.xml'));
$this->tester = $tester;
}
protected function getSetUpOperation()
{
if (self::$_oldDataset == null)
{
return PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT(true);
}
else if (self::$_oldDataset != $this->_dataset)
{
$truncate = PHPUnit_Extensions_Database_Operation_Factory::TRUNCATE(true);
$truncate->execute($this->getConnection(),
$this->createFlatXMLDataSet(self::$_oldDataset));
return PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT(true);
}
else
{
return PHPUnit_Extensions_Database_Operation_Factory::NONE();
}
}
/**
* Creates a new database tester.
*
* @param PHPUnit_Extensions_Database_DB_IDatabaseConnection $databaseConnection
*/
public function __construct()
{
$this->setUpOperation = PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT();
$this->tearDownOperation = PHPUnit_Extensions_Database_Operation_Factory::NONE();
}
/**
* Use our own truncate operation so that we can work with InnoDB foreign
* keys constraints.
*
* @see http://stackoverflow.com/questions/10331445/phpunit-and-mysql-truncation-error
* @return \PHPUnit_Extensions_Database_Operation_Composite
*/
public function getSetUpOperation()
{
return new \PHPUnit_Extensions_Database_Operation_Composite(array(new TruncateOperation(true), \PHPUnit_Extensions_Database_Operation_Factory::INSERT()));
}
public function __construct(IDatabaseConnection $connection)
{
$this->connection = $connection;
$this->setUpOperation = new \PHPUnit_Extensions_Database_Operation_Composite(array(new Operations\Truncate($connection->allowsCascading()), OperationFactory::INSERT()));
$this->tearDownOperation = OperationFactory::NONE();
}
public function __construct(\PHPUnit_Extensions_Database_DB_IDatabaseConnection $connection, $fixturePath)
{
parent::__construct($connection, $fixturePath);
$this->setUpOperation = \PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT(true);
}
protected function getSetUpOperation()
{
return PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT();
}
/**
* Returns the database operation executed in test cleanup.
*
* @return PHPUnit_Extensions_Database_Operation_DatabaseOperation
*
* @since 12.1
*/
protected function getTearDownOperation()
{
// Required given the use of InnoDB contraints.
return PHPUnit_Extensions_Database_Operation_Factory::DELETE_ALL();
}
/**
* Returns the database operation executed in test setup.
*
* @return \PHPUnit_Extensions_Database_Operation_Composite
*
* @since 1.0
*/
protected function getSetUpOperation()
{
// At the moment we can safely TRUNCATE tables, since we're not using InnoDB tables nor foreign keys
// However if we ever need them, we can use our InsertOperation and TruncateOperation to suppress foreign keys
return new \PHPUnit_Extensions_Database_Operation_Composite(array(\PHPUnit_Extensions_Database_Operation_Factory::TRUNCATE(), \PHPUnit_Extensions_Database_Operation_Factory::INSERT()));
}
public function getSetUpOperation()
{
$cascadeTruncates = TRUE;
return new \PHPUnit_Extensions_Database_Operation_Composite(array(new FoodAppTruncateOperation($cascadeTruncates), \PHPUnit_Extensions_Database_Operation_Factory::INSERT()));
}
/**
* @depends testConnection
*/
public function testBuild_withDefaultOperationsHasDefaultTearDownOperation($connection)
{
$dbConfig = $this->builder->connection($connection)->dataSet($this->dataSet)->build();
$this->assertEquals(PHPUnit_Extensions_Database_Operation_Factory::TRUNCATE(), $dbConfig->getTearDownOperation());
}
public function getSetUpOperation()
{
return PHPUnit_Extensions_Database_Operation_Factory::NONE();
}
protected function getSetUpOperation()
{
return \PHPUnit_Extensions_Database_Operation_Factory::DELETE_ALL();
}
/**
* templates the tearDown method that runs after each test; this method expunges the database after each run
*
* @return PHPUnit_Extensions_Database_Operation_IDatabaseOperation delete command for the database
**/
public final function getTearDownOperation()
{
return PHPUnit_Extensions_Database_Operation_Factory::DELETE_ALL();
}
/**
* @return \PHPUnit_Extensions_Database_Operation
*/
protected function getSetUpOperation()
{
return new \PHPUnit_Extensions_Database_Operation_Composite(array(\PHPUnit_Extensions_Database_Operation_Factory::DELETE_ALL(), \PHPUnit_Extensions_Database_Operation_Factory::INSERT()));
}
/**
* Returns the database operation executed in test setup.
* Overriding to fix Mysql 5.5 truncate errors
*
* @return PHPUnit_Extensions_Database_Operation_DatabaseOperation
*/
protected function getSetUpOperation()
{
//return PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT();
$cascadeTruncates = TRUE;
return new PHPUnit_Extensions_Database_Operation_Composite(array(new Unittest_Database_Operation_MySQL55Truncate($cascadeTruncates), PHPUnit_Extensions_Database_Operation_Factory::INSERT()));
}
/**
* Returns the database operation executed in test cleanup.
*
* @return PHPUnit_Extensions_Database_Operation_DatabaseOperation
*/
protected function getTearDownOperation()
{
return PHPUnit_Extensions_Database_Operation_Factory::NONE();
}
protected function getSetUpOperation()
{
return new \PHPUnit_Extensions_Database_Operation_Composite(array(\PHPUnit_Extensions_Database_Operation_Factory::TRUNCATE(), new BulkInsertDatabaseOperation()));
}
/**
* setupd db
* called in setUp()
*/
public function getSetUpOperation()
{
$cascadeTruncates = false;
// 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()));
}
/**
* Load database fixtures
*
* @param \HQ\Test\FixtureLoader $fixtureLoader
* @param AbstractConnection $connection
*/
protected function loadFixtures(FixtureLoader $fixtureLoader, AbstractConnection $connection)
{
$this->executeQueryWithForeignKeySetting(function () use($fixtureLoader, $connection) {
$fixtureSet = $fixtureLoader->load($connection, $this);
// create database tester & setup tasks
$databaseTester = $this->createDatabaseTester($connection);
$databaseTester->setSetUpOperation(\PHPUnit_Extensions_Database_Operation_Factory::INSERT());
$databaseTester->setDataSet($fixtureSet);
$databaseTester->onSetUp();
}, $connection, $this->disableFixturesForeignKeyChecks);
}
