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/client_side_validations/active_record/middleware.rb', line 8
def self.is_unique?(klass, attribute, value, params)
value = type_cast_value(klass, attribute, value)
column = klass.columns_hash[attribute.to_s]
value = column.limit ? value.to_s.mb_chars[0, column.limit] : value.to_s if column.text?
t = klass.arel_table
if params[:case_sensitive] == 'true'
if t.engine.connection.instance_variable_get("@config")[:adapter] == 'mysql'
relation = Arel::Nodes::SqlLiteral.new("BINARY #{t[attribute].eq(value).to_sql}")
else
relation = t[attribute].eq(value)
end
else
relation = t[attribute].matches(value)
end
if relation.is_a?(Arel::Nodes::SqlLiteral)
relation = Arel::Nodes::SqlLiteral.new("BINARY #{t[attribute].eq(value).to_sql} AND #{t.primary_key.not_eq(params[:id]).to_sql}")
else
relation = relation.and(t.primary_key.not_eq(params[:id])) if params[:id]
end
(params[:scope] || {}).each do |attribute, value|
value = type_cast_value(klass, attribute, value)
if relation.is_a?(Arel::Nodes::SqlLiteral)
relation = Arel::Nodes::SqlLiteral.new("#{relation} AND #{t[attribute].eq(value).to_sql}")
else
relation = relation.and(t[attribute].eq(value))
end
end
!klass.where(relation).exists?
end
|