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

annotate OrthancServer/Resources/Graveyard/DatabasePluginSample/DatabaseWrapperBase.cpp @ 4704:f0038043fb97 openssl-3.x

removed OpenSSL license exception, as OpenSSL 3.0 was relicensed under Apache 2.0

author	Sebastien Jodogne <s.jodogne@gmail.com>
date	Tue, 22 Jun 2021 07:37:20 +0200
parents	d9473bd5ed43
children	2e71a08eea15

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

Mercurial > hg > orthanc

annotate OrthancServer/Resources/Graveyard/DatabasePluginSample/DatabaseWrapperBase.cpp @ 4704:f0038043fb97 openssl-3.x