Mercurial > hg > orthanc

comparison OrthancServer/DatabaseWrapper.cpp @ 268:4bc02e2254ec

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
preparing ServerIndex for recycling
author Sebastien Jodogne <s.jodogne@gmail.com>
date Fri, 07 Dec 2012 13:43:35 +0100
parents 2354560daf2f
children d384af918264
comparison
equal deleted inserted replaced
266:a08dca15790e 268:4bc02e2254ec
793 internalId = s.ColumnInt(0); 793 internalId = s.ColumnInt(0);
794 return true; 794 return true;
795 } 795 }
796 } 796 }
797 797
798 bool DatabaseWrapper::SelectPatientToRecycle(int64_t& internalId,
799 int64_t patientIdToAvoid)
800 {
801 SQLite::Statement s(db_, SQLITE_FROM_HERE,
802 "SELECT patientId FROM PatientRecyclingOrder "
803 "WHERE patientId != ? ORDER BY seq ASC LIMIT 1");
804 s.BindInt(0, patientIdToAvoid);
805
806 if (!s.Step())
807 {
808 // No patient remaining or all the patients are protected
809 return false;
810 }
811 else
812 {
813 internalId = s.ColumnInt(0);
814 return true;
815 }
816 }
817
798 bool DatabaseWrapper::IsProtectedPatient(int64_t internalId) 818 bool DatabaseWrapper::IsProtectedPatient(int64_t internalId)
799 { 819 {
800 SQLite::Statement s(db_, SQLITE_FROM_HERE, 820 SQLite::Statement s(db_, SQLITE_FROM_HERE,
801 "SELECT * FROM PatientRecyclingOrder WHERE patientId = ?"); 821 "SELECT * FROM PatientRecyclingOrder WHERE patientId = ?");
802 s.BindInt(0, internalId); 822 s.BindInt(0, internalId);