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

2 votes408 views2 answers
Check if date between two dates laravel eloquent
PHP Laravel
0 vote368 views2 answers
Steps to create laravel project
PHP Laravel
0 vote367 views1 answer
Laravel form validation based on another field value
PHP Laravel
0 vote386 views1 answer
Laravel package for getID3()
PHP Laravel
2 votes412 views1 answer
Laravel 8 delete by id
PHP Laravel
8 votes417 views1 answer
How to migrate single table in laravel
PHP Laravel
13 votes362 views6 answers
Prefix laravel route
PHP Laravel
11 votes340 views4 answers
Laravel create resource controller
PHP Laravel
1 vote373 views1 answer
Laravel images mimetypes validatiion
PHP Laravel
-1 vote471 views1 answer
Validate rule if row exist laravel
PHP Laravel