PHP Zend_Db_Table_Abstract::getDefaultMetadataCache方法代码示例

 public function testTableSetDefaultMetadataCacheRegistry()
 {
     $cache = $this->_getCache();
     Zend_Registry::set('registered_metadata_cache', $cache);
     Zend_Db_Table_Abstract::setDefaultMetadataCache('registered_metadata_cache');
     $this->assertSame($cache, Zend_Db_Table_Abstract::getDefaultMetadataCache());
 }

 * @since      File available since Release 6.0
 * @author     David Soria Parra <soria_parra@mayflower.de>
 */
// Force quotes off to run in cruisecontrol
ini_set("magic_quotes_gpc", 0);
ini_set("magic_quotes_runtime", 0);
ini_set("magic_quotes_sybase", 0);
/* use command line switches to overwrite this */
define("DEFAULT_CONFIG_FILE", "configuration.php");
define("PHPR_CONFIG_FILE", "configuration.php");
define("DEFAULT_CONFIG_SECTION", "testing-mysql");
define("PHPR_CONFIG_SECTION", "testing-mysql");
define('PHPR_ROOT_PATH', realpath(dirname(__FILE__) . '/../../'));
require_once PHPR_ROOT_PATH . DIRECTORY_SEPARATOR . 'library' . DIRECTORY_SEPARATOR . 'Phprojekt.php';
Phprojekt::getInstance();
Zend_Db_Table_Abstract::getDefaultMetadataCache()->clean();
if (!defined('PHPUnit_MAIN_METHOD')) {
    define('PHPUnit_MAIN_METHOD', 'AllTests::main');
}
require_once 'PHPUnit/Framework.php';
require_once 'PHPUnit/TextUI/TestRunner.php';
require_once 'PHPUnit/Util/Filter.php';
require_once 'Default/AllTests.php';
require_once 'Phprojekt/AllTests.php';
require_once 'Timecard/AllTests.php';
require_once 'History/AllTests.php';
require_once 'User/AllTests.php';
require_once 'Calendar/AllTests.php';
require_once 'Note/AllTests.php';
require_once 'Role/AllTests.php';
require_once 'Todo/AllTests.php';

 /**
  * Gets content panel for the Debugbar
  *
  * @return string
  */
 public function getPanel()
 {
     if (!$this->_db) {
         return '';
     }
     $html = '<h4>Database queries';
     // @TODO: This is always on?
     if (Zend_Db_Table_Abstract::getDefaultMetadataCache()) {
         $html .= ' – Metadata cache ENABLED';
     } else {
         $html .= ' – Metadata cache DISABLED';
     }
     $html .= '</h4>';
     return $html . $this->getProfile();
 }

 /**
  * Gets content panel for the Debugbar
  *
  * @return string
  */
 public function getPanel()
 {
     if (!$this->_db) {
         return '';
     }
     $html = '<h4>Database queries</h4>';
     if (Zend_Db_Table_Abstract::getDefaultMetadataCache()) {
         $html .= 'Metadata cache is ENABLED';
     } else {
         $html .= 'Metadata cache is DISABLED';
     }
     foreach ($this->_db as $name => $adapter) {
         if ($profiles = $adapter->getProfiler()->getQueryProfiles()) {
             $html .= '<h4>Adapter ' . $name . '</h4><ol>';
             foreach ($profiles as $profile) {
                 $html .= '<li><strong>[' . round($profile->getElapsedSecs() * 1000, 2) . ' ms]</strong> ' . htmlspecialchars($profile->getQuery()) . '</li>';
             }
             $html .= '</ol>';
         }
     }
     return $html;
 }

 /**
  * Gets content panel for the Debugbar
  *
  * @return string
  */
 public function getPanel()
 {
     if (!$this->_db) {
         return '';
     }
     $html = '<h4>Database queries</h4>';
     if (Zend_Db_Table_Abstract::getDefaultMetadataCache()) {
         $html .= 'Metadata cache is ENABLED';
     } else {
         $html .= 'Metadata cache is DISABLED';
     }
     # For adding quotes to query params
     function add_quotes(&$value, $key)
     {
         $value = "'" . $value . "'";
     }
     foreach ($this->_db as $name => $adapter) {
         if ($profiles = $adapter->getProfiler()->getQueryProfiles()) {
             $adapter->getProfiler()->setEnabled(false);
             $html .= '<h4>Adapter ' . $name . '</h4><ol>';
             foreach ($profiles as $profile) {
                 $params = $profile->getQueryParams();
                 array_walk($params, 'add_quotes');
                 $paramCount = count($params);
                 if ($paramCount) {
                     $html .= '<li>' . htmlspecialchars(preg_replace(array_fill(0, $paramCount, '/\\?/'), $params, $profile->getQuery(), 1));
                 } else {
                     $html .= '<li>' . htmlspecialchars($profile->getQuery());
                 }
                 $html .= '<p><strong>Time:</strong> ' . round($profile->getElapsedSecs() * 1000, 2) . ' ms' . $this->getLinebreak();
                 $supportedAdapter = $adapter instanceof Zend_Db_Adapter_Mysqli || $adapter instanceof Zend_Db_Adapter_Pdo_Mysql;
                 # Run explain if enabled, supported adapter and SELECT query
                 if ($this->_explain && $supportedAdapter && Zend_Db_Profiler::SELECT == $profile->getQueryType()) {
                     $explain = $adapter->fetchRow('EXPLAIN ' . $profile->getQuery());
                     $html .= '<strong>Type:</strong> ' . strtolower($explain['select_type']) . ', ' . $explain['type'] . $this->getLinebreak() . '<strong>Possible Keys:</strong> ' . $explain['possible_keys'] . $this->getLinebreak() . '<strong>Key Used:</strong> ' . $explain['key'] . $this->getLinebreak() . '<strong>Rows:</strong> ' . $explain['rows'] . $this->getLinebreak() . '<strong>Extra:</strong> ' . $explain['Extra'];
                 }
                 $html .= '</p></li>';
             }
             $html .= '</ol>';
         }
     }
     return $html;
 }

 /**
  * Ensures that Zend_Db_Table_Abstract::setDefaultMetadataCache() performs as expected
  *
  * @return void
  */
 public function testTableSetDefaultMetadataCache()
 {
     $cache = $this->_getCache();
     Zend_Db_Table_Abstract::setDefaultMetadataCache($cache);
     $this->assertSame($cache, Zend_Db_Table_Abstract::getDefaultMetadataCache());
     Zend_Db_Table_Abstract::setDefaultMetadataCache();
     $this->assertNull(Zend_Db_Table_Abstract::getDefaultMetadataCache());
 }

    /**
     * Gets content panel for the Debugbar
     *
     * @return string
     */
    public function getPanel()
    {
        if (!$this->_db)
            return '';

        $html = '<h4>Requêtes sur la base de données</h4>';
        if (Zend_Db_Table_Abstract::getDefaultMetadataCache ()) {
            $html .= 'Cache de Métadonnées ACTIF';
        } else {
            $html .= 'Cache de Métadonnées INACTIF';
        }

        foreach ($this->_db as $name => $adapter) {
            if ($profiles = $adapter->getProfiler()->getQueryProfiles()) {
                $html .= '<h4>Adaptateur '.$name.'</h4><ol>';
                foreach ($profiles as $profile) {
                    $html .= '<li><strong>['.round($profile->getElapsedSecs()*1000, 2).' ms]</strong> '
                             .htmlspecialchars($profile->getQuery()).'</li>';
                }
                $html .= '</ol>';
            }
        }

        return $html;
    }

 public function setUp()
 {
     parent::setUp();
     Phprojekt::getInstance();
     Zend_Db_Table_Abstract::getDefaultMetadataCache()->clean();
 }

 /**
  * Check the current Fields and make the sync in the table of the module.
  *
  * @param array  $newFields Array with all the data per new field.
  * @param string $tableName Name of the module Table.
  * @param array  $tableData Array with the table data definition per new field.
  *
  * @return boolean True on a sucessful sync.
  */
 public function syncTable($newFields, $tableName, $tableData)
 {
     $systemFields = array('id', 'owner_id', 'project_id');
     $tableManager = new Phprojekt_Table(Phprojekt::getInstance()->getDb());
     // Clean the metadata cache
     if (null !== $this->_model) {
         $info = $this->_model->info();
         $dbConfig = Phprojekt::getInstance()->getDb()->getConfig();
         // Define the cache identifier where the metadata are saved
         $cacheId = md5((isset($dbConfig['options']['port']) ? ':' . $dbConfig['options']['port'] : null) . (isset($dbConfig['options']['host']) ? ':' . $dbConfig['options']['host'] : null) . '/' . $dbConfig['dbname'] . ':' . $info['schema'] . '.' . $info['name']);
         Zend_Db_Table_Abstract::getDefaultMetadataCache()->remove($cacheId);
     }
     $oldFields = $this->getDataDefinition();
     $tableDataForCreate['id'] = array('type' => 'auto_increment', 'length' => 11);
     $tableDataForCreate['owner_id'] = array('type' => 'int', 'length' => 11);
     if (!isset($tableDataForCreate['project_id'])) {
         $tableDataForCreate['project_id'] = array('type' => 'int', 'length' => 11);
     }
     array_merge($tableDataForCreate, $tableData);
     $tableName = strtolower(self::convertTableField($tableName));
     $tableFields = $tableManager->getTableFields($tableName, $tableDataForCreate);
     // Search for Modify and Delete
     $return = true;
     foreach ($oldFields as $oldValues) {
         $found = false;
         foreach ($newFields as $newValues) {
             if ($oldValues['id'] == $newValues['id']) {
                 $newValues['tableField'] = self::convertTableField($newValues['tableField']);
                 $fieldDefinition = $tableData[$newValues['tableField']];
                 $fieldDefinition['name'] = $newValues['tableField'];
                 if (!in_array($fieldDefinition['name'], $systemFields)) {
                     if ($oldValues['tableField'] == $newValues['tableField']) {
                         if (!$tableManager->modifyField($tableName, $fieldDefinition)) {
                             $return = false;
                         }
                     } else {
                         $fieldDefinition['oldName'] = $oldValues['tableField'];
                         if (!$tableManager->changeField($tableName, $fieldDefinition)) {
                             $return = false;
                         }
                     }
                 }
                 $found = true;
                 break;
             }
         }
         if (!$found) {
             $fieldDefinition = array();
             $fieldDefinition['name'] = $oldValues['tableField'];
             if (!in_array($fieldDefinition['name'], $systemFields)) {
                 if (!$tableManager->deleteField($tableName, $fieldDefinition)) {
                     $return = false;
                 }
             }
         }
     }
     // Search for Add
     foreach ($newFields as $newValues) {
         if ($newValues['id'] == 0) {
             $newValues['tableField'] = self::convertTableField($newValues['tableField']);
             $fieldDefinition = $tableData[$newValues['tableField']];
             $fieldDefinition['name'] = $newValues['tableField'];
             if (!in_array($fieldDefinition['name'], $systemFields)) {
                 if (!$tableManager->addField($tableName, $fieldDefinition)) {
                     $return = false;
                 }
             }
         }
     }
     return $return;
 }

 public function install()
 {
     parent::install();
     $languageModule = new RM_Languages();
     $languages = $languageModule->fetchAll();
     require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'EmailNotifications.php';
     $model = new RM_EmailNotifications();
     foreach ($languages as $language) {
         if ($language->iso !== 'en_GB') {
             $model->addLanguage($language->iso);
         }
     }
     //Currently we just added extra columns and need to clean cache
     Zend_Db_Table_Abstract::getDefaultMetadataCache()->clean();
     //Copy en_GB default value to all other languages
     $emailNotification = $model->fetchByName('ReservationCompleteSuccessful', RM_EmailNotifications::REGULAR_USER);
     foreach ($languages as $language) {
         $iso = $language->iso;
         if ($iso !== 'en_GB') {
             $emailNotification->{$iso} = $emailNotification->en_GB;
         }
     }
     $emailNotification->save();
 }