X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/73d73c7b799ddb60363ddf409d8d301b27c82c00..c203e53c2929c2ddf1b079ec077364f8f4d23c40:/services/api/lib/load_param.rb diff --git a/services/api/lib/load_param.rb b/services/api/lib/load_param.rb index e01063d153..71678cd223 100644 --- a/services/api/lib/load_param.rb +++ b/services/api/lib/load_param.rb @@ -34,8 +34,10 @@ module LoadParam elsif params[:filters].is_a? String and !params[:filters].empty? begin f = Oj.load params[:filters] - raise unless f.is_a? Array - @filters += f + if not f.nil? + raise unless f.is_a? Array + @filters += f + end rescue raise ArgumentError.new("Could not parse \"filters\" param as an array") end @@ -69,7 +71,22 @@ module LoadParam @orders = [] if params[:order] - params[:order].split(',').each do |order| + od = [] + (case params[:order] + when String + if params[:order].starts_with? '[' + od = Oj.load(params[:order]) + raise unless od.is_a? Array + od + else + params[:order].split(',') + end + when Array + params[:order] + else + [] + end).each do |order| + order = order.to_s attr, direction = order.strip.split " " direction ||= 'asc' if attr.match /^[a-z][_a-z0-9]+$/ and @@ -79,9 +96,34 @@ module LoadParam end end end + if @orders.empty? - @orders << default_orders + @orders = default_orders + end + + case params[:select] + when Array + @select = params[:select] + when String + begin + @select = Oj.load params[:select] + raise unless @select.is_a? Array or @select.nil? + rescue + raise ArgumentError.new("Could not parse \"select\" param as an array") + end end + + if @select + # Any ordering columns must be selected when doing select, + # otherwise it is an SQL error, so filter out invaliding orderings. + @orders.select! { |o| + # match select column against order array entry + @select.select { |s| /^#{table_name}.#{s}( (asc|desc))?$/.match o }.any? + } + end + + @distinct = true if (params[:distinct] == true || params[:distinct] == "true") + @distinct = false if (params[:distinct] == false || params[:distinct] == "false") end