diff OrthancServer/Sources/Database/SQLiteDatabaseWrapper.cpp @ 5567:f3562c1a150d find-refactoring

FindRequest: group metadata and tag constrains in a single class, allow ordering against metadata
author Alain Mazy <am@orthanc.team>
date Tue, 23 Apr 2024 16:49:44 +0200
parents 12d8a1a266e9
children b0b5546f1b9f
line wrap: on
line diff
--- a/OrthancServer/Sources/Database/SQLiteDatabaseWrapper.cpp	Tue Apr 23 14:37:11 2024 +0200
+++ b/OrthancServer/Sources/Database/SQLiteDatabaseWrapper.cpp	Tue Apr 23 16:49:44 2024 +0200
@@ -1143,8 +1143,22 @@
     virtual void ExecuteFind(FindResponse& response,
                              const FindRequest& request) ORTHANC_OVERRIDE
     {
+#if 1
       Compatibility::GenericFind find(*this);
       find.Execute(response, request);
+#else
+      {
+        SQLite::Statement s(db_, SQLITE_FROM_HERE, "DROP TABLE IF EXISTS FilteredResourcesIds");
+        s.Run();
+      }
+
+      {
+        std::string sql;
+        // sql = "CREATE TEMPORARY TABLE FilteredResourcesIds AS ";
+        sql = "..";
+        SQLite::Statement s(db_, SQLITE_FROM_HERE_DYNAMIC(sql), sql);
+      }
+#endif
     }
   };