sqlDB

Copy SQLite Database to Document Directory
Rahul Pandey1.0.115
platforms: android,ios
$ cordova plugin add me.rahul.plugins.sqlDB

cordova-plugin-dbcopy

Copy SQLite Database from assets(Android) or Resources(iOS) to App Directory

Note

Android

Put your sqlite database in the assets directory.

iOS

Put your database in Resources directory and then Add it in to your Xcode Project. Right Click on the Resources directory, then click Add files.

Methods

Currently there is only one method which is to copy the db in documents directory.

        window.plugins.sqlDB.copy(dbname,success,error);

Here -

dbname -> Is the name of the database you want to copy. The dbname can be filename (without extensions) or filename.db or filename.sqlite. The plugin will look for and copy the file according to the filename provided here. And the same file name should be used while opening the database via SQLitePlugin.

success -> function will be called if the db is copied sucessfully.

error -> function will be called if the there is some problem in copying the db or the file already exists on the location (Working on it to get more relevant results).

Example Usage

In your JavaScript or HTML use the following method -

function dbcopy()
{
        //Database filename to be copied is demo.db
        window.plugins.sqlDB.copy("demo.db",copysuccess,copyerror);
}

function copysuccess()
{
        //open db and run your queries
         db = window.sqlitePlugin.openDatabase({name: "demo.db"});.
}

funtion copyerror(e)
{
        //db already exists or problem in copying the db file. Check the Log.
        console.log("Error = "+JSON.stringify(e));
}