Mercurial > hg > orthanc

comparison OrthancServer/Sources/Database/SQLiteDatabaseWrapper.cpp @ 5256:261ce0ed85e6 db-protobuf

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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));