Mercurial > hg > orthanc

comparison OrthancServer/DatabaseWrapper.cpp @ 197:530a25320461

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
removal of text as ids in sqlite db
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 27 Nov 2012 14:59:55 +0100
parents a1b9d1e1497b
children 663cc6c46d0a
comparison
equal deleted inserted replaced
196:6d0225a26fd8 197:530a25320461
314 return defaultValue; 314 return defaultValue;
315 } 315 }
316 } 316 }
317 317
318 void DatabaseWrapper::AttachFile(int64_t id, 318 void DatabaseWrapper::AttachFile(int64_t id,
319 const std::string& contentName, 319 AttachedFileType contentType,
320 const std::string& fileUuid, 320 const std::string& fileUuid,
321 uint64_t compressedSize, 321 uint64_t compressedSize,
322 uint64_t uncompressedSize, 322 uint64_t uncompressedSize,
323 CompressionType compressionType) 323 CompressionType compressionType)
324 { 324 {
325 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO AttachedFiles VALUES(?, ?, ?, ?, ?, ?)"); 325 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO AttachedFiles VALUES(?, ?, ?, ?, ?, ?)");
326 s.BindInt(0, id); 326 s.BindInt(0, id);
327 s.BindString(1, contentName); 327 s.BindInt(1, contentType);
328 s.BindString(2, fileUuid); 328 s.BindString(2, fileUuid);
329 s.BindInt(3, compressedSize); 329 s.BindInt(3, compressedSize);
330 s.BindInt(4, uncompressedSize); 330 s.BindInt(4, uncompressedSize);
331 s.BindInt(5, compressionType); 331 s.BindInt(5, compressionType);
332 s.Run(); 332 s.Run();
333 } 333 }
334 334
335 bool DatabaseWrapper::LookupFile(int64_t id, 335 bool DatabaseWrapper::LookupFile(int64_t id,
336 const std::string& contentName, 336 AttachedFileType contentType,
337 std::string& fileUuid, 337 std::string& fileUuid,
338 uint64_t& compressedSize, 338 uint64_t& compressedSize,
339 uint64_t& uncompressedSize, 339 uint64_t& uncompressedSize,
340 CompressionType& compressionType) 340 CompressionType& compressionType)
341 { 341 {
342 SQLite::Statement s(db_, SQLITE_FROM_HERE, 342 SQLite::Statement s(db_, SQLITE_FROM_HERE,
343 "SELECT uuid, compressedSize, uncompressedSize, compressionType FROM AttachedFiles WHERE id=? AND contentName=?"); 343 "SELECT uuid, compressedSize, uncompressedSize, compressionType FROM AttachedFiles WHERE id=? AND fileType=?");
344 s.BindInt(0, id); 344 s.BindInt(0, id);
345 s.BindString(1, contentName); 345 s.BindInt(1, contentType);
346 346
347 if (!s.Step()) 347 if (!s.Step())
348 { 348 {
349 return false; 349 return false;
350 } 350 }