Mercurial > hg > orthanc-databases

comparison Framework/Plugins/IndexBackend.cpp @ 326:4454545bb265

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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;