Databases
StackOverflow2013
Postsdbo
POmapping JSON to an Object
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmapping JSON to an Object
    primarykey
    data
    text
    <p>I have a JSON file that was converted from a csv and is too big to hand edit. Its' syntax is one large array I think. The data is from a group of routers and I aim to build router objects. The way the current CSV to JSON file is organized by each row and I want to pick out each router and have an object with router name, the all bandwidth measurements associated with that router.</p> <p>How would you approach this? I'm attempting to take care of all of this when I iterate through the JSON file and when the router changes, I start a new instance of the router object. I'm a no longer a newb, just a slow learner. So would the next step be to create a router class with js and populate the class with what I pull out of my giant JSON array, or could/should I do with out the handwritten class and create all the objects on the fly? (can I create objects on the fly.</p> <p>Current JSON (it goes on for pages, each router having a few hundred entries in the csv:</p> <pre><code>[ { "Router": "RouterID1", "TimeStamp": "2012/01/01 06:00:00", "transferBytes": "23235", "ReceivedBytes": "29903" }, { "Router": "RouterID1", "TimeStamp": "2012/01/01 06:05:00", "transferBytes": "21235", "ReceivedBytes": "22103" } { "Router": "RouterID2", "TimeStamp": "2012/01/01 06:00:00", "transferBytes": "23235", "ReceivedBytes": "29903" }, { "Router": "RouterID2", "TimeStamp": "2012/01/01 06:05:00", "transferBytes": "21235", "ReceivedBytes": "22103" } ] </code></pre> <p>@amnotiam: the router types are gauranteed to be adjecent to each other</p> <p>This might not be valid but here is the structure I think I'm going for:</p> <pre><code>[ { "Router": "RouterID1" "TimeStamp": array of timestamps "transferBytes": array of bytes transferred for each timestamp "ReceivedBytes": array of bytes received for each timestamp }, { "Router": "RouterID2", "TimeStamp": array of timestamps "transferBytes": array of bytes transferred for each timestamp "ReceivedBytes": array of bytes received for each timestamp } ] </code></pre> <p>@Bergi I want to make an object for each router with there historical data contained with in the object. Right know I have an object for every time entry. (I think)</p> <p>@Rick Good call, I will be and will probably ask that question later:)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USrd42
    1. USrd42
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COAre the routers organized so that the same router types are guaranteed to be adjacent to each other? And can you give an illustration of what the resulting data structure should look like?
      singulars
      1. POmapping JSON to an Object
      1. This table or related slice is empty.
    2. COYou already have a lot of objects for routers in your (parsed json) array. To what do you want to transform them?
      singulars
      1. POmapping JSON to an Object
      1. USBergi
    3. COAre you going to be parsing/making objects every time the page loads or refreshes? Creating all these and caching these would probably be better so you don't have to parse the data x number of times when the router is changed.
      singulars
      1. POmapping JSON to an Object
      1. USRick
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload