mirror of
https://github.com/expo/node-websql.git
synced 2026-11-21 07:39:25 -10:00
105 lines
2.7 KiB
JavaScript
105 lines
2.7 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, args, sqlCallback, sqlErrorCallback) {
|
|
this.sql = sql;
|
|
this.args = args;
|
|
this.sqlCallback = sqlCallback;
|
|
this.sqlErrorCallback = sqlErrorCallback;
|
|
}
|
|
|
|
function runBatch(self, batch) {
|
|
|
|
function onDone() {
|
|
self._running = false;
|
|
runAllSql(self);
|
|
}
|
|
|
|
self._websqlDatabase._db.exec(batch, self._readOnly, function (err, results) {
|
|
/* istanbul ignore next */
|
|
if (err) {
|
|
self._error = err;
|
|
return onDone();
|
|
}
|
|
for (var i = 0; i < results.length; i++) {
|
|
var res = results[i];
|
|
var batchTask = batch[i];
|
|
if (res.error) {
|
|
if (batchTask.sqlErrorCallback(self, res.error)) {
|
|
// user didn't handle the error
|
|
self._error = res.error;
|
|
return onDone();
|
|
}
|
|
} else {
|
|
batchTask.sqlCallback(self, new WebSQLResultSet(
|
|
res.insertId, res.rowsAffected, res.rows));
|
|
}
|
|
}
|
|
onDone();
|
|
});
|
|
}
|
|
|
|
function runAllSql(self) {
|
|
if (self._running || self._complete) {
|
|
return;
|
|
}
|
|
if (self._error) {
|
|
self._complete = true;
|
|
return self._completeCallback(self._error);
|
|
}
|
|
if (!self._sqlQueue.length) {
|
|
self._complete = true;
|
|
return self._completeCallback();
|
|
}
|
|
self._running = true;
|
|
var batch = [];
|
|
var task;
|
|
while ((task = self._sqlQueue.shift())) {
|
|
batch.push(task);
|
|
}
|
|
runBatch(self, batch);
|
|
}
|
|
|
|
function executeSql(self, sql, args, sqlCallback, sqlErrorCallback) {
|
|
self._sqlQueue.push(new SQLTask(sql, args, sqlCallback, sqlErrorCallback));
|
|
if (self._runningTimeout) {
|
|
return;
|
|
}
|
|
self._runningTimeout = true;
|
|
immediate(function () {
|
|
self._runningTimeout = false;
|
|
runAllSql(self);
|
|
});
|
|
}
|
|
|
|
function WebSQLTransaction(websqlDatabase, readOnly, completeCallback) {
|
|
this._websqlDatabase = websqlDatabase;
|
|
this._readOnly = readOnly;
|
|
this._completeCallback = completeCallback;
|
|
this._sqlQueue = new Queue();
|
|
this._error = null;
|
|
this._complete = false;
|
|
this._runningTimeout = false;
|
|
}
|
|
|
|
WebSQLTransaction.prototype.executeSql = function (sql, args, sqlCallback, sqlErrorCallback) {
|
|
args = Array.isArray(args) ? args : [];
|
|
sqlCallback = typeof sqlCallback === 'function' ? sqlCallback : noop;
|
|
sqlErrorCallback = typeof sqlErrorCallback === 'function' ? sqlErrorCallback : errorUnhandled;
|
|
|
|
executeSql(this, sql, args, sqlCallback, sqlErrorCallback);
|
|
};
|
|
|
|
WebSQLTransaction.prototype._checkDone = function () {
|
|
runAllSql(this);
|
|
};
|
|
|
|
module.exports = WebSQLTransaction; |