XF 2.2 Updating a value in a db table

[Anatoliy]

I added a custom column av-aw-processed into xf-user table. I want to be able to 'mark' users by updating the field (overwrite with the current timestamp).

Is there some built in xF way to do it, like fetching with a finder? Or I should run a usual SQL query like

public function actionProcessed(ParameterBag $params)
    {
        $userId = $params->user_id;
        $time = time();

        $db = $this->app->db();
        $db->query("
        UPDATE xf_user SET av-aw-processed=$time WHERE id=$userId
        ")->execute();
    }

Thanks in advance.

 

[asprin]

Yeh, $db->query() works, finder should work too, although it seems pointless to grab a record from the database just to update it.

$user = \XF::finder('XF:User')->where('user_id', $userId)->fetchOne();
if($user)
{
    $user->av-aw-processed = $time; // untested, I think you might have an issue with the presence of "-" in the column name
    $user->save();
}

 

[Anatoliy]

Yeh, $db->query() works, finder should work too, although it seems pointless to grab a record from the database just to update it.

no, not fetching one to update. sorry for my english. )
I mean maybe there is something like 'updater' (like finder) in xenForo. something like

$user = \XF::updater('XF:User')
  ->where('user_id', $userId)
  ->update('av-aw-processed', $someData);
$user->save();

)))

 

[asprin]

As far as I know, no, there's nothing like that out of the box.