public function testTest()
{
$q = Doctrine_Query::create()->from('Ticket_1523_User u')->innerJoin('u.Ticket_1523_Group g')->where('EXISTS (SELECT uu.id FROM Ticket_1523_User uu WHERE uu.id = u.id)')->orderBy('u.code ASC');
$pager = new Doctrine_Pager($q, 1, 10);
$pager->execute(array());
$this->assertEqual($pager->getQuery()->getSqlQuery(), 'SELECT t.id AS t__id, t.code AS t__code, t2.id AS t2__id, t2.tmp_id AS t2__tmp_id FROM ticket_1523__user t INNER JOIN ticket_1523__group t2 ON t.id = t2.tmp_id WHERE t.id IN (SELECT DISTINCT t3.id FROM ticket_1523__user t3 INNER JOIN ticket_1523__group t4 ON t3.id = t4.tmp_id WHERE EXISTS (SELECT t5.id AS t3__id FROM ticket_1523__user t5 WHERE t5.id = t3.id) ORDER BY t3.code ASC LIMIT 10) AND EXISTS (SELECT t3.id AS t3__id FROM ticket_1523__user t3 WHERE t3.id = t.id) ORDER BY t.code ASC');
}
public function testTicket()
{
Doctrine_Manager::getInstance()->setAttribute(Doctrine::ATTR_USE_DQL_CALLBACKS, true);
$query1 = Doctrine_Query::create()->select('u.*')->from('Ticket_1860_User u');
$this->assertEqual(count($query1->fetchArray()), 0);
$query2 = Doctrine_Query::create()->select('u.*')->from('Ticket_1860_User u');
// Defining initial variables
$currentPage = 1;
$resultsPerPage = 5;
// Creating pager object
$pager = new Doctrine_Pager($query2, $currentPage, $resultsPerPage);
$this->assertEqual(count($pager->execute()->toArray()), 0);
$this->assertEqual($pager->getQuery()->getSqlQuery(), 'SELECT t.id AS t__id, t.username AS t__username, t.password AS t__password, t.deleted_at AS t__deleted_at FROM ticket_1860_users t WHERE (t.deleted_at IS NULL) LIMIT 5');
Doctrine_Manager::getInstance()->setAttribute(Doctrine::ATTR_USE_DQL_CALLBACKS, false);
}
