| | 85 | |
| | 86 | // Test Doctrine_Query::count() applies dql hooks |
| | 87 | public function testTicket1170() |
| | 88 | { |
| | 89 | $orig = Doctrine_Manager::getInstance()->getAttribute('use_dql_callbacks'); |
| | 90 | |
| | 91 | Doctrine_Manager::getInstance()->setAttribute('use_dql_callbacks', true); |
| | 92 | |
| | 93 | $q = Doctrine_Query::create() |
| | 94 | ->from('SoftDeleteTest s') |
| | 95 | ->addWhere('s.name = ?', 'test1') |
| | 96 | ->addWhere('s.something = ?', 'test2'); |
| | 97 | |
| | 98 | $this->assertEqual($q->getCountQuery(), 'SELECT COUNT(DISTINCT s.name) AS num_results FROM soft_delete_test s WHERE s.name = ? AND s.something = ? AND s.deleted = ? GROUP BY s.name'); |
| | 99 | $this->assertEqual($q->count(), 0); |
| | 100 | |
| | 101 | Doctrine_Manager::getInstance()->setAttribute('use_dql_callbacks', $orig); |
| | 102 | } |