diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-01-30 15:50:35 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-30 15:50:56 +0100 |
| commit | ce4981b23f55eee427a850986ebbdd373d0683fe (patch) | |
| tree | db2c74f01377419c10b3ebbad0cfed8f33ec19e9 /src/server/database/Updater/DBUpdater.cpp | |
| parent | 50178650b2d1c123c40aa4d7ed3ecf3d7fefa00d (diff) | |
Core/DBUpdater: Apply each sql update file in a separate transaction
(cherry picked from commit b79a91039bba12d62e43806d8a20ad76107ac5d7)
Diffstat (limited to 'src/server/database/Updater/DBUpdater.cpp')
| -rw-r--r-- | src/server/database/Updater/DBUpdater.cpp | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/server/database/Updater/DBUpdater.cpp b/src/server/database/Updater/DBUpdater.cpp index 3c4d52a2639..c61aa506f7b 100644 --- a/src/server/database/Updater/DBUpdater.cpp +++ b/src/server/database/Updater/DBUpdater.cpp @@ -332,7 +332,7 @@ void DBUpdater<T>::ApplyFile(DatabaseWorkerPool<T>& pool, std::string const& hos Path const& path) { std::vector<std::string> args; - args.reserve(7); + args.reserve(9); // CLI Client connection info args.emplace_back("-h" + host); @@ -382,13 +382,17 @@ void DBUpdater<T>::ApplyFile(DatabaseWorkerPool<T>& pool, std::string const& hos #endif + // Execute sql file + args.emplace_back("-e"); + args.emplace_back(Trinity::StringFormat("BEGIN; SOURCE %s; COMMIT;", path.generic_string().c_str())); + // Database if (!database.empty()) args.emplace_back(database); // Invokes a mysql process which doesn't leak credentials to logs int const ret = Trinity::StartProcess(DBUpdaterUtil::GetCorrectedMySQLExecutable(), args, - "sql.updates", path.generic_string(), true); + "sql.updates", "", true); if (ret != EXIT_SUCCESS) { |