PHP DboSource::dropSchema方法代碼示例

 /**
  * testDropSchemaNoSchema method
  *
  * @expectedException PHPUnit_Framework_Error
  * @throws PHPUnit_Framework_Error
  * @return void
  */
 public function testDropSchemaNoSchema()
 {
     try {
         $this->Dbo->dropSchema(null);
     } catch (Throwable $t) {
         throw new PHPUnit_Framework_Error($t);
     }
 }

 /**
  * sql drop statement
  *
  * @param $datasource
  * @param $tablename
  * @param $exclude_missing_tables
  * @return string
  */
 function getDropSql($datasource, $tablename = null, $exclude_missing_tables = false)
 {
     if (!$this->_checkCurrentDatasource($datasource)) {
         $this->_setupDataSource();
     }
     $this->Schema->tables = $this->_getProcessTables($tablename, $exclude_missing_tables);
     $sql = $this->DataSource->dropSchema($this->Schema);
     return $this->out($sql);
 }

 /**
  * testSchema method
  *
  * @access public
  * @return void
  */
 public function testSchema()
 {
     $Schema = new CakeSchema();
     $Schema->tables = array('table' => array(), 'anotherTable' => array());
     $this->expectError();
     $result = $this->Dbo->dropSchema(null);
     $this->assertTrue($result === null);
     $result = $this->Dbo->dropSchema($Schema, 'non_existing');
     $this->assertTrue(empty($result));
     $result = $this->Dbo->dropSchema($Schema, 'table');
     $this->assertPattern('/^\\s*DROP TABLE IF EXISTS\\s+' . $this->Dbo->fullTableName('table') . ';\\s*$/s', $result);
 }

 /**
  * Drop an existing table.
  *
  * @param string $table
  * @throws MissingTableException if the table does not exists in the database
  * @throws MigrationException if an sql error occurred
  * @return Migration
  */
 public function dropTable($table)
 {
     if (!in_array($this->_db->fullTableName($table, false, false), $this->_db->listSources())) {
         throw new MissingTableException(__d('migration', 'Table "%s" does not exist in database.', $this->_db->fullTableName($table, false, false)));
     }
     $this->_schema->tables = array($table => array());
     try {
         $this->_db->execute($this->_db->dropSchema($this->_schema));
     } catch (Exception $e) {
         throw new MigrationException(__d('migration', 'SQL Error: %s', $e->getMessage()));
     }
     return $this;
 }

 /**
  * Drop Table method
  *
  * @param string $type Type of operation to be done, in this case 'drop_table'
  * @param array $tables List of tables to be dropped
  * @return boolean Return true in case of success, otherwise false
  * @throws MigrationException
  */
 protected function _dropTable($type, $tables)
 {
     foreach ($tables as $table) {
         $this->Schema->tables = array($table => array());
         if ($this->_invokePrecheck('beforeAction', 'drop_table', array('table' => $table))) {
             $this->_invokeCallbacks('beforeAction', 'drop_table', array('table' => $table));
             if (@$this->db->execute($this->db->dropSchema($this->Schema)) === false) {
                 throw new MigrationException($this, sprintf(__d('migrations', 'SQL Error: %s'), $this->db->error));
             }
             $this->_invokeCallbacks('afterAction', 'drop_table', array('table' => $table));
         }
     }
     return true;
 }

 /**
  * Test the alter index capabilities of postgres
  *
  * @return void
  */
 public function testAlterIndexes()
 {
     $this->Dbo->cacheSources = false;
     $schema1 = new CakeSchema(array('name' => 'AlterTest1', 'connection' => 'test', 'altertest' => array('id' => array('type' => 'integer', 'null' => false, 'default' => 0), 'name' => array('type' => 'string', 'null' => false, 'length' => 50), 'group1' => array('type' => 'integer', 'null' => true), 'group2' => array('type' => 'integer', 'null' => true))));
     $this->Dbo->rawQuery($this->Dbo->createSchema($schema1));
     $schema2 = new CakeSchema(array('name' => 'AlterTest2', 'connection' => 'test', 'altertest' => array('id' => array('type' => 'integer', 'null' => false, 'default' => 0), 'name' => array('type' => 'string', 'null' => false, 'length' => 50), 'group1' => array('type' => 'integer', 'null' => true), 'group2' => array('type' => 'integer', 'null' => true), 'indexes' => array('name_idx' => array('unique' => false, 'column' => 'name'), 'group_idx' => array('unique' => false, 'column' => 'group1'), 'compound_idx' => array('unique' => false, 'column' => array('group1', 'group2')), 'PRIMARY' => array('unique' => true, 'column' => 'id')))));
     $this->Dbo->query($this->Dbo->alterSchema($schema2->compare($schema1)));
     $indexes = $this->Dbo->index('altertest');
     $this->assertEquals($schema2->tables['altertest']['indexes'], $indexes);
     // Change three indexes, delete one and add another one
     $schema3 = new CakeSchema(array('name' => 'AlterTest3', 'connection' => 'test', 'altertest' => array('id' => array('type' => 'integer', 'null' => false, 'default' => 0), 'name' => array('type' => 'string', 'null' => false, 'length' => 50), 'group1' => array('type' => 'integer', 'null' => true), 'group2' => array('type' => 'integer', 'null' => true), 'indexes' => array('name_idx' => array('unique' => true, 'column' => 'name'), 'group_idx' => array('unique' => false, 'column' => 'group2'), 'compound_idx' => array('unique' => false, 'column' => array('group2', 'group1')), 'another_idx' => array('unique' => false, 'column' => array('group1', 'name'))))));
     $this->Dbo->query($this->Dbo->alterSchema($schema3->compare($schema2)));
     $indexes = $this->Dbo->index('altertest');
     $this->assertEquals($schema3->tables['altertest']['indexes'], $indexes);
     // Compare us to ourself.
     $this->assertEquals(array(), $schema3->compare($schema3));
     // Drop the indexes
     $this->Dbo->query($this->Dbo->alterSchema($schema1->compare($schema3)));
     $indexes = $this->Dbo->index('altertest');
     $this->assertEquals(array(), $indexes);
     $this->Dbo->query($this->Dbo->dropSchema($schema1));
 }

 /**
  * testDropSchemaNoSchema method
  *
  * @expectedException PHPUnit_Framework_Error
  * @return void
  */
 public function testDropSchemaNoSchema()
 {
     $result = $this->Dbo->dropSchema(null);
 }

 /**
  * Run after all tests executed, should return SQL statement to drop table for this fixture.
  *
  * @param DboSource $db An instance of the database object used to create the fixture table
  * @return bool True on success, false on failure
  */
 public function drop($db)
 {
     if (empty($this->fields)) {
         return false;
     }
     $this->Schema->build(array($this->table => $this->fields));
     try {
         $db->execute($db->dropSchema($this->Schema), array('log' => false));
         $this->created = array_diff($this->created, array($db->configKeyName));
     } catch (Exception $e) {
         return false;
     }
     return true;
 }

 /**
  * testDropSchemaNoSchema method
  *
  * @expectedException PHPUnit_Framework_Error
  * @return void
  */
 public function testDropSchemaNoSchema()
 {
     $this->Dbo->dropSchema(NULL);
 }