orthanc-databases: Framework/Plugins/IndexBackend.cpp comparison

sync ISqlLookupFormatter from Orthanc + fix bug 224: LIMIT shall not be used with MSSQL

comparison

equal deleted inserted replaced

-:03a4a1bc852a
+:4ecf50a4521c
 default:
 throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented);
 }
 }
+virtual std::string FormatLimits(uint64_t since, uint64_t count)
+{
+std::string sql;
+switch (dialect_)
+{
+case Dialect_MSSQL:
+{
+if (since > 0)
+{
+sql += " OFFSET " + boost::lexical_cast<std::string>(since) + " ROWS ";
+}
+if (count > 0)
+{
+sql += " FETCH NEXT " + boost::lexical_cast<std::string>(count) + " ROWS ONLY ";
+}
+}; break;
+case Dialect_SQLite:
+case Dialect_PostgreSQL:
+case Dialect_MySQL:
+{
+if (count > 0)
+{
+sql += " LIMIT " + boost::lexical_cast<std::string>(count);
+}
+if (since > 0)
+{
+sql += " OFFSET " + boost::lexical_cast<std::string>(since);
+}
+}; break;
+default:
+throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented);
+}
+return sql;
+}
 virtual bool IsEscapeBrackets() const
 {
 // This was initially done at a bad location by the following changeset:
 // https://orthanc.uclouvain.be/hg/orthanc-databases/rev/389c037387ea
 return (dialect_ == Dialect_MSSQL);
 #if ORTHANC_PLUGINS_HAS_DATABASE_CONSTRAINT == 1
 // New primitive since Orthanc 1.5.2
 void IndexBackend::LookupResources(IDatabaseBackendOutput& output,
 DatabaseManager& manager,
-const std::vector<Orthanc::DatabaseConstraint>& lookup,
+Orthanc::DatabaseConstraints& lookup,
 OrthancPluginResourceType queryLevel_,
 const std::set<std::string>& labels,
 Orthanc::LabelsConstraint labelsConstraint,
 uint32_t limit,
 bool requestSomeInstance)

Mercurial > hg > orthanc-databases