CODEWITHSUNDEEP
phplaravellaravel-4eloquentupdates
arrowill12
arrowill12

Reputation: 1804

How to use mutators in laravel mass update?

I am currently updating multiple rows in my database by doing the following:

I take an array in a post and loop through it, each member is an array of fieldname=>value and I am doing an update on each one. the problem is that the mutators I have set up do not get run when I update this way. is there another way to update that is efficient and will call the mutators?

code:

foreach ($post['row'] as $row) {
     Instances::where('id', $row['id'])->update($row);
  }

Upvotes: 2

Views: 2477

Answers (1)

Antonio Carlos Ribeiro
Antonio Carlos Ribeiro

Reputation: 87719

You probably will be able to use your mutators by doing something like:

foreach ($post['row'] as $row) 
{
     $data = Instances::where('id', $row['id'])->first();

     foreach($row as $key => $value)
     {
        $data->$key = $value; // which is the same as $data->setAttribute($key, $value);
     }

     $data->save();
}

Can't you just override the update method?

class BaseModel extends Eloquent {

    public function update($array)
    {
        parent::update($this->trimAll($array));
    }

    public function trimAll($data)
    {
        /// trim them here
    }

}

And you can keep using:

Instances::where('id', $row['id'])->update($row);

Upvotes: 1

Related Questions