Module: Card::Query::Run
- Included in:
- Card::Query
- Defined in:
- lib/card/query/run.rb
Instance Method Summary collapse
- #alter_result(name) ⇒ Object
- #alter_results? ⇒ Boolean
- #card_result(record, _field) ⇒ Object
- #count_result(results, _field) ⇒ Object
- #default_result(record, field) ⇒ Object
- #fetch_or_instantiate(record) ⇒ Object
- #id_result(record, field) ⇒ Object
- #large_list(length) ⇒ Object
- #name_result(record, pattern) ⇒ Object
- #process_name(name, pattern) ⇒ Object
- #raw_result(record, _field) ⇒ Object
- #result_method(retrn) ⇒ Object
- #return_list(sql_results, retrn) ⇒ Array
- #return_simple(sql_result, retrn) ⇒ (not an Array)
-
#run ⇒ Object
run the current query.
- #run_sql ⇒ Object
- #simple_result?(retrn) ⇒ Boolean
Instance Method Details
#alter_result(name) ⇒ Object
93 94 95 96 |
# File 'lib/card/query/run.rb', line 93 def alter_result name name_parts = [statement[:prepend], name, statement[:append]].compact Card::Name[name_parts] end |
#alter_results? ⇒ Boolean
102 103 104 |
# File 'lib/card/query/run.rb', line 102 def alter_results? statement[:prepend] || statement[:append] end |
#card_result(record, _field) ⇒ Object
63 64 65 66 67 68 69 |
# File 'lib/card/query/run.rb', line 63 def card_result record, _field if alter_results? Card.fetch alter_result(record["name"]), new: {} else fetch_or_instantiate record end end |
#count_result(results, _field) ⇒ Object
43 44 45 |
# File 'lib/card/query/run.rb', line 43 def count_result results, _field results.first["count"].to_i end |
#default_result(record, field) ⇒ Object
47 48 49 |
# File 'lib/card/query/run.rb', line 47 def default_result record, field record[field] end |
#fetch_or_instantiate(record) ⇒ Object
71 72 73 74 75 76 77 78 79 |
# File 'lib/card/query/run.rb', line 71 def fetch_or_instantiate record card = Card.retrieve_from_cache record["key"] unless card card = Card.instantiate record Card.write_to_cache card, {} end card.include_set_modules card end |
#id_result(record, field) ⇒ Object
51 52 53 |
# File 'lib/card/query/run.rb', line 51 def id_result record, field record[field].to_i end |
#large_list(length) ⇒ Object
30 31 32 |
# File 'lib/card/query/run.rb', line 30 def large_list length Rails.logger.info "#{length} records returned by #{@statement}" end |
#name_result(record, pattern) ⇒ Object
59 60 61 |
# File 'lib/card/query/run.rb', line 59 def name_result record, pattern process_name record["name"], pattern end |
#process_name(name, pattern) ⇒ Object
87 88 89 90 91 |
# File 'lib/card/query/run.rb', line 87 def process_name name, pattern name = pattern.to_name.absolute(name) if pattern =~ /_\w+/ return name unless alter_results? alter_result name end |
#raw_result(record, _field) ⇒ Object
55 56 57 |
# File 'lib/card/query/run.rb', line 55 def raw_result record, _field record end |
#result_method(retrn) ⇒ Object
34 35 36 37 38 39 40 41 |
# File 'lib/card/query/run.rb', line 34 def result_method retrn case when respond_to?(:"#{retrn}_result") then :"#{retrn}_result" when (retrn =~ /id$/) then :id_result when (retrn =~ /_\w+/) then :name_result else :default_result end end |
#return_list(sql_results, retrn) ⇒ Array
23 24 25 26 27 28 |
# File 'lib/card/query/run.rb', line 23 def return_list sql_results, retrn large_list sql_results.length if sql_results.length > 1000 sql_results.map do |record| return_simple record, retrn end end |
#return_simple(sql_result, retrn) ⇒ (not an Array)
18 19 20 |
# File 'lib/card/query/run.rb', line 18 def return_simple sql_result, retrn send result_method(retrn), sql_result, retrn end |
#run ⇒ Object
run the current query
11 12 13 14 15 |
# File 'lib/card/query/run.rb', line 11 def run retrn = statement[:return].present? ? statement[:return].to_s : "card" return_method = :"return_#{simple_result?(retrn) ? :simple : :list}" send return_method, run_sql, retrn end |
#run_sql ⇒ Object
81 82 83 84 85 |
# File 'lib/card/query/run.rb', line 81 def run_sql # puts "\nstatement = #{@statement}" # puts "sql = #{sql}" ActiveRecord::Base.connection.select_all(sql) end |
#simple_result?(retrn) ⇒ Boolean
98 99 100 |
# File 'lib/card/query/run.rb', line 98 def simple_result? retrn retrn == "count" end |