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