Breaking News: Grepper is joining You.com. Read the official announcement!

Raw qeury with Laravel Mongodb using Jensseger

devlob answered on July 8, 2022 Popularity 6/10 Helpfulness 4/10

answer Raw qeury with Laravel Mongodb using Jensseger

Raw qeury with Laravel Mongodb using Jensseger

Comment

// This is the SQL version
$unreadMessageCount = Message::selectRaw('from_id as sender_id, count(from_id) as messages_count')
   ->where('to_id', auth()->id())
   ->where('read', false)
   ->groupBy('from')
   ->get();

// This is the Mongo version. The solution was figuring out the 'aggregate' concept in Mongo
$unreadMessageCount = Message::raw(function($collection)
{
    return $collection->aggregate([
    [
      '$match' => [
        'to_id' => auth()->id()
      ]
    ],
        [
            '$group' => [
                '_id' => '$from_id',
                'messages_count' => [
                    '$sum' => 1
                ]
            ]
        ]
    ]);
});

Popularity 6/10 Helpfulness 4/10 Language whatever

Source: stackoverflow.com

Tags: laravel-mongodb raw using whatever

Link to this answer
Share Copy Link