Module: DbMod::Statements::Configuration::As::Json

Defined in:
lib/db_mod/statements/configuration/as/json.rb

Overview

Coercer which converts an SQL result set into a string formatted as a JSON array. May be enabled for a prepared method or statement method using .as(:json):

def_statement(:a, 'SELECT a, b FROM foo').as(:json)
def_prepared(:b, 'SELECT b, c FROM bar').as(:json)

def do_stuff
 a # => '[{"a":"x","b":"y"},...]'
end

Class Method Summary collapse

Class Method Details

.call(results) ⇒ String

Enables this module to be passed to DbMod::Statements::Configuration.process_method_results as the wrapper function, in which case it will retrieve the results and format them as a JSON string using the column names from the result set for the keys of each object.

Parameters:

  • results (Object) —

    SQL result set

Returns:

  • (String) —

    a JSON formatted string



25
26
27
28
 
# File 'lib/db_mod/statements/configuration/as/json.rb', line 25

def self.call(results)
  # .map turns the result object into an array
  results.map { |x| x }.to_json
end