Optimistic Locking Laravel

<?php

function transfer($fromAccountId, $toAccountId, $balance)
{
  $fromQuery = Account::whereId($fromAccountId);
  if (! $fromQuery->exists()) {
    throw new InvalidAccountException();
  }

  $toQuery = Account::whereId($toAccountId);
  if (! $toQuery->exists()) {
    throw new InvalidAccountException();
  }

  do {
    $fromAccount = $fromQuery->first();
    if ($fromAccount->balance < $amount) {
      throw new InsufficientBalanceException();
    }
    $updated = Account::whereId($fromAccountId)
      ->where('updated_at', '=', $fromAccount->updated_at)
      ->update(['balance' => $fromAccount->balance - $amount]);
  } while (! $updated);

  do {
    $toAccount = $toQuery->first();    
    $updated = Account::whereId($toAccountId)
      ->where('updated_at', '=', $toAccount->updated_at)
      ->update(['balance' => $toAccount->balance + $amount]);
  } while (! $updated);

  $transaction = new Transaction();
  $transaction->from_account_id = $fromAccountId;
  $transaction->to_account_id   = $toAccountId;
  $transaction->amount          = $amount;
  $transaction->save();
}

Source: gist.githubusercontent.com

Similar codes

33 votes170 views5 answers
Php elseif
PHP
4 votes162 views1 answer
How to check query execution time in laravel
PHP
12 votes160 views3 answers
Carbon in laravel documentation
PHP Laravel
37 votes150 views6 answers
Php remove last character in string
PHP
0 vote156 views1 answer
Phpfiddle
PHP
11 votes119 views1 answer
Install php 8.1 fpm and all modules on ubuntu
PHP
0 vote194 views1 answer
Laravel jwt check token sent by request is valid
PHP Laravel
0 vote172 views1 answer
Laravel target is not instantiable while building
PHP
1 vote183 views1 answer
Php counting number of chars excluding newlines
PHP
0 vote172 views2 answers
Is_wplogin
PHP