GitHub - amudev007/fetch: Fluent API to query data in ContentResolver and SQLiteDatabase

A library to eliminate boilerplate when querying ContentResolver and SQLiteDatabase.

Usage

Add the following dependency to your Gradle config:

dependencies {
    compile 'com.evernote:android-fetch:0.1.0'
}

In its simplest form, the library enables this:

Cursor cursor;
List<String> result = new ArrayList<>();
try {
  cursor = contentResolver.query(sourceUri, null, null, null, null);
  while (cursor != null && cursor.moveToNext()) {
    result.add(cursor.getString(0));
  }
} finally {
  if (cursor != null) {
    cursor.close();
  }
}

To become this:

List<String> result = QueryBuilder.cr(sourceUri)
  .fetch(contentResolver).toList(Converter.STRING);

Every parameter of query can be specified by calling additional optional methods, and you can use a custom Converter to build your own objects:

List<Thing> things = QueryBuilder.db("my_table")
  .projection("id", "name", "description")
  .selection("size = ?")
  .selectionArgs("42")
  .sortOrder("name")
  .fetch(database)
  .toList(new Converter<Thing>() {
    @Override
    public Thing convert(Cursor c) {
      int id = c.getInt(0);
      String name = c.getString(1);
      String description = c.getString(2);
      return new Thing(id, name, description);
    }
  });

There are also convenience methods for filters on list of values:

QueryBuilder.cr(sourceUri).select("name", nameList);

is equivalent to:

contentResolver.query(sourceUri, null,
  "name in (?,?,?)",
  nameList.toArray(new String[nameList.size()]),
  null);