Files
node-websql/lib/WebSQLTransaction.js

180 lines
5.1 KiB
JavaScript

'use strict';
var noop = require('noop-fn');
var Queue = require('tiny-queue');
var immediate = require('immediate');
var WebSQLResultSet = require('./WebSQLResultSet');
function errorUnhandled() {
return true; // a non-truthy return indicates error was handled
}
function SQLTask(sql, sqlArgs, sqlCallback, sqlErrorCallback) {
this.sql = sql;
this.sqlArgs = sqlArgs;
this.sqlCallback = sqlCallback;
this.sqlErrorCallback = sqlErrorCallback;
}
function runSql(self, task) {
var sql = task.sql;
var sqlArgs = task.sqlArgs;
var sqlCallback = task.sqlCallback;
var sqlErrorCallback = task.sqlErrorCallback;
function onQueryComplete(err, results) {
if (err) {
var errorResult = sqlErrorCallback(self, err);
if (!!errorResult) { // user didn't handle the error
self._error = err;
}
} else {
sqlCallback(self, results);
}
self._running = false;
runNextSql(self);
}
function runSelect() {
self._websqlDatabase._db.all(sql, sqlArgs, function (err, rows) {
if (err) {
return onQueryComplete(err);
}
var insertId = void 0;
var rowsAffected = 0;
var resultSet = new WebSQLResultSet(insertId, rowsAffected, rows);
onQueryComplete(null, resultSet);
});
}
function runCreate() {
self._websqlDatabase._db.run(sql, sqlArgs, function (err) {
if (err) {
return onQueryComplete(err);
}
// WebSQL always returns an insertId of 0 for "CREATE TABLE" statements
var insertId = 0;
var rowsAffected = 0;
var rows = [];
var resultSet = new WebSQLResultSet(insertId, rowsAffected, rows);
onQueryComplete(null, resultSet);
});
}
function runDrop() {
self._websqlDatabase._db.run(sql, sqlArgs, function (err) {
if (err) {
return onQueryComplete(err);
}
// WebSQL always returns insertId=undefined and rowsAffected=0
// for "DROP TABLE" statements. Go figure.
var insertId = void 0;
var rowsAffected = 0;
var rows = [];
var resultSet = new WebSQLResultSet(insertId, rowsAffected, rows);
onQueryComplete(null, resultSet);
});
}
function runInsert() {
self._websqlDatabase._db.run(sql, sqlArgs, function (err) {
if (err) {
return onQueryComplete(err);
}
/* jshint validthis:true */
var executionResult = this;
var insertId = executionResult.lastID;
var rowsAffected = executionResult.changes;
var rows = [];
var resultSet = new WebSQLResultSet(insertId, rowsAffected, rows);
onQueryComplete(null, resultSet);
});
}
function runUpdate() {
self._websqlDatabase._db.run(sql, sqlArgs, function (err) {
if (err) {
return onQueryComplete(err);
}
/* jshint validthis:true */
var executionResult = this;
var insertId = void 0;
var rowsAffected = executionResult.changes;
var rows = [];
var resultSet = new WebSQLResultSet(insertId, rowsAffected, rows);
onQueryComplete(null, resultSet);
});
}
// TODO: It seems like the sqlite3 API either allows:
// 1) all(), which returns results but not rowsAffected or lastID
// 2) run(), which doesn't return results, but returns rowsAffected and lastID
// So we try to sniff whether it's a SELECT query or not.
// This is inherently error-prone, although it will probably work in the 99%
// case.
var isSelect = /^\s*SELECT\b/i.test(sql);
var isInsert = /^\s*INSERT\b/i.test(sql);
var isCreate = /^\s*CREATE\s+TABLE\b/i.test(sql);
var isDrop = /^\s*DROP\s+TABLE\b/i.test(sql);
if (self._readOnly && !isSelect) {
return immediate(function () {
onQueryComplete(new Error('could not prepare statement (23 not authorized)'));
});
}
if (isSelect) {
runSelect();
} else if (isInsert) {
runInsert();
} else if (isCreate) {
runCreate();
} else if (isDrop) {
runDrop();
} else {
runUpdate();
}
}
function runNextSql(self) {
if (self._running) {
return;
}
if (self._error) {
return self._completeCallback(self._error);
}
var task = self._sqlQueue.shift();
if (!task) {
return self._completeCallback();
}
self._running = true;
runSql(self, task);
}
function executeSql(self, sql, sqlArgs, sqlCallback, sqlErrorCallback) {
self._sqlQueue.push(new SQLTask(sql, sqlArgs, sqlCallback, sqlErrorCallback));
runNextSql(self);
}
function WebSQLTransaction(websqlDatabase, readOnly, completeCallback) {
this._websqlDatabase = websqlDatabase;
this._readOnly = readOnly;
this._completeCallback = completeCallback;
this._sqlQueue = new Queue();
this._error = null;
}
WebSQLTransaction.prototype.executeSql = function (sql, sqlArgs, sqlCallback, sqlErrorCallback) {
sqlArgs = Array.isArray(sqlArgs) ? sqlArgs : [];
sqlCallback = typeof sqlCallback === 'function' ? sqlCallback : noop;
sqlErrorCallback = typeof sqlErrorCallback === 'function' ? sqlErrorCallback : errorUnhandled;
executeSql(this, sql, sqlArgs, sqlCallback, sqlErrorCallback);
};
WebSQLTransaction.prototype._checkDone = function () {
runNextSql(this);
};
module.exports = WebSQLTransaction;