Issue with Android copyDbFromStorage about cordova-plugin-dbcopy

[an-rahulpandey]

Hi,
If you read here - https://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper

SQLiteOpenHelper requires to open the db in readable or writable format first before performing an action first. I do not remember why exactly I try to open the database before copying it, rather than directly copying it to native location.

I will create one test copy of the plugin which just copy the db whenever I get time.

[bryans99]

As near as I can tell, dbcopy is not aware of sqlite-storage. I am using sqlite-storage to control access to the databases (open, close, delete etc). dbcopy is just being used to copy from the location where the database is downloaded to, to the location where the databases are stored. The advantage of dbcopy is that it figures out the location of the databases. Prior to the copy, I close and delete the file using sqlite-storage.

I figured out what was happening by using the built in Android database classes (androidDatabaseImplementation: 2). When using this implementation three files are created in the database directory when the database is opened.

-rw------- 1 u0_a81 u0_a81 69632 2018-06-19 17:40 Code.db
-rw------- 1 u0_a81 u0_a81 32768 2018-06-19 17:40 Code.db-shm
-rw------- 1 u0_a81 u0_a81 412032 2018-06-19 17:40 Code.db-wal

After using copyDbFromStorage, I noticed the same three files being created. sqllite-storage is not aware of the database being opened so I cannot use it to close the database. When I open the database using sqllite-storage, the database appears to be empty (although on the file system, the size does not change). As soon as I close the database, the file is truncated.

I guess an alternate possibility is to close the database after the copy. If I get a chance I will try that today.

Thanks.

[an-rahulpandey]

@bryans99 Yes, thats a good observation, closing the database after opening in the plugin might do the trick. Let me see if I can quickly do it.