protected function _checkDbTable()
{
if (null !== $this->_dbRessource) {
$tablesToCheck = array();
$tablesNotFound = array();
$tablesToCheck[] = 'auth_belong';
$tablesToCheck[] = 'auth_group';
$tablesToCheck[] = 'auth_group_permission';
$tablesToCheck[] = 'auth_permission';
$tablesToCheck[] = 'auth_user';
$tablesToCheck[] = 'auth_user_permission';
$tablesToCheck[] = 'centurion_content_type';
$tablesToCheck[] = 'centurion_navigation';
$tablesToCheck[] = 'centurion_site';
$tablesToCheck[] = 'cms_flatpage';
$tablesToCheck[] = 'cms_flatpage_template';
$tablesToCheck[] = 'media_duplicate';
$tablesToCheck[] = 'media_file';
$tablesToCheck[] = 'media_image';
$tablesToCheck[] = 'media_multiupload_ticket';
$tablesToCheck[] = 'media_video';
$tablesToCheck[] = 'translation_language';
$tablesToCheck[] = 'translation_tag';
$tablesToCheck[] = 'translation_tag_uid';
$tablesToCheck[] = 'translation_translation';
$tablesToCheck[] = 'translation_uid';
$tablesToCheck[] = 'user_profile';
foreach ($tablesToCheck as $tableName) {
try {
$this->_dbRessource->getDbAdapter()->describeTable($tableName);
} catch (Exception $e) {
if ($e->getCode() == '42') {
$tablesNotFound[] = $tableName;
} else {
throw $e;
}
}
}
if (count($tablesNotFound) > 0) {
if (count($tablesNotFound) == count($tablesToCheck)) {
//TODO: zf db install
$this->_checklist[] = array('code' => -1, 'canBeBetter' => true, 'isNotSecure' => false, 'text' => 'All table are missing.', 'alt' => 'Have you forget a "zf db install" ?');
} else {
$this->_checklist[] = array('code' => 0, 'canBeBetter' => true, 'isNotSecure' => false, 'text' => 'Some table are missing', 'alt' => 'Some table are missing: <br /> - ' . implode('<br />- ', $tablesNotFound));
}
}
} else {
$this->_checklist[] = array('code' => -1, 'canBeBetter' => true, 'isNotSecure' => true, 'text' => 'Can\'t check table; no connection to bdd', 'alt' => '');
}
}
public function testInitShouldInitializeDbAdapter()
{
// require_once 'Zend/Application/Resource/Db.php';
$config = array('adapter' => 'Pdo_Sqlite', 'params' => array('dbname' => ':memory:'), 'isDefaultTableAdapter' => false);
$resource = new Zend_Application_Resource_Db($config);
$resource->init();
$db = $resource->getDbAdapter();
$this->assertTrue($db instanceof Zend_Db_Adapter_Pdo_Sqlite);
}
public function getDbAdapter()
{
if (self::$_cachedAdapter instanceof Zend_Db_Adapter_Abstract) {
$adapter = self::$_cachedAdapter;
} else {
$adapter = parent::getDbAdapter();
}
return $adapter;
}