batch update query not work

Question

batch update query not work

diggymo Nov '17

Created Nov '17	Last Reply Nov '17	Replies 1	Views 769	Votes 0

diggymo 2.5k

Nov '17

This query work correctly when user that user.rank is 1 is not included in $userIds .but, this query not work when user that user.rank is 1 is included in $userIds .

so what's happen!?.

phalcon's version is 3.1.

        $userIds = [1,2,3,4];
        $increasedCount = 1;

        var_dump($increasedCount);
        switch ($increasedCount) {
            case $increasedCount > 0:
                $countSql = "+ " . $increasedCount;
                break;
            case $increasedCount < 0:
                $countSql = "- " . abs($increasedCount);
                break;
            default:
                return false;
        }

        $user = new UserEntity();

        try {
            $phql = "UPDATE Application\Models\Entities\User SET rank = rank $countSql WHERE id IN (" . implode(",", $userIds) . ")";
            return $user->getModelsManager()->executeQuery($phql);
        } catch (Exception $e) {
            return false;
        }

Lajos Bencz · Answer 1 · 2017-11-28T04:15:43-07:00

What does "it does not work" exactly mean? Does it throw an exception? Does it not perform the expected operation?

You can also omit the $countSql and the switch logic, SQL addition inherently handles signs.

$userIds = [1,2,3,4];
$increasedCount = 1;
if($increasedCount === 0) {
    return false;
}
$user = new UserEntity();
try {
    $phql = "UPDATE Application\Models\Entities\User SET rank = rank + :count:  WHERE id IN (" . implode(",", $userIds) . ")";
    return $user->getModelsManager()->executeQuery($phql, ['count'=>$increasedCount]);
} catch (Exception $e) {
    return false;
}

diggymo · Answer 2 · 2017-11-28T19:07:15-07:00

Thank you for your answer.

What does "it does not work" exactly mean?

This means that query return success result. but , user.rank that user.rank is 1 was'nt added.

So, I changed code as below while I expected to go well.

But , the result is same as the previous one.

Consequently,,,, I'm in a puzzle...

$userIds = [1,2,3,4];
$increasedCount = 1;
if($increasedCount === 0) {
    return false;
}
$user = new UserEntity();
try {
    $phql = "UPDATE Application\Models\Entities\User SET rank = rank + 1  WHERE id IN (" . implode(",", $userIds) . ")";
    return $user->getModelsManager()->executeQuery($phql);
} catch (Exception $e) {
    return false;
}

diggymo · Answer 3 · 2017-11-28T20:00:03-07:00

I feel like that user.rank is recognized as boolean when user.rank is 1. and user.rank that user.rank is'nt 1 is recognized as int

UPDATE Application\Models\Entities\User SET rank = rank + 1 WHERE id IN (" . implode(",", $userIds) . ")"