Extracting data from a Firebase realtime database JSON-export is a straightforward process that can be

Question

Extracting data from a Firebase realtime database JSON-export is a straightforward process that can be

I'm currently working with a Firebase realtime database export in JSON format that contains nested information that I need to extract. The JSON structure is as follows:

{
  "users" : {
    "024w97mv8NftGFY8THfQIU6PhaJ3" : {
      "email" : "xxx",
      "id" : "024w97mv8NftGFY8THfQIU6PhaJ3",
      "name" : "xxx",
      "items" : {
        "-LQL9n-r9BGdo3HJZ2sk" : {
          "disliked" : true,
          "id" : 396,
          "name" : "Aaa"
        },
        "-LQL9oO63nH-QW2w6zz0" : {
          "liked" : true,
          "id" : 3674,
          "name" : "Bbb"
        }
      }
    },
    "0ERLT5DLRvbZUnjlnM7Ow0qItpz2" : {
      "email" : "zzz",
      "id" : "0ERLT5DLRvbZUnjlnM7Ow0qItpz2",
      "name" : "zzz",
      "items" : {
        "-LIZnriSVQMzqTsPFNYa" : {
          "id" : 396,
          "liked" : true,
          "name" : "Aaa"
        },
        "-LIZnrzOuk4WyjqEiLG8" : {
          "disliked" : true,
          "id" : 4805,
          "name" : "Ccc"
        }
      }
    }
  }
}

My goal is to compile a list of all liked item names and potentially calculate the frequency at which an item is liked. Can anyone recommend a simple tool or script for accomplishing this task? Preferably in Ruby or Javascript. Thank you!

javascript json ruby firebase-realtime-database

Answer 1

Answer №1

If you want to parse JSON data in Ruby, you can do it like this:

result_hash = JSON.parse(result)
result_ary = result_hash["users"].collect do |k,v| 
  v["items"].values.select{|v1| v1["liked"] == true } 
end
result_data = result_ary.flatten

The parsed result looks like this:

=> [{"liked"=>true, "id"=>3674, "name"=>"Bbb"}, {"id"=>396, "liked"=>true, "name"=>"Aaa"}]

Now you can easily get the results you need:

result_data.collect{|x| x["name"] }
=> ["Bbb", "Aaa"]

 result_data.count {|x| x["name"] == "Aaa"}
=> 1

result_data.count {|x| x["name"] == "Bbb"}
=> 1

Answer 2

If you want to parse JSON data in Ruby, you can do it like this:

result_hash = JSON.parse(result)
result_ary = result_hash["users"].collect do |k,v| 
  v["items"].values.select{|v1| v1["liked"] == true } 
end
result_data = result_ary.flatten

The parsed result looks like this:

=> [{"liked"=>true, "id"=>3674, "name"=>"Bbb"}, {"id"=>396, "liked"=>true, "name"=>"Aaa"}]

Now you can easily get the results you need:

result_data.collect{|x| x["name"] }
=> ["Bbb", "Aaa"]

 result_data.count {|x| x["name"] == "Aaa"}
=> 1

result_data.count {|x| x["name"] == "Bbb"}
=> 1

Extracting data from a Firebase realtime database JSON-export is a straightforward process that can be

Answer №1

Similar questions

Generating innerHTML and retrieving attributes simultaneously from a single Div element

The use of JSON.parse does not support parsing URL links

Steps for assigning a 404 status code upon promise rejection

The significance of using the Spread operator in React-Redux Reducers

Strategies for effectively and speedily parsing extensive line-formatted JSON files

Parameters for MongoDB search queries

Mongoose fails to carry out internal query using Promise mechanism

Why does Javascript Tic-Tac-Toe delay notifying the user until the entire board is full?

Is there a way to configure cloudantDb.search to fetch all records without the default limitations of 25 records and

Create a fresh array by merging two existing arrays together

A discrepancy has arisen as the value within the array structure is being altered

Is there a way to retrieve the value from a select tag and pass it as a parameter to a JavaScript function?

Utilizing Parallax.js within the React Framework

Check if a rotated rectangle lies within the circular boundary of the canvas

Creating a JSON-based notification system in Unity

Problem with Jquery Focus-Out in Internet Explorer on two textboxes

Tips for preventing child elements from becoming distorted when the parent element is resized

tag directive not functioning properly

Chokidar operates smoothly from the command line, but fails to function properly when invoked through the use of 'npm run'

How can I link the function name stored in JSON data to the (click) event of a button in an Angular project?