public function testToArrayCreatesArrayOfArraysRepresentingRows() { $count = rand(3, 75); $dataSource = $this->getArrayDataSource($count); $this->set->setDataSource($dataSource); $test = $this->set->toArray(); $this->assertEquals($dataSource->getArrayCopy(), $test, var_export($test, 1)); }
public function fetchAll() { $statement = $dbAdapter->createStatement(); $select->prepareStatement($dbAdapter, $statement); $driverResult = $statment->execute(); $resultset = new ResultSet(); $resultset->setDataSource($driverResult); foreach ($resultset as $row) { // $row is an ArrayObject } }
public function fetchAll() { $select = new Select(); $select->from('person')->columns(array('f_name' => 'person.firstname', 'l_name' => 'person.lastname', 'comp_name' => 'contact.companyname', 'cont_name' => 'contactstate.name'))->join('contact', 'contactstate', 'person.id = contact.person_id', 'contact.state_contactstate_id = contactstate.id'); $statement = $dbAdapter->createStatement(); $select->prepareStatement($dbAdapter, $statement); $driverResult = $statment->execute(); $resultset = new ResultSet(); $resultset->setDataSource($driverResult); foreach ($resultset as $row) { // $row is an ArrayObject } }
public function selectWith(Select $select, $scrollable = true) { // Get the data $adapter = $this->getReadAdapter(); $statement = $adapter->createStatement(); $select->prepareStatement($adapter, $statement); $result = $statement->execute(); if ($scrollable) { // Convert data to an array so we can iterate more than once $resultArray = array(); foreach ($result as $row) { $resultArray[] = $this->toScalarValueArray($row); } $result = $resultArray; } // Create the ResultSet $resultSet = new ResultSet(); $resultSet->setRowObjectPrototype($this->getModelPrototype()); $resultSet->setDataSource($result); return $resultSet; }
/** * _authenticateQuerySelect() - This method accepts a Zend\Db\Sql\Select object and * performs a query against the database with that object. * * @param DbSelect $dbSelect * @throws Exception\RuntimeException when an invalid select object is encountered * @return array */ protected function _authenticateQuerySelect(DbSelect $dbSelect) { $statement = $this->_zendDb->createStatement(); $dbSelect->prepareStatement($this->_zendDb, $statement); $resultSet = new ResultSet(); try { $resultSet->setDataSource($statement->execute(array($this->_credential, $this->_identity))); $resultIdentities = $resultSet->toArray(); } catch (\Exception $e) { throw new Exception\RuntimeException( 'The supplied parameters to DbTable failed to ' . 'produce a valid sql statement, please check table and column names ' . 'for validity.', 0, $e ); } return $resultIdentities; }