so we use this query in one of our periodicaly executed scripts:
$manager->executeQuery("UPDATE Robomaniac\Robot\Robot SET actionPoints=actionPoints+1 WHERE actionPoints<actionPointsLimit");
The point in doing this, is that I don't want the modelsmanager to do a find() and than crawl through every result, hydrating and than updating the model (which it does, according to the mysql replication bin log). I could do that by myself.
Is there a way that phalcon/the ORM just translates the query above to a simple update query like shown below, replacing the the full qualified class name with the table name and the fields according to the column map ?
UPDATE robots SET action_points=action_points+1 WHERE action_points<action_points_limit
Greetings and thanks for your help