PHP Doctrine_Query::getConnection方法代码示例

 /**
  * constructor
  *
  * @param Doctrine_Query $query
  */
 public function __construct(Doctrine_Query $query, $viewName)
 {
     $this->name = $viewName;
     $this->query = $query;
     $this->query->setView($this);
     $this->conn = $query->getConnection();
 }

 /**
  * constructor
  *
  * @param Doctrine_Query $query
  */
 public function __construct(Doctrine_Query $query, $viewName)
 {
     $this->_name = $viewName;
     $this->_query = $query;
     $this->_query->setView($this);
     $this->_conn = $query->getConnection();
     $this->_dql = $query->getDql();
     $this->_sql = $query->getSqlQuery();
 }

 private function update($table_name, $d, $id)
 {
     $tid = $id;
     if (!is_array($id)) {
         $tid = array('id' => $id);
     }
     $table = Doctrine::getTable($table_name);
     $dq = new Doctrine_Query();
     $conn = $dq->getConnection();
     return $conn->update($table, $d, $tid);
 }

 /**
  * Should return the database server name or source name
  *
  * Ex: mysql, pgsql, array, xml
  *
  * @return string
  */
 public function getSourceName()
 {
     return strtolower($this->_query->getConnection()->getDriverName());
 }

 protected function modifyImpl(Doctrine_Query &$o)
 {
     if (!$this->ignoreIds) {
         $table = $o->getConnection()->getTable($this->getTarget());
         $keys = $table->getIdentifierColumnNames();
         $o->addSelect(implode($keys));
     } else {
         $o->disableAutoIdentifierFields(true);
     }
     foreach ($this->additionalSelects as $alias => $select) {
         $o->addSelect($select . (is_numeric($alias) ? "" : " AS " . $alias));
     }
     $db = $this->getContext()->getDatabaseManager()->getDatabase('icinga');
     // check if retained state must be respected
     if (method_exists($db, "useRetained")) {
         /*
          * the core with idomod dumps 2 different config types
          * idomod.cfg:config_output_options
          * 1 = original config => config_type = 0
          * 2 = retained config => config_type = 1
          * 3 = both, both config_types are available
          */
         if ($this->retainedAlias) {
             $o->andWhere($this->retainedAlias . ".config_type= ?", $db->useRetained() ? "1" : "0");
         }
     }
     if ($this->getTarget() == "IcingaObjects") {
         $o->andWhere($this->mainAlias . ".is_active = 1");
     }
     foreach ($this->forceGroup as $group) {
         $o->addGroupBy($group);
     }
     parent::modifyImpl($o);
 }

    public function executeUpdateFilter(sfWebRequest $request)
    {
        $this->menu = $this->getMenu('index');
        $this->informations = $this->getInformations();
        $id = $request->getParameter('id');
        $sql = <<<ENDSQL
\t\t\tSELECT domain, lists_id, ordre
\t\t\tFROM lists_filter
\t\t\tJOIN lists ON lists_filter.list_id = lists.id
\t\t\tJOIN lists_detail ON lists.id = lists_detail.lists_id
\t\t\tWHERE lists_filter.filter_id = '{$id}'
\t\t\tAND lists.origin = 'SI'
\t\t\tORDER BY ordre
ENDSQL;
        $dq = new Doctrine_Query();
        $conn = $dq->getConnection();
        $filters_private_lists_res = $conn->fetchAll($sql);
        foreach ($filters_private_lists_res as $filter) {
            if ($filter['domain'] != '') {
                switch ($filter['ordre']) {
                    case 0:
                        $globale_whitelist .= $filter['domain'] . "\n";
                        break;
                    case 1:
                        $globale_blacklist .= $filter['domain'] . "\n";
                        break;
                    case 2:
                        $private_whitelist .= $filter['domain'] . "\n";
                        break;
                    case 3:
                        $private_blacklist .= $filter['domain'] . "\n";
                        break;
                    case 4:
                        $other_blacklists[$filter['lists_id']] = $filter['lists_id'];
                        break;
                }
            }
        }
        $this->globale_whitelist = $globale_whitelist;
        $this->globale_blacklist = $globale_blacklist;
        $this->private_whitelist = $private_whitelist;
        $this->private_blacklist = $private_blacklist;
        // @TODO  ////////////////////////////////////////////////////////////
        $sql = <<<SQL
\t\t\tSELECT li.id, li.name, lf.ordre
\t\t\tFROM lists li
\t\t\t\tLEFT JOIN lists_filter lf ON li.id = lf.list_id
\t\t\tWHERE lf.filter_id = '{$id}'
\t\t\t\tAND li.origin != 'SI'
SQL;
        $dq = new Doctrine_Query();
        $conn = $dq->getConnection();
        $filters_to = $conn->fetchAll($sql);
        foreach ($filters_to as $filterT) {
            $aaa = $filterT['id'];
            $other_blacklists[$aaa] = $aaa;
        }
        $this->other_blacklists = $other_blacklists;
        $this->aaa = $filters_to;
        $lists = Doctrine_Query::create()->select('l.name, l.id')->from('Lists l')->where('origin != ?', 'SI')->orderBy('name')->execute();
        $this->lists = $lists;
        $filters = Doctrine_Query::create()->select('name, description, id')->from('Filter')->where('id = ?', $request->getParameter('id'))->execute();
        $this->filters = $filters;
        return;
    }