stanford.androidlib.data

Class SimpleDatabase

java.lang.Object

stanford.androidlib.data.SimpleDatabase

public class SimpleDatabase
extends Object

This class provides methods to help make it easier to query local SQLite databases. Some methods require the context of a SimpleActivity, so you must call SimpleDatabase.with(yourActivity) first.

Method Summary

Modifier and Type	Method and Description
SimpleDatabase	executeSqlFile(SQLiteDatabase db, int id) Reads the .sql file with the given resource ID and executes all SQL statements inside it using the given database.
SimpleDatabase	executeSqlFile(String name) Reads the .sql file with the given name and executes all SQL statements inside it, placing them into a database with the same name as the file.
static String[]	getTableNames(SQLiteDatabase db) Returns the names of all tables in the given database as an array.
static SimpleCursor	rows(Cursor cursor) Returns an object that can be used to iterate over the rows of a given query cursor.
static SimpleDatabase	setLogging(boolean logging) Sets whether Log.d statements should print as queries are run.
static SimpleDatabase	with(SimpleActivity context) Returns a singleton SimpleDatabase instance bound to the given context.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

with

public static SimpleDatabase with(SimpleActivity context)

Returns a singleton SimpleDatabase instance bound to the given context.

setLogging

public static SimpleDatabase setLogging(boolean logging)

Sets whether Log.d statements should print as queries are run.

executeSqlFile

public SimpleDatabase executeSqlFile(String name)

Reads the .sql file with the given name and executes all SQL statements inside it, placing them into a database with the same name as the file. For example, if you pass "foo", reads/executes file resource R.raw.foo and uses it to create/populate a database named foo.

executeSqlFile

public SimpleDatabase executeSqlFile(SQLiteDatabase db,
                                     @RawRes
                                     int id)

Reads the .sql file with the given resource ID and executes all SQL statements inside it using the given database.

getTableNames

public static String[] getTableNames(SQLiteDatabase db)

Returns the names of all tables in the given database as an array. (Omits the private SQLite/Android table names like android_metadata.) Reference: http://stackoverflow.com/questions/15383847/how-to-get-all-table-names-in-android-sqlite-database

rows

public static SimpleCursor rows(Cursor cursor)

Returns an object that can be used to iterate over the rows of a given query cursor.

     for (SimpleRow row : SimpleDatabase.rows(myCursor)) { ... }