/**
* @group ZF-5957
*/
public function testAdapterCanUseModifiedDbSelectObject()
{
$this->_db->getProfiler()->setEnabled(true);
$select = $this->_adapter->getDbSelect();
$select->where('1 = 1');
$this->_adapter->setIdentity('my_username');
$this->_adapter->setCredential('my_password');
$this->_adapter->authenticate();
$profiler = $this->_db->getProfiler();
$this->assertEquals('SELECT "users".*, (CASE WHEN "password" = \'my_password\' THEN 1 ELSE 0 END) AS "zend_auth_credential_match" FROM "users" WHERE (1 = 1) AND ("username" = \'my_username\')', $profiler->getLastQueryProfile()->getQuery());
}
/**
* @group ZF-10884
*/
public function testSetRowCountWithAlias()
{
$select = $this->_db->select();
$select->from('test', array(Zend_Paginator_Adapter_DbSelect::ROW_COUNT_COLUMN => new Zend_Db_Expr('COUNT(DISTINCT number)')));
$this->_db->setProfiler(true);
$adapter = new Zend_Paginator_Adapter_DbSelect($this->_db->select());
$adapter->setRowCount($select);
$adapter->count();
$expected = 'SELECT COUNT(DISTINCT number) AS "zend_paginator_row_count" FROM "test"';
$lastQuery = $this->_db->getProfiler()->getLastQueryProfile()->getQuery();
$this->assertEquals($expected, $lastQuery);
}
