Methods enabling Database object integration with the json type.
Parse JSON data coming from the database. Since PostgreSQL allows non JSON data in JSON fields (such as plain numbers and strings), we don’t want to raise an exception for that.
# File lib/sequel/extensions/pg_json.rb, line 147 def self.db_parse_json(s) parse_json(s) rescue Sequel::InvalidValue raise unless s.is_a?(String) parse_json("[#{s}]").first end
Same as ::db_parse_json, but consider the input as jsonb.
# File lib/sequel/extensions/pg_json.rb, line 155 def self.db_parse_jsonb(s) parse_json(s, true) rescue Sequel::InvalidValue raise unless s.is_a?(String) parse_json("[#{s}]").first end
# File lib/sequel/extensions/pg_json.rb, line 136 def self.extended(db) db.instance_eval do copy_conversion_procs([114, 199, 3802, 3807]) @schema_type_classes[:json] = [JSONHash, JSONArray] @schema_type_classes[:jsonb] = [JSONBHash, JSONBArray] end end
Parse the given string as json, returning either a JSONArray or JSONHash instance (or JSONBArray or JSONBHash instance if jsonb argument is true), or a String, Numeric, true, false, or nil if the json library used supports that.
# File lib/sequel/extensions/pg_json.rb, line 166 def self.parse_json(s, jsonb=false) begin value = Sequel.parse_json(s) rescue Sequel.json_parser_error_class => e raise Sequel.convert_exception_class(e, Sequel::InvalidValue) end case value when Array (jsonb ? JSONBArray : JSONArray).new(value) when Hash (jsonb ? JSONBHash : JSONHash).new(value) when String, Numeric, true, false, nil value else raise Sequel::InvalidValue, "unhandled json value: #{value.inspect} (from #{s.inspect})" end end