Module: Nativeson
- Defined in:
- lib/nativeson.rb,
lib/nativeson/railtie.rb,
lib/nativeson/version.rb
Defined Under Namespace
Classes: Railtie
Constant Summary collapse
- VERSION =
'0.1.1'
Class Method Summary collapse
- .fetch_json_by_query_hash(query_hash) ⇒ Object
- .fetch_json_by_rails_query(rails_query) ⇒ Object
- .fetch_json_by_string(string) ⇒ Object
Class Method Details
.fetch_json_by_query_hash(query_hash) ⇒ Object
5 6 7 8 9 10 11 12 13 14 15 |
# File 'lib/nativeson.rb', line 5 def self.fetch_json_by_query_hash(query_hash) nativeson_hash = {} nativeson_hash[:query_hash] = query_hash nativeson_hash[:container] = NativesonContainer.new(container_type: :base, query: nativeson_hash[:query_hash], parent: nil) sql = nativeson_hash[:container].generate_sql nativeson_hash[:sql] = sql result = ActiveRecord::Base.connection.execute(sql) nativeson_hash[:json] = result.getvalue(0, 0) result.clear return nativeson_hash end |
.fetch_json_by_rails_query(rails_query) ⇒ Object
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
# File 'lib/nativeson.rb', line 17 def self.fetch_json_by_rails_query(rails_query) if rails_query.respond_to?(:to_sql) nativeson_hash = {} nativeson_hash[:sql] = " SELECT JSON_AGG(t) FROM ( #{rails_query.to_sql} ) t;" result = ActiveRecord::Base.connection.execute(nativeson_hash[:sql]) nativeson_hash[:json] = result.getvalue(0, 0) result.clear return nativeson_hash else raise ArgumentError.new("#{__method__} input doesn't respond to :to_sql") end end |
.fetch_json_by_string(string) ⇒ Object
35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
# File 'lib/nativeson.rb', line 35 def self.fetch_json_by_string(string) if string.is_a?(String) nativeson_hash = {} nativeson_hash[:sql] = " SELECT JSON_AGG(t) FROM ( #{string} ) t;" result = ActiveRecord::Base.connection.execute(nativeson_hash[:sql]) nativeson_hash[:json] = result.getvalue(0, 0) result.clear return nativeson_hash else raise ArgumentError.new("#{__method__} input isn't a String") end end |