Massive Update Strategy

$this->getUser()->getNotifications("seen=0")

The result is an instance of Mvc\Resultset . You can do this:

$unseen_notifications = $this->getUser()->getNotifications("seen=0");

foreach ($unseen_notifications as $notification) {
    $notification-update(['seen' => 1]);
    // or
    // $notification->setSeen(1);
    // $notification->update();
}

Hi Calin, thanks for the reply. I'm tring to optimize the process using a statement to create the relative update query in the rdbms without massive single updates.

Inside docs is written:

Updating related records¶ Instead of doing this:

<?php

foreach ($robots->getParts() as $part) {
    $part->stock = 100;
    $part->updated_at = time();
    if ($part->update() == false) {
        foreach ($part->getMessages() as $message) {
            echo $message;
        }
        break;
    }
}

you can do this:

<?php

$robots->getParts()->update(array(
    'stock' => 100,
    'updated_at' => time()
));

So what's happening with my code? I'm missing something :(

Well.

First, you shouldn't put it in an if statement and second the update can fail if:

A) There are no notifications B) There are notifications but the relation in your model is wrong.

You could try my code. If that is not working, probably you should look more into point B)

couldn't you do smth like

$query = new Phalcon\Mvc\Model\Query("update notifications set seen = 1 where seen = 0 && user_id = $id", $this->getDI());

// Execute the query returning a result if any
$cars = $query->execute();

As posted here my question seems to be unanswered even if correct. https://forum.phalcon.io/discussion/1290/update-resultset

I don't know why the documentation reports we can call update on a resultset but the class definition is lacking the method.

Can anyone explain this? I agree, it's impossible to accomplish in manual/iterative ways, but the doc says you have not to!

simple, someone forgot to add it

• https://github.com/phalcon/cphalcon/blob/1.3.4/ext/mvc/model/resultset.c
• https://github.com/phalcon/cphalcon/blob/2.0.0/phalcon/mvc/model/resultset.zep

you obviously see someone missing out the update function in 1.3.4

Thanks 7thcubic! Is it going to be fixed in 1.3.4? I suppose not... can you confirm this?

1.3.4 has already been released, so it looks like you'll have to wait until 2.0.