How to save a hash or json string into a jsonb field

Question

I have a json string from my active admin from "{\"en\":\"Lorem\"}"

I want to save this in my question.name field, which is of postgres jsonb type.

class Question < ActiveRecord::Base
  serialize :name
end

# db/schema.rb
create_table "preset_questions", force: :cascade do |t|
  t.jsonb    "name",               default: {}
end

I've tried the following:

question.update(name:"{\"en\":\"Lorem\"}")
question.update(name:JSON.parse("{\"en\":\"Lorem\"}"))

Result for both:

question.name
=> nil

Answer 1

Got it to work by removing serialize :name. Looks like rails already knows what to do given that the column type is jsonb

class Question < ActiveRecord::Base
end

# db/schema.rb
create_table "preset_questions", force: :cascade do |t|
  t.jsonb    "name",               default: {} 
end

question.update(name:"{\"en\":\"Lorem\"}")
question.update(name:JSON.parse("{\"en\":\"Lorem\"}"))

Both return

question.name
=> {"en"=>"lorem", "id"=>"ipsum"}