orthanc: OrthancServer/Sources/Search/ISqlLookupFormatter.cpp annotate

annotate OrthancServer/Sources/Search/ISqlLookupFormatter.cpp @ 5798:ebd828518719 find-refactoring tip

merged default -> find-refactoring

author	Alain Mazy <am@orthanc.team>
date	Fri, 20 Sep 2024 08:20:55 +0200
parents	16ce3c920f71
children

rev	line source
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	1 /**
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	2 * Orthanc - A Lightweight, RESTful DICOM Store
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	3 * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	4 * Department, University Hospital of Liege, Belgium
5640 f7adfb22e20e updated copyright, as Orthanc Team now replaces Osimis Sebastien Jodogne <s.jodogne@gmail.com> parents: 5485 diff changeset	5 * Copyright (C) 2017-2023 Osimis S.A., Belgium
f7adfb22e20e updated copyright, as Orthanc Team now replaces Osimis Sebastien Jodogne <s.jodogne@gmail.com> parents: 5485 diff changeset	6 * Copyright (C) 2024-2024 Orthanc Team SRL, Belgium
5485 48b8dae6dc77 upgrade to year 2024 Sebastien Jodogne <s.jodogne@gmail.com> parents: 5477 diff changeset	7 * Copyright (C) 2021-2024 Sebastien Jodogne, ICTEAM UCLouvain, Belgium
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	8 *
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	9 * This program is free software: you can redistribute it and/or
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	10 * modify it under the terms of the GNU General Public License as
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	11 * published by the Free Software Foundation, either version 3 of the
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	12 * License, or (at your option) any later version.
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	13 *
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	14 * This program is distributed in the hope that it will be useful, but
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	15 * WITHOUT ANY WARRANTY; without even the implied warranty of
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	17 * General Public License for more details.
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	18 *
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	19 * You should have received a copy of the GNU General Public License
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	20 * along with this program. If not, see <http://www.gnu.org/licenses/>.
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	21 **/
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	22
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	23
5765 247fc5368693 un-sharing DatabaseConstraint and ISqlLookupFormatter with orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: 5762 diff changeset	24 #include "../PrecompiledHeadersServer.h"
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	25 #include "ISqlLookupFormatter.h"
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	26
5765 247fc5368693 un-sharing DatabaseConstraint and ISqlLookupFormatter with orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: 5762 diff changeset	27 #include "../../../OrthancFramework/Sources/OrthancException.h"
247fc5368693 un-sharing DatabaseConstraint and ISqlLookupFormatter with orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: 5762 diff changeset	28 #include "../../../OrthancFramework/Sources/Toolbox.h"
247fc5368693 un-sharing DatabaseConstraint and ISqlLookupFormatter with orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: 5762 diff changeset	29 #include "../Database/FindRequest.h"
3100 f6de9d25b20d removing build dependency on plugins Sebastien Jodogne <s.jodogne@gmail.com> parents: 3079 diff changeset	30 #include "DatabaseConstraint.h"
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	31
5477 78f68ad10b69 missing includes for assert() Alain Mazy <am@osimis.io> parents: 5460 diff changeset	32 #include <cassert>
4304 50b0c69b653a continued abi Sebastien Jodogne <s.jodogne@gmail.com> parents: 4096 diff changeset	33 #include <boost/lexical_cast.hpp>
5227 988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	34 #include <list>
4304 50b0c69b653a continued abi Sebastien Jodogne <s.jodogne@gmail.com> parents: 4096 diff changeset	35
50b0c69b653a continued abi Sebastien Jodogne <s.jodogne@gmail.com> parents: 4096 diff changeset	36
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	37 namespace Orthanc
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	38 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	39 static std::string FormatLevel(ResourceType level)
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	40 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	41 switch (level)
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	42 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	43 case ResourceType_Patient:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	44 return "patients";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	45
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	46 case ResourceType_Study:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	47 return "studies";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	48
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	49 case ResourceType_Series:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	50 return "series";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	51
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	52 case ResourceType_Instance:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	53 return "instances";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	54
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	55 default:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	56 throw OrthancException(ErrorCode_InternalError);
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	57 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	58 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	59
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	60
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	61 static bool FormatComparison(std::string& target,
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	62 ISqlLookupFormatter& formatter,
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	63 const DatabaseConstraint& constraint,
4817 b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	64 size_t index,
b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	65 bool escapeBrackets)
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	66 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	67 std::string tag = "t" + boost::lexical_cast<std::string>(index);
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	68
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	69 std::string comparison;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	70
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	71 switch (constraint.GetConstraintType())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	72 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	73 case ConstraintType_Equal:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	74 case ConstraintType_SmallerOrEqual:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	75 case ConstraintType_GreaterOrEqual:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	76 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	77 std::string op;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	78 switch (constraint.GetConstraintType())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	79 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	80 case ConstraintType_Equal:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	81 op = "=";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	82 break;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	83
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	84 case ConstraintType_SmallerOrEqual:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	85 op = "<=";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	86 break;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	87
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	88 case ConstraintType_GreaterOrEqual:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	89 op = ">=";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	90 break;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	91
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	92 default:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	93 throw OrthancException(ErrorCode_InternalError);
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	94 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	95
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	96 std::string parameter = formatter.GenerateParameter(constraint.GetSingleValue());
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	97
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	98 if (constraint.IsCaseSensitive())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	99 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	100 comparison = tag + ".value " + op + " " + parameter;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	101 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	102 else
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	103 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	104 comparison = "lower(" + tag + ".value) " + op + " lower(" + parameter + ")";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	105 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	106
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	107 break;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	108 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	109
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	110 case ConstraintType_List:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	111 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	112 for (size_t i = 0; i < constraint.GetValuesCount(); i++)
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	113 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	114 if (!comparison.empty())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	115 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	116 comparison += ", ";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	117 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	118
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	119 std::string parameter = formatter.GenerateParameter(constraint.GetValue(i));
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	120
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	121 if (constraint.IsCaseSensitive())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	122 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	123 comparison += parameter;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	124 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	125 else
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	126 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	127 comparison += "lower(" + parameter + ")";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	128 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	129 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	130
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	131 if (constraint.IsCaseSensitive())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	132 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	133 comparison = tag + ".value IN (" + comparison + ")";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	134 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	135 else
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	136 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	137 comparison = "lower(" + tag + ".value) IN (" + comparison + ")";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	138 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	139
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	140 break;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	141 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	142
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	143 case ConstraintType_Wildcard:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	144 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	145 const std::string value = constraint.GetSingleValue();
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	146
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	147 if (value == "*")
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	148 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	149 if (!constraint.IsMandatory())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	150 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	151 // Universal constraint on an optional tag, ignore it
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	152 return false;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	153 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	154 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	155 else
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	156 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	157 std::string escaped;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	158 escaped.reserve(value.size());
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	159
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	160 for (size_t i = 0; i < value.size(); i++)
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	161 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	162 if (value[i] == '*')
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	163 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	164 escaped += "%";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	165 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	166 else if (value[i] == '?')
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	167 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	168 escaped += "_";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	169 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	170 else if (value[i] == '%')
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	171 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	172 escaped += "\\%";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	173 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	174 else if (value[i] == '_')
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	175 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	176 escaped += "\\_";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	177 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	178 else if (value[i] == '\\')
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	179 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	180 escaped += "\\\\";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	181 }
4817 b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	182 else if (escapeBrackets && value[i] == '[')
b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	183 {
b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	184 escaped += "\\[";
b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	185 }
b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	186 else if (escapeBrackets && value[i] == ']')
b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	187 {
b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	188 escaped += "\\]";
b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	189 }
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	190 else
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	191 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	192 escaped += value[i];
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	193 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	194 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	195
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	196 std::string parameter = formatter.GenerateParameter(escaped);
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	197
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	198 if (constraint.IsCaseSensitive())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	199 {
3079 65e2bfa953ef ISqlLookupFormatter::FormatWildcardEscape() Sebastien Jodogne <s.jodogne@gmail.com> parents: 3078 diff changeset	200 comparison = (tag + ".value LIKE " + parameter + " " +
65e2bfa953ef ISqlLookupFormatter::FormatWildcardEscape() Sebastien Jodogne <s.jodogne@gmail.com> parents: 3078 diff changeset	201 formatter.FormatWildcardEscape());
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	202 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	203 else
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	204 {
3079 65e2bfa953ef ISqlLookupFormatter::FormatWildcardEscape() Sebastien Jodogne <s.jodogne@gmail.com> parents: 3078 diff changeset	205 comparison = ("lower(" + tag + ".value) LIKE lower(" +
65e2bfa953ef ISqlLookupFormatter::FormatWildcardEscape() Sebastien Jodogne <s.jodogne@gmail.com> parents: 3078 diff changeset	206 parameter + ") " + formatter.FormatWildcardEscape());
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	207 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	208 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	209
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	210 break;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	211 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	212
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	213 default:
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	214 return false;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	215 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	216
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	217 if (constraint.IsMandatory())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	218 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	219 target = comparison;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	220 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	221 else if (comparison.empty())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	222 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	223 target = tag + ".value IS NULL";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	224 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	225 else
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	226 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	227 target = tag + ".value IS NULL OR " + comparison;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	228 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	229
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	230 return true;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	231 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	232
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	233
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	234 static void FormatJoin(std::string& target,
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	235 const DatabaseConstraint& constraint,
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	236 size_t index)
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	237 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	238 std::string tag = "t" + boost::lexical_cast<std::string>(index);
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	239
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	240 if (constraint.IsMandatory())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	241 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	242 target = " INNER JOIN ";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	243 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	244 else
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	245 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	246 target = " LEFT JOIN ";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	247 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	248
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	249 if (constraint.IsIdentifier())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	250 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	251 target += "DicomIdentifiers ";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	252 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	253 else
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	254 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	255 target += "MainDicomTags ";
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	256 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	257
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	258 target += (tag + " ON " + tag + ".id = " + FormatLevel(constraint.GetLevel()) +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	259 ".internalId AND " + tag + ".tagGroup = " +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	260 boost::lexical_cast<std::string>(constraint.GetTag().GetGroup()) +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	261 " AND " + tag + ".tagElement = " +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	262 boost::lexical_cast<std::string>(constraint.GetTag().GetElement()));
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	263 }
5227 988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	264
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	265
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	266 static std::string Join(const std::list<std::string>& values,
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	267 const std::string& prefix,
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	268 const std::string& separator)
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	269 {
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	270 if (values.empty())
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	271 {
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	272 return "";
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	273 }
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	274 else
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	275 {
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	276 std::string s = prefix;
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	277
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	278 bool first = true;
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	279 for (std::list<std::string>::const_iterator it = values.begin(); it != values.end(); ++it)
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	280 {
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	281 if (first)
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	282 {
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	283 first = false;
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	284 }
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	285 else
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	286 {
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	287 s += separator;
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	288 }
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	289
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	290 s += *it;
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	291 }
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	292
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	293 return s;
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	294 }
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	295 }
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	296
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	297 static bool FormatComparison2(std::string& target,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	298 ISqlLookupFormatter& formatter,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	299 const DatabaseConstraint& constraint,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	300 bool escapeBrackets)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	301 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	302 std::string comparison;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	303 std::string tagFilter = ("tagGroup = " + boost::lexical_cast<std::string>(constraint.GetTag().GetGroup())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	304 + " AND tagElement = " + boost::lexical_cast<std::string>(constraint.GetTag().GetElement()));
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	305
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	306 switch (constraint.GetConstraintType())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	307 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	308 case ConstraintType_Equal:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	309 case ConstraintType_SmallerOrEqual:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	310 case ConstraintType_GreaterOrEqual:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	311 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	312 std::string op;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	313 switch (constraint.GetConstraintType())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	314 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	315 case ConstraintType_Equal:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	316 op = "=";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	317 break;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	318
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	319 case ConstraintType_SmallerOrEqual:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	320 op = "<=";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	321 break;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	322
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	323 case ConstraintType_GreaterOrEqual:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	324 op = ">=";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	325 break;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	326
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	327 default:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	328 throw OrthancException(ErrorCode_InternalError);
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	329 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	330
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	331 std::string parameter = formatter.GenerateParameter(constraint.GetSingleValue());
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	332
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	333 if (constraint.IsCaseSensitive())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	334 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	335 comparison = " AND value " + op + " " + parameter;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	336 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	337 else
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	338 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	339 comparison = " AND lower(value) " + op + " lower(" + parameter + ")";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	340 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	341
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	342 break;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	343 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	344
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	345 case ConstraintType_List:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	346 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	347 std::vector<std::string> comparisonValues;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	348 for (size_t i = 0; i < constraint.GetValuesCount(); i++)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	349 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	350 std::string parameter = formatter.GenerateParameter(constraint.GetValue(i));
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	351
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	352 if (constraint.IsCaseSensitive())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	353 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	354 comparisonValues.push_back(parameter);
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	355 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	356 else
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	357 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	358 comparisonValues.push_back("lower(" + parameter + ")");
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	359 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	360 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	361
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	362 std::string values;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	363 Toolbox::JoinStrings(values, comparisonValues, ", ");
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	364
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	365 if (constraint.IsCaseSensitive())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	366 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	367 comparison = " AND value IN (" + values + ")";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	368 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	369 else
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	370 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	371 comparison = " AND lower(value) IN (" + values + ")";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	372 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	373
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	374 break;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	375 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	376
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	377 case ConstraintType_Wildcard:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	378 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	379 const std::string value = constraint.GetSingleValue();
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	380
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	381 if (value == "*")
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	382 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	383 if (!constraint.IsMandatory())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	384 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	385 // Universal constraint on an optional tag, ignore it
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	386 return false;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	387 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	388 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	389 else
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	390 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	391 std::string escaped;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	392 escaped.reserve(value.size());
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	393
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	394 for (size_t i = 0; i < value.size(); i++)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	395 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	396 if (value[i] == '*')
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	397 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	398 escaped += "%";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	399 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	400 else if (value[i] == '?')
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	401 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	402 escaped += "_";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	403 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	404 else if (value[i] == '%')
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	405 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	406 escaped += "\\%";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	407 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	408 else if (value[i] == '_')
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	409 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	410 escaped += "\\_";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	411 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	412 else if (value[i] == '\\')
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	413 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	414 escaped += "\\\\";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	415 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	416 else if (escapeBrackets && value[i] == '[')
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	417 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	418 escaped += "\\[";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	419 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	420 else if (escapeBrackets && value[i] == ']')
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	421 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	422 escaped += "\\]";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	423 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	424 else
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	425 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	426 escaped += value[i];
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	427 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	428 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	429
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	430 std::string parameter = formatter.GenerateParameter(escaped);
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	431
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	432 if (constraint.IsCaseSensitive())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	433 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	434 comparison = " AND value LIKE " + parameter + " " + formatter.FormatWildcardEscape();
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	435 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	436 else
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	437 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	438 comparison = " AND lower(value) LIKE lower(" + parameter + ") " + formatter.FormatWildcardEscape();
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	439 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	440 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	441
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	442 break;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	443 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	444
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	445 default:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	446 return false;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	447 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	448
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	449 if (constraint.IsMandatory())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	450 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	451 target = tagFilter + comparison;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	452 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	453 else if (comparison.empty())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	454 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	455 target = tagFilter + " AND value IS NULL";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	456 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	457 else
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	458 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	459 target = tagFilter + " AND value IS NULL OR " + comparison;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	460 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	461
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	462 return true;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	463 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	464
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	465
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	466 void ISqlLookupFormatter::GetLookupLevels(ResourceType& lowerLevel,
68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	467 ResourceType& upperLevel,
68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	468 const ResourceType& queryLevel,
68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	469 const DatabaseConstraints& lookup)
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	470 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	471 assert(ResourceType_Patient < ResourceType_Study &&
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	472 ResourceType_Study < ResourceType_Series &&
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	473 ResourceType_Series < ResourceType_Instance);
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	474
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	475 lowerLevel = queryLevel;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	476 upperLevel = queryLevel;
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	477
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	478 for (size_t i = 0; i < lookup.GetSize(); i++)
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	479 {
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	480 ResourceType level = lookup.GetConstraint(i).GetLevel();
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	481
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	482 if (level < upperLevel)
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	483 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	484 upperLevel = level;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	485 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	486
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	487 if (level > lowerLevel)
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	488 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	489 lowerLevel = level;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	490 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	491 }
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	492 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	493
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	494
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	495 void ISqlLookupFormatter::Apply(std::string& sql,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	496 ISqlLookupFormatter& formatter,
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	497 const DatabaseConstraints& lookup,
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	498 ResourceType queryLevel,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	499 const std::set<std::string>& labels,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	500 LabelsConstraint labelsConstraint,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	501 size_t limit)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	502 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	503 ResourceType lowerLevel, upperLevel;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	504 GetLookupLevels(lowerLevel, upperLevel, queryLevel, lookup);
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	505
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	506 assert(upperLevel <= queryLevel &&
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	507 queryLevel <= lowerLevel);
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	508
4817 b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	509 const bool escapeBrackets = formatter.IsEscapeBrackets();
b8fcd331b4b3 added ISqlLookupFormatter::IsEscapeBrackets() Sebastien Jodogne <s.jodogne@gmail.com> parents: 4437 diff changeset	510
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	511 std::string joins, comparisons;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	512
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	513 size_t count = 0;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	514
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	515 for (size_t i = 0; i < lookup.GetSize(); i++)
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	516 {
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	517 const DatabaseConstraint& constraint = lookup.GetConstraint(i);
68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	518
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	519 std::string comparison;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	520
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	521 if (FormatComparison(comparison, formatter, constraint, count, escapeBrackets))
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	522 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	523 std::string join;
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	524 FormatJoin(join, constraint, count);
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	525 joins += join;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	526
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	527 if (!comparison.empty())
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	528 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	529 comparisons += " AND " + comparison;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	530 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	531
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	532 count ++;
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	533 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	534 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	535
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	536 sql = ("SELECT " +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	537 FormatLevel(queryLevel) + ".publicId, " +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	538 FormatLevel(queryLevel) + ".internalId" +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	539 " FROM Resources AS " + FormatLevel(queryLevel));
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	540
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	541 for (int level = queryLevel - 1; level >= upperLevel; level--)
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	542 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	543 sql += (" INNER JOIN Resources " +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	544 FormatLevel(static_cast<ResourceType>(level)) + " ON " +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	545 FormatLevel(static_cast<ResourceType>(level)) + ".internalId=" +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	546 FormatLevel(static_cast<ResourceType>(level + 1)) + ".parentId");
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	547 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	548
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	549 for (int level = queryLevel + 1; level <= lowerLevel; level++)
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	550 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	551 sql += (" INNER JOIN Resources " +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	552 FormatLevel(static_cast<ResourceType>(level)) + " ON " +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	553 FormatLevel(static_cast<ResourceType>(level - 1)) + ".internalId=" +
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	554 FormatLevel(static_cast<ResourceType>(level)) + ".parentId");
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	555 }
5227 988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	556
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	557 std::list<std::string> where;
5256 261ce0ed85e6 fix Sebastien Jodogne <s.jodogne@gmail.com> parents: 5248 diff changeset	558 where.push_back(FormatLevel(queryLevel) + ".resourceType = " +
261ce0ed85e6 fix Sebastien Jodogne <s.jodogne@gmail.com> parents: 5248 diff changeset	559 formatter.FormatResourceType(queryLevel) + comparisons);
5227 988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	560
5248 a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	561 if (!labels.empty())
5227 988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	562 {
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	563 /**
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	564 * "In SQL Server, NOT EXISTS and NOT IN predicates are the best
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	565 * way to search for missing values, as long as both columns in
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	566 * question are NOT NULL."
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	567 * https://explainextended.com/2009/09/15/not-in-vs-not-exists-vs-left-join-is-null-sql-server/
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	568 **/
5248 a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	569
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	570 std::list<std::string> formattedLabels;
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	571 for (std::set<std::string>::const_iterator it = labels.begin(); it != labels.end(); ++it)
5227 988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	572 {
5248 a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	573 formattedLabels.push_back(formatter.GenerateParameter(*it));
5227 988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	574 }
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	575
5248 a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	576 std::string condition;
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	577 switch (labelsConstraint)
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	578 {
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	579 case LabelsConstraint_Any:
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	580 condition = "> 0";
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	581 break;
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	582
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	583 case LabelsConstraint_All:
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	584 condition = "= " + boost::lexical_cast<std::string>(labels.size());
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	585 break;
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	586
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	587 case LabelsConstraint_None:
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	588 condition = "= 0";
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	589 break;
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	590
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	591 default:
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	592 throw OrthancException(ErrorCode_ParameterOutOfRange);
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	593 }
a7d95f951f8a replaced "WithLabels" and "WithoutLabels", by "Labels" and "LabelsConstraint" Sebastien Jodogne <s.jodogne@gmail.com> parents: 5227 diff changeset	594
5256 261ce0ed85e6 fix Sebastien Jodogne <s.jodogne@gmail.com> parents: 5248 diff changeset	595 where.push_back("(SELECT COUNT(1) FROM Labels AS selectedLabels WHERE selectedLabels.id = " + FormatLevel(queryLevel) +
261ce0ed85e6 fix Sebastien Jodogne <s.jodogne@gmail.com> parents: 5248 diff changeset	596 ".internalId AND selectedLabels.label IN (" + Join(formattedLabels, "", ", ") + ")) " + condition);
5227 988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	597 }
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	598
988dab8deb1c "/tools/find" accepts the "WithLabels" and "WithoutLabels" arguments Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	599 sql += joins + Join(where, " WHERE ", " AND ");
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	600
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	601 if (limit != 0)
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	602 {
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	603 sql += " LIMIT " + boost::lexical_cast<std::string>(limit);
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	604 }
6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	605 }
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	606
5765 247fc5368693 un-sharing DatabaseConstraint and ISqlLookupFormatter with orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: 5762 diff changeset	607
5748 4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	608 void ISqlLookupFormatter::Apply(std::string& sql,
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	609 ISqlLookupFormatter& formatter,
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	610 const FindRequest& request)
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	611 {
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	612 const bool escapeBrackets = formatter.IsEscapeBrackets();
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	613 ResourceType queryLevel = request.GetLevel();
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	614 const std::string& strQueryLevel = FormatLevel(queryLevel);
5750 f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	615
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	616 ResourceType lowerLevel, upperLevel;
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	617 GetLookupLevels(lowerLevel, upperLevel, queryLevel, request.GetDicomTagConstraints());
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	618
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	619 assert(upperLevel <= queryLevel &&
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	620 queryLevel <= lowerLevel);
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	621
5796 16ce3c920f71 rewrote SQLite find using CTEs instead of temporary tables Alain Mazy <am@orthanc.team> parents: 5765 diff changeset	622 std::string ordering = "row_number() over (order by " + strQueryLevel + ".publicId) as rowNumber"; // we need a default ordering in order to make default queries repeatable when using since&limit
16ce3c920f71 rewrote SQLite find using CTEs instead of temporary tables Alain Mazy <am@orthanc.team> parents: 5765 diff changeset	623
5750 f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	624
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	625 sql = ("SELECT " +
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	626 strQueryLevel + ".publicId, " +
5796 16ce3c920f71 rewrote SQLite find using CTEs instead of temporary tables Alain Mazy <am@orthanc.team> parents: 5765 diff changeset	627 strQueryLevel + ".internalId, " +
16ce3c920f71 rewrote SQLite find using CTEs instead of temporary tables Alain Mazy <am@orthanc.team> parents: 5765 diff changeset	628 ordering +
5750 f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	629 " FROM Resources AS " + strQueryLevel);
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	630
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	631
5748 4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	632 std::string joins, comparisons;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	633
5750 f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	634 if (request.GetOrthancIdentifiers().IsDefined() && request.GetOrthancIdentifiers().DetectLevel() <= queryLevel)
5748 4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	635 {
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	636 // single child resource matching, there should not be other constraints (at least for now)
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	637 assert(request.GetDicomTagConstraints().GetSize() == 0);
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	638 assert(request.GetLabels().size() == 0);
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	639 assert(request.HasLimits() == false);
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	640
5750 f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	641 ResourceType topParentLevel = request.GetOrthancIdentifiers().DetectLevel();
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	642 const std::string& strTopParentLevel = FormatLevel(topParentLevel);
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	643
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	644 comparisons = " AND " + strTopParentLevel + ".publicId = " + formatter.GenerateParameter(request.GetOrthancIdentifiers().GetLevel(topParentLevel));
5748 4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	645
5750 f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	646 for (int level = queryLevel; level > topParentLevel; level--)
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	647 {
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	648 sql += (" INNER JOIN Resources " +
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	649 FormatLevel(static_cast<ResourceType>(level - 1)) + " ON " +
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	650 FormatLevel(static_cast<ResourceType>(level - 1)) + ".internalId=" +
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	651 FormatLevel(static_cast<ResourceType>(level)) + ".parentId");
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	652 }
5748 4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	653 }
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	654 else
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	655 {
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	656 size_t count = 0;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	657
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	658 const DatabaseConstraints& dicomTagsConstraints = request.GetDicomTagConstraints();
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	659 for (size_t i = 0; i < dicomTagsConstraints.GetSize(); i++)
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	660 {
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	661 const DatabaseConstraint& constraint = dicomTagsConstraints.GetConstraint(i);
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	662
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	663 std::string comparison;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	664
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	665 if (FormatComparison(comparison, formatter, constraint, count, escapeBrackets))
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	666 {
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	667 std::string join;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	668 FormatJoin(join, constraint, count);
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	669 joins += join;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	670
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	671 if (!comparison.empty())
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	672 {
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	673 comparisons += " AND " + comparison;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	674 }
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	675
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	676 count ++;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	677 }
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	678 }
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	679 }
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	680
5750 f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	681 for (int level = queryLevel - 1; level >= upperLevel; level--)
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	682 {
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	683 sql += (" INNER JOIN Resources " +
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	684 FormatLevel(static_cast<ResourceType>(level)) + " ON " +
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	685 FormatLevel(static_cast<ResourceType>(level)) + ".internalId=" +
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	686 FormatLevel(static_cast<ResourceType>(level + 1)) + ".parentId");
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	687 }
5748 4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	688
5750 f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	689 for (int level = queryLevel + 1; level <= lowerLevel; level++)
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	690 {
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	691 sql += (" INNER JOIN Resources " +
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	692 FormatLevel(static_cast<ResourceType>(level)) + " ON " +
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	693 FormatLevel(static_cast<ResourceType>(level - 1)) + ".internalId=" +
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	694 FormatLevel(static_cast<ResourceType>(level)) + ".parentId");
f39406a9eda4 ExtendedFind in SQLite continued (6 tests still failing) Alain Mazy <am@orthanc.team> parents: 5748 diff changeset	695 }
5748 4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	696
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	697 std::list<std::string> where;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	698 where.push_back(strQueryLevel + ".resourceType = " +
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	699 formatter.FormatResourceType(queryLevel) + comparisons);
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	700
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	701
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	702 if (!request.GetLabels().empty())
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	703 {
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	704 /**
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	705 * "In SQL Server, NOT EXISTS and NOT IN predicates are the best
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	706 * way to search for missing values, as long as both columns in
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	707 * question are NOT NULL."
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	708 * https://explainextended.com/2009/09/15/not-in-vs-not-exists-vs-left-join-is-null-sql-server/
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	709 **/
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	710
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	711 const std::set<std::string>& labels = request.GetLabels();
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	712 std::list<std::string> formattedLabels;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	713 for (std::set<std::string>::const_iterator it = labels.begin(); it != labels.end(); ++it)
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	714 {
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	715 formattedLabels.push_back(formatter.GenerateParameter(*it));
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	716 }
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	717
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	718 std::string condition;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	719 switch (request.GetLabelsConstraint())
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	720 {
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	721 case LabelsConstraint_Any:
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	722 condition = "> 0";
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	723 break;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	724
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	725 case LabelsConstraint_All:
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	726 condition = "= " + boost::lexical_cast<std::string>(labels.size());
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	727 break;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	728
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	729 case LabelsConstraint_None:
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	730 condition = "= 0";
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	731 break;
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	732
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	733 default:
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	734 throw OrthancException(ErrorCode_ParameterOutOfRange);
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	735 }
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	736
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	737 where.push_back("(SELECT COUNT(1) FROM Labels AS selectedLabels WHERE selectedLabels.id = " + strQueryLevel +
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	738 ".internalId AND selectedLabels.label IN (" + Join(formattedLabels, "", ", ") + ")) " + condition);
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	739 }
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	740
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	741 sql += joins + Join(where, " WHERE ", " AND ");
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	742
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	743 if (request.HasLimits())
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	744 {
5762 d52b3f394f69 FormatLimits (SQLServer needs custom code) Alain Mazy <am@orthanc.team> parents: 5752 diff changeset	745 sql += formatter.FormatLimits(request.GetLimitsSince(), request.GetLimitsCount());
5748 4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	746 }
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	747 }
4bc650d88463 WIP: started to implement IntegratedFind in SQLite Alain Mazy <am@orthanc.team> parents: 5680 diff changeset	748
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	749
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	750 void ISqlLookupFormatter::ApplySingleLevel(std::string& sql,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	751 ISqlLookupFormatter& formatter,
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	752 const DatabaseConstraints& lookup,
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	753 ResourceType queryLevel,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	754 const std::set<std::string>& labels,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	755 LabelsConstraint labelsConstraint,
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	756 size_t limit
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	757 )
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	758 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	759 ResourceType lowerLevel, upperLevel;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	760 GetLookupLevels(lowerLevel, upperLevel, queryLevel, lookup);
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	761
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	762 assert(upperLevel == queryLevel &&
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	763 queryLevel == lowerLevel);
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	764
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	765 const bool escapeBrackets = formatter.IsEscapeBrackets();
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	766
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	767 std::vector<std::string> mainDicomTagsComparisons, dicomIdentifiersComparisons;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	768
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	769 for (size_t i = 0; i < lookup.GetSize(); i++)
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	770 {
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	771 const DatabaseConstraint& constraint = lookup.GetConstraint(i);
68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	772
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	773 std::string comparison;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	774
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	775 if (FormatComparison2(comparison, formatter, constraint, escapeBrackets))
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	776 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	777 if (!comparison.empty())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	778 {
5680 68fc5af30c03 added container class DatabaseConstraints Sebastien Jodogne <s.jodogne@gmail.com> parents: 5640 diff changeset	779 if (constraint.IsIdentifier())
5422 7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	780 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	781 dicomIdentifiersComparisons.push_back(comparison);
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	782 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	783 else
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	784 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	785 mainDicomTagsComparisons.push_back(comparison);
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	786 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	787 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	788 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	789 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	790
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	791 sql = ("SELECT publicId, internalId "
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	792 "FROM Resources "
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	793 "WHERE resourceType = " + formatter.FormatResourceType(queryLevel)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	794 + " ");
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	795
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	796 if (dicomIdentifiersComparisons.size() > 0)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	797 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	798 for (std::vector<std::string>::const_iterator it = dicomIdentifiersComparisons.begin(); it < dicomIdentifiersComparisons.end(); ++it)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	799 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	800 sql += (" AND internalId IN (SELECT id FROM DicomIdentifiers WHERE " + *it + ") ");
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	801 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	802 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	803
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	804 if (mainDicomTagsComparisons.size() > 0)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	805 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	806 for (std::vector<std::string>::const_iterator it = mainDicomTagsComparisons.begin(); it < mainDicomTagsComparisons.end(); ++it)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	807 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	808 sql += (" AND internalId IN (SELECT id FROM MainDicomTags WHERE " + *it + ") ");
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	809 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	810 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	811
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	812 if (!labels.empty())
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	813 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	814 /**
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	815 * "In SQL Server, NOT EXISTS and NOT IN predicates are the best
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	816 * way to search for missing values, as long as both columns in
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	817 * question are NOT NULL."
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	818 * https://explainextended.com/2009/09/15/not-in-vs-not-exists-vs-left-join-is-null-sql-server/
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	819 **/
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	820
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	821 std::list<std::string> formattedLabels;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	822 for (std::set<std::string>::const_iterator it = labels.begin(); it != labels.end(); ++it)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	823 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	824 formattedLabels.push_back(formatter.GenerateParameter(*it));
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	825 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	826
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	827 std::string condition;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	828 std::string inOrNotIn;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	829 switch (labelsConstraint)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	830 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	831 case LabelsConstraint_Any:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	832 condition = "> 0";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	833 inOrNotIn = "IN";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	834 break;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	835
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	836 case LabelsConstraint_All:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	837 condition = "= " + boost::lexical_cast<std::string>(labels.size());
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	838 inOrNotIn = "IN";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	839 break;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	840
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	841 case LabelsConstraint_None:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	842 condition = "> 0";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	843 inOrNotIn = "NOT IN";
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	844 break;
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	845
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	846 default:
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	847 throw OrthancException(ErrorCode_ParameterOutOfRange);
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	848 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	849
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	850 sql += (" AND internalId " + inOrNotIn + " (SELECT id"
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	851 " FROM (SELECT id, COUNT(1) AS labelsCount "
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	852 "FROM Labels "
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	853 "WHERE label IN (" + Join(formattedLabels, "", ", ") + ") GROUP BY id"
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	854 ") AS temp "
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	855 " WHERE labelsCount " + condition + ")");
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	856 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	857
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	858 if (limit != 0)
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	859 {
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	860 sql += " LIMIT " + boost::lexical_cast<std::string>(limit);
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	861 }
7f37233359aa sync code from DB plugins Alain Mazy <am@osimis.io> parents: 5256 diff changeset	862 }
3058 6faf575ba9cc refactoring: class ISqlLookupFormatter to be used in orthanc-databases Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	863 }

Mercurial > hg > orthanc

annotate OrthancServer/Sources/Search/ISqlLookupFormatter.cpp @ 5798:ebd828518719 find-refactoring tip