Mercurial > hg > orthanc
comparison OrthancServer/DatabaseWrapper.cpp @ 268:4bc02e2254ec
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); |