orthanc: OrthancServer/DatabaseWrapperBase.cpp annotate

author	Sebastien Jodogne <s.jodogne@gmail.com>
date	Thu, 01 Oct 2015 14:03:07 +0200
parents
children	2f2e2ec17bc4

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
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	3 * Copyright (C) 2012-2015 Sebastien Jodogne, Medical Physics
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	4 * Department, University Hospital of Liege, Belgium
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	5 *
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	6 * This program is free software: you can redistribute it and/or
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	7 * modify it under the terms of the GNU General Public License as
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	8 * published by the Free Software Foundation, either version 3 of the
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	9 * License, or (at your option) any later version.
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	10 *
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	11 * In addition, as a special exception, the copyright holders of this
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	12 * program give permission to link the code of its release with the
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	13 * OpenSSL project's "OpenSSL" library (or with modified versions of it
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	14 * that use the same license as the "OpenSSL" library), and distribute
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	15 * the linked executables. You must obey the GNU General Public License
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	16 * in all respects for all of the code used other than "OpenSSL". If you
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	17 * modify file(s) with this exception, you may extend this exception to
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	18 * your version of the file(s), but you are not obligated to do so. If
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	19 * you do not wish to do so, delete this exception statement from your
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	20 * version. If you delete this exception statement from all source files
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	21 * in the program, then also delete it here.
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	22 *
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	23 * 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	24 * WITHOUT ANY WARRANTY; without even the implied warranty of
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	26 * General Public License for more details.
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 * You should have received a copy of the GNU General Public License
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	29 * along with this program. If not, see <http://www.gnu.org/licenses/>.
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	30 **/
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	31
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 #include "PrecompiledHeadersServer.h"
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	34 #include "DatabaseWrapperBase.h"
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	35
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	36 #include <stdio.h>
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 namespace Orthanc
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	39 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	40 void DatabaseWrapperBase::SetGlobalProperty(GlobalProperty property,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	41 const std::string& value)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	42 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	43 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT OR REPLACE INTO GlobalProperties VALUES(?, ?)");
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 s.BindString(1, value);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	46 s.Run();
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
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	49 bool DatabaseWrapperBase::LookupGlobalProperty(std::string& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	50 GlobalProperty property)
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 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	53 "SELECT value FROM GlobalProperties WHERE property=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	54 s.BindInt(0, property);
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 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	57 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	58 return false;
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 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	61 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	62 target = s.ColumnString(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	63 return true;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	64 }
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 int64_t DatabaseWrapperBase::CreateResource(const std::string& publicId,
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 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	70 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	71 s.BindInt(0, type);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	72 s.BindString(1, publicId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	73 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	74 return db_.GetLastInsertRowId();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	75 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	76
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	77 bool DatabaseWrapperBase::LookupResource(int64_t& id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	78 ResourceType& type,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	79 const std::string& publicId)
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 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	82 "SELECT internalId, resourceType FROM Resources WHERE publicId=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	83 s.BindString(0, publicId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	84
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	85 if (!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 false;
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 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	90 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	91 id = s.ColumnInt(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	92 type = static_cast<ResourceType>(s.ColumnInt(1));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	93
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	94 // Check whether there is a single resource with this public id
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	95 assert(!s.Step());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	96
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	97 return true;
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 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	100
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	101 bool DatabaseWrapperBase::LookupParent(int64_t& parentId,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	102 int64_t resourceId)
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 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	105 "SELECT parentId FROM Resources WHERE internalId=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	106 s.BindInt64(0, resourceId);
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 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	109 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	110 throw OrthancException(ErrorCode_UnknownResource);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	111 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	112
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	113 if (s.ColumnIsNull(0))
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	114 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	115 return false;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	116 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	117 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	118 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	119 parentId = s.ColumnInt(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	120 return true;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	121 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	122 }
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 std::string DatabaseWrapperBase::GetPublicId(int64_t resourceId)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	125 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	126 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	127 "SELECT publicId FROM Resources WHERE internalId=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	128 s.BindInt64(0, resourceId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	129
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	130 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	131 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	132 throw OrthancException(ErrorCode_UnknownResource);
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 return s.ColumnString(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	136 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	137
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 ResourceType DatabaseWrapperBase::GetResourceType(int64_t resourceId)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	140 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	141 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	142 "SELECT resourceType FROM Resources WHERE internalId=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	143 s.BindInt64(0, resourceId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	144
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	145 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	146 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	147 throw OrthancException(ErrorCode_UnknownResource);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	148 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	149
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	150 return static_cast<ResourceType>(s.ColumnInt(0));
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 void DatabaseWrapperBase::AttachChild(int64_t parent,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	155 int64_t child)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	156 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	157 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	158 s.BindInt64(0, parent);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	159 s.BindInt64(1, child);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	160 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	161 }
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 void DatabaseWrapperBase::SetMetadata(int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	165 MetadataType type,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	166 const std::string& value)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	167 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	168 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	169 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	170 s.BindInt(1, type);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	171 s.BindString(2, value);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	172 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	173 }
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 void DatabaseWrapperBase::DeleteMetadata(int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	176 MetadataType type)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	177 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	178 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	179 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	180 s.BindInt(1, type);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	181 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	182 }
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 bool DatabaseWrapperBase::LookupMetadata(std::string& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	185 int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	186 MetadataType type)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	187 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	188 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	189 "SELECT value FROM Metadata WHERE id=? AND type=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	190 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	191 s.BindInt(1, type);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	192
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	193 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	194 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	195 return false;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	196 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	197 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	198 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	199 target = s.ColumnString(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	200 return true;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	201 }
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 void DatabaseWrapperBase::ListAvailableMetadata(std::list<MetadataType>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	205 int64_t id)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	206 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	207 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	208
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	209 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	210 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	211
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	212 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	213 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	214 target.push_back(static_cast<MetadataType>(s.ColumnInt(0)));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	215 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	216 }
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 void DatabaseWrapperBase::AddAttachment(int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	220 const FileInfo& attachment)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	221 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	222 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO AttachedFiles VALUES(?, ?, ?, ?, ?, ?, ?, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	223 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	224 s.BindInt(1, attachment.GetContentType());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	225 s.BindString(2, attachment.GetUuid());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	226 s.BindInt64(3, attachment.GetCompressedSize());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	227 s.BindInt64(4, attachment.GetUncompressedSize());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	228 s.BindInt(5, attachment.GetCompressionType());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	229 s.BindString(6, attachment.GetUncompressedMD5());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	230 s.BindString(7, attachment.GetCompressedMD5());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	231 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	232 }
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 void DatabaseWrapperBase::DeleteAttachment(int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	236 FileContentType attachment)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	237 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	238 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	239 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	240 s.BindInt(1, attachment);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	241 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	242 }
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 void DatabaseWrapperBase::ListAvailableAttachments(std::list<FileContentType>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	247 int64_t id)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	248 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	249 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	250
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	251 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	252 "SELECT fileType FROM AttachedFiles WHERE id=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	253 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	254
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	255 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	256 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	257 target.push_back(static_cast<FileContentType>(s.ColumnInt(0)));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	258 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	259 }
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 bool DatabaseWrapperBase::LookupAttachment(FileInfo& attachment,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	262 int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	263 FileContentType contentType)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	264 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	265 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	266 "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	267 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	268 s.BindInt(1, contentType);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	269
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	270 if (!s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	271 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	272 return false;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	273 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	274 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	275 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	276 attachment = FileInfo(s.ColumnString(0),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	277 contentType,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	278 s.ColumnInt64(1),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	279 s.ColumnString(4),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	280 static_cast<CompressionType>(s.ColumnInt(2)),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	281 s.ColumnInt64(3),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	282 s.ColumnString(5));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	283 return true;
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	284 }
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 void DatabaseWrapperBase::ClearMainDicomTags(int64_t id)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	289 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	290 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	291 SQLite::Statement s(db_, SQLITE_FROM_HERE, "DELETE FROM DicomIdentifiers WHERE id=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	292 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	293 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	294 }
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 SQLite::Statement s(db_, SQLITE_FROM_HERE, "DELETE FROM MainDicomTags WHERE id=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	298 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	299 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	300 }
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 static void SetMainDicomTagsInternal(SQLite::Statement& s,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	305 int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	306 const DicomTag& tag,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	307 const std::string& value)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	308 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	309 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	310 s.BindInt(1, tag.GetGroup());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	311 s.BindInt(2, tag.GetElement());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	312 s.BindString(3, value);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	313 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	314 }
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 void DatabaseWrapperBase::SetMainDicomTag(int64_t id,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	318 const DicomTag& tag,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	319 const std::string& value)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	320 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	321 if (tag.IsIdentifier())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	322 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	323 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO DicomIdentifiers VALUES(?, ?, ?, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	324 SetMainDicomTagsInternal(s, id, tag, value);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	325 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	326 else
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	327 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	328 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO MainDicomTags VALUES(?, ?, ?, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	329 SetMainDicomTagsInternal(s, id, tag, value);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	330 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	331 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	332
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	333 void DatabaseWrapperBase::GetMainDicomTags(DicomMap& map,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	334 int64_t id)
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 map.Clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	337
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	338 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT * FROM MainDicomTags WHERE id=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	339 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	340 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	341 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	342 map.SetValue(s.ColumnInt(1),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	343 s.ColumnInt(2),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	344 s.ColumnString(3));
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 SQLite::Statement s2(db_, SQLITE_FROM_HERE, "SELECT * FROM DicomIdentifiers WHERE id=?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	348 s2.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	349 while (s2.Step())
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 map.SetValue(s2.ColumnInt(1),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	352 s2.ColumnInt(2),
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	353 s2.ColumnString(3));
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 }
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
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 void DatabaseWrapperBase::GetChildrenPublicId(std::list<std::string>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	360 int64_t id)
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 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	363 "WHERE a.parentId = b.internalId AND b.internalId = ?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	364 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	365
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	366 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	367
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	368 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	369 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	370 target.push_back(s.ColumnString(0));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	371 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	372 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	373
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	374
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	375 void DatabaseWrapperBase::GetChildrenInternalId(std::list<int64_t>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	376 int64_t id)
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 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	379 "WHERE a.parentId = b.internalId AND b.internalId = ?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	380 s.BindInt64(0, id);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	381
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	382 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	383
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	384 while (s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	385 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	386 target.push_back(s.ColumnInt64(0));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	387 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	388 }
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 void DatabaseWrapperBase::LogChange(int64_t internalId,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	392 const ServerIndexChange& change)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	393 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	394 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO Changes VALUES(NULL, ?, ?, ?, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	395 s.BindInt(0, change.GetChangeType());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	396 s.BindInt64(1, internalId);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	397 s.BindInt(2, change.GetResourceType());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	398 s.BindString(3, change.GetDate());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	399 s.Run();
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
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	402
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	403 void DatabaseWrapperBase::GetChangesInternal(std::list<ServerIndexChange>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	404 bool& done,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	405 SQLite::Statement& s,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	406 uint32_t maxResults)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	407 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	408 target.clear();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	409
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	410 while (target.size() < maxResults && s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	411 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	412 int64_t seq = s.ColumnInt64(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	413 ChangeType changeType = static_cast<ChangeType>(s.ColumnInt(1));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	414 ResourceType resourceType = static_cast<ResourceType>(s.ColumnInt(3));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	415 const std::string& date = s.ColumnString(4);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	416
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	417 int64_t internalId = s.ColumnInt64(2);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	418 std::string publicId = GetPublicId(internalId);
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 target.push_back(ServerIndexChange(seq, changeType, resourceType, publicId, date));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	421 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	422
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	423 done = !(target.size() == maxResults && s.Step());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	424 }
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
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	427 void DatabaseWrapperBase::GetChanges(std::list<ServerIndexChange>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	428 bool& done,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	429 int64_t since,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	430 uint32_t maxResults)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	431 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	432 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	433 s.BindInt64(0, since);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	434 s.BindInt(1, maxResults + 1);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	435 GetChangesInternal(target, done, s, maxResults);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	436 }
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 void DatabaseWrapperBase::GetLastChange(std::list<ServerIndexChange>& target)
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 bool done; // Ignored
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	441 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT * FROM Changes ORDER BY seq DESC LIMIT 1");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	442 GetChangesInternal(target, done, s, 1);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	443 }
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
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	446 void DatabaseWrapperBase::LogExportedResource(const ExportedResource& resource)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	447 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	448 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	449 "INSERT INTO ExportedResources VALUES(NULL, ?, ?, ?, ?, ?, ?, ?, ?)");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	450
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	451 s.BindInt(0, resource.GetResourceType());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	452 s.BindString(1, resource.GetPublicId());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	453 s.BindString(2, resource.GetModality());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	454 s.BindString(3, resource.GetPatientId());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	455 s.BindString(4, resource.GetStudyInstanceUid());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	456 s.BindString(5, resource.GetSeriesInstanceUid());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	457 s.BindString(6, resource.GetSopInstanceUid());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	458 s.BindString(7, resource.GetDate());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	459 s.Run();
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	460 }
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
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	463 void DatabaseWrapperBase::GetExportedResourcesInternal(std::list<ExportedResource>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	464 bool& done,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	465 SQLite::Statement& s,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	466 uint32_t maxResults)
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	467 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	468 target.clear();
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 while (target.size() < maxResults && s.Step())
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	471 {
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	472 int64_t seq = s.ColumnInt64(0);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	473 ResourceType resourceType = static_cast<ResourceType>(s.ColumnInt(1));
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	474 std::string publicId = s.ColumnString(2);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	475
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	476 ExportedResource resource(seq,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	477 resourceType,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	478 publicId,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	479 s.ColumnString(3), // modality
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	480 s.ColumnString(8), // date
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	481 s.ColumnString(4), // patient ID
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	482 s.ColumnString(5), // study instance UID
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	483 s.ColumnString(6), // series instance UID
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	484 s.ColumnString(7)); // sop instance UID
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 target.push_back(resource);
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	487 }
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	488
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	489 done = !(target.size() == maxResults && s.Step());
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	490 }
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
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	493 void DatabaseWrapperBase::GetExportedResources(std::list<ExportedResource>& target,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	494 bool& done,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	495 int64_t since,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	496 uint32_t 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 SQLite::Statement s(db_, SQLITE_FROM_HERE,
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	499 "SELECT * FROM ExportedResources WHERE seq>? ORDER BY seq LIMIT ?");
16955f8fec4d refactoring: DatabaseWrapperBase Sebastien Jodogne <s.jodogne@gmail.com> parents: diff changeset	500 s.BindInt64(0, since);

1670

16955f8fec4d refactoring: DatabaseWrapperBase