krackers · October 26, 2019 01:24 · Nov 26, 2014 · Nov 26, 2014
diff --git a/easysql.js b/easysql.js
@@ -3,8 +3,8 @@
 
 /**
  * Usage:
- * var db = openDatabase('demo', '1.0', 'Demo', 2 * 1024 * 1024);
- * query('SELECT * FROM mytable')
+ * var db = new DB('demo', '1.0', 'Demo', 2 * 1024 * 1024);
+ * db.query('SELECT * FROM mytable')
  *   .then(function(res){
  *     console.log(res.rows); 
  *   }, function(err){
@@ -13,7 +13,12 @@
  * 
  */
 
-function query(sql, params){
+function DB(name, version, title, size){
+  this.db = openDatabase(name, version, title, size);
+}
+
+DB.prototype.query = function(sql, params){
+  var db = this.db;
   return new Promise(function(resolve, reject){
     if (!db) return reject('no database.');
     db.transaction(function(tx){
@@ -32,4 +37,5 @@ function query(sql, params){
       });
     });
   });
-}
+};
+
diff --git a/easysql.js b/easysql.js
@@ -0,0 +1,35 @@
+// https://github.com/Philzen/WebSQL-Polyfill
+// https://github.com/jakearchibald/es6-promise
+
+/**
+ * Usage:
+ * var db = openDatabase('demo', '1.0', 'Demo', 2 * 1024 * 1024);
+ * query('SELECT * FROM mytable')
+ *   .then(function(res){
+ *     console.log(res.rows); 
+ *   }, function(err){
+ *     console.error(err);
+ *   });
+ * 
+ */
+
+function query(sql, params){
+  return new Promise(function(resolve, reject){
+    if (!db) return reject('no database.');
+    db.transaction(function(tx){
+      tx.executeSql(sql, params||[], function(tx,res){
+        // tidy up
+        var rows = [];
+        for(var i=res.rows.length; i; i--){
+          rows.unshift(res.rows.item(i-1));
+        }
+        var out = {rows:rows, rowsAffected:res.rowsAffected};
+        // don't worry about no insertId
+        try{ out.insertId = res.insertId; }catch(e){}
+        resolve(out);
+      }, function(tx, err){
+        reject(err.message);
+      });
+    });
+  });
+}