在 Laravel 6 的 Eloquent ORM 中使用数据库事务
1、在 Laravel 6 的 Eloquent ORM 中使用数据库事务。应用程序仅使用 PHP 7.0 及更高版本，因此将 \Exception 替换为 \Throwable。参考：https://stackoverflow.com/questions/49814785/how-can-i-use-transaction-with-eloquent-laravel-5-5
2、最终实现代码如下
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | DB::beginTransaction();try { $themeInstallation = new ThemeInstallation(); $themeInstallation->theme_store_theme_id = $saasThemeConfig[$name]['id']; $themeInstallation->theme_id = $name; $themeInstallation->wp_theme_id = $wpTheme->id; $themeInstallation->theme_custom_name = $custom_name; $themeInstallation->save(); $themeInstallationVersion = new ThemeInstallationVersion(); $themeInstallationVersion->theme_installation_id = $themeInstallation->id; $themeInstallationVersion->theme_store_theme_id = $saasThemeConfig[$name]['id']; $themeInstallationVersion->theme_store_theme_version_id = $saasThemeConfig[$name]['id']; $themeInstallationVersion->save(); $themeInstallationTask = new ThemeInstallationTask(); $themeInstallationTask->theme_installation_id = $themeInstallation->id; $themeInstallationTask->theme_installation_version_id = $themeInstallationVersion->id; $themeInstallationTask->theme_store_theme_version_id = $saasThemeConfig[$name]['id']; $themeInstallationTask->save(); DB::commit();} catch(\Throwable $e) { DB::rollBack(); throw $e;} |
3、当特地让事务失败时，即让第 3 个模型中插入一个不存在的字段，事务回滚，确认 3 张表中皆未插入数据。如图1
图1
1 2 3 4 5 6 7 8 9 10 11 12 | { "message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'theme_store_theme_version_id' in 'field list' (SQL: insert into `theme_installation_task` (`processing`, `processing_failed`, `step`, `message`, `theme_installation_id`, `theme_installation_version_id`, `theme_store_theme_version_id`, `updated_at`, `created_at`) values (1, 0, 1, , 1, 1, 9, 2022-05-17 17:39:35, 2022-05-17 17:39:35))", "code": "42S22", "status_code": 500, "debug": { "line": 669, "file": "\\.\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php", "class": "Illuminate\\Database\\QueryException", "trace": { } }} |
4、当事务成功后，确认 3 张表中皆已插入数据。
近期评论