Route::get('/pessimism', function () {
DB::beginTransaction();
try {
$name = 'java';
$count = DB::table('test')->where('name', $name)->lockForUpdate()->count();
if ($count <= 0) {
DB::table('test')->insert(['name' => $name]);
echo 1;
} else {
echo 0;
}
// 提交事务
DB::commit();
} catch (\Exception $e) {
// 回滚事务
DB::rollBack();
}
});