/**
* Returns all storage engines which are supported by the current server.
*
* @return array Array of supported StorageEngine objects
*/
public static function getSupportedEngines()
{
return StorageEngine::model()->findAllByAttributes(array('Support' => array('YES', 'DEFAULT')));
}
/**
* Shows all installed storage engines.
*/
public function actionStorageEngines()
{
$engines = StorageEngine::model()->findAll();
$this->render('storageEngines', array('engines' => $engines));
}
/**
* tests the return values of the getSupports* methods
*/
public function testSupports()
{
$db_arr = array('MEMORY', 'BerkeleyDB', 'BLACKHOLE', 'EXAMPLE', 'ARCHIVE', 'CSV', 'ndbcluster', 'FEDERATED', 'MRG_MYISAM', 'ISAM');
foreach ($db_arr as $db) {
$se = StorageEngine::model()->findAllByAttributes(array('Engine' => $db));
if (count($se) == 0) {
continue;
}
$this->assertFalse($se[0]->getSupportsChecksum());
$this->assertFalse($se[0]->getSupportsPackKeys());
$this->assertFalse($se[0]->getSupportsDelayKeyWrite());
}
$se = StorageEngine::model()->findAllByAttributes(array('Engine' => 'MyISAM'));
$this->assertTrue($se[0]->getSupportsChecksum());
$this->assertTrue($se[0]->getSupportsPackKeys());
$this->assertTrue($se[0]->getSupportsDelayKeyWrite());
$se = StorageEngine::model()->findAllByAttributes(array('Engine' => 'InnoDB'));
$this->assertFalse($se[0]->getSupportsChecksum());
$this->assertFalse($se[0]->getSupportsPackKeys());
$this->assertFalse($se[0]->getSupportsDelayKeyWrite());
}
