Last active
September 21, 2023 07:36
-
-
Save botris/29d1ed19d0df6051c56f to your computer and use it in GitHub Desktop.
Ionic using Cordova-SQLitePlugin with service / factory. A merge of https://blog.nraboy.com/2014/11/use-sqlite-instead-local-storage-ionic-framework/ and https://gist.github.com/jgoux/10738978
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cordova plugin add https://github.com/brodysoft/Cordova-SQLitePlugin.git |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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)"); | |
| }); | |
| }) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| .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(); | |
| }; | |
| }) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!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> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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; | |
| }) |
If I'm correct, get getById method returns the first result. Is "getFirst" not a much better method name?
Hi Dirk, no it returns 1 result based on the ID, so not the first result.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Thanks for the great work Boriss.
I got an error when trying to display a single item.
"Error: Failed to execute 'item' on 'SQLResultSetRowList': The index provided (0) is greater than or equal to the maximum bound (0).
at Error (native)
at Object.self.getById"
Thanks for your help.