botris · September 21, 2023 07:36 · praveen2308 · Aug 24, 2015 · botris · Sep 23, 2015
diff --git a/addsqlite.sh b/addsqlite.sh
 cordova plugin add https://github.com/brodysoft/Cordova-SQLitePlugin.git
diff --git a/app.js b/app.js
 var db = null;

 angular.module('myapp', ['ionic', 'myapp.controllers', 'myapp.services', 'ngCordova'])

 .run(function($ionicPlatform, $cordovaSQLite) {
  $ionicPlatform.ready(function() {
    // Hide the accessory bar by default (remove this to show the accessory bar above the keyboard
    // for form inputs)
    if (window.cordova && window.cordova.plugins.Keyboard) {
      cordova.plugins.Keyboard.hideKeyboardAccessoryBar(true);
    }
    if (window.StatusBar) {
      // org.apache.cordova.statusbar required
      StatusBar.styleDefault();
    }

    
    if(window.cordova) {
      // App syntax
      db = $cordovaSQLite.openDB("myapp.db");
    } else {
      // Ionic serve syntax
      db = window.openDatabase("myapp.db", "1.0", "My app", -1);
    }

    $cordovaSQLite.execute(db, "CREATE TABLE IF NOT EXISTS team (id integer primary key, name text)");
  });
 })
diff --git a/controllers.js b/controllers.js
 .controller('TeamCtrl', function($scope, Team) {
  $scope.team = [];
  $scope.team = null;

  $scope.updateTeam = function() {
    Team.all().then(function(team){
      $scope.team = team;
    });
  }

  $scope.updateTeam();

  $scope.createNewTeamMember = function(member) {
    Team.add(member);
    $scope.updateTeam();
  };

  $scope.removeMember = function(member) {
    Team.remove(member);
    $scope.updateTeam();
  };
  
  $scope.editMember = function(origMember, editMember) {
    Team.update(origMember, editMember);
    $scope.updateTeam();
  };
  
 })
diff --git a/index.html b/index.html
 <!DOCTYPE html>
 <html>
  <head>
  <!-- standard Ionic head -->
  
  <!-- Download https://github.com/driftyco/ng-cordova/archive/master.zip -->
  <script src="js/ng-cordova.min.js"></script>
diff --git a/services.js b/services.js
 angular.module('myapp.services', [])

 .factory('DBA', function($cordovaSQLite, $q, $ionicPlatform) {
  var self = this;

  // Handle query's and potential errors
  self.query = function (query, parameters) {
    parameters = parameters || [];
    var q = $q.defer();

    $ionicPlatform.ready(function () {
      $cordovaSQLite.execute(db, query, parameters)
        .then(function (result) {
          q.resolve(result);
        }, function (error) {
          console.warn('I found an error');
          console.warn(error);
          q.reject(error);
        });
    });
    return q.promise;
  }

  // Proces a result set
  self.getAll = function(result) {
    var output = [];

    for (var i = 0; i < result.rows.length; i++) {
      output.push(result.rows.item(i));
    }
    return output;
  }

  // Proces a single result
  self.getById = function(result) {
    var output = null;
    output = angular.copy(result.rows.item(0));
    return output;
  }

  return self;
 })

 .factory('Team', function($cordovaSQLite, DBA) {
  var self = this;

  self.all = function() {
    return DBA.query("SELECT id, name FROM team")
      .then(function(result){
        return DBA.getAll(result);
      });
  }

  self.get = function(memberId) {
    var parameters = [memberId];
    return DBA.query("SELECT id, name FROM team WHERE id = (?)", parameters)
      .then(function(result) {
        return DBA.getById(result);
      });
  }

  self.add = function(member) {
    var parameters = [member.id, member.name];
    return DBA.query("INSERT INTO team (id, name) VALUES (?,?)", parameters);
  }

  self.remove = function(member) {
    var parameters = [member.id];
    return DBA.query("DELETE FROM team WHERE id = (?)", parameters);
  }

  self.update = function(origMember, editMember) {
    var parameters = [editMember.id, editMember.name, origMember.id];
    return DBA.query("UPDATE team SET id = (?), name = (?) WHERE id = (?)", parameters);
  }

  return self;
 })
	var db = null;

	angular.module('myapp', ['ionic', 'myapp.controllers', 'myapp.services', 'ngCordova'])

	.run(function($ionicPlatform, $cordovaSQLite) {
	$ionicPlatform.ready(function() {
	// Hide the accessory bar by default (remove this to show the accessory bar above the keyboard
	// for form inputs)
	if (window.cordova && window.cordova.plugins.Keyboard) {
	cordova.plugins.Keyboard.hideKeyboardAccessoryBar(true);
	}
	if (window.StatusBar) {
	// org.apache.cordova.statusbar required
	StatusBar.styleDefault();
	}


	if(window.cordova) {
	// App syntax
	db = $cordovaSQLite.openDB("myapp.db");
	} else {
	// Ionic serve syntax
	db = window.openDatabase("myapp.db", "1.0", "My app", -1);
	}

	$cordovaSQLite.execute(db, "CREATE TABLE IF NOT EXISTS team (id integer primary key, name text)");
	});
	})
	.controller('TeamCtrl', function($scope, Team) {
	$scope.team = [];
	$scope.team = null;

	$scope.updateTeam = function() {
	Team.all().then(function(team){
	$scope.team = team;
	});
	}

	$scope.updateTeam();

	$scope.createNewTeamMember = function(member) {
	Team.add(member);
	$scope.updateTeam();
	};

	$scope.removeMember = function(member) {
	Team.remove(member);
	$scope.updateTeam();
	};

	$scope.editMember = function(origMember, editMember) {
	Team.update(origMember, editMember);
	$scope.updateTeam();
	};

	})
	<!DOCTYPE html>
	<html>
	<head>
	<!-- standard Ionic head -->

	<!-- Download https://github.com/driftyco/ng-cordova/archive/master.zip -->
	<script src="js/ng-cordova.min.js"></script>
	angular.module('myapp.services', [])

	.factory('DBA', function($cordovaSQLite, $q, $ionicPlatform) {
	var self = this;

	// Handle query's and potential errors
	self.query = function (query, parameters) {
	parameters = parameters \|\| [];
	var q = $q.defer();

	$ionicPlatform.ready(function () {
	$cordovaSQLite.execute(db, query, parameters)
	.then(function (result) {
	q.resolve(result);
	}, function (error) {
	console.warn('I found an error');
	console.warn(error);
	q.reject(error);
	});
	});
	return q.promise;
	}

	// Proces a result set
	self.getAll = function(result) {
	var output = [];

	for (var i = 0; i < result.rows.length; i++) {
	output.push(result.rows.item(i));
	}
	return output;
	}

	// Proces a single result
	self.getById = function(result) {
	var output = null;
	output = angular.copy(result.rows.item(0));
	return output;
	}

	return self;
	})

	.factory('Team', function($cordovaSQLite, DBA) {
	var self = this;

	self.all = function() {
	return DBA.query("SELECT id, name FROM team")
	.then(function(result){
	return DBA.getAll(result);
	});
	}

	self.get = function(memberId) {
	var parameters = [memberId];
	return DBA.query("SELECT id, name FROM team WHERE id = (?)", parameters)
	.then(function(result) {
	return DBA.getById(result);
	});
	}

	self.add = function(member) {
	var parameters = [member.id, member.name];
	return DBA.query("INSERT INTO team (id, name) VALUES (?,?)", parameters);
	}

	self.remove = function(member) {
	var parameters = [member.id];
	return DBA.query("DELETE FROM team WHERE id = (?)", parameters);
	}

	self.update = function(origMember, editMember) {
	var parameters = [editMember.id, editMember.name, origMember.id];
	return DBA.query("UPDATE team SET id = (?), name = (?) WHERE id = (?)", parameters);
	}

	return self;
	})