Mercurial > hg > orthanc
comparison OrthancServer/Database/SQLiteDatabaseWrapper.cpp @ 3187:4bbadcd03966
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); |