Mercurial > hg > orthanc

diff 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
line wrap: on
line diff
--- a/OrthancServer/DatabaseWrapper.cpp	Fri Nov 16 08:23:05 2012 +0100
+++ b/OrthancServer/DatabaseWrapper.cpp	Tue Nov 27 14:59:55 2012 +0100
@@ -316,7 +316,7 @@
   }
 
   void DatabaseWrapper::AttachFile(int64_t id,
-                                   const std::string& contentName,
+                                   AttachedFileType contentType,
                                    const std::string& fileUuid,
                                    uint64_t compressedSize,
                                    uint64_t uncompressedSize,
@@ -324,7 +324,7 @@
   {
     SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO AttachedFiles VALUES(?, ?, ?, ?, ?, ?)");
     s.BindInt(0, id);
-    s.BindString(1, contentName);
+    s.BindInt(1, contentType);
     s.BindString(2, fileUuid);
     s.BindInt(3, compressedSize);
     s.BindInt(4, uncompressedSize);
@@ -333,16 +333,16 @@
   }
 
   bool DatabaseWrapper::LookupFile(int64_t id,
-                                   const std::string& contentName,
+                                   AttachedFileType contentType,
                                    std::string& fileUuid,
                                    uint64_t& compressedSize,
                                    uint64_t& uncompressedSize,
                                    CompressionType& compressionType)
   {
     SQLite::Statement s(db_, SQLITE_FROM_HERE, 
-                        "SELECT uuid, compressedSize, uncompressedSize, compressionType FROM AttachedFiles WHERE id=? AND contentName=?");
+                        "SELECT uuid, compressedSize, uncompressedSize, compressionType FROM AttachedFiles WHERE id=? AND fileType=?");
     s.BindInt(0, id);
-    s.BindString(1, contentName);
+    s.BindInt(1, contentType);
 
     if (!s.Step())
     {