How do I merge multiple JSON objects in one file ruby

Question

I'm trying to loop over JSON objects and I can't because I have two separate JSON objects in my one JSON file. How would I merge the two objects?

This is how my Json file currently looks like

answers.json

{"visit_count":280,"employability":"employed","nationality":"Canadian","income":"5555","email":"dsfs@fsfs"}
{"visit_count":280,"employability":"employed","nationality":"Canadian","income":"5555","email":"dsfs@fsfs"}

This is how I'm storing data in my json file

if env["REQUEST_METHOD"] == "POST"
      json = template_data.to_json
      open('answers.json', 'a') do |file|
        file.puts json 
   end
end

I tried this solution to merge JSON objects

data_hash = JSON.parse(File.read('answers.json'))
data_hash.gsub(/}.*?{/m, '},{')}]")

this is the error that showed up when I tried the above

`load': admin.rb:10: syntax error, unexpected tSTRING_DEND, expecting keyword_end (SyntaxError)
ta_hash.gsub(/}.*?{/m, '},{')}]")

Any help would be greatly appreciated

When do you want to merge these objects, while saving to file or while reading from file? — Marcin Kołodziej
– Marcin Kołodziej, Commented Oct 26, 2018 at 1:38

Marcin Kołodziej · Accepted Answer · 2018-10-26 01:33:37Z

1

Well, first of all, your file is not JSON. If you want to keep it that way and still be capable of parsing the file, I suggest you read each line and add it to an array as a hash, like this:

File.foreach("answers.json").map { |x| JSON.parse(x) }
 => [
     {"visit_count"=>280, "employability"=>"employed", "nationality"=>"Canadian", "income"=>"5555", "email"=>"dsfs@fsfs"},
     {"visit_count"=>280, "employability"=>"employed", "nationality"=>"Canadian", "income"=>"5555", "email"=>"dsfs@fsfs"}
    ]

If you want to save proper JSON, you'll need to save an array of objects. The simplest way is to JSON.parse contents of the file, add a new object to the array, dump it to JSON and save it to the file again, like this:

File.open("answers.json", "r+") do |f|
  contents = File.read("answers.json")
  prev = contents.empty? ? [] : JSON.parse(contents)
  f.write(prev.push(template_data).to_json)
end

edited Oct 26, 2018 at 1:33

answered Oct 26, 2018 at 1:17

Marcin Kołodziej

5,3231 gold badge12 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

How do I merge multiple JSON objects in one file ruby

answers.json

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

answers.json

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related