Mercurial > hg > orthanc-databases
diff PostgreSQL/Plugins/PostgreSQLIndex.cpp @ 473:15e609c439d1
Fixed the MaximumStorageSize & MaximumPatientCount.
author | Alain Mazy <am@osimis.io> |
---|---|
date | Wed, 14 Feb 2024 13:46:04 +0100 |
parents | ff84104f7842 |
children | 0974a58fdc76 |
line wrap: on
line diff
--- a/PostgreSQL/Plugins/PostgreSQLIndex.cpp Thu Feb 08 16:18:36 2024 +0100 +++ b/PostgreSQL/Plugins/PostgreSQLIndex.cpp Wed Feb 14 13:46:04 2024 +0100 @@ -240,9 +240,8 @@ { DatabaseManager::CachedStatement statement( STATEMENT_FROM_HERE, manager, - "SELECT value FROM GlobalIntegers WHERE key = 0"); + "SELECT * FROM UpdateSingleStatistic(0)"); - statement.SetReadOnly(true); statement.Execute(); result = static_cast<uint64_t>(statement.ReadInteger64(0)); @@ -262,9 +261,8 @@ { DatabaseManager::CachedStatement statement( STATEMENT_FROM_HERE, manager, - "SELECT value FROM GlobalIntegers WHERE key = 1"); + "SELECT * FROM UpdateSingleStatistic(1)"); - statement.SetReadOnly(true); statement.Execute(); result = static_cast<uint64_t>(statement.ReadInteger64(0)); @@ -622,19 +620,11 @@ uint64_t result; { - DatabaseManager::CachedStatement statement( - STATEMENT_FROM_HERE, manager, - "SELECT value FROM GlobalIntegers WHERE key = ${key}"); - - statement.SetParameterType("key", ValueType_Integer64); + DatabaseManager::StandaloneStatement statement( + manager, + std::string("SELECT * FROM UpdateSingleStatistic(") + boost::lexical_cast<std::string>(resourceType + 2) + ")"); // For an explanation of the "+ 2" below, check out "PrepareIndex.sql" - Dictionary args; - - // For an explanation of the "+ 2" below, check out "FastCountResources.sql" - args.SetIntegerValue("key", static_cast<int>(resourceType + 2)); - - statement.SetReadOnly(true); - statement.Execute(args); + statement.Execute(); result = static_cast<uint64_t>(statement.ReadInteger64(0)); }