Mercurial > hg > orthanc
view OrthancServer/Sources/ServerToolbox.cpp @ 4612:4982733a4e39 db-changes
fix database retries
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Wed, 07 Apr 2021 10:41:39 +0200 |
parents | ff8170d17d90 |
children | 95ffe3b6ef7c |
line wrap: on
line source
/** * Orthanc - A Lightweight, RESTful DICOM Store * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics * Department, University Hospital of Liege, Belgium * Copyright (C) 2017-2021 Osimis S.A., Belgium * * This program is free software: you can redistribute it and/or * modify it under the terms of the GNU General Public License as * published by the Free Software Foundation, either version 3 of the * License, or (at your option) any later version. * * In addition, as a special exception, the copyright holders of this * program give permission to link the code of its release with the * OpenSSL project's "OpenSSL" library (or with modified versions of it * that use the same license as the "OpenSSL" library), and distribute * the linked executables. You must obey the GNU General Public License * in all respects for all of the code used other than "OpenSSL". If you * modify file(s) with this exception, you may extend this exception to * your version of the file(s), but you are not obligated to do so. If * you do not wish to do so, delete this exception statement from your * version. If you delete this exception statement from all source files * in the program, then also delete it here. * * This program is distributed in the hope that it will be useful, but * WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. **/ #include "PrecompiledHeadersServer.h" #include "ServerToolbox.h" #include "../../OrthancFramework/Sources/DicomFormat/DicomArray.h" #include "../../OrthancFramework/Sources/DicomParsing/ParsedDicomFile.h" #include "../../OrthancFramework/Sources/FileStorage/StorageAccessor.h" #include "../../OrthancFramework/Sources/Logging.h" #include "../../OrthancFramework/Sources/OrthancException.h" #include "Database/IDatabaseWrapper.h" #include "Database/ResourcesContent.h" #include "OrthancConfiguration.h" #include "ServerContext.h" #include <cassert> namespace Orthanc { static const DicomTag PATIENT_IDENTIFIERS[] = { DICOM_TAG_PATIENT_ID, DICOM_TAG_PATIENT_NAME, DICOM_TAG_PATIENT_BIRTH_DATE }; static const DicomTag STUDY_IDENTIFIERS[] = { DICOM_TAG_PATIENT_ID, DICOM_TAG_PATIENT_NAME, DICOM_TAG_PATIENT_BIRTH_DATE, DICOM_TAG_STUDY_INSTANCE_UID, DICOM_TAG_ACCESSION_NUMBER, DICOM_TAG_STUDY_DESCRIPTION, DICOM_TAG_STUDY_DATE }; static const DicomTag SERIES_IDENTIFIERS[] = { DICOM_TAG_SERIES_INSTANCE_UID }; static const DicomTag INSTANCE_IDENTIFIERS[] = { DICOM_TAG_SOP_INSTANCE_UID }; static void StoreMainDicomTagsInternal(ResourcesContent& target, int64_t resource, const DicomMap& tags) { DicomArray flattened(tags); for (size_t i = 0; i < flattened.GetSize(); i++) { const DicomElement& element = flattened.GetElement(i); const DicomTag& tag = element.GetTag(); const DicomValue& value = element.GetValue(); if (!value.IsNull() && !value.IsBinary()) { target.AddMainDicomTag(resource, tag, element.GetValue().GetContent()); } } } static void StoreIdentifiers(ResourcesContent& target, int64_t resource, ResourceType level, const DicomMap& map) { const DicomTag* tags; size_t size; ServerToolbox::LoadIdentifiers(tags, size, level); for (size_t i = 0; i < size; i++) { // The identifiers tags are a subset of the main DICOM tags assert(DicomMap::IsMainDicomTag(tags[i])); const DicomValue* value = map.TestAndGetValue(tags[i]); if (value != NULL && !value->IsNull() && !value->IsBinary()) { std::string s = ServerToolbox::NormalizeIdentifier(value->GetContent()); target.AddIdentifierTag(resource, tags[i], s); } } } void ResourcesContent::AddResource(int64_t resource, ResourceType level, const DicomMap& dicomSummary) { StoreIdentifiers(*this, resource, level, dicomSummary); DicomMap tags; switch (level) { case ResourceType_Patient: dicomSummary.ExtractPatientInformation(tags); break; case ResourceType_Study: // Duplicate the patient tags at the study level (new in Orthanc 0.9.5 - db v6) dicomSummary.ExtractPatientInformation(tags); StoreMainDicomTagsInternal(*this, resource, tags); dicomSummary.ExtractStudyInformation(tags); break; case ResourceType_Series: dicomSummary.ExtractSeriesInformation(tags); break; case ResourceType_Instance: dicomSummary.ExtractInstanceInformation(tags); break; default: throw OrthancException(ErrorCode_InternalError); } StoreMainDicomTagsInternal(*this, resource, tags); } namespace ServerToolbox { bool FindOneChildInstance(int64_t& result, IDatabaseWrapper::ITransaction& transaction, int64_t resource, ResourceType type) { for (;;) { if (type == ResourceType_Instance) { result = resource; return true; } std::list<int64_t> children; transaction.GetChildrenInternalId(children, resource); if (children.empty()) { return false; } resource = children.front(); type = GetChildResourceType(type); } } void ReconstructMainDicomTags(IDatabaseWrapper::ITransaction& transaction, IStorageArea& storageArea, ResourceType level) { // WARNING: The database should be locked with a transaction! // TODO: This function might consume much memory if level == // ResourceType_Instance. To improve this, first download the // list of studies, then remove the instances for each single // study (check out OrthancRestApi::InvalidateTags for an // example). Take this improvement into consideration for the // next upgrade of the database schema. const char* plural = NULL; switch (level) { case ResourceType_Patient: plural = "patients"; break; case ResourceType_Study: plural = "studies"; break; case ResourceType_Series: plural = "series"; break; case ResourceType_Instance: plural = "instances"; break; default: throw OrthancException(ErrorCode_InternalError); } LOG(WARNING) << "Upgrade: Reconstructing the main DICOM tags of all the " << plural << "..."; std::list<std::string> resources; transaction.GetAllPublicIds(resources, level); for (std::list<std::string>::const_iterator it = resources.begin(); it != resources.end(); ++it) { // Locate the resource and one of its child instances int64_t resource, instance; ResourceType tmp; if (!transaction.LookupResource(resource, tmp, *it) || tmp != level || !FindOneChildInstance(instance, transaction, resource, level)) { throw OrthancException(ErrorCode_InternalError, "Cannot find an instance for " + std::string(EnumerationToString(level)) + " with identifier " + *it); } // Get the DICOM file attached to some instances in the resource FileInfo attachment; if (!transaction.LookupAttachment(attachment, instance, FileContentType_Dicom)) { throw OrthancException(ErrorCode_InternalError, "Cannot retrieve the DICOM file associated with instance " + transaction.GetPublicId(instance)); } try { // Read and parse the content of the DICOM file StorageAccessor accessor(storageArea); std::string content; accessor.Read(content, attachment); ParsedDicomFile dicom(content); // Update the tags of this resource DicomMap dicomSummary; OrthancConfiguration::DefaultExtractDicomSummary(dicomSummary, dicom); transaction.ClearMainDicomTags(resource); ResourcesContent tags; tags.AddResource(resource, level, dicomSummary); transaction.SetResourcesContent(tags); } catch (OrthancException&) { LOG(ERROR) << "Cannot decode the DICOM file with UUID " << attachment.GetUuid() << " associated with instance " << transaction.GetPublicId(instance); throw; } } } void LoadIdentifiers(const DicomTag*& tags, size_t& size, ResourceType level) { switch (level) { case ResourceType_Patient: tags = PATIENT_IDENTIFIERS; size = sizeof(PATIENT_IDENTIFIERS) / sizeof(DicomTag); break; case ResourceType_Study: tags = STUDY_IDENTIFIERS; size = sizeof(STUDY_IDENTIFIERS) / sizeof(DicomTag); break; case ResourceType_Series: tags = SERIES_IDENTIFIERS; size = sizeof(SERIES_IDENTIFIERS) / sizeof(DicomTag); break; case ResourceType_Instance: tags = INSTANCE_IDENTIFIERS; size = sizeof(INSTANCE_IDENTIFIERS) / sizeof(DicomTag); break; default: throw OrthancException(ErrorCode_ParameterOutOfRange); } } std::string NormalizeIdentifier(const std::string& value) { std::string t; t.reserve(value.size()); for (size_t i = 0; i < value.size(); i++) { if (value[i] == '%' || value[i] == '_') { t.push_back(' '); // These characters might break wildcard queries in SQL } else if (isascii(value[i]) && !iscntrl(value[i]) && (!isspace(value[i]) || value[i] == ' ')) { t.push_back(value[i]); } } Toolbox::ToUpperCase(t); return Toolbox::StripSpaces(t); } bool IsIdentifier(const DicomTag& tag, ResourceType level) { const DicomTag* tags; size_t size; LoadIdentifiers(tags, size, level); for (size_t i = 0; i < size; i++) { if (tag == tags[i]) { return true; } } return false; } void ReconstructResource(ServerContext& context, const std::string& resource) { LOG(WARNING) << "Reconstructing resource " << resource; std::list<std::string> instances; context.GetIndex().GetChildInstances(instances, resource); for (std::list<std::string>::const_iterator it = instances.begin(); it != instances.end(); ++it) { ServerContext::DicomCacheLocker locker(context, *it); // Delay the reconstruction of DICOM-as-JSON to its next access through "ServerContext" context.GetIndex().DeleteAttachment(*it, FileContentType_DicomAsJson); context.GetIndex().ReconstructInstance(locker.GetDicom()); } } } }