Merge pull request #28608 from nextcloud/path-prefix-filter

generate a better optimized query for path prefix search filters

2 files changed, 20 insertions, 0 deletions

diff --git a/lib/public/Files/Search/ISearchComparison.php b/lib/public/Files/Search/ISearchComparison.php
index 36d10824653..8ebaeced304 100644
--- a/lib/public/Files/Search/ISearchComparison.php
+++ b/lib/public/Files/Search/ISearchComparison.php
@@ -35,6 +35,8 @@ interface ISearchComparison extends ISearchOperator {
 	public const COMPARE_LIKE = 'like';
 	public const COMPARE_LIKE_CASE_SENSITIVE = 'clike';
 
+	public const HINT_PATH_EQ_HASH = 'path_eq_hash'; // transform `path = "$path"` into `path_hash = md5("$path")`, on by default
+
 	/**
 	 * Get the type of comparison, one of the ISearchComparison::COMPARE_* constants
 	 *
diff --git a/lib/public/Files/Search/ISearchOperator.php b/lib/public/Files/Search/ISearchOperator.php
index bcf2fb86573..1799b97c1ca 100644
--- a/lib/public/Files/Search/ISearchOperator.php
+++ b/lib/public/Files/Search/ISearchOperator.php
@@ -26,4 +26,22 @@ namespace OCP\Files\Search;
  * @since 12.0.0
  */
 interface ISearchOperator {
+	/**
+	 * Get a query builder hint by name
+	 *
+	 * @param string $name
+	 * @param $default
+	 * @return mixed
+	 * @since 23.0.0
+	 */
+	public function getQueryHint(string $name, $default);
+
+	/**
+	 * Get a query builder hint
+	 *
+	 * @param string $name
+	 * @param $value
+	 * @since 23.0.0
+	 */
+	public function setQueryHint(string $name, $value): void;
 }