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