Inserting JSON data into Sqlite/webSQL database

Question

I am pulling data from my remote database and get this JSON data:

{"list1":{"id":1, "item":"testobj1"},"list2":{"id":2, "item":"testobj2"},"list3":{"id":3, 
"item":"testobj3"},"list4":{"id":4, "item":"testobj4"},"list5":{"id":5, "item":"testobj5"}}

I can now loop through the objects in the data and display a list of objects on my screen. It works fine:

var d = JSON.parse(hr.responseText);
databox.innerHTML = "";
for (var o in d) {
    if (d[o].item) {
        databox.innerHTML += '<p>' +     d[o].item + '</p>' + '<hr>';

    }
}

Now however, I would like to insert this data into my Sqlite database. I am not quite sure how I can tell the loop that 'd[o].id' and 'd[o].item' are the items I would like insert into my db.

db.transaction(function(tx) {
    var sql = "INSERT OR REPLACE INTO testTable (id, item) " + "VALUES
    (?, ?)";
    log('Inserting or Updating in local database:');
    var d = JSON.parse(hr.responseText);
    var id = d[o].id;
    var item = d[o].item;
    for (var i = 0; i < d.length; i++) {
        log(d[o].id + ' ' + d[o].item);
        var params = [d[o].id, d[o].item];
        tx.executeSql(sql, params);
    }
    log('Synchronization complete (' + d + ' items synchronized)');
}, this.txErrorHandler, function(tx) {
    callback();
});

I hope somebody can take a look at this loop and tell me where did I go wrong. Many thanks in advance!

Is d an array or an object? If it's an object, your iteration as it is will not work (d.length is undefined). — Drazen Bjelovuk
– Drazen Bjelovuk, Commented May 16, 2014 at 23:47

Drazen Bjelovuk · Accepted Answer · 2016-06-03 01:21:32Z

1

You're iterating over d as if it's an array rather than an object. Something like this is probably what you're looking for:

var d = JSON.parse(hr.responseText);
for (var o in d) {
    var params = [d[o].id, d[o].item];
    tx.executeSql(sql, params);
}

edited Jun 3, 2016 at 1:21

answered May 16, 2014 at 23:54

Drazen Bjelovuk

5,5626 gold badges44 silver badges68 bronze badges

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

2 Comments

user3645783 Over a year ago

Thanks a lot for the hint! d is an object. I didn't get it to run yet but do you think it'd be easier to insert data from an array?

Drazen Bjelovuk Over a year ago

Easier? Not necessarily, though it'd make more sense in your case. Especially if the order of your inner objects matter (for...in won't always iterate over your properties in the order which they're declared)

Collectives™ on Stack Overflow

Inserting JSON data into Sqlite/webSQL database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related