Rails 4 : Saving value as JSON string object/array in PostgreSQL

Question

I have 1 column called 'message_notification' inside table 'configuration'. I want to produce save result as JSON object in this column:

message_notification: [
  {
    "alert" : "how are you doing today?"
  },
  {
    "alert" : "where have you been today?"
  }
]

for the form, i use

<%= simple_form_for(@configuration) do |f| %>
  Alert 1: <%= check_box_tag "configuration[message_notification][][alert]", 'how are you doing today?' %><label>Alert 1</label><br/>
  Alert 2: <%= check_box_tag "configuration[message_notification][][alert]", 'where have you been today?' %><label>Alert 2</label><br/>
  <%= f.submit %>
<% end %>

How to achieve this?

[UPDATED]

above code will resolve as a ruby hash (not as JSON)

my controller

@configuration.message_notification = {
  alert: params[:message][:alert]
}.to_json

result:

message_notification: [
  {
    "alert" => "how are you doing today?"
  },
  {
    "alert" => "where have you been today?"
  }
]

[UPDATED 2]

In console:

=> a = value.message_notification
=> "[{\"alert\"=>\"alert1\"}, {\"alert\"=>\"alert2\"}]"
=> puts a
=> [{"alert"=>"alert1"}, {"alert"=>"alert2"}]
=> nil

@Sravan yup i did that in my controller.. but still produce =>.. see my updated above — Amirol Ahmad
– Amirol Ahmad, Commented Dec 1, 2016 at 5:49
check, puts { 'alert' => params[:message][:alert] }.to_json — Sravan
– Sravan, Commented Dec 1, 2016 at 6:02

Sravan · Accepted Answer · 2016-12-01 08:09:50Z

2

You can use, to_json to convert the ruby hash to JSON object

just require 'json' in your controller.

params = {"utf8"=>"✓", "_method"=>"new", "authenticity_token"=>"txroAHF2+YZOrm48DtBZdVqKzxLYyHFq4+GWQFnM6kNldXgRZJMPv0yfj‌0/tfZVpuVvh39UVX4Fb66FNkkCZqA==", "message"=>{"name"=>"Dan Murphy Roundabout Test", "company"=>"transtech", "location_id"=>"", "message_notification"=>[{"alert"=>"alert1"}, {"alert"=>"alert2"}], "commit"=>"save", "controller"=>"message", "action"=>"create", "id"=>"1717"}}

Since your params object is above, according to your requirement you can use,

params['message']['message_notification'] = (params['message']['message_notification'].to_json)

this converts the message_notification in the params to a json object, and stores in the DB.

answered Dec 1, 2016 at 8:09

Sravan

18.7k3 gold badges33 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jason Swett Over a year ago

It's not clear to me exactly where params['message']['message_notification'] = (params['message']['message_notification'].to_json) goes.

Jason Swett · Accepted Answer · 2019-03-21 13:08:49Z

1

Here's what I did.

  def resource_params
    params.require(:appointment_modules_dataset_intake).permit(
      :appointment_id,
      :main_issue,
      :cvf
    ).tap do |p|
      p[:cvf] = JSON.parse(p[:cvf]) # This is the significant line
    end
  end

answered Mar 21, 2019 at 13:08

Jason Swett

45.4k70 gold badges231 silver badges360 bronze badges

Collectives™ on Stack Overflow

Rails 4 : Saving value as JSON string object/array in PostgreSQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related