From 9e203582b367a1b84035572261a79b62e22bfeaa Mon Sep 17 00:00:00 2001
From: Hiroyuki Sato <sathiroyuki@gmail.com>
Date: Wed, 23 Aug 2017 01:51:53 +0900
Subject: Improve AutocompleteController#user.json performance

---
 lib/gitlab/sql/pattern.rb | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 lib/gitlab/sql/pattern.rb

(limited to 'lib/gitlab/sql')

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
-- 
cgit v1.2.3