How to use Parameters with web workers

[cardenasivan]

And do they have to be named?

sqljsWorker.postMessage({
id: stringUtils.createGuidCompact(),
action: workerActions.EXEC,
sql: sqlQuery
});

[lovasoa]

If you want to use query parameters, then you have to use the action each, and specify an additional params parameter. (sql.js source code).

You should use something like:

var id = 'REQID';

sqljsWorker.postMessage({
  id: id,
  action: 'each',
  sql: 'SELECT * FROM hello WHERE a=:aval AND b=:bval',
  params: {':aval' : 1, ':bval' : 'world'}
});

sqljsWorker.addEventListener('message', function(e) {
  var msg = e.data;
  if (msg.id === id) {
    if (msg.finished === false) {
      var retrievedRow = msg.row;
      // do something with the row you retrieved from the db
    } else {
      // eventually do something once the last row has been received
    }
  }
});

[cardenasivan]

Do parameters have to be named or can we do something like

sqljsWorker.postMessage({
  id: id,
  action: 'each',
  sql: 'SELECT * FROM hello WHERE a= ? AND b=?',
  params: [1, 'world']
});

[lovasoa]

Yes, it should work. db.each(...) is called in the worker, so you can use the same argument types as you would with db.each(...).