PHP Doctrine_Query::select方法代码示例

 /**
  * Constructs Neo_Doctrine_Paginator_Adapter
  *
  * @param Doctrine_Query_Abstract|string $query
  * @param integer $hydratationMode Use constaints Doctrine_Core::HYDRATE_*.
  * @param array[string]=>mixed $options Options may be:
  *              'countQuery'-custom query for count counting. Dql or Doctrine_Query instance.
  */
 public function __construct($query, $hydrationMode = null, $options = array())
 {
     if (is_string($query)) {
         $newQuery = new Doctrine_Query();
         $newQuery->parseDqlQuery($query);
         $query = $newQuery;
     } else {
         if (!$query instanceof Doctrine_Query_Abstract) {
             require_once 'Neo/Doctrine/Paginator/Adapter/Exception.php';
             throw new Neo_Doctrine_Paginator_Adapter_Exception("Given query is not instance of Doctrine_Query");
         }
     }
     $this->_query = $query;
     $this->_hydrationMode = is_null($hydrationMode) ? Doctrine_Core::HYDRATE_RECORD : $hydrationMode;
     //options
     if (!empty($options['countQuery'])) {
         if (is_string($options['countQuery'])) {
             $countQuery = new Doctrine_Query();
             $countQuery->parseDqlQuery($options['countQuery']);
             $options['countQuery'] = $countQuery;
         } else {
             if (!$options['countQuery'] instanceof Doctrine_Query) {
                 require_once 'Neo/Doctrine/Paginator/Adapter/Exception.php';
                 throw new Neo_Doctrine_Paginator_Adapter_Exception("Given count-query is not instance of Doctrine_Query");
             }
         }
         $this->_countQuery = $options['countQuery'];
         $this->_countQuery->select('count(*) as count');
     }
 }

 public function executeRemove()
 {
     $id = $this->getRequestParameter('id');
     if ($id) {
         $q = new Doctrine_Query();
         if ($this->getUser()->hasCredential('admin')) {
             $this->comment = $q->select('c.*')->from('Comment c')->where('id = ?', array($id))->execute()->getFirst();
         } else {
             $this->comment = $q->select('c.*')->from('Comment c')->where('id = ? and user_id = ?', array($id, $this->getUser()->getId()))->execute()->getFirst();
         }
         $this->forward404Unless($this->comment);
         $this->comment->delete();
     }
     return $this->redirect($this->getRequest()->getReferer());
 }

 public function retrieveAsso(Doctrine_Query $q)
 {
     $alias = $q->getRootAlias();
     $q->select("{$alias}.name, {$alias}.login, {$alias}.description, {$alias}.logo, {$alias}.salle, {$alias}.phone, {$alias}.facebook, p.id, p.asso_id, p.couleur");
     $q->leftJoin("{$alias}.Pole p");
     return $q->fetchOne();
 }

 /**
 public function testShortAliasesWithSingleComponent() {
     $q = new Doctrine_Query();
 
     $q->select('u.name')->from('User u');
 
     $this->assertEqual($q->getSqlQuery(), 'SELECT e.id AS e__id, e.name AS e__name FROM entity e WHERE (e.type = 0)');
 }
 */
 public function testShortAliasesWithOneToManyLeftJoin()
 {
     $q = new Doctrine_Query();
     $q->select('u.name, p.id')->from('User u LEFT JOIN u.Phonenumber p');
     $this->assertEqual($q->getSqlQuery(), 'SELECT e.id AS e__id, e.name AS e__name, p.id AS p__id FROM entity e LEFT JOIN phonenumber p ON e.id = p.entity_id WHERE (e.type = 0)');
     $users = $q->execute();
     $this->assertEqual($users->count(), 8);
 }

 public function executeShowcase()
 {
     $q = new Doctrine_Query();
     $this->madule = $q->select('m.*')->from('Madule m')->where('id = ?', array($this->getRequestParameter('id')))->fetchOne();
     $this->forward404Unless($this->madule);
     $this->madule->setShowcase(!$this->madule->getShowcase());
     $this->madule->save();
     return $this->redirect($this->getRequest()->getReferer());
 }

 public static function getEschoolTypes($public_only = false)
 {
     $q = new Doctrine_Query();
     $q->select('e.*');
     $q->from('GcrEschoolType e');
     if ($public_only) {
         $q->where('e.is_public = ?', 't');
     }
     return $q->execute();
 }

 public function testHydratation()
 {
     $q = new Doctrine_Query();
     $q->select('t.name')->from('NewTag t INDEXBY t.name');
     try {
         $results = $q->execute(array(), Doctrine_Core::HYDRATE_ARRAY);
     } catch (Exception $e) {
         $this->fail($e->getMessage());
     }
 }

 public function testFetchArraySupportsTwoAggregatesInRelationAndRoot()
 {
     $q = new Doctrine_Query();
     $q->select("u.*, p.*, CONCAT(u.name, '_1') concat1, CONCAT(u.name, '_2') concat2, CONCAT(p.phonenumber, '_3') concat3, CONCAT(p.phonenumber, '_3') concat4")->from('User u')->innerJoin('u.Phonenumber p')->where("u.name = 'zYne'");
     $users = $q->execute(array(), Doctrine::HYDRATE_ARRAY);
     $this->assertEqual($users[0]['concat1'], 'zYne_1');
     $this->assertEqual($users[0]['concat2'], 'zYne_2');
     $this->assertEqual($users[0]['Phonenumber'][0]['concat3'], '123 123_3');
     $this->assertTrue(isset($users[0]['Phonenumber'][0]['concat4']));
 }

 public function testTicket()
 {
     try {
         $q = new Doctrine_Query();
         $result = $q->select('d.*')->from('T923_Diagnostic d')->where('d.diag_timestamp >= ? AND d.diag_timestamp <= ?', array('2008-03-27 00:00:00', '2008-03-27 23:00:00'))->addWhere('d.id_type = ?', array('101'))->orderBy('d.diag_timestamp')->limit(20)->offset(0)->execute();
         $this->assertEqual($result->count(), 3);
     } catch (Exception $e) {
         $this->fail($e->getMessage());
     }
 }

 public static function getTypes($public_only = false)
 {
     $q = new Doctrine_Query();
     $q->select('i.*');
     $q->from('GcrInstitutionType i');
     if ($public_only) {
         $q->where('i.is_public = ?', 't');
     }
     return $q->execute();
 }

 public function testDoctrineQueryJoinSelect()
 {
     $q = new Doctrine_Query();
     $q->select('person.id, points.total')->from('T1015_Person person')->innerJoin('person.T1015_Points points WITH person.id = 1');
     $results = $q->execute(array(), Doctrine_Core::HYDRATE_ARRAY);
     //var_dump($results);
     $person = $results[0];
     // number of points for person id of 1 should be 15
     $this->assertEqual(15, $person['T1015_Points']['total']);
     //THIS WILL FAIL
 }

 public function testMultipleJoinFetchingWithArrayFetching()
 {
     $query = new Doctrine_Query($this->connection);
     $queryCount = $this->connection->count();
     try {
         $categories = $query->select('c.*, subCats.*, b.*, le.*, a.*')->from('QueryTest_Category c')->leftJoin('c.subCategories subCats')->leftJoin('c.boards b')->leftJoin('b.lastEntry le')->leftJoin('le.author a')->where('c.parentCategoryId = 0')->orderBy('c.position ASC, subCats.position ASC, b.position ASC')->execute(array(), Doctrine::HYDRATE_ARRAY);
         $this->pass();
     } catch (Doctrine_Exception $e) {
         $this->fail($e->getMessage());
     }
 }

 public function testGetLimitSubqueryWithOrderByOnAggregateValuesAndColumns()
 {
     $q = new Doctrine_Query();
     $q->select('u.name, COUNT(DISTINCT a.id) num_albums');
     $q->from('User u, u.Album a');
     $q->orderby('num_albums, u.name');
     $q->groupby('u.id');
     $q->limit(5);
     $q->execute();
     $this->assertEqual($this->dbh->pop(), 'SELECT e.id AS e__id, e.name AS e__name, COUNT(DISTINCT a.id) AS a__0 FROM entity e LEFT JOIN album a ON e.id = a.user_id WHERE e.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT e2.id, COUNT(DISTINCT a2.id) AS a2__0 FROM entity e2 LEFT JOIN album a2 ON e2.id = a2.user_id WHERE (e2.type = 0) GROUP BY e2.id ORDER BY a2__0, e2.name LIMIT 5) AS doctrine_subquery_alias) AND (e.type = 0) GROUP BY e.id ORDER BY a__0, e.name');
 }

 public function testTicket()
 {
     try {
         $q = new Doctrine_Query();
         $q->update('EnumUpdateBug')->set('bla_id', '?', 5)->set('separator', '?', 'pipe')->where('id = 1')->execute();
     } catch (Exception $e) {
         $this->fail($e->getMessage());
     }
     $q = new Doctrine_Query();
     $row = $q->select('a.*')->from('EnumUpdateBug a')->where('a.id = 1')->fetchOne();
     $this->assertEqual($row->bla_id, 5);
 }

 public function prepareUpdate()
 {
     $id = $this->getRequestParameter('id');
     if ($id) {
         $q = new Doctrine_Query();
         $this->themeGroup = $q->select('t.*')->from('ThemeGroup t')->where('id = ?', array($id))->execute()->getFirst();
         $this->forward404Unless($this->themeGroup);
     } else {
         $this->themeGroup = new ThemeGroup();
     }
     $this->form = new ThemeGroupForm(array('title' => $this->themeGroup->getTitle(), 'known' => $this->themeGroup->getKnown()));
 }