JarCasting
SqliteManager
get sample apk from Google Play Store
What is this library about?
Sqlite Manager helps to manage your android Sqlite Database very effectively with ease
(currently under active development, expect to see new releases almost daily)
Features
- Add, Update and Delete entries from tables in UI (no sql).
- Check all the table entries in your database with preferred sort order
- Do custom queries on your database and results are displayed in UI
Download
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
Usage
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);
CSV/Json Export feature
To Use export as CSV/Json feature. need to define FileProvider in your app manifest.
1. If you don't have file-provider in your 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>
- create a new xml file with name file_provider_paths and paste the below content in the file
<?xml version="1.0" encoding="utf-8"?>
<paths>
<files-path
name="sqlite_dump"
path="sqliteManager/" />
</paths>
- while launching sqlite manager pass application_id
SqliteManager.launchSqliteManager(this, new HelperSqliteDataRetriever(sqliteHelper), BuildConfig.APPLICATION_ID);
2. If you already have a file-provider in your manifest
- add files-path mentioned below to existing paths in your xml file.
<?xml version="1.0" encoding="utf-8"?>
<paths>
<!-- -.-.-.-.-.-.-.-.-.-.- your current paths, caches ..etc -.-.-.-.-.-.-.-.-.-.- -->
<files-path
name="sqlite_dump"
path="sqliteManager/" />
</paths>
- while launching sqlite manager pass the authorities declared in your manifest
SqliteManager.launchSqliteManager(this, new HelperSqliteDataRetriever(sqliteHelper), "authority_string_mentioned_in_your_manifest");
License
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.
Other Open Source Libraries
- Gander : Gander is a simple in-app HTTP inspector for Android OkHttp clients. Gander intercepts and persists all HTTP requests and responses inside your application, and provides a UI for inspecting their content.
- SharedPrefManager : SharedPref Manager is a Dev Debug tool that helps to manage(Edit, Add, Clear) your android Shared Preferences.
- BottomNavigation : This Library helps users to use Bottom Navigation Bar (A new pattern from google) with ease and allows ton of customizations.