class PatternQueryHelper::Sql
Constants
- QUERY_COUNT_COLUMN
Public Class Methods
single_record_query(config)
click to toggle source
# File lib/pattern_query_helper/sql.rb, line 35 def self.single_record_query(config) results = sql_query(config) results.first end
sql_query(config)
click to toggle source
# File lib/pattern_query_helper/sql.rb, line 4 def self.sql_query(config) model = config[:model] query_params = config[:query_params] || {} page = config[:page] per_page = config[:per_page] filter_params = config[:filter_params] || {} if page && per_page query_params[:limit] = per_page query_params[:offset] = (page - 1) * per_page limit = "limit :limit offset :offset" end full_count_join = "cross join (select count(*) as #{QUERY_COUNT_COLUMN} from filtered_query) as filtered_query_count" if page || per_page query_params = query_params.merge(filter_params).symbolize_keys sql = %( with filtered_query as (#{filtered_query(config)}) select * from filtered_query #{full_count_join} #{limit} ) model.find_by_sql([sql, query_params]) end
sql_query_count(sql_query_results)
click to toggle source
# File lib/pattern_query_helper/sql.rb, line 31 def self.sql_query_count(sql_query_results) sql_query_results.empty? ? 0 : sql_query_results.first[QUERY_COUNT_COLUMN] end
Private Class Methods
filtered_query(config)
click to toggle source
# File lib/pattern_query_helper/sql.rb, line 42 def self.filtered_query(config) query = config[:query] filter_string = config[:filter_string] sort_string = config[:sort_string] sort_string = "order by #{sort_string}" if !sort_string.blank? sql = %( with query as (#{query}) select * from query #{filter_string} #{sort_string} ) end