aboutsummaryrefslogtreecommitdiffstats
path: root/app/controllers/admin/blog/posts_controller.rb
diff options
context:
space:
mode:
Diffstat (limited to 'app/controllers/admin/blog/posts_controller.rb')
-rw-r--r--app/controllers/admin/blog/posts_controller.rb16
1 files changed, 14 insertions, 2 deletions
diff --git a/app/controllers/admin/blog/posts_controller.rb b/app/controllers/admin/blog/posts_controller.rb
index 9fdc638..29ffb01 100644
--- a/app/controllers/admin/blog/posts_controller.rb
+++ b/app/controllers/admin/blog/posts_controller.rb
@@ -12,9 +12,21 @@ class Admin::Blog::PostsController < Admin::BaseController
end
def tags
+ op = case ActiveRecord::Base.connection.adapter_name.downcase
+ when 'postgresql'
+ 'SIMILAR TO'
+ else
+ 'LIKE'
+ end
+ wildcard = case ActiveRecord::Base.connection.adapter_name.downcase
+ when 'postgresql'
+ '.*'
+ else
+ '%'
+ end
@tags = BlogPost.tag_counts_on(:tags).where(
- ["tags.name LIKE ?", "%#{params[:term].to_s.downcase}%"]
- ).map { |tag| {:id => tag.id, :value => tag.name}}
+ ["tags.name #{op} ?", "#{wildcard}#{params[:term].to_s.downcase}#{wildcard}"]
+ ).map { |tag| {:id => tag.id, :value => tag.name}}
render :json => @tags.flatten
end