Mercurial > hg > orthanc-databases

comparison Framework/Plugins/IndexBackend.cpp @ 302:3a52e27a2d80

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
in GenericFormatter, replaced ${} by ${AUTOINCREMENT}
author Sebastien Jodogne <s.jodogne@gmail.com>
date Fri, 09 Jul 2021 16:25:08 +0200
parents 2447c290fc73
children dd4b0edd1661
comparison
equal deleted inserted replaced
301:2447c290fc73 302:3a52e27a2d80
940 OrthancPluginResourceType resourceType, 940 OrthancPluginResourceType resourceType,
941 const char* date) 941 const char* date)
942 { 942 {
943 DatabaseManager::CachedStatement statement( 943 DatabaseManager::CachedStatement statement(
944 STATEMENT_FROM_HERE, manager, 944 STATEMENT_FROM_HERE, manager,
945 "INSERT INTO Changes VALUES(${}, ${changeType}, ${id}, ${resourceType}, ${date})"); 945 "INSERT INTO Changes VALUES(${AUTOINCREMENT} ${changeType}, ${id}, ${resourceType}, ${date})");
946 946
947 statement.SetParameterType("changeType", ValueType_Integer64); 947 statement.SetParameterType("changeType", ValueType_Integer64);
948 statement.SetParameterType("id", ValueType_Integer64); 948 statement.SetParameterType("id", ValueType_Integer64);
949 statement.SetParameterType("resourceType", ValueType_Integer64); 949 statement.SetParameterType("resourceType", ValueType_Integer64);
950 statement.SetParameterType("date", ValueType_Utf8String); 950 statement.SetParameterType("date", ValueType_Utf8String);
962 void IndexBackend::LogExportedResource(DatabaseManager& manager, 962 void IndexBackend::LogExportedResource(DatabaseManager& manager,
963 const OrthancPluginExportedResource& resource) 963 const OrthancPluginExportedResource& resource)
964 { 964 {
965 DatabaseManager::CachedStatement statement( 965 DatabaseManager::CachedStatement statement(
966 STATEMENT_FROM_HERE, manager, 966 STATEMENT_FROM_HERE, manager,
967 "INSERT INTO ExportedResources VALUES(${}, ${type}, ${publicId}, " 967 "INSERT INTO ExportedResources VALUES(${AUTOINCREMENT} ${type}, ${publicId}, "
968 "${modality}, ${patient}, ${study}, ${series}, ${instance}, ${date})"); 968 "${modality}, ${patient}, ${study}, ${series}, ${instance}, ${date})");
969 969
970 statement.SetParameterType("type", ValueType_Integer64); 970 statement.SetParameterType("type", ValueType_Integer64);
971 statement.SetParameterType("publicId", ValueType_Utf8String); 971 statement.SetParameterType("publicId", ValueType_Utf8String);
972 statement.SetParameterType("modality", ValueType_Utf8String); 972 statement.SetParameterType("modality", ValueType_Utf8String);
1694 } 1694 }
1695 else if (IsProtectedPatient(manager, internalId)) 1695 else if (IsProtectedPatient(manager, internalId))
1696 { 1696 {
1697 DatabaseManager::CachedStatement statement( 1697 DatabaseManager::CachedStatement statement(
1698 STATEMENT_FROM_HERE, manager, 1698 STATEMENT_FROM_HERE, manager,
1699 "INSERT INTO PatientRecyclingOrder VALUES(${}, ${id})"); 1699 "INSERT INTO PatientRecyclingOrder VALUES(${AUTOINCREMENT} ${id})");
1700 1700
1701 statement.SetParameterType("id", ValueType_Integer64); 1701 statement.SetParameterType("id", ValueType_Integer64);
1702 1702
1703 Dictionary args; 1703 Dictionary args;
1704 args.SetIntegerValue("id", internalId); 1704 args.SetIntegerValue("id", internalId);
2273 // Add the patient to the end of the recycling order 2273 // Add the patient to the end of the recycling order
2274 2274
2275 { 2275 {
2276 DatabaseManager::CachedStatement statement( 2276 DatabaseManager::CachedStatement statement(
2277 STATEMENT_FROM_HERE, manager, 2277 STATEMENT_FROM_HERE, manager,
2278 "INSERT INTO PatientRecyclingOrder VALUES(${}, ${id})"); 2278 "INSERT INTO PatientRecyclingOrder VALUES({AUTOINCREMENT} ${id})");
2279 2279
2280 statement.SetParameterType("id", ValueType_Integer64); 2280 statement.SetParameterType("id", ValueType_Integer64);
2281 2281
2282 Dictionary args; 2282 Dictionary args;
2283 args.SetIntegerValue("id", patient); 2283 args.SetIntegerValue("id", patient);