PHP dmDb::pdo方法代码示例

 public function executeCurrentVersion(dmWebRequest $request)
 {
     if ($branch = $request->getParameter('branch')) {
         $version = dmDb::pdo('SELECT v.number FROM version v INNER JOIN branch b ON v.branch_id = b.id AND b.number = ? WHERE v.is_active = ? ORDER BY v.position ASC LIMIT 1', array(str_replace(array('_', '-'), '.', $branch), true))->fetchColumn();
     } else {
         $version = dmDb::pdo('SELECT v.number FROM version v WHERE v.is_active = ? ORDER BY v.position ASC LIMIT 1', array(true))->fetchColumn();
     }
     return $this->renderText($version);
 }

 protected function preTransform($text)
 {
     $text = parent::preTransform($text);
     if (strpos($text, '[/code]')) {
         $text = preg_replace_callback('#\\[code\\s?(\\w*)\\]((?:\\n|.)*)\\n\\[/code\\]#uU', array($this, 'formatCode'), $text);
     }
     if (strpos($text, '%latest_diem_version%')) {
         $version = dmDb::pdo('SELECT v.number FROM version v INNER JOIN branch b ON v.branch_id = b.id AND b.number = ? WHERE v.is_active = ? ORDER BY v.position ASC LIMIT 1', array('5.0', true))->fetchColumn();
         $text = str_replace('%latest_diem_version%', $version, $text);
     }
     if (strpos($text, '%latest_diem_download_url%')) {
         $version = dmDb::query('Version v')->innerJoin('v.Branch b')->where('b.number = ?', '5.0')->andWhere('v.is_active = ?', true)->orderBy('v.position ASC')->fetchOne();
         $text = str_replace('%latest_diem_download_url%', $this->helper->link($version->downloadUrl)->getAbsoluteHref(), $text);
     }
     return $text;
 }

 public function removeOldLocks()
 {
     dmDb::pdo(sprintf('DELETE FROM %s WHERE time < ?', $this->getTableName()), array($_SERVER['REQUEST_TIME'] - 10 * sfConfig::get('dm_locks_timeout', 10)));
 }

 public function getData($tableName)
 {
     return dmDb::pdo('SELECT * FROM ' . $tableName, array(), $this->conn)->fetchAll(Doctrine::FETCH_ASSOC);
 }

    protected function getParentSlugs($module)
    {
        if ($module->hasListPage()) {
            $parentPageModuleKey = $module->getKey();
            $parentPageActionKey = 'list';
        } elseif ($parentModule = $module->getNearestAncestorWithPage()) {
            $parentPageModuleKey = $parentModule->getKey();
            $parentPageActionKey = 'show';
        } else {
            throw new dmException(sprintf('can not identify parent module for %s module', $module));
        }
        $parentSlugResults = dmDb::pdo('SELECT t.id, t.slug
FROM dm_page p, dm_page_translation t
WHERE p.module = ? AND p.action = ? AND p.id = t.id AND t.lang = ?', array($parentPageModuleKey, $parentPageActionKey, $this->culture))->fetchAll(PDO::FETCH_NUM);
        $parentSlugs = array();
        foreach ($parentSlugResults as $psr) {
            $parentSlugs[$psr[0]] = $psr[1];
        }
        unset($parentSlugsResult);
        return $parentSlugs;
    }

 protected function getAvailableIdsByLocalAlias(dmDoctrineTable $refTable)
 {
     $availableIds = array();
     foreach ($refTable->getRelationHolder()->getLocals() as $relationAlias => $relation) {
         $tmp = dmDb::pdo('SELECT t.id FROM ' . $relation->getTable()->getTableName() . ' t')->fetchAll(PDO::FETCH_NUM);
         if (empty($tmp)) {
             throw new dmRecordException();
         }
         foreach ($tmp as $t) {
             $availableIds[$relationAlias][$t[0]] = $t[0];
         }
     }
     return $availableIds;
 }

 protected function getParentRecordIds(dmProjectModule $module, dmProjectModule $parentModule)
 {
     /*
      * if parent is local relation for module,
      * we can prepare parent records
      */
     if ($module->hasLocal($parentModule)) {
         $local = $module->getTable()->getRelationHolder()->getLocalByClass($parentModule->getModel())->getLocal();
         $query = sprintf('SELECT r.id, r.%s FROM %s r WHERE EXISTS (SELECT page.id FROM dm_page page WHERE page.module = ? AND page.action = ? AND page.record_id = r.%s)', $local, $module->getTable()->getTableName(), $local);
         $_parentRecordIds = dmDb::pdo($query, array($parentModule->getKey(), 'show'))->fetchAll(PDO::FETCH_NUM);
         $parentRecordIds = array();
         foreach ($_parentRecordIds as $_parentRecordId) {
             $parentRecordIds[$_parentRecordId[0]] = $_parentRecordId[1];
         }
     } elseif ($module->hasAssociation($parentModule)) {
         $association = $module->getTable()->getRelationHolder()->getAssociationByClass($parentModule->getModel());
         $query = sprintf('SELECT association.%s, association.%s FROM %s association WHERE EXISTS (SELECT page.id FROM dm_page page WHERE page.module = ? AND page.action = ? AND page.record_id = association.%s) GROUP BY association.%s', $association->getForeign(), $association->getLocal(), $association->getAssociationTable()->getTableName(), $association->getForeign(), $association->getLocal());
         $_parentRecordIds = dmDb::pdo($query, array($parentModule->getKey(), 'show'))->fetchAll(PDO::FETCH_NUM);
         $parentRecordIds = array();
         foreach ($_parentRecordIds as $value) {
             $parentRecordIds[$value[1]] = $value[0];
         }
     } else {
         $parentRecordIds = false;
     }
     return $parentRecordIds;
 }

 public static function load($useCache = true)
 {
     if (!self::$culture) {
         if (class_exists('dmContext', false) && dmContext::hasInstance() && ($user = dmContext::getInstance()->getUser())) {
             self::$culture = $user->getCulture();
         } else {
             self::$culture = sfConfig::get('sf_default_culture');
         }
     }
     try {
         if (self::$culture == sfConfig::get('sf_default_culture')) {
             $results = dmDb::pdo('SELECT s.name, t.value, t.lang FROM dm_setting s LEFT JOIN dm_setting_translation t ON t.id=s.id AND t.lang = ?', array(self::$culture))->fetchAll(PDO::FETCH_NUM);
         } else {
             $results = dmDb::pdo('SELECT s.name, t.value, t.lang FROM dm_setting s LEFT JOIN dm_setting_translation t ON t.id=s.id AND t.lang IN (?, ?)', array(self::$culture, sfConfig::get('sf_default_culture')))->fetchAll(PDO::FETCH_NUM);
         }
     } catch (PDOException $e) {
         $results = array();
     } catch (Doctrine_Connection_Exception $e) {
         $results = array();
     }
     self::$config = array();
     foreach ($results as $result) {
         if (!isset(self::$config[$result[0]]) || isset(self::$config[$result[0]]) && $result[2] == self::$culture) {
             self::$config[$result[0]] = $result[1];
         }
     }
     unset($results);
     self::$loaded = true;
 }

 public static function load($useCache = true)
 {
     if ($useCache && file_exists(self::getCacheFileName())) {
         require_once self::getCacheFileName();
     } else {
         if (sfConfig::has('dm_i18n_cultures')) {
             $cultures = sfConfig::get('dm_i18n_cultures');
         } else {
             $tmp = sfYaml::load(file_get_contents(dmOs::join(sfConfig::get('sf_config_dir'), 'dm/config.yml')));
             $cultures = $tmp['all']['i18n']['cultures'];
         }
         $results = dmDb::pdo(sprintf('SELECT s.name, s.type, t.value, t.default_value, t.lang FROM dm_setting s LEFT JOIN dm_setting_translation t ON t.id=s.id AND t.lang IN (\'%s\')', implode('\', \'', $cultures)))->fetchAll(PDO::FETCH_NUM);
         $config = array();
         foreach ($results as $result) {
             $value = $result[2] != '' ? $result[2] : $result[3];
             switch ($result[1]) {
                 case 'boolean':
                     if ($value == '1') {
                         $value = true;
                     } else {
                         $value = false;
                     }
                     break;
                 case 'number':
                     $value = floatval($value);
                     break;
                 case 'integer':
                     $value = intval($value);
                     break;
             }
             // sfConfig::set(sprintf('dm_dmConfig_cache_%s_%s', $result[4], $result[0]), $value);
             // $config[sprintf('dm_dmConfig_cache_%s_%s', $result[4], $result[0])] = $value;
             $config[$result[0]][$result[4]] = $value;
         }
         unset($results);
         self::toMemory($config, $cultures);
         self::dump();
     }
     self::$loaded = true;
 }

 /**
  * Checks if a particular catalogue+variant exists in the database.
  *
  * @param string $variant catalogue+variant
  * @return boolean true if the catalogue+variant is in the database, false otherwise.
  */
 public function isValidSource($variant)
 {
     $result = dmDb::pdo('SELECT EXISTS(SELECT 1 FROM ' . $this->catalogueTable . ' WHERE name = ?)', array($variant))->fetch(PDO::FETCH_NUM);
     return $result[0];
 }