How to add JS object into Sqlite database

Question

I am having trouble trying to add a JS Object into an sqlite database. I am using cordova, creating an app for android, windows and iOS.

I have this code for my insert and retrieval...

var data = localStorage.getItem('folderData');
console.log(data);
var username = localStorage.getItem("username");
var session = localStorage.getItem("session_ID");
tx.executeSql('CREATE TABLE IF NOT EXISTS folderData (id integer primary key autoincrement, username, sessionID, folderData text)');
tx.executeSql('SELECT * FROM folderData WHERE username = "'+username+'"', [], function(tx, result) {
    if(result.rows.length > 0){
        tx.executeSql('UPDATE folderData SET folderData = "'+data+'", sessionID = "'+session+'" WHERE username = "'+username+'"');
        alert('An update has occured folderData');
    } else {
        tx.executeSql('INSERT INTO folderData (username, sessionID, folderData) VALUES ("'+username+'", "'+session+'", "'+data+'")');
        alert('An insert has occured folderData');
    }
});
tx.executeSql('SELECT folderData FROM folderData WHERE username = "'+username+'" AND sessionID = "'+session+'" ORDER BY id desc LIMIT 1', [], function(tx, result) {
    querySuccessFolderData(tx, result);
});

The data variable is my object. When I console.log(data) before insertion i get the following

enter image description here

This my querySuccessFolderData function

function querySuccessFolderData(tx, results) {
    var len = results.rows.length;
    //alert("folderData table: " + len + " rows found.");
    var newFolderData = jsonParse(results.rows.item(0).folderData);
    for(i=0;i<len;i++)
    {
        var newFolderData = results.rows.item(i).folderData;
    }
    console.log(newFolderData);
}

console.log(newFolderData); now shows up as [Object Object]

What am I doing wrong? Do i need to convert the object again after I select it from the database? This is becoming a nightmare for me now, i've been looking at it for way too long. Any help would be much appreciated.

You're using data = jsonParse(data); and inserting that indo the database. Then, when reading, you are doing jsonParse(results.rows.item(0).folderData). There is no such thing as a "JSON Object" there is a JS Object or a JSON String. You need to insert into the database as a JSON String, then when reading, parse that JSON String into a JS Object — CodingIntrigue
– CodingIntrigue, Commented Aug 22, 2014 at 8:43
Thanks for the clarification. I've edited my question to reflect that. I've removed the jsonParse(data) before insertion, but when I retrieve the data it shows up as [object Object] still. Any ideas? — Pooshonk
– Pooshonk, Commented Aug 22, 2014 at 8:51

Pooshonk · Accepted Answer · 2014-08-22 11:06:03Z

1

Managed to fix my issue.

Set my localStorage data.

localStorage.setItem("folderData", JSON.stringify(data['root']));

Used getItem to retrieve it in another function and encoded it for the database insert

var data = localStorage.getItem('folderData');
data = encodeURI(data);

Then used decodedURI and jsonParse to turn it back into an object

var newFolderData = results.rows.item(0).folderData;
newFolderData = decodeURI(newFolderData);
newFolderData = jsonParse(newFolderData);

Which gave me the correct data saved.

answered Aug 22, 2014 at 11:06

Pooshonk

1,3342 gold badges25 silver badges49 bronze badges

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

1 Comment

Will Haley Over a year ago

You may want to look at brian.io/lawnchair I've found it really great at simplifying localStorage operations. It may be overkill for what you are doing, but it has saved me a lot of time.

Collectives™ on Stack Overflow

How to add JS object into Sqlite database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related