class Arel::Visitors::PostgreSQL

Private Instance Methods

visit_Arel_Nodes_ContainedWithin(o, a = nil) click to toggle source
# File lib/postgres_ext/arel/4.1/visitors/postgresql.rb, line 36
def visit_Arel_Nodes_ContainedWithin o, a = nil
  "#{visit o.left, a} << #{visit o.right, o.left}"
end
visit_Arel_Nodes_ContainedWithinEquals(o, a = nil) click to toggle source
# File lib/postgres_ext/arel/4.1/visitors/postgresql.rb, line 40
def visit_Arel_Nodes_ContainedWithinEquals o, a = nil
  "#{visit o.left, a} <<= #{visit o.right, o.left}"
end
visit_Arel_Nodes_Contains(o, a = nil) click to toggle source
# File lib/postgres_ext/arel/4.1/visitors/postgresql.rb, line 26
def visit_Arel_Nodes_Contains o, a = nil
  left_column = o.left.relation.engine.columns.find { |col| col.name == o.left.name.to_s }
  
  if left_column && (left_column.type == :hstore || (left_column.respond_to?(:array) && left_column.array))
    "#{visit o.left, a} @> #{visit o.right, o.left}"
  else
    "#{visit o.left, a} >> #{visit o.right, o.left}"
  end
end
visit_Arel_Nodes_ContainsArray(o, a = nil) click to toggle source
# File lib/postgres_ext/arel/4.1/visitors/postgresql.rb, line 44
def visit_Arel_Nodes_ContainsArray o, a = nil
  "#{visit o.left, a} @> #{visit o.right, o.left}"
end
visit_Arel_Nodes_ContainsEquals(o, a = nil) click to toggle source
# File lib/postgres_ext/arel/4.1/visitors/postgresql.rb, line 56
def visit_Arel_Nodes_ContainsEquals o, a = nil
  "#{visit o.left, a} >>= #{visit o.right, o.left}"
end
visit_Arel_Nodes_ContainsHStore(o, a = nil) click to toggle source
# File lib/postgres_ext/arel/4.1/visitors/postgresql.rb, line 48
def visit_Arel_Nodes_ContainsHStore o, a = nil
  "#{visit o.left, a} @> #{visit o.right, o.left}"
end
visit_Arel_Nodes_ContainsINet(o, a = nil) click to toggle source
# File lib/postgres_ext/arel/4.1/visitors/postgresql.rb, line 52
def visit_Arel_Nodes_ContainsINet o, a = nil
  "#{visit o.left, a} >> #{visit o.right, o.left}"
end
visit_Arel_Nodes_Overlap(o, a = nil) click to toggle source
# File lib/postgres_ext/arel/4.1/visitors/postgresql.rb, line 60
def visit_Arel_Nodes_Overlap o, a = nil
  "#{visit o.left, a} && #{visit o.right, o.left}"
end
visit_Array(o, a) click to toggle source
# File lib/postgres_ext/arel/4.1/visitors/postgresql.rb, line 8
def visit_Array o, a
  column = case a.try(:relation)
           when Arel::Nodes::TableAlias, NilClass
           # noop Prevent from searching for table alias name in schema cache
           # which won't exist for aliased table when used with Single Table
           # Inheritance. see dockyard/postgres_ext#154
           else
             a.relation.engine.connection.schema_cache.columns(a.relation.name)
               .find { |col| col.name == a.name.to_s }
           end
  
  if column && column.respond_to?(:array) && column.array
    quoted o, a
  else
    o.empty? ? 'NULL' : o.map { |x| visit x }.join(', ')
  end
end
visit_IPAddr(value, a = nil) click to toggle source
# File lib/postgres_ext/arel/4.1/visitors/postgresql.rb, line 64
def visit_IPAddr value, a = nil
  "'#{value.to_s}/#{value.instance_variable_get(:@mask_addr).to_s(2).count('1')}'"
end