PHP PHPUnit_Extensions_Database_Operation_Factory::CLEAN_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'));
     }
 }

 /**
  * @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);
}