orthanc: OrthancServer/Resources/Graveyard/DatabasePluginSample/DatabaseWrapperBase.cpp annotate

annotate OrthancServer/Resources/Graveyard/DatabasePluginSample/DatabaseWrapperBase.cpp @ 5594:a906dc19264c find-refactoring

created FindResponse::Resource::Format()

author	Sebastien Jodogne <s.jodogne@gmail.com>
date	Sat, 04 May 2024 15:25:19 +0200
parents	48b8dae6dc77
children	f7adfb22e20e

rev	line source
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	1 /**
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	2 * Orthanc - A Lightweight, RESTful DICOM Store
1900 b1291df2f780 2016 Sebastien Jodogne <s.jodogne@gmail.com> parents: 1761 diff changeset	3 * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	4 * Department, University Hospital of Liege, Belgium
5485 48b8dae6dc77 upgrade to year 2024 Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	5 * Copyright (C) 2017-2024 Osimis S.A., Belgium
48b8dae6dc77 upgrade to year 2024 Sebastien Jodogne <s.jodogne@gmail.com> parents: 5185 diff changeset	6 * Copyright (C) 2021-2024 Sebastien Jodogne, ICTEAM UCLouvain, Belgium
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	7 *
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	8 * This program is free software: you can redistribute it and/or
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	9 * modify it under the terms of the GNU General Public License as
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	10 * published by the Free Software Foundation, either version 3 of the
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	11 * License, or (at your option) any later version.
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	12 *
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	13 * This program is distributed in the hope that it will be useful, but
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	14 * WITHOUT ANY WARRANTY; without even the implied warranty of
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	15 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	16 * General Public License for more details.
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	17 *
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	18 * You should have received a copy of the GNU General Public License
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	19 * along with this program. If not, see <http://www.gnu.org/licenses/>.
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	20 **/
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	21
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	22
4050 cd363608551a fix paths Sebastien Jodogne <s.jodogne@gmail.com> parents: 4044 diff changeset	23 #include "../../../Sources/PrecompiledHeadersServer.h"
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	24 #include "DatabaseWrapperBase.h"
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	25
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	26 #include <stdio.h>
1746 d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	27 #include <memory>
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	28
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	29 namespace Orthanc
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	30 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	31 void DatabaseWrapperBase::SetGlobalProperty(GlobalProperty property,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	32 const std::string& value)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	33 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	34 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT OR REPLACE INTO GlobalProperties VALUES(?, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	35 s.BindInt(0, property);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	36 s.BindString(1, value);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	37 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	38 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	39
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	40 bool DatabaseWrapperBase::LookupGlobalProperty(std::string& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	41 GlobalProperty property)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	42 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	43 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	44 "SELECT value FROM GlobalProperties WHERE property=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	45 s.BindInt(0, property);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	46
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	47 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	48 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	49 return false;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	50 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	51 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	52 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	53 target = s.ColumnString(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	54 return true;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	55 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	56 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	57
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	58 int64_t DatabaseWrapperBase::CreateResource(const std::string& publicId,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	59 ResourceType type)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	60 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	61 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO Resources VALUES(NULL, ?, ?, NULL)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	62 s.BindInt(0, type);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	63 s.BindString(1, publicId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	64 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	65 return db_.GetLastInsertRowId();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	66 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	67
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	68 bool DatabaseWrapperBase::LookupResource(int64_t& id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	69 ResourceType& type,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	70 const std::string& publicId)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	71 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	72 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	73 "SELECT internalId, resourceType FROM Resources WHERE publicId=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	74 s.BindString(0, publicId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	75
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	76 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	77 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	78 return false;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	79 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	80 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	81 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	82 id = s.ColumnInt(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	83 type = static_cast<ResourceType>(s.ColumnInt(1));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	84
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	85 // Check whether there is a single resource with this public id
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	86 assert(!s.Step());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	87
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	88 return true;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	89 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	90 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	91
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	92 ErrorCode DatabaseWrapperBase::LookupParent(bool& found,
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	93 int64_t& parentId,
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	94 int64_t resourceId)
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	95 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	96 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	97 "SELECT parentId FROM Resources WHERE internalId=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	98 s.BindInt64(0, resourceId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	99
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	100 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	101 {
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	102 return ErrorCode_UnknownResource;
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	103 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	104
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	105 if (s.ColumnIsNull(0))
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	106 {
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	107 found = false;
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	108 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	109 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	110 {
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	111 found = true;
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	112 parentId = s.ColumnInt(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	113 }
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	114
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	115 return ErrorCode_Success;
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	116 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	117
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	118 bool DatabaseWrapperBase::GetPublicId(std::string& result,
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	119 int64_t resourceId)
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	120 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	121 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	122 "SELECT publicId FROM Resources WHERE internalId=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	123 s.BindInt64(0, resourceId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	124
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	125 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	126 {
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	127 return false;
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	128 }
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	129 else
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	130 {
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	131 result = s.ColumnString(0);
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	132 return true;
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	133 }
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	134 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	135
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	136
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	137 ErrorCode DatabaseWrapperBase::GetResourceType(ResourceType& result,
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	138 int64_t resourceId)
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	139 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	140 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	141 "SELECT resourceType FROM Resources WHERE internalId=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	142 s.BindInt64(0, resourceId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	143
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	144 if (s.Step())
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	145 {
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	146 result = static_cast<ResourceType>(s.ColumnInt(0));
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	147 return ErrorCode_Success;
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	148 }
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	149 else
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	150 {
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	151 return ErrorCode_UnknownResource;
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	152 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	153 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	154
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	155
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	156 void DatabaseWrapperBase::AttachChild(int64_t parent,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	157 int64_t child)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	158 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	159 SQLite::Statement s(db_, SQLITE_FROM_HERE, "UPDATE Resources SET parentId = ? WHERE internalId = ?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	160 s.BindInt64(0, parent);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	161 s.BindInt64(1, child);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	162 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	163 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	164
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	165
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	166 void DatabaseWrapperBase::SetMetadata(int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	167 MetadataType type,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	168 const std::string& value)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	169 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	170 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT OR REPLACE INTO Metadata VALUES(?, ?, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	171 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	172 s.BindInt(1, type);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	173 s.BindString(2, value);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	174 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	175 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	176
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	177 void DatabaseWrapperBase::DeleteMetadata(int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	178 MetadataType type)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	179 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	180 SQLite::Statement s(db_, SQLITE_FROM_HERE, "DELETE FROM Metadata WHERE id=? and type=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	181 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	182 s.BindInt(1, type);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	183 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	184 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	185
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	186 bool DatabaseWrapperBase::LookupMetadata(std::string& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	187 int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	188 MetadataType type)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	189 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	190 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	191 "SELECT value FROM Metadata WHERE id=? AND type=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	192 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	193 s.BindInt(1, type);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	194
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	195 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	196 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	197 return false;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	198 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	199 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	200 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	201 target = s.ColumnString(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	202 return true;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	203 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	204 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	205
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	206 void DatabaseWrapperBase::ListAvailableMetadata(std::list<MetadataType>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	207 int64_t id)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	208 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	209 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	210
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	211 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT type FROM Metadata WHERE id=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	212 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	213
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	214 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	215 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	216 target.push_back(static_cast<MetadataType>(s.ColumnInt(0)));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	217 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	218 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	219
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	220
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	221 void DatabaseWrapperBase::AddAttachment(int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	222 const FileInfo& attachment)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	223 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	224 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO AttachedFiles VALUES(?, ?, ?, ?, ?, ?, ?, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	225 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	226 s.BindInt(1, attachment.GetContentType());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	227 s.BindString(2, attachment.GetUuid());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	228 s.BindInt64(3, attachment.GetCompressedSize());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	229 s.BindInt64(4, attachment.GetUncompressedSize());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	230 s.BindInt(5, attachment.GetCompressionType());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	231 s.BindString(6, attachment.GetUncompressedMD5());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	232 s.BindString(7, attachment.GetCompressedMD5());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	233 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	234 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	235
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	236
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	237 void DatabaseWrapperBase::DeleteAttachment(int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	238 FileContentType attachment)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	239 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	240 SQLite::Statement s(db_, SQLITE_FROM_HERE, "DELETE FROM AttachedFiles WHERE id=? AND fileType=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	241 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	242 s.BindInt(1, attachment);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	243 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	244 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	245
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	246
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	247
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	248 void DatabaseWrapperBase::ListAvailableAttachments(std::list<FileContentType>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	249 int64_t id)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	250 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	251 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	252
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	253 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	254 "SELECT fileType FROM AttachedFiles WHERE id=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	255 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	256
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	257 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	258 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	259 target.push_back(static_cast<FileContentType>(s.ColumnInt(0)));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	260 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	261 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	262
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	263 bool DatabaseWrapperBase::LookupAttachment(FileInfo& attachment,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	264 int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	265 FileContentType contentType)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	266 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	267 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	268 "SELECT uuid, uncompressedSize, compressionType, compressedSize, uncompressedMD5, compressedMD5 FROM AttachedFiles WHERE id=? AND fileType=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	269 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	270 s.BindInt(1, contentType);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	271
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	272 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	273 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	274 return false;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	275 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	276 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	277 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	278 attachment = FileInfo(s.ColumnString(0),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	279 contentType,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	280 s.ColumnInt64(1),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	281 s.ColumnString(4),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	282 static_cast<CompressionType>(s.ColumnInt(2)),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	283 s.ColumnInt64(3),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	284 s.ColumnString(5));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	285 return true;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	286 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	287 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	288
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	289
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	290 void DatabaseWrapperBase::ClearMainDicomTags(int64_t id)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	291 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	292 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	293 SQLite::Statement s(db_, SQLITE_FROM_HERE, "DELETE FROM DicomIdentifiers WHERE id=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	294 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	295 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	296 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	297
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	298 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	299 SQLite::Statement s(db_, SQLITE_FROM_HERE, "DELETE FROM MainDicomTags WHERE id=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	300 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	301 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	302 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	303 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	304
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	305
1715 c3baf74e443f simplify Sebastien Jodogne <s.jodogne@gmail.com> parents: 1713 diff changeset	306 void DatabaseWrapperBase::SetMainDicomTag(int64_t id,
c3baf74e443f simplify Sebastien Jodogne <s.jodogne@gmail.com> parents: 1713 diff changeset	307 const DicomTag& tag,
c3baf74e443f simplify Sebastien Jodogne <s.jodogne@gmail.com> parents: 1713 diff changeset	308 const std::string& value)
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	309 {
1715 c3baf74e443f simplify Sebastien Jodogne <s.jodogne@gmail.com> parents: 1713 diff changeset	310 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO MainDicomTags VALUES(?, ?, ?, ?)");
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	311 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	312 s.BindInt(1, tag.GetGroup());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	313 s.BindInt(2, tag.GetElement());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	314 s.BindString(3, value);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	315 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	316 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	317
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	318
1713 4db9200c7f46 SetIdentifierTag Sebastien Jodogne <s.jodogne@gmail.com> parents: 1711 diff changeset	319 void DatabaseWrapperBase::SetIdentifierTag(int64_t id,
4db9200c7f46 SetIdentifierTag Sebastien Jodogne <s.jodogne@gmail.com> parents: 1711 diff changeset	320 const DicomTag& tag,
4db9200c7f46 SetIdentifierTag Sebastien Jodogne <s.jodogne@gmail.com> parents: 1711 diff changeset	321 const std::string& value)
4db9200c7f46 SetIdentifierTag Sebastien Jodogne <s.jodogne@gmail.com> parents: 1711 diff changeset	322 {
4db9200c7f46 SetIdentifierTag Sebastien Jodogne <s.jodogne@gmail.com> parents: 1711 diff changeset	323 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO DicomIdentifiers VALUES(?, ?, ?, ?)");
1715 c3baf74e443f simplify Sebastien Jodogne <s.jodogne@gmail.com> parents: 1713 diff changeset	324 s.BindInt64(0, id);
c3baf74e443f simplify Sebastien Jodogne <s.jodogne@gmail.com> parents: 1713 diff changeset	325 s.BindInt(1, tag.GetGroup());
c3baf74e443f simplify Sebastien Jodogne <s.jodogne@gmail.com> parents: 1713 diff changeset	326 s.BindInt(2, tag.GetElement());
c3baf74e443f simplify Sebastien Jodogne <s.jodogne@gmail.com> parents: 1713 diff changeset	327 s.BindString(3, value);
c3baf74e443f simplify Sebastien Jodogne <s.jodogne@gmail.com> parents: 1713 diff changeset	328 s.Run();
1713 4db9200c7f46 SetIdentifierTag Sebastien Jodogne <s.jodogne@gmail.com> parents: 1711 diff changeset	329 }
4db9200c7f46 SetIdentifierTag Sebastien Jodogne <s.jodogne@gmail.com> parents: 1711 diff changeset	330
4db9200c7f46 SetIdentifierTag Sebastien Jodogne <s.jodogne@gmail.com> parents: 1711 diff changeset	331
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	332 void DatabaseWrapperBase::GetMainDicomTags(DicomMap& map,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	333 int64_t id)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	334 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	335 map.Clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	336
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	337 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT * FROM MainDicomTags WHERE id=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	338 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	339 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	340 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	341 map.SetValue(s.ColumnInt(1),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	342 s.ColumnInt(2),
2007 655489d9165d DicomMap::ParseDicomMetaInformation() Sebastien Jodogne <s.jodogne@gmail.com> parents: 1900 diff changeset	343 s.ColumnString(3), false);
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	344 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	345 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	346
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	347
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	348
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	349 void DatabaseWrapperBase::GetChildrenPublicId(std::list<std::string>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	350 int64_t id)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	351 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	352 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT a.publicId FROM Resources AS a, Resources AS b "
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	353 "WHERE a.parentId = b.internalId AND b.internalId = ?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	354 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	355
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	356 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	357
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	358 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	359 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	360 target.push_back(s.ColumnString(0));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	361 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	362 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	363
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	364
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	365 void DatabaseWrapperBase::GetChildrenInternalId(std::list<int64_t>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	366 int64_t id)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	367 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	368 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT a.internalId FROM Resources AS a, Resources AS b "
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	369 "WHERE a.parentId = b.internalId AND b.internalId = ?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	370 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	371
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	372 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	373
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	374 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	375 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	376 target.push_back(s.ColumnInt64(0));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	377 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	378 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	379
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	380
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	381 void DatabaseWrapperBase::LogChange(int64_t internalId,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	382 const ServerIndexChange& change)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	383 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	384 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO Changes VALUES(NULL, ?, ?, ?, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	385 s.BindInt(0, change.GetChangeType());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	386 s.BindInt64(1, internalId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	387 s.BindInt(2, change.GetResourceType());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	388 s.BindString(3, change.GetDate());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	389 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	390 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	391
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	392
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	393 ErrorCode DatabaseWrapperBase::GetChangesInternal(std::list<ServerIndexChange>& target,
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	394 bool& done,
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	395 SQLite::Statement& s,
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	396 uint32_t maxResults)
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	397 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	398 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	399
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	400 while (target.size() < maxResults && s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	401 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	402 int64_t seq = s.ColumnInt64(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	403 ChangeType changeType = static_cast<ChangeType>(s.ColumnInt(1));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	404 ResourceType resourceType = static_cast<ResourceType>(s.ColumnInt(3));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	405 const std::string& date = s.ColumnString(4);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	406
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	407 int64_t internalId = s.ColumnInt64(2);
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	408 std::string publicId;
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	409 if (!GetPublicId(publicId, internalId))
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	410 {
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	411 return ErrorCode_UnknownResource;
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	412 }
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	413
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	414 target.push_back(ServerIndexChange(seq, changeType, resourceType, publicId, date));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	415 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	416
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	417 done = !(target.size() == maxResults && s.Step());
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	418 return ErrorCode_Success;
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	419 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	420
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	421
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	422 ErrorCode DatabaseWrapperBase::GetChanges(std::list<ServerIndexChange>& target,
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	423 bool& done,
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	424 int64_t since,
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	425 uint32_t maxResults)
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	426 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	427 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT * FROM Changes WHERE seq>? ORDER BY seq LIMIT ?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	428 s.BindInt64(0, since);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	429 s.BindInt(1, maxResults + 1);
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	430 return GetChangesInternal(target, done, s, maxResults);
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	431 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	432
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	433 ErrorCode DatabaseWrapperBase::GetLastChange(std::list<ServerIndexChange>& target)
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	434 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	435 bool done; // Ignored
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	436 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT * FROM Changes ORDER BY seq DESC LIMIT 1");
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	437 return GetChangesInternal(target, done, s, 1);
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	438 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	439
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	440
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	441 void DatabaseWrapperBase::LogExportedResource(const ExportedResource& resource)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	442 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	443 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	444 "INSERT INTO ExportedResources VALUES(NULL, ?, ?, ?, ?, ?, ?, ?, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	445
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	446 s.BindInt(0, resource.GetResourceType());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	447 s.BindString(1, resource.GetPublicId());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	448 s.BindString(2, resource.GetModality());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	449 s.BindString(3, resource.GetPatientId());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	450 s.BindString(4, resource.GetStudyInstanceUid());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	451 s.BindString(5, resource.GetSeriesInstanceUid());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	452 s.BindString(6, resource.GetSopInstanceUid());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	453 s.BindString(7, resource.GetDate());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	454 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	455 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	456
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	457
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	458 void DatabaseWrapperBase::GetExportedResourcesInternal(std::list<ExportedResource>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	459 bool& done,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	460 SQLite::Statement& s,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	461 uint32_t maxResults)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	462 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	463 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	464
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	465 while (target.size() < maxResults && s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	466 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	467 int64_t seq = s.ColumnInt64(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	468 ResourceType resourceType = static_cast<ResourceType>(s.ColumnInt(1));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	469 std::string publicId = s.ColumnString(2);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	470
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	471 ExportedResource resource(seq,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	472 resourceType,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	473 publicId,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	474 s.ColumnString(3), // modality
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	475 s.ColumnString(8), // date
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	476 s.ColumnString(4), // patient ID
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	477 s.ColumnString(5), // study instance UID
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	478 s.ColumnString(6), // series instance UID
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	479 s.ColumnString(7)); // sop instance UID
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	480
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	481 target.push_back(resource);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	482 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	483
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	484 done = !(target.size() == maxResults && s.Step());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	485 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	486
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	487
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	488 void DatabaseWrapperBase::GetExportedResources(std::list<ExportedResource>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	489 bool& done,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	490 int64_t since,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	491 uint32_t maxResults)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	492 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	493 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	494 "SELECT * FROM ExportedResources WHERE seq>? ORDER BY seq LIMIT ?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	495 s.BindInt64(0, since);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	496 s.BindInt(1, maxResults + 1);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	497 GetExportedResourcesInternal(target, done, s, maxResults);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	498 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	499
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	500
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	501 void DatabaseWrapperBase::GetLastExportedResource(std::list<ExportedResource>& target)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	502 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	503 bool done; // Ignored
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	504 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	505 "SELECT * FROM ExportedResources ORDER BY seq DESC LIMIT 1");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	506 GetExportedResourcesInternal(target, done, s, 1);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	507 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	508
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	509
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	510
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	511 uint64_t DatabaseWrapperBase::GetTotalCompressedSize()
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	512 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	513 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT SUM(compressedSize) FROM AttachedFiles");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	514 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	515 return static_cast<uint64_t>(s.ColumnInt64(0));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	516 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	517
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	518
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	519 uint64_t DatabaseWrapperBase::GetTotalUncompressedSize()
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	520 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	521 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT SUM(uncompressedSize) FROM AttachedFiles");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	522 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	523 return static_cast<uint64_t>(s.ColumnInt64(0));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	524 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	525
1750 55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	526 void DatabaseWrapperBase::GetAllInternalIds(std::list<int64_t>& target,
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	527 ResourceType resourceType)
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	528 {
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	529 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT internalId FROM Resources WHERE resourceType=?");
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	530 s.BindInt(0, resourceType);
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	531
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	532 target.clear();
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	533 while (s.Step())
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	534 {
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	535 target.push_back(s.ColumnInt64(0));
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	536 }
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	537 }
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	538
55d52567bebb LookupResource implemented Sebastien Jodogne <s.jodogne@gmail.com> parents: 1746 diff changeset	539
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	540 void DatabaseWrapperBase::GetAllPublicIds(std::list<std::string>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	541 ResourceType resourceType)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	542 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	543 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT publicId FROM Resources WHERE resourceType=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	544 s.BindInt(0, resourceType);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	545
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	546 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	547 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	548 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	549 target.push_back(s.ColumnString(0));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	550 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	551 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	552
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	553 void DatabaseWrapperBase::GetAllPublicIds(std::list<std::string>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	554 ResourceType resourceType,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	555 size_t since,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	556 size_t limit)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	557 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	558 if (limit == 0)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	559 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	560 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	561 return;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	562 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	563
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	564 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT publicId FROM Resources WHERE resourceType=? LIMIT ? OFFSET ?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	565 s.BindInt(0, resourceType);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	566 s.BindInt64(1, limit);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	567 s.BindInt64(2, since);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	568
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	569 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	570 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	571 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	572 target.push_back(s.ColumnString(0));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	573 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	574 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	575
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	576
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	577 uint64_t DatabaseWrapperBase::GetResourceCount(ResourceType resourceType)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	578 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	579 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	580 "SELECT COUNT(*) FROM Resources WHERE resourceType=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	581 s.BindInt(0, resourceType);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	582
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	583 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	584 {
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	585 return 0;
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	586 }
1671 2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	587 else
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	588 {
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	589 int64_t c = s.ColumnInt(0);
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	590 assert(!s.Step());
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	591 return c;
2f2e2ec17bc4 sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1670 diff changeset	592 }
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	593 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	594
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	595
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	596 bool DatabaseWrapperBase::SelectPatientToRecycle(int64_t& internalId)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	597 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	598 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	599 "SELECT patientId FROM PatientRecyclingOrder ORDER BY seq ASC LIMIT 1");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	600
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	601 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	602 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	603 // No patient remaining or all the patients are protected
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	604 return false;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	605 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	606 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	607 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	608 internalId = s.ColumnInt(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	609 return true;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	610 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	611 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	612
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	613 bool DatabaseWrapperBase::SelectPatientToRecycle(int64_t& internalId,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	614 int64_t patientIdToAvoid)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	615 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	616 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	617 "SELECT patientId FROM PatientRecyclingOrder "
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	618 "WHERE patientId != ? ORDER BY seq ASC LIMIT 1");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	619 s.BindInt64(0, patientIdToAvoid);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	620
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	621 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	622 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	623 // No patient remaining or all the patients are protected
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	624 return false;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	625 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	626 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	627 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	628 internalId = s.ColumnInt(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	629 return true;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	630 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	631 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	632
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	633 bool DatabaseWrapperBase::IsProtectedPatient(int64_t internalId)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	634 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	635 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	636 "SELECT * FROM PatientRecyclingOrder WHERE patientId = ?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	637 s.BindInt64(0, internalId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	638 return !s.Step();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	639 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	640
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	641 void DatabaseWrapperBase::SetProtectedPatient(int64_t internalId,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	642 bool isProtected)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	643 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	644 if (isProtected)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	645 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	646 SQLite::Statement s(db_, SQLITE_FROM_HERE, "DELETE FROM PatientRecyclingOrder WHERE patientId=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	647 s.BindInt64(0, internalId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	648 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	649 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	650 else if (IsProtectedPatient(internalId))
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	651 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	652 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO PatientRecyclingOrder VALUES(NULL, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	653 s.BindInt64(0, internalId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	654 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	655 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	656 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	657 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	658 // Nothing to do: The patient is already unprotected
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	659 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	660 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	661
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	662
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	663
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	664 bool DatabaseWrapperBase::IsExistingResource(int64_t internalId)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	665 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	666 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	667 "SELECT * FROM Resources WHERE internalId=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	668 s.BindInt64(0, internalId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	669 return s.Step();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	670 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	671
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	672
1746 d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	673
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	674 void DatabaseWrapperBase::LookupIdentifier(std::list<int64_t>& target,
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	675 ResourceType level,
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	676 const DicomTag& tag,
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	677 IdentifierConstraintType type,
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	678 const std::string& value)
1729 54d78925cbb6 notes Sebastien Jodogne <s.jodogne@gmail.com> parents: 1728 diff changeset	679 {
1746 d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	680 static const char* COMMON = ("SELECT d.id FROM DicomIdentifiers AS d, Resources AS r WHERE "
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	681 "d.id = r.internalId AND r.resourceType=? AND "
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	682 "d.tagGroup=? AND d.tagElement=? AND ");
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	683
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	684 std::auto_ptr<SQLite::Statement> s;
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	685
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	686 switch (type)
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	687 {
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	688 case IdentifierConstraintType_GreaterOrEqual:
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	689 s.reset(new SQLite::Statement(db_, std::string(COMMON) + "d.value>=?"));
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	690 break;
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	691
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	692 case IdentifierConstraintType_SmallerOrEqual:
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	693 s.reset(new SQLite::Statement(db_, std::string(COMMON) + "d.value<=?"));
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	694 break;
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	695
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	696 case IdentifierConstraintType_Wildcard:
1758 318c2e83c2bd fix Sebastien Jodogne <s.jodogne@gmail.com> parents: 1750 diff changeset	697 s.reset(new SQLite::Statement(db_, std::string(COMMON) + "d.value GLOB ?"));
1746 d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	698 break;
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	699
1761 f4286d99ee0a fix sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1760 diff changeset	700 case IdentifierConstraintType_Equal:
1746 d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	701 default:
1761 f4286d99ee0a fix sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1760 diff changeset	702 s.reset(new SQLite::Statement(db_, std::string(COMMON) + "d.value=?"));
f4286d99ee0a fix sample database plugin Sebastien Jodogne <s.jodogne@gmail.com> parents: 1760 diff changeset	703 break;
1746 d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	704 }
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	705
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	706 assert(s.get() != NULL);
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	707
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	708 s->BindInt(0, level);
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	709 s->BindInt(1, tag.GetGroup());
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	710 s->BindInt(2, tag.GetElement());
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	711 s->BindString(3, value);
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	712
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	713 target.clear();
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	714
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	715 while (s->Step())
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	716 {
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	717 target.push_back(s->ColumnInt64(0));
d143db00a794 SetOfResources Sebastien Jodogne <s.jodogne@gmail.com> parents: 1745 diff changeset	718 }
1729 54d78925cbb6 notes Sebastien Jodogne <s.jodogne@gmail.com> parents: 1728 diff changeset	719 }
2697 e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	720
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	721
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	722 void DatabaseWrapperBase::LookupIdentifierRange(std::list<int64_t>& target,
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	723 ResourceType level,
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	724 const DicomTag& tag,
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	725 const std::string& start,
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	726 const std::string& end)
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	727 {
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	728 SQLite::Statement statement(db_, SQLITE_FROM_HERE,
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	729 "SELECT d.id FROM DicomIdentifiers AS d, Resources AS r WHERE "
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	730 "d.id = r.internalId AND r.resourceType=? AND "
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	731 "d.tagGroup=? AND d.tagElement=? AND d.value>=? AND d.value<=?");
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	732
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	733 statement.BindInt(0, level);
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	734 statement.BindInt(1, tag.GetGroup());
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	735 statement.BindInt(2, tag.GetElement());
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	736 statement.BindString(3, start);
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	737 statement.BindString(4, end);
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	738
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	739 target.clear();
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	740
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	741 while (statement.Step())
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	742 {
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	743 target.push_back(statement.ColumnInt64(0));
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	744 }
e583478e0c6c New primitive in database SDK: "lookupIdentifierRange" to speed up range searches Sebastien Jodogne <s.jodogne@gmail.com> parents: 2447 diff changeset	745 }
1670 16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	746 }

Mercurial > hg > orthanc

annotate OrthancServer/Resources/Graveyard/DatabasePluginSample/DatabaseWrapperBase.cpp @ 5594:a906dc19264c find-refactoring