10
votes

I am using a sqlite DB as a storage system for a webapp. I been using the objects that are returned from queries directly in application. For example:

function get_book_by_id(id,successCallback,errorCallback)
{
    function _successCallback(transaction, results)
    {
        if(results.rows.length==0) {successCallback(null);}
        else
        {
            book=results.rows.item(0);
            successCallback(book);
        }
    }
    db.transaction(
        function (transaction) {
            transaction.executeSql("SELECT id,title,content,last_read from books where id=?;",[id], _successCallback, errorCallback);
    });
}

This returns me an object with the given id, all columns are provided as properties. Nice. The problem I just figured out is that all the properties of the result set object are immutable. So for example if I want to change the property 'title' it takes no effect, which in my opinion makes no sense. Example:

get_book_by_id(1,handle,error);
function handle(book)
{
 //THIS DOESN'T WORK, book.title is still what it was.
 book.title=book.title+"more text";

}

I of course can convert all my DB objects into mutable objects, but I rather would not do that.

Is that an expected behavior? Can I request mutable objects?

I am using google chrome 9.0 on Mac OS X.

2
I am doing this as a workaround: function convert_to_mutable(result_object) { var mutable=new Object(); for(var key in result_object){mutable[key]=result_object[key]}; return mutable; } - Stan Wiechers
Can you show how you created the database or link to the documentation for it? - Havvy
I did that here: github.com/whoisstan/hyper_books/blob/master/js/book_storage.js - The Projects goal was to write a html5 based ebook reader for out of copyright books, I haven't spent much time with it in the last years, I should. - Stan Wiechers
Stan Wiechers, have you tried Object.defineProperty() to make your result mutable . developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/… - Vlad Nikitin

2 Answers

5
votes

The WebSQL spec doesn't require for the returned item to be sealed, but it's up to the implementation (the spec does require for the item to be an ordered dictionary with the properties in the same order as the columns in your query).

And no, there is no way to explicitly request a mutable object, so you'll want to do something like the convert_to_mutable() approach suggested by Stan.

BTW, assuming you're using a 3rd party library, it probably has a function for this, for example jQuery.extend() or _.extend().

0
votes

Building on Stepan's answer, but for people like me that want a quick fix from SO.
You can create another basic object and copy the sqlite row properties onto it.
Something like this:

var immutable_book = results.rows.item(0);
var book = {};
for (var prop in immutable_book) {
    if (immutable_book.hasOwnProperty(prop)) {
        book[prop] = immutable_book[prop];
    }
}

That goes in the _successCallback, and then later you can do this:

book.title=book.title+"more text"; // works now !

I came across this issue in iOS Safari, but in Chrome and Android web-kit browsers I was able to update properties of the returned row object directly.