My Product model has a jsonb field specs (which we're managing using ActiveRecord's store_accessor). Many of my products' specs have a spec in that hash called spec_options.
Before now, this spec_option field was just text. Now it needs to be an array.
The scope used before now to query products for this field was this:
scope :with_spec_options, ->(spec_options) {
where("'#{spec_options}'::jsonb \? (specs->>'spec_option')")
}
Ruby equivalent (just to help understand what this is doing):
select{ |product| spec_options.include?(product.specs['spec_option']) }
ActiveRecord equivalent (if spec_option were a regular column):
where(spec_option: spec_options)
However, now that specs['spec_options'] is an array, I can't do that. I think I need to use postgres' ?| jsonb operator, but I can't work out how to get the right side of this operation into the correct format.
Ruby equivalent:
def self.with_spec_options(spec_options)
all.select{|product|
if product.specs['spec_options'].present?
product.specs['spec_options'].any?{|option|
spec_options.include?(option)
}
else
false
end
}
end
Anyone got ideas?
