Class: E9Tags::Rack::TagAutoCompleter

Inherits:
Object
  • Object
show all
Defined in:
lib/e9_tags/rack/tag_auto_completer.rb

Constant Summary collapse

DEFAULT_LIMIT = 
10

Class Method Summary collapse

Class Method Details

.call(env) ⇒ Object 



5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
# File 'lib/e9_tags/rack/tag_auto_completer.rb', line 5

def self.call(env)
  if env["PATH_INFO"] =~ /^\/autocomplete\/tags/
    terms = []
    @params = Rack::Request.new(env).params
    
    if @term = @params['term']
      tags, taggings = ::Tag.arel_table, ::Tagging.arel_table

      relation = tags.join(taggings).on(tags[:id].eq(taggings[:tag_id])).
                 where(tags[:name].matches("#{@term}%")).
                 group(tags[:id]).
                 take(@params['limit'] ? @params['limit'].to_i : DEFAULT_LIMIT).
                 project(tags[:name], tags[:name].count.as('count')).
                 #having('count > 0'). # having count > 0 is unnecessary because of the join type
                 order('name ASC')

      if @context = @params['context']
        relation = relation.where(taggings[:context].matches(E9Tags.escape_context(@context))) 
      end

      if @except = @params['except']
        relation = relation.where(tags[:name].not_in(@except))
      end

      # NOTE this select is stolen from Arel::SelectManager's deprecated to_a method, but since Arel has been re-written
      #      (and even before that) it'd probably be smarter here to avoid arel tables and just use AR and to_json
      #   
      terms = ::ActiveRecord::Base.connection.send(:select, relation.to_sql, 'Tag Autocomplete').map do |row| 
        { :label => "#{row['name']} - #{row['count']}", :value => row['name'], :count => row['count'] }
      end
    end

    [200, {"Content-Type" => "application/json", "Cache-Control" => "max-age=3600, must-revalidate"}, [terms.to_json]]
  else
    [404, {"Content-Type" => "text/html", "X-Cascade" => "pass"}, ["Not Found"]]
  end
end