lib/ahoy/query_methods.rb in ahoy_matey-5.0.2 vs lib/ahoy/query_methods.rb in ahoy_matey-5.1.0
- old
+ new
@@ -12,11 +12,11 @@
adapter_name = respond_to?(:connection) ? connection.adapter_name.downcase : "mongoid"
case adapter_name
when "mongoid"
where(properties.to_h { |k, v| ["properties.#{k}", v] })
- when /mysql/
+ when /mysql|trilogy/
where("JSON_CONTAINS(properties, ?, '$') = 1", properties.to_json)
when /postgres|postgis/
case columns_hash["properties"].type
when :hstore
properties.inject(all) do |relation, (k, v)|
@@ -52,10 +52,10 @@
relation = all
adapter_name = respond_to?(:connection) ? connection.adapter_name.downcase : "mongoid"
case adapter_name
when "mongoid"
raise "Adapter not supported: #{adapter_name}"
- when /mysql/
+ when /mysql|trilogy/
props.each do |prop|
quoted_prop = connection.quote("$.#{prop}")
relation = relation.group("JSON_UNQUOTE(JSON_EXTRACT(properties, #{quoted_prop}))")
end
when /postgres|postgis/