Mercurial > hg > orthanc-databases

comparison Framework/Plugins/IndexBackend.cpp @ 301:2447c290fc73

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added unit test
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 08 Jul 2021 18:28:47 +0200
parents e55e4e8f9459
children 3a52e27a2d80
comparison
equal deleted inserted replaced
300:a116dbdf9118 301:2447c290fc73
733 statement.reset(new DatabaseManager::CachedStatement( 733 statement.reset(new DatabaseManager::CachedStatement(
734 STATEMENT_FROM_HERE, manager, 734 STATEMENT_FROM_HERE, manager,
735 "SELECT CAST(COUNT(*) AS BIGINT) FROM Resources WHERE resourceType=${type}")); 735 "SELECT CAST(COUNT(*) AS BIGINT) FROM Resources WHERE resourceType=${type}"));
736 break; 736 break;
737 737
738 case Dialect_MSSQL:
738 case Dialect_SQLite: 739 case Dialect_SQLite:
739 statement.reset(new DatabaseManager::CachedStatement( 740 statement.reset(new DatabaseManager::CachedStatement(
740 STATEMENT_FROM_HERE, manager, 741 STATEMENT_FROM_HERE, manager,
741 "SELECT COUNT(*) FROM Resources WHERE resourceType=${type}")); 742 "SELECT COUNT(*) FROM Resources WHERE resourceType=${type}"));
742 break; 743 break;
801 statement.reset(new DatabaseManager::CachedStatement( 802 statement.reset(new DatabaseManager::CachedStatement(
802 STATEMENT_FROM_HERE, manager, 803 STATEMENT_FROM_HERE, manager,
803 "SELECT CAST(COALESCE(SUM(compressedSize), 0) AS BIGINT) FROM AttachedFiles")); 804 "SELECT CAST(COALESCE(SUM(compressedSize), 0) AS BIGINT) FROM AttachedFiles"));
804 break; 805 break;
805 806
807 case Dialect_MSSQL:
806 case Dialect_SQLite: 808 case Dialect_SQLite:
807 statement.reset(new DatabaseManager::CachedStatement( 809 statement.reset(new DatabaseManager::CachedStatement(
808 STATEMENT_FROM_HERE, manager, 810 STATEMENT_FROM_HERE, manager,
809 "SELECT COALESCE(SUM(compressedSize), 0) FROM AttachedFiles")); 811 "SELECT COALESCE(SUM(compressedSize), 0) FROM AttachedFiles"));
810 break; 812 break;
838 statement.reset(new DatabaseManager::CachedStatement( 840 statement.reset(new DatabaseManager::CachedStatement(
839 STATEMENT_FROM_HERE, manager, 841 STATEMENT_FROM_HERE, manager,
840 "SELECT CAST(COALESCE(SUM(uncompressedSize), 0) AS BIGINT) FROM AttachedFiles")); 842 "SELECT CAST(COALESCE(SUM(uncompressedSize), 0) AS BIGINT) FROM AttachedFiles"));
841 break; 843 break;
842 844
845 case Dialect_MSSQL:
843 case Dialect_SQLite: 846 case Dialect_SQLite:
844 statement.reset(new DatabaseManager::CachedStatement( 847 statement.reset(new DatabaseManager::CachedStatement(
845 STATEMENT_FROM_HERE, manager, 848 STATEMENT_FROM_HERE, manager,
846 "SELECT COALESCE(SUM(uncompressedSize), 0) FROM AttachedFiles")); 849 "SELECT COALESCE(SUM(uncompressedSize), 0) FROM AttachedFiles"));
847 break; 850 break;
1797 STATEMENT_FROM_HERE, manager, 1800 STATEMENT_FROM_HERE, manager,
1798 "SELECT CAST(COUNT(*) AS BIGINT) FROM Resources")); 1801 "SELECT CAST(COUNT(*) AS BIGINT) FROM Resources"));
1799 break; 1802 break;
1800 1803
1801 case Dialect_SQLite: 1804 case Dialect_SQLite:
1805 case Dialect_MSSQL:
1802 statement.reset(new DatabaseManager::CachedStatement( 1806 statement.reset(new DatabaseManager::CachedStatement(
1803 STATEMENT_FROM_HERE, manager, 1807 STATEMENT_FROM_HERE, manager,
1804 "SELECT COUNT(*) FROM Resources")); 1808 "SELECT COUNT(*) FROM Resources"));
1805 break; 1809 break;
1806 1810