All pastes #484961 Raw Edit

Cory

public ruby v1 · immutable
·published 2007-05-12 19:54 UTC
rendered paste body
 def all_pulls    # move this off into static level business    query_map = Hash.new    query_map["pull_group_query"] = "select p.* from pulls p, pull_groups pg where p.pull_group_id = pg.id"    query_map["pull_group_title"] = "pg.title"    query_map["pull_group_date"]  = "pg.date"        query = query_map.has_key?(params[:sort]) ? query_map["pull_group_query"] : "select * from pulls"        if params[:sort]      order = "order by #{query_map.has_key?(params[:sort]) ? query_map[params[:sort]] : params[:sort]} #{params[:order]}"    end        @pull_pages, @pulls = paginate_collection Pull.find_by_sql("#{query} #{order}"), :page => params[:page]    render_action :list_pulls  end