mirror of
https://github.com/expo/node-websql.git
synced 2026-11-15 17:37:00 -10:00
180 lines
5.1 KiB
JavaScript
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; |