How to implement the following Mongo pseudocode in Laravel?

Question

I want to implement:

db.lawcases.find().snapshot().forEach(
    function (elem) {
        db.lawcases.update(
            {
                _id: elem._id
            },
            {
                $set: {
                    name: elem.firstname + ' ' + elem.lastname
                }
            }
        );
    }
);

I am using the Laravael MongoDB package which allows me to do raw queries as it explains in https://github.com/jenssegers/Laravel-MongoDB#raw-expressions.

I have so far:

$lawCases =  \DB::connection('mongodb')->collection('lawcases')->raw(function($collection)
        {
            return $collection->find();
        });



        foreach($lawCases as $case){
                    //DO SOMETHING

            }

But am needing a bit of help as I do not know how to persist the change. I feel I am not doing it right.

Taha Paksu · Accepted Answer · 2018-12-24 08:52:53Z

1

Use it like you use Laravel's Database usage:

<?php

// get the cases first
$lawCases = \DB::connection('mongodb')
    ->collection('lawcases')
    ->get();

// update each record
foreach($lawCases as $case)
{
    \DB::connection('mongodb')
    ->collection('lawcases')
    ->where([
        "_id" =>  $case["_id"]
    ])
    ->update([
        "name" => $case["firstname"] . " " $case["lastname"]
    ]);
}

answered Dec 24, 2018 at 8:52

Taha Paksu

15.6k2 gold badges50 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to implement the following Mongo pseudocode in Laravel?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related