PHP Doctrine_Query::create方法代碼示例

 public function testTicket()
 {
     // SELECT picture_id FROM ItemPicture INNER JOIN Puzzle ON ItemPicture.item_id=ItemPuzzle_item_id
     $q = Doctrine_Query::create()->select('pic.id')->from('T1467_Picture pic')->innerJoin('pic.Items ite')->innerJoin('ite.Puzzles puz');
     $this->assertEqual($q->getDql(), 'SELECT pic.id FROM T1467_Picture pic INNER JOIN pic.Items ite INNER JOIN ite.Puzzles puz');
     $this->assertEqual($q->getSqlQuery(), 'SELECT t.id AS t__id FROM t1467__picture t INNER JOIN t1467__item_picture t3 ON (t.id = t3.picture_id) INNER JOIN t1467__item t2 ON t2.id = t3.item_id INNER JOIN t1467__item_puzzle t5 ON (t2.id = t5.item_id) INNER JOIN t1467__puzzle t4 ON t4.id = t5.puzzle_id');
 }

 public function doMassAction($user_id, $is_admin = false)
 {
     if ($this->isBound() && $this->isValid()) {
         $actions_values = $this->getValue('MassActionForm');
         $query = Doctrine_Query::create()->update('Specimens s');
         if ($is_admin === false) {
             $query->andWhere('s.id in (select fct_filter_encodable_row(?,?,?))', array(implode(',', $this->getValue('item_list')), 'spec_ref', $user_id));
         } else {
             $query->andWhere('s.id in (' . implode(',', $this->getValue('item_list')) . ')');
         }
         $group_action = 0;
         foreach ($this->embeddedForms['MassActionForm'] as $key => $form) {
             if (method_exists($this->getEmbeddedForm('MassActionForm')->getEmbeddedForm($key), 'doGroupedAction')) {
                 $this->getEmbeddedForm('MassActionForm')->getEmbeddedForm($key)->doGroupedAction($query, $actions_values[$key], $this->getValue('item_list'));
                 $group_action++;
             }
             if (method_exists($this->getEmbeddedForm('MassActionForm')->getEmbeddedForm($key), 'doMassAction')) {
                 $this->getEmbeddedForm('MassActionForm')->getEmbeddedForm($key)->doMassAction($user_id, $this->getValue('item_list'), $actions_values[$key]);
             }
         }
         if ($group_action) {
             $query->execute();
         }
     }
 }

 public function countProyectos(Doctrine_Query $q = null)
 {
     if (is_null($q)) {
         $q = Doctrine_Query::create()->from('ProyectoLey p');
     }
     return $q->count();
 }

 public function save(Doctrine_Connection $conn = null)
 {
     try {
         $this->setIsTosync(1);
         parent::save($conn);
         if ($this->getGainId() != null) {
             $send_email_visiteur_template_id = $this->getGain()->getSendEmailVisiteurTemplateId();
             $send_email_admin_template_id = $this->getGain()->getSendEmailAdminTemplateId();
             if ($send_email_visiteur_template_id || $send_email_admin_template_id) {
                 $visiteur = Doctrine_Core::getTable('Visiteur')->findOneBy('guid', $this->getVisiteurId());
                 $gain = $this->getGain();
                 $univers_status = $this->getUniversStatus();
                 $visiteur_email = $visiteur->getEmail();
                 $admin_email = sfConfig::get('app_gain_admin_email', null);
                 $array_replace = array('$visiteur_pseudo' => $visiteur->getPseudoSon(), '$visiteur_nom' => $visiteur->getNom(), '$visiteur_prenom' => $visiteur->getPrenom(), '$visiteur_adresse1' => $visiteur->getAdresse(), '$visiteur_adresse2' => $visiteur->getAdresse2(), '$visiteur_cp' => $visiteur->getCodePostal(), '$visiteur_ville' => $visiteur->getVille(), '$visiteur_num_mobile' => $visiteur->getNumMobile(), '$visiteur_email' => $visiteur->getEmail(), '$host_image_src' => sfConfig::get('app_host_image_src'), '$gain_libelle' => $gain->getLibelle(), '$gain_image' => $gain->getImage(), '$gain_description' => $gain->getDescription(), '$gain_start_at' => $gain->getStartAt(), '$gain_end_at' => $gain->getEndAt(), '$univers_status_level' => $univers_status->getLevel(), '$univers_status_level_name' => $univers_status->getLevelName(), '$univers_status_description' => $univers_status->getDescription(), '$univers_status_libelle' => $univers_status->getLibelle());
             }
             // envoi d'un email au visiteur
             if ($send_email_visiteur_template_id && $visiteur_email) {
                 $template = Doctrine_Query::create()->from('TemplateMail t')->where('t.guid = ?', $send_email_visiteur_template_id)->fetchOne();
                 if ($template !== false) {
                     $template->sendEmail($visiteur_email, $array_replace);
                 }
             }
             // envoi d'un email a l'admin
             if ($send_email_admin_template_id && $admin_email) {
                 $template = Doctrine_Query::create()->from('TemplateMail t')->where('t.guid = ?', $send_email_admin_template_id)->fetchOne();
                 if ($template !== false) {
                     $template->sendEmail($admin_email, $array_replace);
                 }
             }
         }
     } catch (Exception $e) {
         throw new Exception($e->getMessage());
     }
 }

 public static function get_district_name_($district)
 {
     $query = Doctrine_Query::create()->select("*")->from("districts")->where("id='{$district}'");
     $drugs = $query->execute();
     $drugs = $drugs->toArray();
     return $drugs[0];
 }

 public function executeBulk(sfWebRequest $request)
 {
     $ids = array_keys($request->getParameter('rl-check', array()));
     $query = Doctrine_Query::create();
     $query->update('Role r')->set('deleted_at', '?', date('Y-m-d H:i:s'))->whereIn('r.id', $ids)->andWhere('it.account_id = ?', $this->getUser()->getAttribute('account_id'))->execute();
     $this->redirect('adminRole/list');
 }

 public function testTest()
 {
     $q = Doctrine_Query::create()->select('u.*, CONCAT(u.id, u.name) as custom')->from('User u INDEXBY custom');
     $this->assertEqual($q->getSqlQuery(), 'SELECT e.id AS e__id, e.name AS e__name, e.loginname AS e__loginname, e.password AS e__password, e.type AS e__type, e.created AS e__created, e.updated AS e__updated, e.email_id AS e__email_id, CONCAT(e.id, e.name) AS e__0 FROM entity e WHERE (e.type = 0)');
     $results = $q->fetchArray();
     $this->assertEqual($results['4zYne']['name'], 'zYne');
 }

 /**
  * Get comments for a specific module and spec entry
  * @param string $module
  * @param array||int $key
  * @return array -> objects
  */
 public function getComments($module, $key)
 {
     // If the key isn't an array (directly the integer)
     if (!is_array($key)) {
         // Encaspluate the key in a array
         $key = array($key);
     }
     switch ($module) {
         case "forums":
             $column = "tid";
             break;
         case "up":
             $column = "upid";
             break;
         case "sht":
             $column = "shtid";
             break;
         case "pm":
             $column = "pmid";
             break;
         case "poll":
             $column = "pollid";
             break;
         case "news":
             $column = "nwsid";
             break;
     }
     // Execute & return the request
     return Doctrine_Query::create()->select("m.*, v.*, u.username, u.avatar, u.slug, uu.username, uu.avatar, uu.slug")->from("MsgMessages m")->leftJoin("m.MsgVotes v")->leftJoin('m.Users u')->leftJoin('v.Users uu')->where('m.module = ?', $module)->andWhereIn('m.' . $column, $key)->useQueryCache(true)->setQueryCacheLifeSpan(3600 * 24)->execute();
 }

 /**
  * execute
  *
  * @param string $value
  * @param string $error
  * @return void
  */
 public function execute(&$value, &$error)
 {
     $className = $this->getParameter('class');
     $columnName = $className . '.' . $this->getParameter('column');
     $primaryKeys = Doctrine::getTable($className)->getIdentifier();
     if (!is_array($primaryKeys)) {
         $primaryKeys = array($primaryKeys);
     }
     // implied assumption: the is at least one primary key
     foreach ($primaryKeys as $primaryKey) {
         if (is_null($primaryKeyValue = $this->getContext()->getRequest()->getParameter($primaryKey))) {
             break;
         }
     }
     $query = Doctrine_Query::create()->from($className);
     if ($primaryKeyValue == null) {
         $query->where($columnName . ' = ?');
         $res = $query->execute(array($value));
     } else {
         $query->where($columnName . ' = ? AND ' . $primaryKey . ' != ?');
         $res = $query->execute(array($value, $primaryKeyValue));
     }
     if ($res->count()) {
         $error = $this->getParameterHolder()->get('unique_error');
         return false;
     }
     return true;
 }

 public function testInheritanceSubclasses()
 {
     $records = Doctrine_Query::create()->query('FROM Parent1713 m');
     foreach ($records as $rec) {
         $this->assertEqual(get_class($rec), $rec['title']);
     }
 }

 public function testTicket()
 {
     $q = Doctrine_Query::create()->from('T1500_User u')->innerJoin('u.Group g')->where('u.id = 1');
     $this->assertEqual($q->getSqlQuery(), 'SELECT t.user_id AS t__user_id, t.group_id AS t__group_id, t.name AS t__name, t2.group_id AS t2__group_id, t2.name AS t2__name FROM t1500__user t INNER JOIN t1500__group t2 ON t.group_id = t2.group_id WHERE t.user_id = 1');
     $q = Doctrine_Query::create()->from('T1500_Group g')->innerJoin('g.Users u')->where('g.id = 1');
     $this->assertEqual($q->getSqlQuery(), 'SELECT t.group_id AS t__group_id, t.name AS t__name, t2.user_id AS t2__user_id, t2.group_id AS t2__group_id, t2.name AS t2__name FROM t1500__group t INNER JOIN t1500__user t2 ON t.group_id = t2.group_id WHERE t.group_id = 1');
 }

 protected function processForm(sfWebRequest $request, sfForm $form)
 {
     $form->bind($request->getParameter($form->getName()), $request->getFiles($form->getName()));
     if ($form->isValid()) {
         try {
             $peticion = $form->save();
             $aux = Doctrine_Query::create()->from('sfGuardUser s')->where('s.email_address = ?', $peticion->getEmailAddress());
             $aux1 = $aux->fetchOne();
             if (!$aux1) {
                 $auxU = Doctrine_Query::create()->from('sfGuardUser s')->where('s.username = ?', $peticion->getUsername());
                 $auxU1 = $auxU->fetchOne();
                 if (!$auxU1) {
                     $this->redirect('peticion/notificacion');
                 } else {
                     $peticion->delete();
                     $this->getUser()->setFlash('error', 'El nombre de usuario "' . $peticion->getUsername() . '" no esta disponible.', false);
                 }
             } else {
                 $peticion->delete();
                 $this->getUser()->setFlash('error', 'El correo electrónico "' . $peticion->getEmailAddress() . '" ya se encuentra registrado.', false);
             }
         } catch (Exception $e) {
             $this->getUser()->setFlash('error', 'El correo electrónico ingresado ya se encuentra registrado.', false);
         }
     }
 }

 /**
  * @todo Execute deleteUser function for delete the particular user based on parameter.
  *
  * @param $snIdUser  Integer UserId.
  * @return type array or boolean.
  */
 public static function deleteCategory($snIdUser)
 {
     if ($snIdUser == "" || !is_numeric($snIdUser)) {
         return false;
     }
     return Doctrine_Query::create()->delete("Model_Category MU")->where("id_category = ?", $snIdUser)->execute();
 }

 public static function getFeedEntries($uid = null, $actorid = null, $friends = false, $actions = true, $stories = true)
 {
     $q = Doctrine_Query::create();
     if (isset($actorid) && !empty($actorid)) {
         $_whereClause = "feed.actor_id = {$actorid}";
     } else {
         if (isset($uid) && !empty($uid)) {
             if ($friends) {
                 $_whereClause = "friend.from_id = '{$uid}' and feed.author_id = friend.to_id";
             } else {
                 if (!empty($_whereClause)) {
                     $_whereClause .= ' and ';
                 }
                 $_whereClause = "feed.author_id = '{$uid}'";
             }
         }
     }
     if (!$actions || !$stories) {
         $_type = empty($actions) ? '1' : '2';
         $_whereClause .= ' and feed.type = ' . $_type;
     }
     //		error_log( 'where clause: ' . $_whereClause );
     $q->select(self::getSelect($friends))->from(self::getFrom($uid, $actorid, $friends))->where($_whereClause)->orderby('feed.created desc');
     return $q->execute()->toArray(true);
 }

 public function testSavingUnmodifiedRecordsDoesNotInvokeTimestampableListener()
 {
     $this->conn->clear();
     $wiki = Doctrine_Query::create()->from('Wiki w')->where('w.id = 1')->fetchOne();
     $wiki->save();
     $this->assertEqual($wiki->Translation['FI']->version, 2);
 }