Mercurial > hg > orthanc
comparison OrthancServer/Sources/Database/SQLiteDatabaseWrapper.cpp @ 5256:261ce0ed85e6 db-protobuf
fix
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Tue, 11 Apr 2023 20:50:43 +0200 |
parents | f22c8fac764b |
children | 176bc05f85f4 48b8dae6dc77 |
comparison
equal
deleted
inserted
replaced
5255:f783b99e4738 | 5256:261ce0ed85e6 |
---|---|
1082 { | 1082 { |
1083 throw OrthancException(ErrorCode_ParameterOutOfRange); | 1083 throw OrthancException(ErrorCode_ParameterOutOfRange); |
1084 } | 1084 } |
1085 else | 1085 else |
1086 { | 1086 { |
1087 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT OR IGNORE INTO Labels (internalId, label) VALUES(?, ?)"); | 1087 SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT OR IGNORE INTO Labels (id, label) VALUES(?, ?)"); |
1088 s.BindInt64(0, resource); | 1088 s.BindInt64(0, resource); |
1089 s.BindString(1, label); | 1089 s.BindString(1, label); |
1090 s.Run(); | 1090 s.Run(); |
1091 } | 1091 } |
1092 } | 1092 } |
1099 { | 1099 { |
1100 throw OrthancException(ErrorCode_ParameterOutOfRange); | 1100 throw OrthancException(ErrorCode_ParameterOutOfRange); |
1101 } | 1101 } |
1102 else | 1102 else |
1103 { | 1103 { |
1104 SQLite::Statement s(db_, SQLITE_FROM_HERE, "DELETE FROM Labels WHERE internalId=? AND label=?"); | 1104 SQLite::Statement s(db_, SQLITE_FROM_HERE, "DELETE FROM Labels WHERE id=? AND label=?"); |
1105 s.BindInt64(0, resource); | 1105 s.BindInt64(0, resource); |
1106 s.BindString(1, label); | 1106 s.BindString(1, label); |
1107 s.Run(); | 1107 s.Run(); |
1108 } | 1108 } |
1109 } | 1109 } |
1113 int64_t resource) ORTHANC_OVERRIDE | 1113 int64_t resource) ORTHANC_OVERRIDE |
1114 { | 1114 { |
1115 target.clear(); | 1115 target.clear(); |
1116 | 1116 |
1117 SQLite::Statement s(db_, SQLITE_FROM_HERE, | 1117 SQLite::Statement s(db_, SQLITE_FROM_HERE, |
1118 "SELECT label FROM Labels WHERE internalId=?"); | 1118 "SELECT label FROM Labels WHERE id=?"); |
1119 s.BindInt64(0, resource); | 1119 s.BindInt64(0, resource); |
1120 | 1120 |
1121 while (s.Step()) | 1121 while (s.Step()) |
1122 { | 1122 { |
1123 target.insert(s.ColumnString(0)); | 1123 target.insert(s.ColumnString(0)); |