WebSql

(function(app){
 var connect;
 app.db = {};
 var Database = app.db;
 
 Database.initialize = function(){
    db = window.sqlitePlugin.openDatabase({name: "DB.db", location: 2});
 }
 
 Database.findBy = function(params){
 params = params || {};
 var $deferred = $.Deferred();
 var row=[];
 
 //params.table
 //params.where
 db.transaction(function(tx) {
                tx.executeSql('SELECT * FROM ' + params.table +';',[],
                              function(tx, results)
                              {
                              var totRes = results.rows.length;
                                for (var i=0; i < totRes; i++){
                                  row[i] = results.rows.item(i);
                                }
                              $deferred.resolveWith(undefined,[row]);
                              },
                              function(tx, error)
                              {
                                $deferred.rejectwith(undefined,[error]);
                              }
                              );
                }); return $deferred.promise();
 }
 
 
 

 
 

 
 
 
 })(app)