/** * @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); }