CanFail middleware to handle Database Transaction on whole request

CanFailMiddleware.php

<?php

namespace App\Http\Middleware;

use Closure;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Symfony\Component\HttpFoundation\Response;

class CanFailMiddleware
{
    public function handle(Request $request, Closure $next): Response
    {
        DB::beginTransaction();

        try {
            // Your middleware logic here
            // For example, interacting with the database

            // Capture the response before committing
            $response = $next($request);

            // Commit the transaction
            DB::commit();

            // Return the captured response
            return $response;
        } catch (\Exception $e) {
            // If an exception occurs, rollback the transaction
            DB::rollBack();

            // Now throw captured exception
            throw $e;
        }
    }
}