Mercurial > hg > orthanc-databases

comparison PostgreSQL/Plugins/PostgreSQLIndex.cpp @ 467:ff84104f7842 pg-transactions

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
renamed v6.2 to REV2 + removed 'default' TransactionMode + renamed 'READ COMMITTED' into 'ReadCommitted'
author Alain Mazy <am@osimis.io>
date Mon, 05 Feb 2024 09:43:14 +0100
parents f0976163dbe1
children 15e609c439d1
comparison
equal deleted inserted replaced
466:daaa35ddba54 467:ff84104f7842
184 { 184 {
185 LOG(WARNING) << "Upgrading DB schema from unknown to revision 1"; 185 LOG(WARNING) << "Upgrading DB schema from unknown to revision 1";
186 std::string query; 186 std::string query;
187 187
188 Orthanc::EmbeddedResources::GetFileResource 188 Orthanc::EmbeddedResources::GetFileResource
189 (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_UNKNOWN_TO_V6_1); 189 (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_UNKNOWN_TO_REV1);
190 t.GetDatabaseTransaction().ExecuteMultiLines(query); 190 t.GetDatabaseTransaction().ExecuteMultiLines(query);
191 } 191 }
192 192
193 if (needToRunUpgradeV1toV2) 193 if (needToRunUpgradeV1toV2)
194 { 194 {
195 LOG(WARNING) << "Upgrading DB schema from revision 1 to revision 2"; 195 LOG(WARNING) << "Upgrading DB schema from revision 1 to revision 2";
196 196
197 std::string query; 197 std::string query;
198 198
199 Orthanc::EmbeddedResources::GetFileResource 199 Orthanc::EmbeddedResources::GetFileResource
200 (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_V6_1_TO_V6_2); 200 (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_REV1_TO_REV2);
201 t.GetDatabaseTransaction().ExecuteMultiLines(query); 201 t.GetDatabaseTransaction().ExecuteMultiLines(query);
202 202
203 // apply all idempotent changes that are in the PrepareIndexV2 203 // apply all idempotent changes that are in the PrepareIndexV2
204 ApplyPrepareIndex(t, manager); 204 ApplyPrepareIndex(t, manager);
205 } 205 }