Module: Sequel::Postgres::JSONDatabaseMethods

Defined in:
lib/sequel/extensions/pg_json.rb

Overview

Methods enabling Database object integration with the json type.

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.extended(db) ⇒ Object

Reset the conversion procs when extending the Database object, so it will pick up the json convertor. This is only done for the native postgres adapter.



109
110
111
 
# File 'lib/sequel/extensions/pg_json.rb', line 109

def self.extended(db)
  db.reset_conversion_procs if db.respond_to?(:reset_conversion_procs)
end

.parse_json(s) ⇒ Object

Parse the given string as json, returning either a JSONArray or JSONHash instance, and raising an error if the JSON parsing does not yield an array or hash.



89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
 
# File 'lib/sequel/extensions/pg_json.rb', line 89

def self.parse_json(s)
  begin
    value = JSON.parse(s)
  rescue JSON::ParserError=>e
    raise Sequel.convert_exception_class(e, Sequel::InvalidValue)
  end

  case value
  when Array
    JSONArray.new(value)
  when Hash 
    JSONHash.new(value)
  else
    raise Sequel::InvalidValue, "unhandled json value: #{value.inspect} (from #{s.inspect})"
  end
end

Instance Method Details

#bound_variable_arg(arg, conn) ⇒ Object

Handle JSONArray and JSONHash in bound variables



114
115
116
117
118
119
120
121
 
# File 'lib/sequel/extensions/pg_json.rb', line 114

def bound_variable_arg(arg, conn)
  case arg
  when JSONArray, JSONHash
    arg.to_json
  else
    super
  end
end

#schema_column_type(db_type) ⇒ Object

Make the column type detection recognize the json type.



124
125
126
127
128
129
130
131
 
# File 'lib/sequel/extensions/pg_json.rb', line 124

def schema_column_type(db_type)
  case db_type
  when 'json'
    :json
  else
    super
  end
end