Returns a clean insert database operation. It will remove all contents
from the table prior to re-inserting rows.
public static CLEAN_INSERT ( boolean $cascadeTruncates = FALSE ) : PHPUnit_Extensions_Database_Operation_IDatabaseOperation | ||
$cascadeTruncates | boolean | Set to true to force truncates to cascade on databases that support this. |
return | PHPUnit_Extensions_Database_Operation_IDatabaseOperation |
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')); } }
/** * @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; }
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; }
public static function setUpBeforeClass() { $config = array('dbname' => 'DBALiteTest', 'username' => 'dbalite', 'password' => 'testme', 'host' => '127.0.0.1'); $csvfile = DATA_DIR . 'TABLE_Products.csv'; $pdoObj = new PDO("pgsql:host=127.0.0.1 dbname={$config['dbname']}", $config['username'], $config['password']); self::$phpunitConn = new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($pdoObj); self::$dataset = new PHPUnit_Extensions_Database_Dataset_CsvDataSet(); self::$dataset->addTable('Products', $csvfile); $setupOperation = PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT(); $setupOperation->execute(self::$phpunitConn, self::$dataset); $driver = DBALite::factory('pgsql', $config); $sql = 'SELECT * FROM "Products" WHERE "CategoryID" = ?'; self::$dbaliteStmt = $driver->prepare($sql); self::$dbaliteDriver = $driver; }
public static function setUpBeforeClass() { $dbfile = DATA_DIR . 'SqliteTest.sqlite'; $csvfile = DATA_DIR . 'TABLE_Products.csv'; $pdoObj = new PDO("sqlite:{$dbfile}"); self::$phpunitConn = new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($pdoObj); self::$dataset = new PHPUnit_Extensions_Database_Dataset_CsvDataSet(); self::$dataset->addTable('Products', $csvfile); $setupOperation = PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT(); $setupOperation->execute(self::$phpunitConn, self::$dataset); $driver = DBALite::factory('sqlite', array('dbname' => $dbfile)); $sql = 'SELECT * FROM Products WHERE CategoryID = ?'; self::$dbaliteStmt = $driver->prepare($sql); self::$dbaliteDriver = $driver; }
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; }
/** * Executed when this test case is initialized */ public function setUp() { $this->databaseTester = NULL; // Build the PDO datasource name (DSN) $database_dsn = Kohana::config('database.default.connection.type') . ":" . "dbname=" . Kohana::config('database.default.connection.database') . ";" . "host=" . Kohana::config('database.default.connection.host'); // Create PDO object $pdo = new PDO($database_dsn, Kohana::config('database.default.connection.user'), Kohana::config('database.default.connection.pass')); // Create connection $connection = new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($pdo, Kohana::config('database.default.connection.database')); // Set up the database tester object, setup operation and dataset $this->databaseTester = new PHPUnit_Extensions_Database_DefaultTester($connection); $this->databaseTester->setSetUpOperation(PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT()); // Set the dataset for the tester $this->databaseTester->setDataSet($this->getDataSet()); // Run setup $this->databaseTester->onSetUp(); }
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(); } }
/** * Returns the database operation executed in test setup. * * @return PHPUnit_Extensions_Database_Operation_DatabaseOperation */ protected function getSetUpOperation() { return PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT(); }
/** * 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(); }
/** * @depends testConnection */ public function testBuild_withDefaultOperationsHasDefaultSetUpOperation($connection) { $dbConfig = $this->builder->connection($connection)->dataSet($this->dataSet)->build(); $this->assertEquals(PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT(), $dbConfig->getSetUpOperation()); }
public function __construct(\PHPUnit_Extensions_Database_DB_IDatabaseConnection $connection, $fixturePath) { parent::__construct($connection, $fixturePath); $this->setUpOperation = \PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT(true); }
break; default: case 'sqlite': $params = array('path' => PSX_PATH_CACHE . '/fusio_ui.db', 'driver' => 'pdo_sqlite'); break; } $config = new Doctrine\DBAL\Configuration(); $connection = Doctrine\DBAL\DriverManager::getConnection($params, $config); $container->set('connection', $connection); if (isset($_SERVER['argv']) && in_array('--warmup', $_SERVER['argv'])) { // warmup $loader->addClassMap(['Fusio\\Impl\\Fixture' => __DIR__ . '/../tests/Fixture.php', 'Fusio\\Impl\\TestSchema' => __DIR__ . '/../tests/TestSchema.php']); // create schema $fromSchema = $connection->getSchemaManager()->createSchema(); $version = new Fusio\Impl\Database\Version\Version010(); $toSchema = $version->getSchema(); Fusio\Impl\TestSchema::appendSchema($toSchema); $queries = $fromSchema->getMigrateToSql($toSchema, $connection->getDatabasePlatform()); foreach ($queries as $query) { $connection->query($query); } // insert fixtures $connection = new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($container->get('connection')->getWrappedConnection()); PHPUnit_Extensions_Database_Operation_Factory::CLEAN_INSERT()->execute($connection, Fusio\Impl\Fixture::getDataSet()); echo 'Warmup successful' . "\n"; } else { // run $request = $container->get('request_factory')->createRequest(); $response = $container->get('response_factory')->createResponse(); $container->get('dispatch')->route($request, $response); }