RequestPermissions exception about sqlite HOT 5 CLOSED

@eugenezhornyak
First thanks for using the plugin, i spent my afternoon to try understanding what is wrong. In fact the main reason is that the way you want to work with the plugin is questionable. In fact, the sqliteService instance use in DatabaseInitializationService and the one ProductsRepositoryService is not the same meaning that the

res = mDb.querySQL(statement, new ArrayList<String>());
``` in the CapacitorSQLite.java file  the mDb is null as the open method has not been called for that instance.

The way you make your `readAll()` method in `ProductsRepositoryService` is wrong. It should be 

async readAll(): Promise<Product[]> {
/*
return this.executeIfDbExist(this.selectAllCommand).then(result => {
console.log('Read products result:' + JSON.stringify(result));
return result;
});
*/
return await this.sqliteService.query(this.selectAllCommand);
}

YOU DO NOT REALLY NEED TO EXECUTE executeIfDbExist
as when you run the database.initialization.service.initializeDatabase()
if it return false you do not execute in Home page the refreshData()
if you still do it, it will slow down the app for nothing

I didn't find the way to make the SQLiteService a singleton through the app. 

From Angular doc

Providing a singleton service
There are two ways to make a service a singleton in Angular:

• Set the providedIn property of the @Injectable() to "root".
• Include the service in the AppModule or in a module that is only imported by the AppModule

I have tried both but i did not find the way to make it working.

Look at `https://github.com/jepiqueau/angular-sqlite-app-starter` this one works, and build your application along that.
If you find the way to make the SQLiteService a singleton, i will be interested in

from sqlite.

@eugenezhornyak i have found the solution. I have to update first the android plugin to implement a listener for granted permissions and after this i will share the app.

from sqlite.

@eugenezhornyak have a look at https://github.com/jepiqueau/test-sqlite-issue51
You cannot instantiate DatabaseInitializationService in the ngAfterViewInit lifecycle event on the app.component as the router bring you straight forward in the Home page. Hope this will help.

from sqlite.

@jepiqueau Thank you for attention paid! Your solution is very helpful. My problem solved

from sqlite.

@eugenezhornyak Happy that everything works fine. i close the issue

from sqlite.