Improve AutocompleteController#user.json performance

1 files changed, 29 insertions, 0 deletions

diff --git a/lib/gitlab/sql/pattern.rb b/lib/gitlab/sql/pattern.rb
new file mode 100644
index 00000000000..47ea19994a2
--- /dev/null
+++ b/lib/gitlab/sql/pattern.rb
@@ -0,0 +1,29 @@
+module Gitlab
+  module SQL
+    class Pattern
+      MIN_CHARS_FOR_PARTIAL_MATCHING = 3
+
+      attr_reader :query
+
+      def initialize(query)
+        @query = query
+      end
+
+      def to_sql
+        if exact_matching?
+          query
+        else
+          "%#{query}%"
+        end
+      end
+
+      def exact_matching?
+        !partial_matching?
+      end
+
+      def partial_matching?
+        @query.length >= MIN_CHARS_FOR_PARTIAL_MATCHING
+      end
+    end
+  end
+end