public function fetch()
    {
        $modelName = $this->_className;

        // execute fetch query
        $query = $this->_dataSource->prepare($this->_queryHelper->buildQuery());
        $query->execute($this->_queryHelper->getWhereParamsValues());

        // check for mysql error
        $errorcode = $query->errorInfo();
        if ($errorcode[0] != "00000") {
            throw new Exception($errorcode[2]);
        }

        // fetch query and hydrate models
        $fetch = $query->fetchAll(\PDO::FETCH_ASSOC);
        foreach ($fetch as &$unRes) {
            /** @var $object \PicORM\Model */
            $object = new $modelName();
            $object->hydrate($unRes, false);
            $unRes = $object;
        }

        // configure collection after fetch
        $this->isFetched = true;
        $this->models    = $fetch;

        // if pagination used grab the total found model
        if ($this->_usePagination) {
            $this->_paginationFoundModels = $this->queryFoundModels();
        }

        return $this;
    }
public function fetch()
    {
        $modelName = $this->_className;

        // execute fetch query
        $query = $this->_dataSource->prepare($this->_queryHelper->buildQuery());
        $query->execute($this->_queryHelper->getWhereParamsValues());

        // check for mysql error
        $errorcode = $query->errorInfo();
        if ($errorcode[0] != "00000") {
            throw new Exception($errorcode[2]);
        }

        // fetch query and hydrate models
        $fetch = $query->fetchAll(\PDO::FETCH_ASSOC);
        foreach ($fetch as &$unRes) {
            /** @var $object \PicORM\Model */
            $object = new $modelName();
            $object->hydrate($unRes, false);
            $unRes = $object;
        }

        // configure collection after fetch
        $this->isFetched = true;
        $this->models    = $fetch;

        // if pagination used grab the total found model
        if ($this->_usePagination) {
            $this->_paginationFoundModels = $this->queryFoundModels();
        }

        return $this;
    }
public function fetch ( ) { $ modelName = $ this -> _className ; // execute fetch query $ query = $ this -> _dataSource -> prepare ( $ this -> _queryHelper -> buildQuery ( ) ) ; $ query -> execute ( $ this -> _queryHelper -> getWhereParamsValues ( ) ) ; // check for mysql error $ errorcode = $ query -> errorInfo ( ) ; if ( $ errorcode [ 0 ] != "00000" ) { throw new Exception ( $ errorcode [ 2 ] ) ; } // fetch query and hydrate models $ fetch = $ query -> fetchAll ( \ PDO :: FETCH_ASSOC ) ; foreach ( $ fetch as & $ unRes ) { /** @var $object \PicORM\Model */ $ object = new $ modelName ( ) ; $ object -> hydrate ( $ unRes , false ) ; $ unRes = $ object ; } // configure collection after fetch $ this -> isFetched = true ; $ this -> models = $ fetch ; // if pagination used grab the total found model if ( $ this -> _usePagination ) { $ this -> _paginationFoundModels = $ this -> queryFoundModels ( ) ; } return $ this ; }
Execute query and fetch models from database

@return $this
@throws Exception
Execute query and fetch models from database