Mercurial > hg > orthanc

comparison OrthancServer/Database/SQLiteDatabaseWrapper.cpp @ 3187:4bbadcd03966

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
refactoring retrieval of metadata from database
author Sebastien Jodogne <s.jodogne@gmail.com>
date Mon, 04 Feb 2019 12:06:19 +0100
parents c0d7aee8c3f8
children 94f4a18a79cc
comparison
equal deleted inserted replaced
3184:5d1f5984dc41 3187:4bbadcd03966
759 return true; 759 return true;
760 } 760 }
761 } 761 }
762 762
763 763
764 void SQLiteDatabaseWrapper::ListAvailableMetadata(std::list<MetadataType>& target,
765 int64_t id)
766 {
767 target.clear();
768
769 SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT type FROM Metadata WHERE id=?");
770 s.BindInt64(0, id);
771
772 while (s.Step())
773 {
774 target.push_back(static_cast<MetadataType>(s.ColumnInt(0)));
775 }
776 }
777
778
779 void SQLiteDatabaseWrapper::AddAttachment(int64_t id, 764 void SQLiteDatabaseWrapper::AddAttachment(int64_t id,
780 const FileInfo& attachment) 765 const FileInfo& attachment)
781 { 766 {
782 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO AttachedFiles VALUES(?, ?, ?, ?, ?, ?, ?, ?)"); 767 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO AttachedFiles VALUES(?, ?, ?, ?, ?, ?, ?, ?)");
783 s.BindInt64(0, id); 768 s.BindInt64(0, id);