ngCordova SQLite Plugin

sqlite.js

angular.module('ngCordova.plugins.sqlite', [])

  .factory('$cordovaSQLite', ['$q', function ($q) {

    return  {
      openDB: function(dbName) {
        return  window.sqlitePlugin.openDatabase({name: dbName});
      },


      openDBBackground: function(dbName) {
      	return window.sqlitePlugin.openDatabase({name: dbName, bgType: 1});
      },

      execute: function (db, query, binding) {
      	q = $q.defer();

      	db.transaction(function(tx) {
      		tx.executeSql(query, binding, function(tx, result) {
      			q.resolve(result);
      		},
      		function(transaction, error) {
      			q.reject(error);
      		});
      	})
      	return q.promise;
      },

      nestedExecute: function (db, query1, query2, binding1, binding2) {
        q = $q.defer();

      	db.transaction( function(tx) {
      		tx.executeSql(query1, binding1, function(tx, result) {
            q.resolve(result);
            tx.executeSql(query2, binding2, function(tx, res) {
              q.resolve(res);
            }
          }
        },
      		function(transaction, error) {
      			q.reject(error);
      		});
      	})
      	return q.promise;
      }

      // more methods here
    }

  }]);

How do you handle async calls, since transactions in websql are transactions, I had a problem regarding this field when I tried to scope change a variable based on a result of transaction.

Is very easy with SQLite (Tested with pre-filled databases with 25000 records), see my example: https://github.com/jdnichollsc/Ionic-Starter-Template

Regards, Nicholls