php - Do I need to rollback/commit if my lockForUpdate returned an empty set?

Question

My code:

$connection->beginTransaction();

$row = $this->newQuery()->where(['someField' => 'someValue'])->lockForUpdate()->get()->first();

if (is_null($row)) {
    $connection->rollBack();

    return null;
}
          
//do some stuff with that row

$connection->commit();

My question: The result is empty, so do I need that rollback? Should I commit? Is transaction still opened by that point?

question from:https://stackoverflow.com/questions/65830352/do-i-need-to-rollback-commit-if-my-lockforupdate-returned-an-empty-set

Answer 1

Waitting for answers