Mercurial > hg > orthanc-databases
comparison Framework/Plugins/IndexBackend.cpp @ 326:4454545bb265
Fix issue #200 (fields messed up in /changes route)
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Thu, 22 Jul 2021 19:24:58 +0200 |
parents | 64763998cdff |
children | 2a3bbb4104fa |
comparison
equal
deleted
inserted
replaced
325:e0b9abf98019 | 326:4454545bb265 |
---|---|
566 suffix = "LIMIT ${limit}"; | 566 suffix = "LIMIT ${limit}"; |
567 } | 567 } |
568 | 568 |
569 DatabaseManager::CachedStatement statement( | 569 DatabaseManager::CachedStatement statement( |
570 STATEMENT_FROM_HERE, manager, | 570 STATEMENT_FROM_HERE, manager, |
571 "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Changes.date, " | 571 "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Resources.publicId, " |
572 "Resources.publicId FROM Changes INNER JOIN Resources " | 572 "Changes.date FROM Changes INNER JOIN Resources " |
573 "ON Changes.internalId = Resources.internalId WHERE seq>${since} ORDER BY seq " + suffix); | 573 "ON Changes.internalId = Resources.internalId WHERE seq>${since} ORDER BY seq " + suffix); |
574 | 574 |
575 statement.SetReadOnly(true); | 575 statement.SetReadOnly(true); |
576 statement.SetParameterType("limit", ValueType_Integer64); | 576 statement.SetParameterType("limit", ValueType_Integer64); |
577 statement.SetParameterType("since", ValueType_Integer64); | 577 statement.SetParameterType("since", ValueType_Integer64); |
669 suffix = "LIMIT 1"; | 669 suffix = "LIMIT 1"; |
670 } | 670 } |
671 | 671 |
672 DatabaseManager::CachedStatement statement( | 672 DatabaseManager::CachedStatement statement( |
673 STATEMENT_FROM_HERE, manager, | 673 STATEMENT_FROM_HERE, manager, |
674 "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Changes.date, " | 674 "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Resources.publicId, " |
675 "Resources.publicId FROM Changes INNER JOIN Resources " | 675 "Changes.date FROM Changes INNER JOIN Resources " |
676 "ON Changes.internalId = Resources.internalId ORDER BY seq DESC " + suffix); | 676 "ON Changes.internalId = Resources.internalId ORDER BY seq DESC " + suffix); |
677 | 677 |
678 statement.SetReadOnly(true); | 678 statement.SetReadOnly(true); |
679 | 679 |
680 Dictionary args; | 680 Dictionary args; |