Mercurial > hg > orthanc-databases
comparison PostgreSQL/Plugins/PostgreSQLIndex.cpp @ 263:29d2b76516f6
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) |