Mercurial > hg > orthanc-databases

comparison PostgreSQL/Plugins/PostgreSQLIndex.cpp @ 448:f2427f94d879 pg-transactions

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added downgrade script + renames version
author Alain Mazy <am@osimis.io>
date Wed, 17 Jan 2024 16:22:08 +0100
parents d979f25e60cf
children c437ec7be2b0
comparison
equal deleted inserted replaced
447:5881e4af5799 448:f2427f94d879
64 void PostgreSQLIndex::ApplyPrepareIndex(DatabaseManager::Transaction& t, DatabaseManager& manager) 64 void PostgreSQLIndex::ApplyPrepareIndex(DatabaseManager::Transaction& t, DatabaseManager& manager)
65 { 65 {
66 std::string query; 66 std::string query;
67 67
68 Orthanc::EmbeddedResources::GetFileResource 68 Orthanc::EmbeddedResources::GetFileResource
69 (query, Orthanc::EmbeddedResources::POSTGRESQL_PREPARE_INDEX_V2); 69 (query, Orthanc::EmbeddedResources::POSTGRESQL_PREPARE_INDEX);
70 t.GetDatabaseTransaction().ExecuteMultiLines(query); 70 t.GetDatabaseTransaction().ExecuteMultiLines(query);
71 71
72 SetGlobalIntegerProperty(manager, MISSING_SERVER_IDENTIFIER, Orthanc::GlobalProperty_DatabaseSchemaVersion, 6); 72 SetGlobalIntegerProperty(manager, MISSING_SERVER_IDENTIFIER, Orthanc::GlobalProperty_DatabaseSchemaVersion, 6);
73 SetGlobalIntegerProperty(manager, MISSING_SERVER_IDENTIFIER, Orthanc::GlobalProperty_DatabasePatchLevel, 2); 73 SetGlobalIntegerProperty(manager, MISSING_SERVER_IDENTIFIER, Orthanc::GlobalProperty_DatabasePatchLevel, 2);
74 SetGlobalIntegerProperty(manager, MISSING_SERVER_IDENTIFIER, Orthanc::GlobalProperty_HasCreateInstance, 3); // this is the 3rd version ! 74 SetGlobalIntegerProperty(manager, MISSING_SERVER_IDENTIFIER, Orthanc::GlobalProperty_HasCreateInstance, 3); // this is the 3rd version !
192 { 192 {
193 LOG(WARNING) << "Upgrading DB schema from unknown to revision 1"; 193 LOG(WARNING) << "Upgrading DB schema from unknown to revision 1";
194 std::string query; 194 std::string query;
195 195
196 Orthanc::EmbeddedResources::GetFileResource 196 Orthanc::EmbeddedResources::GetFileResource
197 (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_UNKNOWN_TO_V1); 197 (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_UNKNOWN_TO_V6_1);
198 t.GetDatabaseTransaction().ExecuteMultiLines(query); 198 t.GetDatabaseTransaction().ExecuteMultiLines(query);
199 } 199 }
200 200
201 if (needToRunUpgradeV1toV2) 201 if (needToRunUpgradeV1toV2)
202 { 202 {
203 LOG(WARNING) << "Upgrading DB schema from revision 1 to revision 2"; 203 LOG(WARNING) << "Upgrading DB schema from revision 1 to revision 2";
204 204
205 std::string query; 205 std::string query;
206 206
207 Orthanc::EmbeddedResources::GetFileResource 207 Orthanc::EmbeddedResources::GetFileResource
208 (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_V1_TO_V2); 208 (query, Orthanc::EmbeddedResources::POSTGRESQL_UPGRADE_V6_1_TO_V6_2);
209 t.GetDatabaseTransaction().ExecuteMultiLines(query); 209 t.GetDatabaseTransaction().ExecuteMultiLines(query);
210 210
211 // apply all idempotent changes that are in the PrepareIndexV2 211 // apply all idempotent changes that are in the PrepareIndexV2
212 ApplyPrepareIndex(t, manager); 212 ApplyPrepareIndex(t, manager);
213 } 213 }