Empty result set

[bjaysheel]

• Laravel-mongodb Version: 5.2
• PHP Version: 8.3
• Database Driver & Version: mongodb 8.0.4

Description:

Steps to reproduce

1. Created a model
2. Created a collection using mongo compass
3. use php artisan tinker from laravel project root
4. database query return null

Expected behaviour

Return documents from mongo collection

Actual behaviour

Return null or empty array

I have followed the instruction listed here my dsn is mongodb://127.0.0.1:27017 (I have even tried localhost instead of ip) In either case when using php artisan tinker to test the connection the result set is always empty. There are not errors reported so I assume connection is made to mongdb on localhost but it can't return any data from the collection. My model is

<?php

namespace App\Models;

use App\Helpers\SearchFormQueryBuilder;
use ElasticScoutDriverPlus\Builders\SearchRequestBuilder;
use Laravel\Scout\Searchable;
use ElasticScoutDriverPlus\CustomSearch;
use ElasticScoutDriverPlus\QueryDsl;
use MongoDB\Laravel\Eloquent\Model;
//use Laravel\Scout\Searchable;


class RVDB extends Model
{

    use Searchable;

    protected $connection = 'mongodb';
    protected $collection = 'annotation';
    protected $primaryKey = 'accession';

    protected $keyType = 'string';
}

and php tinker code is

> php artisan tinker
Psy Shell v0.12.7 (PHP 8.3.15 — cli) by Justin Hileman
> $r = new RVDB;
[!] Aliasing 'RVDB' to 'App\Models\RVDB' for this Tinker session.
= App\Models\RVDB {#5449}

> $r = new App\Models\RVDB;
= App\Models\RVDB {#5447}

> $r::first();
= null

> $r;
= App\Models\RVDB {#5447}

> exit

   INFO  Goodbye.

Not sure what I am missing.

Thank you
Jaysheel

[GromNaN]

Hello, looking at the thinker commands you sent, it seems that you did not save the model object. Call $r->save()

[bjaysheel]

Isn't save() method used to write data to Mongo collection? My Laravel app does not write/update any data to db only ready operations. I should be able to view data that is already in the collection and by extending MongoDB\Laravel\Eloquent\Model first and find method should work, at least that is my understanding of it.

[axsweet]

I am having the same issue after updating to 5.2. When I run the query in raw, it works but when I run it via eloquent nope no result, empty. I thought connection then came up with to do it raw which works but eloquent doenst $raw = \DB::connection('mongodbPart')->getMongoClient()
->selectCollection('parts', 'pastParts')
->find([], ['limit' => 10])
->toArray(); worked for ever now isnt. I rolled back but I cant seem to get it to work again. spent a hour more on it since after that composer update poof all data appears gone but mongosh proves its all there... so I ran in raw query boom works

[axsweet]

Yo try this. manually add a function to get the table to your model and make it return just the name of the collection see if htat fixes it for you. The issue was NOT in mongo but other small tweaks that came with a composer update. I suspect 11.44 to 11.44.2 or something. anyway try and see :)
public function getTable()
{
return 'parts'; // Override default
}

[GromNaN]

I spotted the issue. We deprecated usage of $collection property to set the collection name in laravel/mongodb 4.4. You must use the $table property instead, which is consistent with other Eloquent SQL Models.

class RVDB extends Model
{

    use Searchable;

    protected $connection = 'mongodb';
-   protected $collection = 'annotation';
+   protected $table = 'annotation';
    protected $primaryKey = 'accession';

    protected $keyType = 'string';
}

[bjaysheel]

Thank you, I can confirm, all three solutions worked.

Using raw statement works: for mongodb/laravel-mongodb v5.2 statement was
$raw = \DB::connection('mongodb')->getClient() ->selectCollection('DB_NAME', 'TABLE_NAME') ->find([], ['limit' => 10]) ->toArray();

I also tested overwritting getTable function in my Model
function getTable() { return $this->collection(); }

And finally replaced protected property collection with table @GromNaN suggested. This one worked as well.

Thank you everyone, marking it closed.