Mercurial > hg > orthanc-databases
comparison Framework/Plugins/IndexBackend.cpp @ 302:3a52e27a2d80
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); |