get sample apk from Google Play Store
Sqlite Manager helps to manage your android Sqlite Database very effectively with ease
(currently under active development, expect to see new releases almost daily)
Based on your IDE you can import library in one of the following ways
Gradle:
debugCompile 'com.ashokvarma.android:sqlite-manager:1.3.0'
releaseCompile 'com.ashokvarma.android:sqlite-manager-no-op:1.3.0'
If you want this in library in production also then try this :
compile 'com.ashokvarma.android:sqlite-manager:1.3.0'
or grab via Maven:
<dependency>
<groupId>com.ashokvarma.android</groupId>
<artifactId>sqlite-manager</artifactId>
<version>1.3.0</version>
<type>pom</type>
</dependency>
or Ivy:
<dependency org='com.ashokvarma.android' name='sqlite-manager' rev='1.3.0'>
<artifact name='$AID' ext='pom'></artifact>
</dependency>
or Download the latest JAR
Implement SqliteDataRetriever interface either directly in SqliteOpenHelper (OR) if you are using thrid party ORM's ..etc just provide the inteface to library
Here is an example interface if SqliteOpenHelper is used (for other library implementations - check sample project)
public class HelperSqliteDataRetriever implements SqliteDataRetriever {
SqliteHelper mSqliteHelper;
SQLiteDatabase mSQLiteDatabase;
HelperSqliteDataRetriever(SqliteHelper sqliteHelper) {
mSqliteHelper = sqliteHelper;
mSQLiteDatabase = mSqliteHelper.getWritableDatabase();
}
@Override
public Cursor rawQuery(@NonNull String query, String[] selectionArgs) {
if (mSQLiteDatabase == null || !mSQLiteDatabase.isOpen()) {
mSQLiteDatabase = mSqliteHelper.getWritableDatabase();
}
return mSQLiteDatabase.rawQuery(query, selectionArgs);
}
@Override
public String getDatabaseName() {
return mSqliteHelper.getDatabaseName();
}
@Override
public void freeResources() {
// not good practice to open multiple database connections and close every time
}
}
Then just pass the interface instance with the context to launchSqliteManager method
SqliteManager.launchSqliteManager(this, new HelperSqliteDataRetriever(sqliteHelper), null);
To Use export as CSV/Json feature. need to define FileProvider in your app manifest.
Add this section under application tag in your manifest
<provider
android:name="android.support.v4.content.FileProvider"
android:authorities="${applicationId}"
android:exported="false"
android:grantUriPermissions="true">
<meta-data
android:name="android.support.FILE_PROVIDER_PATHS"
android:resource="@xml/file_provider_paths" />
</provider>
<?xml version="1.0" encoding="utf-8"?>
<paths>
<files-path
name="sqlite_dump"
path="sqliteManager/" />
</paths>
SqliteManager.launchSqliteManager(this, new HelperSqliteDataRetriever(sqliteHelper), BuildConfig.APPLICATION_ID);
<?xml version="1.0" encoding="utf-8"?>
<paths>
<!-- -.-.-.-.-.-.-.-.-.-.- your current paths, caches ..etc -.-.-.-.-.-.-.-.-.-.- -->
<files-path
name="sqlite_dump"
path="sqliteManager/" />
</paths>
SqliteManager.launchSqliteManager(this, new HelperSqliteDataRetriever(sqliteHelper), "authority_string_mentioned_in_your_manifest");
Sqlite Manager library for Android
Copyright (c) 2016 Ashok Varma (http://ashokvarma.me/).
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.