Hi,
I’m trying to set up the SQLite plugin (https://github.com/brodysoft/Cordova-SQLitePlugin) for persisting my application data.
I have to use the Platform object to wait until the device is ready. How would you create this service ? How can I return an instance of sqlitePlugin from the Platform ready function ? I’m not sure about how to do it.
.factory('DB', function(Platform) {
var db;
Platform.ready(function() {
db = window.sqlitePlugin.openDatabase({name: "DB"});
});
return db;
})
I would suggest not having the service return a reference to sqlitePlugin directly. Rather, use the service as a wrapper exposing some public methods to initialize and query the database. Then in the main app’s .run, function, init the database service from your $ionicPlatform.ready callback.
That way, you aren’t initializing the database too early, and since you’ve encapsulated all database interaction within the service, you can swap it out in the future with minimal impact to the rest of the app.
Thanks for the answer !
If I declare the database connexion in the main run() function, how can I access it globally ?
For example in my service, I’ll have to do something like :
Inside an init method of your service. The main run function calls the init method on the service once the platform is ready. You won’t access the database directly from anywhere outside the service itself. The service is a wrapper for the sqlitePlugin methods. For instance, your service would expose a query method that runs the transaction on the database. Everywhere else in the app, you’ll inject the service and run the query method. That way if you changed plugins or database back-ends, you could just change the service itself, and the rest of your app will work with it.
Thanks for the advices !
I’m stuck with my DB factory, I don’t understand how to chain promises to be able to do something like this :
// Random controller
.controller('UserIndexCtrl', function($scope, User) {
$scope.users= [];
User.all().then(function(users) {
$scope.users = users;
});
})
// User service
.factory('User', function(DB) {
var self = this;
self.all = function() {
return DB.query('SELECT * FROM users');
};
return self;
})
// DB service
.factory('DB', function($q, DB_CONFIG) {
var self = this;
self.db = null;
self.init = function() {
// DB init from config.js
self.db = window.openDatabase(DB_CONFIG.name, '1.0', 'database', -1);
angular.forEach(DB_CONFIG.tables, function(table) {
var columns = [];
angular.forEach(table.columns, function(column) {
columns.push(column.name + ' ' + column.type);
});
var query = 'CREATE TABLE IF NOT EXISTS ' + table.name + ' (' + columns.join(',') + ')';
console.log('Création de la table ' + table.name);
self.db.query(query);
});
};
self.query = function(query, bindings) {
bindings = typeof bindings !== 'undefined' ? bindings : [];
var deferred = $q.defer();
self.db.transaction(function(transaction) {
return transaction.executeSql(query, bindings);
});
return deferred.promise;
};
return self;
})
So basically I want to use promise in my DB.query function, and then use this function in my Resources services (User as an example here).
And I want my Resources services to return promises too to map my $scope variables with the result of the query function.
Any idea ?
At first glance, I see that your query function is indeed returning a promise, but that promise is never resolved. You also are not actually processing the data response from the executeSql call. You might want that block to look something like this:
You should also be prepared to reject the promise if your query goes awry, and handle that rejection further upstream. Read up on angular promises for more info: http://docs.angularjs.org/api/ng/service/$q
Haha I forgot to resolve it, indeed !
Thank you for all the help provided, here is my working service if anyone want to use it https://gist.github.com/jgoux/10738978
Thanks, it works perfectly.
Just to add for anyone new to this topic: for iOS the DB.init() must be called after the platformReady. Something in the line:
.controller(‘MyController’, function($scope, $ionicPlatform, $state,DBFactoryObj) {
$ionicPlatform.ready(function() {
// Platform stuff here.
DBFactoryObj.initDB();// the factory method will call the database initialization code, DB.init()
});
}
