Exposing non-SQL data as an SQL Cursor
In Chapter: Data Persistence
Author: Ian Darwin (firstname.lastname@example.org) 'idarwin'
You have non-SQL data, such as a list of files, and want to present it as a Cursor
Subclass AbstractCursor and implement various required methods.
It is common to have data in a form other than a Cursor
, but want to present it as a cursor for use in a ListView
with an Adapter
or a CursorLoader.
The AbstractCursor class facilitates this. While Cursor is an interface that you could implement directly, there are a number of routines therein that are pretty much the same in every implementation of Cursor, so they have been abstracted out and made into the AbstractCursor class.
In this short example we expose a list of filenames, which has the structure
We will expose this as a Cursor, and consume it in a SimpleCursorAdapter. First the start of the DataToCursor class:
- id - sequence number
- filename - full path
- type - the filename extension
As you can see there are two arrays, one for the column names going across, and one for the rows going down. In this simple example we don't have to track the ID values (since they are the same as the index into the DATAROWS array) nor the file types (since they are the same as the filename extension).
There are a few structural methods that are needed.
The getColumnCount is obviously derivable but since it's constant, we override the method for efficiency reasons - probably not necessary in most applications.
Then there are some necessary get methods, notably those for getting the type of a given column (is it numeric, string, etc), and those for getting the value of a given column in the current row. Nicely, the AbstractCursor handles all the moveToRow() and related methods, so we just have to call the inherited (and protected) method getPosition().
The remaining methods aren't interesting; methods like getFloat(), getBlob() and so on, merely throw exceptions as, in this example, there are no columns of those types.
The main activity shows nothing different than the other ListView examples in the ListView chapter: the data from the cursor is loaded into a ListView using a SimpleCursorAdapter (which is deprecated, but works fine for this example).
The result is shown here:
We have successfully shown this proof-of-concept of generating a Cursor without using SQLite). It would obviously be straightforward to turn this into a more dynamic file-listing utility, even a file manager. You'd want to use a CursorLoader instead of a SimpleCursorAdapter to make it complete.
Download:The source code for this project is in the Android Cookbook repository,