PHP Index::resetColumnsSize方法代码示例

 public function testResetColumnsSize()
 {
     $columns[] = $this->getColumnMock('foo', array('size' => 100));
     $columns[] = $this->getColumnMock('bar', array('size' => 5));
     $index = new Index();
     $index->setColumns($columns);
     $this->assertTrue($index->hasColumnSize('foo'));
     $this->assertTrue($index->hasColumnSize('bar'));
     $index->resetColumnsSize();
     $this->assertFalse($index->hasColumnSize('foo'));
     $this->assertFalse($index->hasColumnSize('bar'));
 }

 /**
  * Creates a new index.
  *
  * @param  string $name    The index name
  * @param  array  $columns The list of columns to index
  * @return Index  $index   The created index
  */
 protected function createIndex($name, array $columns)
 {
     $index = new Index($name);
     $index->setColumns($columns);
     $index->resetColumnsSize();
     $this->addIndex($index);
     return $index;
 }

 /**
  * Adds extra indices for reverse foreign keys
  * This is required for MySQL databases,
  * and is called from Database::doFinalInitialization()
  */
 public function addExtraIndices()
 {
     /**
      * A collection of indexed columns. The keys is the column name
      * (concatenated with a comma in the case of multi-col index), the value is
      * an array with the names of the indexes that index these columns. We use
      * it to determine which additional indexes must be created for foreign
      * keys. It could also be used to detect duplicate indexes, but this is not
      * implemented yet.
      * @var array
      */
     $_indices = array();
     $this->collectIndexedColumns('PRIMARY', $this->getPrimaryKey(), $_indices);
     $_tableIndices = array_merge($this->getIndices(), $this->getUnices());
     foreach ($_tableIndices as $_index) {
         $this->collectIndexedColumns($_index->getName(), $_index->getColumns(), $_indices);
     }
     // we're determining which tables have foreign keys that point to this table,
     // since MySQL needs an index on any column that is referenced by another table
     // (yep, MySQL _is_ a PITA)
     $counter = 0;
     foreach ($this->referrers as $foreignKey) {
         $referencedColumns = $foreignKey->getForeignColumnObjects();
         $referencedColumnsHash = $this->getColumnList($referencedColumns);
         if (!empty($referencedColumns) && !isset($_indices[$referencedColumnsHash])) {
             // no matching index defined in the schema, so we have to create one
             $name = sprintf('I_referenced_%s_%s', $foreignKey->getName(), ++$counter);
             if ($this->hasIndex($name)) {
                 //if we have already a index with this name, then it looks like the columns of this index have just
                 //been changed, so remove it and inject it again. This is the case if a referenced table is handled
                 //later than the referencing table.
                 $this->removeIndex($name);
             }
             $index = new Index();
             $index->setName($name);
             $index->setColumns($referencedColumns);
             $index->resetColumnsSize();
             $this->addIndex($index);
             // Add this new index to our collection, otherwise we might add it again (bug #725)
             $this->collectIndexedColumns($index->getName(), $referencedColumns, $_indices);
         }
     }
     // we're adding indices for this table foreign keys
     foreach ($this->foreignKeys as $foreignKey) {
         $localColumns = $foreignKey->getLocalColumnObjects();
         $localColumnsHash = $this->getColumnList($localColumns);
         if (!empty($localColumns) && !isset($_indices[$localColumnsHash])) {
             // no matching index defined in the schema, so we have to create one.
             // MySQL needs indices on any columns that serve as foreign keys. these are not auto-created prior to
             // 4.1.2
             $name = substr_replace($foreignKey->getName(), 'FI_', strrpos($foreignKey->getName(), 'FK_'), 3);
             if ($this->hasIndex($name)) {
                 //if we have already a index with this name, then it looks like the columns of this index have just
                 //been changed, so remove it and inject it again. This is the case if a referenced table is handled
                 //later than the referencing table.
                 $this->removeIndex($name);
             }
             $index = new Index();
             $index->setName($name);
             $index->setColumns($localColumns);
             $index->resetColumnsSize();
             $this->addIndex($index);
             $this->collectIndexedColumns($index->getName(), $localColumns, $_indices);
         }
     }
 }