Module: SearchCop::Visitors::Postgres
- Defined in:
- lib/search_cop/visitors/postgres.rb
Defined Under Namespace
Classes: FulltextQuery
Instance Method Summary collapse
- #visit_SearchCopGrammar_Attributes_Collection(node) ⇒ Object
- #visit_SearchCopGrammar_Nodes_FulltextExpression(node) ⇒ Object
- #visit_SearchCopGrammar_Nodes_Matches(node) ⇒ Object
Instance Method Details
#visit_SearchCopGrammar_Attributes_Collection(node) ⇒ Object
27 28 29 30 31 32 33 34 35 36 37 |
# File 'lib/search_cop/visitors/postgres.rb', line 27 def visit_SearchCopGrammar_Attributes_Collection(node) res = node.attributes.collect do |attribute| if attribute.[:coalesce] "COALESCE(#{visit attribute}, '')" else visit attribute end end res.join(" || ' ' || ") end |
#visit_SearchCopGrammar_Nodes_FulltextExpression(node) ⇒ Object
39 40 41 42 43 |
# File 'lib/search_cop/visitors/postgres.rb', line 39 def visit_SearchCopGrammar_Nodes_FulltextExpression(node) dictionary = node.collection.[: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
23 24 25 |
# File 'lib/search_cop/visitors/postgres.rb', line 23 def visit_SearchCopGrammar_Nodes_Matches(node) "(#{visit node.left} IS NOT NULL AND #{visit node.left} ILIKE #{visit node.right})" end |