Showing posts with label import sqlite. Show all posts

SQLite Importer Exporter - Library


A light weight library for exporting and importing sqlite database in android

Created By

API

How to Download

Gradle:
compile 'com.ajts.androidmads.sqliteimpex:library:1.0.0'
Maven:
<dependency>
  <groupId>com.ajts.androidmads.sqliteimpex</groupId>
  <artifactId>library</artifactId>
  <version>1.0.0</version>
  <type>pom</type>
</dependency>

How to use this Library:

This Library is used to import SQLite Database from Assets or External path and Export/Backup SQLite Database to external path.
SQLiteImporterExporter sqLiteImporterExporter = new SQLiteImporterExporter(getApplicationContext(), db);

// Listeners for Import and Export DB
sqLiteImporterExporter.setOnImportListener(new SQLiteImporterExporter.ImportListener() {
    @Override
    public void onSuccess(String message) {
        Toast.makeText(getApplicationContext(), message, Toast.LENGTH_SHORT).show();
    }

    @Override
    public void onFailure(Exception exception) {
        Toast.makeText(getApplicationContext(), exception.getMessage(), Toast.LENGTH_SHORT).show();
    }
});

sqLiteImporterExporter.setOnExportListener(new SQLiteImporterExporter.ExportListener() {
    @Override
    public void onSuccess(String message) {
        Toast.makeText(getApplicationContext(), message, Toast.LENGTH_SHORT).show();
    }

    @Override
    public void onFailure(Exception exception) {
        Toast.makeText(getApplicationContext(), exception.getMessage(), Toast.LENGTH_SHORT).show();
    }
});

To Import SQLite from Assets

try {
    sqLiteImporterExporter.importDataBaseFromAssets();
} catch (Exception e) {
    e.printStackTrace();
}

To import from external storage

try {
    sqLiteImporterExporter.importDataBase(path);
} catch (Exception e) {
    e.printStackTrace();
}

To export to external storage

try {
    sqLiteImporterExporter.exportDataBase(path);
} catch (Exception e) {
    e.printStackTrace();
}

Download From Github