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); }