The previous version was using IN and passing an array which will exact match. Unfortunately, as far as I'm aware, there is no equivalent ILIKE IN so we need to build the query up manually.
Array.new(size, value) initializes a new array of strings with the value 'name ILIKE ?' equivalent to the number of drug names passed in.
value.map {|v| "#{v}%"} tacks on the % for left anchored wildcard matching to each search term, and then the * splats those terms out into parameters to the where clause. So you end up with something that will look like
scope.where("name ILIKE ? OR name ILIKE ?", 'foo', 'bar'). This allows us to dynamically build the query while still using ActiveRecord's built in query parameterization/escaping.
closes #476
The previous version was using
INand passing an array which will exact match. Unfortunately, as far as I'm aware, there is no equivalentILIKE INso we need to build the query up manually.Array.new(size, value)initializes a new array of strings with the value'name ILIKE ?'equivalent to the number of drug names passed in.value.map {|v| "#{v}%"}tacks on the%for left anchored wildcard matching to each search term, and then the*splats those terms out into parameters to thewhereclause. So you end up with something that will look likescope.where("name ILIKE ? OR name ILIKE ?", 'foo', 'bar'). This allows us to dynamically build the query while still using ActiveRecord's built in query parameterization/escaping.