Incubators Mongodb returns too much information

Question

Incubators Mongodb returns too much information

zeetone Oct '17

Created Oct '17	Last Reply Oct '17	Replies 3	Views 621	Votes 0

zeetone 2.5k

Oct '17

I have just got incubators mongodb to work with phalcon but when doing a simple find() it is returning a whole pile of other stuff I do not need.

Is there any way to reduce this to only the results from the table?

the result is huge so here is a sample of what I get returned...

Any help would be gratefully received.

corentin-begne · Answer 1 · 2017-10-05T08:43:43-07:00

Use hydratation mode HYDRATE_ARRAYS or toArray() then you'll only got the query result data
https://olddocs.phalcon.io/en/3.0.2/reference/models-advanced.html

zeetone · Answer 2 · 2017-10-06T10:58:01-07:00

zeetone
2.5k

Oct '17

Perfect, many thanks!

zeetone · Answer 3 · 2017-10-07T08:07:03-07:00

I have tried for a few hours today and cant seem to get this to work. I know it should.... I'm stuck. As I said before I am using the mongodb adapter from Incubator.

it seems as though I have the wrong namespace for the resultset as I keep getting

Fatal error: Uncaught Error: Call to a member function toArray() on array in...

I have tried

<?php 

use Phalcon\Mvc\Model\Resultset;

class ProductsController extends ControllerBase
{
    public function indexAction()
    {
        $products = Products::find();
        print_r($products->toArray());

        // not working

        ...
        //and 
        $products->setHydrateMode(Resultset::HYDRATE_ARRAY);
        print_r($products);

        // also not working

I presume Incubator would need a different namespce for the Resultset I just cant find it.

corentin-begne · Answer 4 · 2017-10-07T17:55:40-07:00

and this way ? :

use Phalcon\Mvc\Model\Resultset;

class ProductsController extends ControllerBase
{
    public function indexAction()
    {
        $products = Products::find([
            "hydration" => Resultset::HYDRATE_ARRAYS,
        ]);

else what the type of your result ?

zeetone · Answer 5 · 2017-10-11T02:59:41-07:00

and this way ? :

use Phalcon\Mvc\Model\Resultset;

class ProductsController extends ControllerBase
{
   public function indexAction()
   {
       $products = Products::find([
          "hydration" => Resultset::HYDRATE_ARRAYS,
       ]);

else what the type of your result ?

That way does return a result although it is still returns all the unwanted information.

initially I thought it was an object but on closer look the result type it is returning is an array. This would explain why toArray() is not working HYDRATE_ARRAYS is not outputing the desired result.

zeetone · Answer 6 · 2017-10-11T08:28:08-07:00

Ok, I have done a little experiment on this hydrate and toArray() issue.


use Phalcon\Mvc\Model\Resultset;

class ProductsController extends ControllerBase
{
    public function indexAction()
    {
        $products = Products::find();
        Print_r($products);
    }
}

outputs and result of array like so...

where as the same query but using findFirst() results in an object same as above but without the containing array. i.e the beginning becomes


Products Object
        (
            [name] => 
            [_id] => MongoDB\BSON\ObjectID Object
                (
                    [oid] => 59d930ce1d41c806e074dcb2

Because the Find() method is retuning an array by default, I cannot use toArray() or HYDRATE_ARRAYS.

However I can Use toArray() for the findFirst method but unfortunatly it does not change the resulting output. Whent I do Print_r($products->toArray()); the output is identiacal to print_r($products);

Is there a setting I have missed? or is this a bug? or simply, it is default behaviour for phalcon or incubator and I have to put up with it? :(

corentin-begne · Answer 7 · 2017-10-11T11:28:43-07:00

Sorry I don't have experience with mongodb, can you try serialize/unserialize instead of toArray ?