Mercurial > hg > orthanc-databases

comparison PostgreSQL/Plugins/PostgreSQLIndex.cpp @ 263:29d2b76516f6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix mysql and postgresql builds
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 20 Apr 2021 15:08:09 +0200
parents d663d9e44f8d
children cc7af42d4f23
comparison
equal deleted inserted replaced
262:b0c65094b299 263:29d2b76516f6
297 args.SetUtf8Value("id", publicId); 297 args.SetUtf8Value("id", publicId);
298 args.SetIntegerValue("type", static_cast<int>(type)); 298 args.SetIntegerValue("type", static_cast<int>(type));
299 299
300 statement.Execute(args); 300 statement.Execute(args);
301 301
302 return ReadInteger64(statement, 0); 302 return statement.ReadInteger64(0);
303 } 303 }
304 304
305 305
306 uint64_t PostgreSQLIndex::GetTotalCompressedSize(DatabaseManager& manager) 306 uint64_t PostgreSQLIndex::GetTotalCompressedSize(DatabaseManager& manager)
307 { 307 {
314 "SELECT value FROM GlobalIntegers WHERE key = 0"); 314 "SELECT value FROM GlobalIntegers WHERE key = 0");
315 315
316 statement.SetReadOnly(true); 316 statement.SetReadOnly(true);
317 statement.Execute(); 317 statement.Execute();
318 318
319 result = static_cast<uint64_t>(ReadInteger64(statement, 0)); 319 result = static_cast<uint64_t>(statement.ReadInteger64(0));
320 } 320 }
321 321
322 assert(result == IndexBackend::GetTotalCompressedSize(manager)); 322 assert(result == IndexBackend::GetTotalCompressedSize(manager));
323 return result; 323 return result;
324 } 324 }
335 "SELECT value FROM GlobalIntegers WHERE key = 1"); 335 "SELECT value FROM GlobalIntegers WHERE key = 1");
336 336
337 statement.SetReadOnly(true); 337 statement.SetReadOnly(true);
338 statement.Execute(); 338 statement.Execute();
339 339
340 result = static_cast<uint64_t>(ReadInteger64(statement, 0)); 340 result = static_cast<uint64_t>(statement.ReadInteger64(0));
341 } 341 }
342 342
343 assert(result == IndexBackend::GetTotalUncompressedSize(manager)); 343 assert(result == IndexBackend::GetTotalUncompressedSize(manager));
344 return result; 344 return result;
345 } 345 }
379 for (size_t i = 0; i < 8; i++) 379 for (size_t i = 0; i < 8; i++)
380 { 380 {
381 statement.SetResultFieldType(i, ValueType_Integer64); 381 statement.SetResultFieldType(i, ValueType_Integer64);
382 } 382 }
383 383
384 result.isNewInstance = (ReadInteger64(statement, 3) == 1); 384 result.isNewInstance = (statement.ReadInteger64(3) == 1);
385 result.instanceId = ReadInteger64(statement, 7); 385 result.instanceId = statement.ReadInteger64(7);
386 386
387 if (result.isNewInstance) 387 if (result.isNewInstance)
388 { 388 {
389 result.isNewPatient = (ReadInteger64(statement, 0) == 1); 389 result.isNewPatient = (statement.ReadInteger64(0) == 1);
390 result.isNewStudy = (ReadInteger64(statement, 1) == 1); 390 result.isNewStudy = (statement.ReadInteger64(1) == 1);
391 result.isNewSeries = (ReadInteger64(statement, 2) == 1); 391 result.isNewSeries = (statement.ReadInteger64(2) == 1);
392 result.patientId = ReadInteger64(statement, 4); 392 result.patientId = statement.ReadInteger64(4);
393 result.studyId = ReadInteger64(statement, 5); 393 result.studyId = statement.ReadInteger64(5);
394 result.seriesId = ReadInteger64(statement, 6); 394 result.seriesId = statement.ReadInteger64(6);
395 } 395 }
396 } 396 }
397 #endif 397 #endif
398 398
399 399
422 args.SetIntegerValue("key", static_cast<int>(resourceType + 2)); 422 args.SetIntegerValue("key", static_cast<int>(resourceType + 2));
423 423
424 statement.SetReadOnly(true); 424 statement.SetReadOnly(true);
425 statement.Execute(args); 425 statement.Execute(args);
426 426
427 result = static_cast<uint64_t>(ReadInteger64(statement, 0)); 427 result = static_cast<uint64_t>(statement.ReadInteger64(0));
428 } 428 }
429 429
430 assert(result == IndexBackend::GetResourcesCount(manager, resourceType)); 430 assert(result == IndexBackend::GetResourcesCount(manager, resourceType));
431 return result; 431 return result;
432 } 432 }
439 "SELECT value FROM GlobalIntegers WHERE key = 6"); 439 "SELECT value FROM GlobalIntegers WHERE key = 6");
440 440
441 statement.SetReadOnly(true); 441 statement.SetReadOnly(true);
442 statement.Execute(); 442 statement.Execute();
443 443
444 return ReadInteger64(statement, 0); 444 return statement.ReadInteger64(0);
445 } 445 }
446 446
447 447
448 void PostgreSQLIndex::TagMostRecentPatient(DatabaseManager& manager, 448 void PostgreSQLIndex::TagMostRecentPatient(DatabaseManager& manager,
449 int64_t patient) 449 int64_t patient)