Exploring the versatility of JSON for data manipulation in JavaScript as akin to working with a relational SQL

Question

Exploring the versatility of JSON for data manipulation in JavaScript as akin to working with a relational SQL

Looking at this JSON variable:

var peopleList = {
    "1": {"Name": "Lisa", "item1": "Name of Item 1"}   ,
    "2": {"Name": "Marty"}   ,
    "3": {"Name": "Jordan",  "item1":"Name of Item 1",  "item2":"Name of Item 2"}
}

This structure seems similar to a relational database.

Currently, I am working on a program where I need to add multiple people (1-3) and assign multiple items to each person in this variable.

One challenge I am facing is determining the getters and setters in JavaScript for this variable.

For instance, how can I add an item to "Marty"?

Also, how do I retrieve the Name for item2 belonging to "Jordan"?

I appreciate any assistance as I am still learning about JSON.

If there is a simpler way to achieve this goal that is easier to work with, I am open to suggestions.

javascript json

Answer 1

Answer №1

To retrieve the value of any object using dot notation:

 peopleList[3].Name // this will give you "Jordan"

If you want to add a key-value pair to an object, you can follow this example:

var MartyData = peopleList[2];
MartyData['item1'] = "Name of item 1 of Marty";
// you can then check if the data has been added
alert(peopleList[2].item1); // this will return "Name of item 1 of Marty"

Check out the DEMO

Answer 2

To retrieve the value of any object using dot notation:

 peopleList[3].Name // this will give you "Jordan"

If you want to add a key-value pair to an object, you can follow this example:

var MartyData = peopleList[2];
MartyData['item1'] = "Name of item 1 of Marty";
// you can then check if the data has been added
alert(peopleList[2].item1); // this will return "Name of item 1 of Marty"

Check out the DEMO

Answer 3

Answer №2

JSON Object can be compared to a Java Bean or Map structure.

var peopleList = {
'one':{'name':'Marty','item1':'Name of item1'},
'two':{'name':'Jack','item1':'Name of item1'},
'three':{'name':'Jordan','item1':'Name of item1','item2':'Name of item2'}
}

For instance, how do I insert an item for "Marty"

Also, how do I retrieve the Name for item2 of the individual "Jordan"

Insert an item for "Marty"

peopleList.two.item1 = "Name of item1"

Retrieve the Name for item2 of the individual "Jordan"

alert(peopleList.three.item2);

===================================================
Apologies for the mistake. Corrected.

Answer 4

JSON Object can be compared to a Java Bean or Map structure.

var peopleList = {
'one':{'name':'Marty','item1':'Name of item1'},
'two':{'name':'Jack','item1':'Name of item1'},
'three':{'name':'Jordan','item1':'Name of item1','item2':'Name of item2'}
}

For instance, how do I insert an item for "Marty"

Also, how do I retrieve the Name for item2 of the individual "Jordan"

Insert an item for "Marty"

peopleList.two.item1 = "Name of item1"

Retrieve the Name for item2 of the individual "Jordan"

alert(peopleList.three.item2);

===================================================
Apologies for the mistake. Corrected.

Exploring the versatility of JSON for data manipulation in JavaScript as akin to working with a relational SQL

Answer №1

Answer №2

Similar questions

Strange behavior exhibited by the HTML DataList component within an Angular application

Vanish Dropdown upon clicking Using JavaScript

Display a component just once in React or React Native by utilizing local storage

Manage a frame directly from the parent page

How come submitting a form without refreshing does not update the database with new values?

Tips for accessing Ajax data within Ember computed property

javascript implementing number formatting during keyup event

Ensuring validity using dynamic context objects within Joi

Leveraging the power of Notepad++

Detecting the specific button that was selected with PHP

Retrieve images of the webpage discreetly and with seamless execution using JSON AsyncTask

Configuration for secondary dependencies in Tailwind

"Creating visual art with processing in 2D using P5

Implement various actions when the window is resized

Improving the innerHTML syntax

jQuery MaskMoney - position input at the start of the field

Converting JSON data into a jQuery-powered spreadsheet

The regular expression for validating credit card numbers is invalid due to a repetition error

Creating a personalized and versatile table component with unique functionality: where to begin?

Mask the "null" data in JSON