Mercurial > hg > orthanc

comparison OrthancServer/DatabaseWrapper.cpp @ 198:663cc6c46d0a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
before refactoring of ServerIndex::GetXXX
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 27 Nov 2012 15:49:42 +0100
parents 530a25320461
children dfa2899d9960
comparison
equal deleted inserted replaced
197:530a25320461 198:663cc6c46d0a
229 229
230 return true; 230 return true;
231 } 231 }
232 } 232 }
233 233
234 bool DatabaseWrapper::LookupParent(int64_t& parentId,
235 int64_t resourceId)
236 {
237 SQLite::Statement s(db_, SQLITE_FROM_HERE,
238 "SELECT parentId FROM Resources WHERE internalId=?");
239 s.BindInt(0, resourceId);
240
241 if (!s.Step())
242 {
243 throw OrthancException(ErrorCode_UnknownResource);
244 }
245
246 if (s.ColumnIsNull(0))
247 {
248 return false;
249 }
250 else
251 {
252 parentId = s.ColumnInt(0);
253 return true;
254 }
255 }
256
257 std::string DatabaseWrapper::GetPublicId(int64_t resourceId)
258 {
259 SQLite::Statement s(db_, SQLITE_FROM_HERE,
260 "SELECT publicId FROM Resources WHERE internalId=?");
261 s.BindInt(0, resourceId);
262
263 if (!s.Step())
264 {
265 throw OrthancException(ErrorCode_UnknownResource);
266 }
267
268 return s.ColumnString(0);
269 }
270
234 void DatabaseWrapper::AttachChild(int64_t parent, 271 void DatabaseWrapper::AttachChild(int64_t parent,
235 int64_t child) 272 int64_t child)
236 { 273 {
237 SQLite::Statement s(db_, SQLITE_FROM_HERE, "UPDATE Resources SET parentId = ? WHERE internalId = ?"); 274 SQLite::Statement s(db_, SQLITE_FROM_HERE, "UPDATE Resources SET parentId = ? WHERE internalId = ?");
238 s.BindInt(0, parent); 275 s.BindInt(0, parent);