Mercurial > hg > orthanc

comparison OrthancServer/DatabaseWrapper.cpp @ 192:c56dc32266e0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
refactoring getfile
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 13 Nov 2012 11:29:43 +0100
parents b6cef9d45cc3
children a1b9d1e1497b
comparison
equal deleted inserted replaced
191:bff0b77b02fa 192:c56dc32266e0
300 return defaultValue; 300 return defaultValue;
301 } 301 }
302 } 302 }
303 303
304 void DatabaseWrapper::AttachFile(int64_t id, 304 void DatabaseWrapper::AttachFile(int64_t id,
305 const std::string& name, 305 const std::string& contentName,
306 const std::string& fileUuid, 306 const std::string& fileUuid,
307 uint64_t compressedSize, 307 uint64_t compressedSize,
308 uint64_t uncompressedSize, 308 uint64_t uncompressedSize,
309 CompressionType compressionType) 309 CompressionType compressionType)
310 { 310 {
311 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO AttachedFiles VALUES(?, ?, ?, ?, ?, ?)"); 311 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO AttachedFiles VALUES(?, ?, ?, ?, ?, ?)");
312 s.BindInt(0, id); 312 s.BindInt(0, id);
313 s.BindString(1, name); 313 s.BindString(1, contentName);
314 s.BindString(2, fileUuid); 314 s.BindString(2, fileUuid);
315 s.BindInt(3, compressedSize); 315 s.BindInt(3, compressedSize);
316 s.BindInt(4, uncompressedSize); 316 s.BindInt(4, uncompressedSize);
317 s.BindInt(5, compressionType); 317 s.BindInt(5, compressionType);
318 s.Run(); 318 s.Run();
319 } 319 }
320 320
321 bool DatabaseWrapper::LookupFile(int64_t id, 321 bool DatabaseWrapper::LookupFile(int64_t id,
322 const std::string& name, 322 const std::string& contentName,
323 std::string& fileUuid, 323 std::string& fileUuid,
324 uint64_t& compressedSize, 324 uint64_t& compressedSize,
325 uint64_t& uncompressedSize, 325 uint64_t& uncompressedSize,
326 CompressionType& compressionType) 326 CompressionType& compressionType)
327 { 327 {
328 SQLite::Statement s(db_, SQLITE_FROM_HERE, 328 SQLite::Statement s(db_, SQLITE_FROM_HERE,
329 "SELECT uuid, compressedSize, uncompressedSize, compressionType FROM AttachedFiles WHERE id=? AND name=?"); 329 "SELECT uuid, compressedSize, uncompressedSize, compressionType FROM AttachedFiles WHERE id=? AND contentName=?");
330 s.BindInt(0, id); 330 s.BindInt(0, id);
331 s.BindString(1, name); 331 s.BindString(1, contentName);
332 332
333 if (!s.Step()) 333 if (!s.Step())
334 { 334 {
335 return false; 335 return false;
336 } 336 }