method

sanitize_sql_hash_for_conditions

v4.2.9 - Show latest stable - 0 notes - Class: ClassMethods

1.0.0
1.1.6
1.2.6
2.0.3
2.1.0
2.2.1
2.3.8
3.0.0
3.0.9
3.1.0
3.2.1 (0)
3.2.8 (0)
3.2.13 (0)
4.0.2 (-2)
4.1.8 (0)
4.2.1 (0)
4.2.7 (0)
4.2.9 (0)
5.0.0.1
5.1.7
5.2.3
6.0.0
6.1.3.1
6.1.7.7
7.0.0
7.1.3.2
7.1.3.4
What's this?

sanitize_sql_hash_for_conditions(attrs, default_table_name = self.table_name) protected

Sanitizes a hash of attribute/value pairs into SQL conditions for a WHERE clause.

{ name: "foo'bar", group_id: 4 }
  # => "name='foo''bar' and group_id= 4"
{ status: nil, group_id: [1,2,3] }
  # => "status IS NULL and group_id IN (1,2,3)"
{ age: 13..18 }
  # => "age BETWEEN 13 AND 18"
{ 'other_records.id' => 7 }
  # => "`other_records`.`id` = 7"
{ other_records: { id: 7 } }
  # => "`other_records`.`id` = 7"

And for value objects on a composed_of relationship:

{ address: Address.new("123 abc st.", "chicago") }
  # => "address_street='123 abc st.' and address_city='chicago'"

Show source

# File activerecord/lib/active_record/sanitization.rb, line 89
      def sanitize_sql_hash_for_conditions(attrs, default_table_name = self.table_name)
        ActiveSupport::Deprecation.warn(sanitize_sql_hash_for_conditions is deprecated, and will be removed in Rails 5.0)
        attrs = PredicateBuilder.resolve_column_aliases self, attrs
        attrs = expand_hash_conditions_for_aggregates(attrs)

        table = Arel::Table.new(table_name, arel_engine).alias(default_table_name)
        PredicateBuilder.build_from_hash(self, attrs, table).map { |b|
          connection.visitor.compile b
        }.join(' AND ')
      end

sanitize_sql_hash_for_conditions

Related methods