Javascript Binding SQL results to a function

Question

All,

I am working with WebOS enyo, but having a really senior moment....

Basically the fact its enyo has no relation to my question however...

I have a method:

clickPopulate: function(){

     // Do some SQL

};

I am using a database class to handle my SQL lite Db connection, the interface for the method i am using is:

 * Execute an arbitrary SQL command on the database.
 *
 * If you need to execute multiple commands in a transaction, use queries()
 *
 * Parameters:
 * - sql (string or query object, required)
 * - options (object):
 *    * values (array): replacements for '?' placeholders in SQL
 *      (only use if not passing a DatabaseQuery object)
 *    * onSuccess (function): method to call on successful query
 *        + receives single argument: results as an array of objects
 *    * onError (function): method to call on error; defaults to logging
 */


query: function(sql, options)

So anyway i send it some SQL and some options, one of which is the onSuccess callback.

this.$.db.query("SELECT fullName, count(*) FROM user WHERE username=? and password=? GROUP BY username",
        {values: [inUser,inPass], onSuccess: enyo.bind(this, this.callBackFunction)});

What i really want to be able to do is have the SQL result array return to my click handler function - clickPopulate, but as its the calling method, i cant get it to work?

Any ideas?

Jani Hartikainen · Accepted Answer · 2011-07-09T18:20:14.660

You can't have an asynchronous callback return to the original caller.

The closest you can do is something like this (since I don't know the Enyo apis I'll just use some pseudo'ish stuff)

function clickPopulate() {
    db.query('Some SQL here', function(results) {
        //This is the code that will be run once the query is complete.
    });
}

So basically you can include a closure as the callback inside your function. This way it kind of looks like it's part of the original caller but it really isn't.

If you really wanted to, you could probably have it call the original function back, and define some parameter which is used to determine whether it's the results from the query, but that would just make it kinda ugly and confusing.

Thanks Jani, this is what i needed - the problem with the async call was that enyo only calls a setUp function once, and when i left it that was it... The option you suggested above works a treat, thank you. — diagonalbatman, Jul 09 '11 at 18:16

Javascript Binding SQL results to a function

1 Answers1

Linked