Module: SearchCop::Visitors::Postgres

Defined in:
lib/search_cop/visitors/postgres.rb

Defined Under Namespace

Classes: FulltextQuery

Instance Method Summary collapse

Instance Method Details

#visit_SearchCopGrammar_Attributes_Collection(node) ⇒ Object 



28
29
30
31
32
33
34
35
36
37
38
 
# File 'lib/search_cop/visitors/postgres.rb', line 28

def visit_SearchCopGrammar_Attributes_Collection(node)
  res = node.attributes.collect do |attribute|
    if attribute.options[:coalesce]
      "COALESCE(#{visit attribute}, '')"
    else
      visit attribute
    end
  end

  res.join(" || ' ' || ")
end

#visit_SearchCopGrammar_Nodes_FulltextExpression(node) ⇒ Object 



40
41
42
43
44
 
# File 'lib/search_cop/visitors/postgres.rb', line 40

def visit_SearchCopGrammar_Nodes_FulltextExpression(node)
  dictionary = node.collection.options[:dictionary] || "simple"

  "to_tsvector(#{visit dictionary}, #{visit node.collection}) @@ to_tsquery(#{visit dictionary}, #{visit FulltextQuery.new(connection).visit(node.node)})"
end

#visit_SearchCopGrammar_Nodes_Matches(node) ⇒ Object 



24
25
26
 
# File 'lib/search_cop/visitors/postgres.rb', line 24

def visit_SearchCopGrammar_Nodes_Matches(node)
  "(#{visit node.left} IS NOT NULL AND #{visit node.left} ILIKE #{visit node.right} ESCAPE #{visit "\\"})"
end