A simplification of database access.
SQLiteProvider implements a ContentProvider for you that allows database access using Uri's
Download the latest JAR or grab via
Gradle:
dependencies {
compile 'com.novoda:sqliteprovider-core:1.0.1'
}Maven:
<dependency>
<groupId>com.novoda</groupId>
<artifactId>sqliteprovider-core</artifactId>
<version>1.0.1</version>
</dependency>You will need to declare the Novoda repository:
Gradle:
repositories {
maven {
url "http://ci.novoda.com/maven/releases/"
}
}Maven:
<repositories>
<repository>
<id>public-mvn-repo-releases</id>
<url>http://ci.novoda.com/maven/releases/</url>
</repository>
</repositories>Check the WIKI for further instruction
Simple example source code can be found in this demo module: Android Simple Demo
Advanced queries & source code can be found in this demo module: Android Extended Demo
The library is meant to augment the ContentProvider interface to fit SQLite in a more pronounced way. The aim is to set convention on queries via URI.
The following Uris are possible (some may not be supported yet):
Generic table support:
Uri: content://<authority>/tableName
Sql: select * from "tableName"
Primary key support:
Uri: content://<authority>/tableName/1
Sql: select * from "tableName" where _id=1
One to many support:
Uri: content://<authority>/tableName/1/child
Sql: select * from "child" where tableName_id=1
Group by & having support:
Uri: content://<authority>/tableName?groupBy=col&having=value
Sql: select * from tableName group by col having value
limit support:
Uri: content://<authority>/tableName?limit=number
Sql: select * from tableName limit number
distinct support:
Uri: content://<authority>/tableName?distinct=true
Sql: select distinct * from tableName limit number
join support (TODO):
Uri: content://<authority>/parent/1/child/2
Sql: select * from child inner join parent on parent._id=child.parent_id;
Gives the ability to query information from the table SQLITE_MASTER and versionning.
content://<authority>/_info
Querying the above will yield the following cursor:
type TEXT | name TEXT | tbl_name TEXT | rootpage INTEGER | sql TEXT
If you are interested to only get the table name, the following should be helpful:
getContentResolver().query(Uri.parse("content://<authority>/_info"), new String[] {"name"}, null, null, null);
To get the current version of the database similar to "select sqlite_version() AS sqlite_version":
content://<authority>/_info?version
returns the following cursor:
sqlite_version TEXT
Executing some file resizing using vacuum
content://<authority>/_vacuum
(TODO) set max size??
Ability to execute Pragma calls against SQLite. This is handy to get further info on table or set values such as "PRAGMA synchronous=OFF"
content://<authority>/_pragma?<pragma_name>=<value>
For instance the following will exectute "PRAGMA synchronous=OFF"
content://<authority>/_pragma?synchronous=OFF
The following will give back table information for a specific table:
content://<authority>/_pragma?table_info("tableName")
The resulting cursor is
column name | data type | can be NULL? | the default value for the column
If you insert against
content://<authority>/_db?create=<tableName>&withId=<true|false>&foreignKey=[<comma_separated_list_of_parent_tables>]&createdAt=false&updatedAt=false
(TODO) alter?
tableName (mandatory): the table name
withId (optional): automatically add "_id PRIMARY KEY AUTOINCREMENT" - default is true
foreignKey (optional): automatically add <fk_name>_id as foreign key to table creation
createdAt (optional): will put a createdAt field which contains creation date - default to insert
updatedAt (optional): will put a updatedAt field which contains update date - default to insert
you should have content values put with "column name" mapped to a SQLite type (look at SQLiteType)
Uri uri = Uri.parse("content://authority/_db?create=table");
ContentValues values = new ContentValues();
values.put("name", "TEXT");
values.put("rid", "INTEGER");
getContentResolver().insert(uri, values);To build the core library jar you can use the following gradle command;
./gradlew assembleRelease
This will result in the core jar being available at
core/build/bundles/release/classes.jar
(c) Copyright 2014 Novoda
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.