orthanc-databases: Framework/Plugins/ISqlLookupFormatter.cpp annotate

author	Sebastien Jodogne <s.jodogne@gmail.com>
date	Mon, 09 Sep 2024 13:18:35 +0200
parents
children	25005693297b

rev	line source
547 b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	1 /**
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	2 * Orthanc - A Lightweight, RESTful DICOM Store
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	3 * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	4 * Department, University Hospital of Liege, Belgium
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	5 * Copyright (C) 2017-2023 Osimis S.A., Belgium
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	6 * Copyright (C) 2024-2024 Orthanc Team SRL, Belgium
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	7 * Copyright (C) 2021-2024 Sebastien Jodogne, ICTEAM UCLouvain, Belgium
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	8 *
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	9 * This program is free software: you can redistribute it and/or
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	10 * modify it under the terms of the GNU Affero General Public License
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	11 * as published by the Free Software Foundation, either version 3 of
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	12 * the License, or (at your option) any later version.
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	13 *
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	14 * This program is distributed in the hope that it will be useful, but
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	15 * WITHOUT ANY WARRANTY; without even the implied warranty of
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	17 * Affero General Public License for more details.
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	18 *
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	19 * You should have received a copy of the GNU Affero General Public License
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	20 * along with this program. If not, see <http://www.gnu.org/licenses/>.
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	21 **/
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	22
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	23
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	24 /**
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	25 * NB: Until 2024-09-09, this file was synchronized with the following
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	26 * folder from the Orthanc main project:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	27 * https://orthanc.uclouvain.be/hg/orthanc/file/default/OrthancServer/Sources/Search/
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	28 **/
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	29
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	30
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	31 #if !defined(ORTHANC_BUILDING_SERVER_LIBRARY)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	32 # error Macro ORTHANC_BUILDING_SERVER_LIBRARY must be defined
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	33 #endif
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	34
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	35 #if ORTHANC_BUILDING_SERVER_LIBRARY == 1
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	36 # include "../PrecompiledHeadersServer.h"
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	37 #endif
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	38
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	39 #include "ISqlLookupFormatter.h"
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	40
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	41 #if ORTHANC_BUILDING_SERVER_LIBRARY == 1
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	42 # include "../../../OrthancFramework/Sources/OrthancException.h"
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	43 # include "../../../OrthancFramework/Sources/Toolbox.h"
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	44 #else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	45 # include <OrthancException.h>
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	46 # include <Toolbox.h>
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	47 #endif
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	48
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	49 #include "DatabaseConstraint.h"
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	50
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	51 #include <cassert>
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	52 #include <boost/lexical_cast.hpp>
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	53 #include <list>
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	54
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	55
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	56 namespace Orthanc
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	57 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	58 static std::string FormatLevel(ResourceType level)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	59 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	60 switch (level)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	61 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	62 case ResourceType_Patient:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	63 return "patients";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	64
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	65 case ResourceType_Study:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	66 return "studies";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	67
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	68 case ResourceType_Series:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	69 return "series";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	70
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	71 case ResourceType_Instance:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	72 return "instances";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	73
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	74 default:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	75 throw OrthancException(ErrorCode_InternalError);
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	76 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	77 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	78
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	79
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	80 static bool FormatComparison(std::string& target,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	81 ISqlLookupFormatter& formatter,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	82 const DatabaseConstraint& constraint,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	83 size_t index,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	84 bool escapeBrackets)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	85 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	86 std::string tag = "t" + boost::lexical_cast<std::string>(index);
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	87
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	88 std::string comparison;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	89
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	90 switch (constraint.GetConstraintType())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	91 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	92 case ConstraintType_Equal:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	93 case ConstraintType_SmallerOrEqual:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	94 case ConstraintType_GreaterOrEqual:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	95 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	96 std::string op;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	97 switch (constraint.GetConstraintType())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	98 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	99 case ConstraintType_Equal:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	100 op = "=";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	101 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	102
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	103 case ConstraintType_SmallerOrEqual:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	104 op = "<=";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	105 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	106
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	107 case ConstraintType_GreaterOrEqual:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	108 op = ">=";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	109 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	110
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	111 default:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	112 throw OrthancException(ErrorCode_InternalError);
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	113 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	114
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	115 std::string parameter = formatter.GenerateParameter(constraint.GetSingleValue());
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	116
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	117 if (constraint.IsCaseSensitive())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	118 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	119 comparison = tag + ".value " + op + " " + parameter;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	120 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	121 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	122 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	123 comparison = "lower(" + tag + ".value) " + op + " lower(" + parameter + ")";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	124 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	125
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	126 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	127 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	128
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	129 case ConstraintType_List:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	130 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	131 for (size_t i = 0; i < constraint.GetValuesCount(); i++)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	132 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	133 if (!comparison.empty())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	134 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	135 comparison += ", ";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	136 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	137
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	138 std::string parameter = formatter.GenerateParameter(constraint.GetValue(i));
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	139
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	140 if (constraint.IsCaseSensitive())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	141 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	142 comparison += parameter;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	143 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	144 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	145 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	146 comparison += "lower(" + parameter + ")";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	147 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	148 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	149
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	150 if (constraint.IsCaseSensitive())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	151 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	152 comparison = tag + ".value IN (" + comparison + ")";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	153 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	154 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	155 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	156 comparison = "lower(" + tag + ".value) IN (" + comparison + ")";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	157 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	158
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	159 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	160 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	161
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	162 case ConstraintType_Wildcard:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	163 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	164 const std::string value = constraint.GetSingleValue();
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	165
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	166 if (value == "*")
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	167 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	168 if (!constraint.IsMandatory())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	169 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	170 // Universal constraint on an optional tag, ignore it
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	171 return false;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	172 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	173 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	174 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	175 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	176 std::string escaped;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	177 escaped.reserve(value.size());
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	178
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	179 for (size_t i = 0; i < value.size(); i++)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	180 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	181 if (value[i] == '*')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	182 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	183 escaped += "%";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	184 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	185 else if (value[i] == '?')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	186 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	187 escaped += "_";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	188 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	189 else if (value[i] == '%')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	190 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	191 escaped += "\\%";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	192 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	193 else if (value[i] == '_')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	194 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	195 escaped += "\\_";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	196 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	197 else if (value[i] == '\\')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	198 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	199 escaped += "\\\\";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	200 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	201 else if (escapeBrackets && value[i] == '[')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	202 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	203 escaped += "\\[";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	204 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	205 else if (escapeBrackets && value[i] == ']')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	206 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	207 escaped += "\\]";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	208 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	209 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	210 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	211 escaped += value[i];
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	212 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	213 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	214
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	215 std::string parameter = formatter.GenerateParameter(escaped);
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	216
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	217 if (constraint.IsCaseSensitive())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	218 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	219 comparison = (tag + ".value LIKE " + parameter + " " +
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	220 formatter.FormatWildcardEscape());
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	221 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	222 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	223 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	224 comparison = ("lower(" + tag + ".value) LIKE lower(" +
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	225 parameter + ") " + formatter.FormatWildcardEscape());
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	226 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	227 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	228
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	229 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	230 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	231
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	232 default:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	233 return false;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	234 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	235
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	236 if (constraint.IsMandatory())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	237 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	238 target = comparison;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	239 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	240 else if (comparison.empty())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	241 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	242 target = tag + ".value IS NULL";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	243 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	244 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	245 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	246 target = tag + ".value IS NULL OR " + comparison;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	247 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	248
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	249 return true;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	250 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	251
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	252
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	253 static void FormatJoin(std::string& target,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	254 const DatabaseConstraint& constraint,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	255 size_t index)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	256 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	257 std::string tag = "t" + boost::lexical_cast<std::string>(index);
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	258
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	259 if (constraint.IsMandatory())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	260 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	261 target = " INNER JOIN ";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	262 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	263 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	264 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	265 target = " LEFT JOIN ";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	266 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	267
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	268 if (constraint.IsIdentifier())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	269 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	270 target += "DicomIdentifiers ";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	271 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	272 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	273 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	274 target += "MainDicomTags ";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	275 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	276
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	277 target += (tag + " ON " + tag + ".id = " + FormatLevel(constraint.GetLevel()) +
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	278 ".internalId AND " + tag + ".tagGroup = " +
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	279 boost::lexical_cast<std::string>(constraint.GetTag().GetGroup()) +
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	280 " AND " + tag + ".tagElement = " +
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	281 boost::lexical_cast<std::string>(constraint.GetTag().GetElement()));
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	282 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	283
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	284
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	285 static std::string Join(const std::list<std::string>& values,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	286 const std::string& prefix,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	287 const std::string& separator)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	288 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	289 if (values.empty())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	290 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	291 return "";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	292 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	293 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	294 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	295 std::string s = prefix;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	296
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	297 bool first = true;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	298 for (std::list<std::string>::const_iterator it = values.begin(); it != values.end(); ++it)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	299 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	300 if (first)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	301 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	302 first = false;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	303 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	304 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	305 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	306 s += separator;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	307 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	308
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	309 s += *it;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	310 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	311
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	312 return s;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	313 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	314 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	315
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	316 static bool FormatComparison2(std::string& target,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	317 ISqlLookupFormatter& formatter,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	318 const DatabaseConstraint& constraint,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	319 bool escapeBrackets)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	320 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	321 std::string comparison;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	322 std::string tagFilter = ("tagGroup = " + boost::lexical_cast<std::string>(constraint.GetTag().GetGroup())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	323 + " AND tagElement = " + boost::lexical_cast<std::string>(constraint.GetTag().GetElement()));
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	324
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	325 switch (constraint.GetConstraintType())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	326 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	327 case ConstraintType_Equal:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	328 case ConstraintType_SmallerOrEqual:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	329 case ConstraintType_GreaterOrEqual:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	330 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	331 std::string op;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	332 switch (constraint.GetConstraintType())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	333 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	334 case ConstraintType_Equal:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	335 op = "=";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	336 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	337
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	338 case ConstraintType_SmallerOrEqual:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	339 op = "<=";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	340 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	341
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	342 case ConstraintType_GreaterOrEqual:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	343 op = ">=";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	344 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	345
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	346 default:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	347 throw OrthancException(ErrorCode_InternalError);
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	348 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	349
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	350 std::string parameter = formatter.GenerateParameter(constraint.GetSingleValue());
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	351
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	352 if (constraint.IsCaseSensitive())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	353 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	354 comparison = " AND value " + op + " " + parameter;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	355 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	356 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	357 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	358 comparison = " AND lower(value) " + op + " lower(" + parameter + ")";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	359 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	360
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	361 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	362 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	363
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	364 case ConstraintType_List:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	365 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	366 std::vector<std::string> comparisonValues;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	367 for (size_t i = 0; i < constraint.GetValuesCount(); i++)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	368 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	369 std::string parameter = formatter.GenerateParameter(constraint.GetValue(i));
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	370
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	371 if (constraint.IsCaseSensitive())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	372 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	373 comparisonValues.push_back(parameter);
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	374 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	375 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	376 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	377 comparisonValues.push_back("lower(" + parameter + ")");
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	378 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	379 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	380
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	381 std::string values;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	382 Toolbox::JoinStrings(values, comparisonValues, ", ");
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	383
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	384 if (constraint.IsCaseSensitive())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	385 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	386 comparison = " AND value IN (" + values + ")";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	387 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	388 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	389 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	390 comparison = " AND lower(value) IN (" + values + ")";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	391 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	392
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	393 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	394 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	395
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	396 case ConstraintType_Wildcard:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	397 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	398 const std::string value = constraint.GetSingleValue();
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	399
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	400 if (value == "*")
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	401 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	402 if (!constraint.IsMandatory())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	403 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	404 // Universal constraint on an optional tag, ignore it
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	405 return false;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	406 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	407 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	408 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	409 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	410 std::string escaped;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	411 escaped.reserve(value.size());
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	412
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	413 for (size_t i = 0; i < value.size(); i++)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	414 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	415 if (value[i] == '*')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	416 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	417 escaped += "%";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	418 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	419 else if (value[i] == '?')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	420 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	421 escaped += "_";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	422 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	423 else if (value[i] == '%')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	424 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	425 escaped += "\\%";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	426 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	427 else if (value[i] == '_')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	428 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	429 escaped += "\\_";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	430 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	431 else if (value[i] == '\\')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	432 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	433 escaped += "\\\\";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	434 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	435 else if (escapeBrackets && value[i] == '[')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	436 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	437 escaped += "\\[";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	438 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	439 else if (escapeBrackets && value[i] == ']')
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	440 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	441 escaped += "\\]";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	442 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	443 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	444 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	445 escaped += value[i];
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	446 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	447 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	448
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	449 std::string parameter = formatter.GenerateParameter(escaped);
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	450
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	451 if (constraint.IsCaseSensitive())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	452 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	453 comparison = " AND value LIKE " + parameter + " " + formatter.FormatWildcardEscape();
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	454 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	455 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	456 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	457 comparison = " AND lower(value) LIKE lower(" + parameter + ") " + formatter.FormatWildcardEscape();
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	458 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	459 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	460
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	461 break;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	462 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	463
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	464 default:
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	465 return false;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	466 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	467
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	468 if (constraint.IsMandatory())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	469 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	470 target = tagFilter + comparison;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	471 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	472 else if (comparison.empty())
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	473 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	474 target = tagFilter + " AND value IS NULL";
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	475 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	476 else
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	477 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	478 target = tagFilter + " AND value IS NULL OR " + comparison;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	479 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	480
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	481 return true;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	482 }
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	483
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	484
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	485 void ISqlLookupFormatter::GetLookupLevels(ResourceType& lowerLevel,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	486 ResourceType& upperLevel,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	487 const ResourceType& queryLevel,
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	488 const DatabaseConstraints& lookup)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	489 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	490 assert(ResourceType_Patient < ResourceType_Study &&
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	491 ResourceType_Study < ResourceType_Series &&
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	492 ResourceType_Series < ResourceType_Instance);
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	493
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	494 lowerLevel = queryLevel;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	495 upperLevel = queryLevel;
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	496
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	497 for (size_t i = 0; i < lookup.GetSize(); i++)
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	498 {
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	499 ResourceType level = lookup.GetConstraint(i).GetLevel();
b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	500

547

b8e6e7a19424 un-sharing DatabaseConstraint and ISqlLookupFormatter with Orthanc core