Mercurial > hg > orthanc-databases
comparison Framework/Plugins/IndexBackend.cpp @ 301:2447c290fc73
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 |