com.blueshift.framework

Class BaseSqliteTable<T>

java.lang.Object

android.database.sqlite.SQLiteOpenHelper

com.blueshift.framework.BaseSqliteTable<T>

All Implemented Interfaces:

java.lang.AutoCloseable

Direct Known Subclasses:

EventsTable, FailedEventsTable, RequestQueueTable

public abstract class BaseSqliteTable<T>
extends android.database.sqlite.SQLiteOpenHelper

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected static class	BaseSqliteTable.FieldType

Field Summary

Fields

Modifier and Type	Field and Description
protected static java.lang.Boolean	lock

Constructor Summary

Constructors

Constructor and Description
BaseSqliteTable(android.content.Context context)

Method Summary

Modifier and Type	Method and Description
protected int	delete(java.lang.String key, java.util.ArrayList<java.lang.String> values)
protected void	delete(java.lang.String key, java.lang.String value)
protected int	delete(java.lang.String fieldName, java.lang.String[] values)
void	deleteAll()
void	deleteAllAsync()
java.util.ArrayList<T>	findAll() finder methods
java.util.ArrayList<T>	findAllByField(java.lang.String[] fieldNames, java.lang.String[] values)
java.util.ArrayList<T>	findAllByField(java.lang.String[] fieldNames, java.lang.String[] values, int pageNo, java.lang.String order)
java.util.ArrayList<T>	findAllByField(java.lang.String[] fieldNames, java.lang.String[] values, int pageNo, java.lang.String order, java.lang.String search)
java.util.ArrayList<T>	findAllByField(java.lang.String fieldName, java.lang.String value)
T	findByField(java.lang.String fieldName, long value)
T	findByField(java.lang.String fieldName, java.lang.String value)
T	findRandomByField(java.lang.String fieldName, long value)
java.util.ArrayList<T>	findWithLimit(int limit)
protected java.lang.String	generateCreateTableQuery() Generates SQL query to create a table with available tableName and field-Type HashMap.
protected abstract android.content.ContentValues	getContentValues(T t)
android.content.Context	getContext()
protected abstract java.util.HashMap<java.lang.String,BaseSqliteTable.FieldType>	getFields()
T	getFirstRecord()
protected abstract java.lang.Long	getId(T t)
protected abstract java.lang.String	getTableName()
void	insert(T item)
protected boolean	isValidCursor(android.database.Cursor cursor)
protected abstract T	loadObject(android.database.Cursor cursor)
void	onCreate(android.database.sqlite.SQLiteDatabase db)
void	onUpgrade(android.database.sqlite.SQLiteDatabase db, int oldVersion, int newVersion)
void	update(T item)

Methods inherited from class android.database.sqlite.SQLiteOpenHelper

close, getDatabaseName, getReadableDatabase, getWritableDatabase, onConfigure, onDowngrade, onOpen, setIdleConnectionTimeout, setLookasideConfig, setOpenParams, setWriteAheadLoggingEnabled

Methods inherited from class java.lang.Object

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

Field Detail

lock

protected static final java.lang.Boolean lock

Constructor Detail

BaseSqliteTable

public BaseSqliteTable(android.content.Context context)

Method Detail

onCreate

public void onCreate(android.database.sqlite.SQLiteDatabase db)

Specified by:

onCreate in class android.database.sqlite.SQLiteOpenHelper

onUpgrade

public void onUpgrade(android.database.sqlite.SQLiteDatabase db,
                      int oldVersion,
                      int newVersion)

Specified by:

onUpgrade in class android.database.sqlite.SQLiteOpenHelper

generateCreateTableQuery

protected java.lang.String generateCreateTableQuery()

Generates SQL query to create a table with available tableName and field-Type HashMap.

Returns:

valid create table SQL query if valid arguments given, else null.

getContext

public android.content.Context getContext()

insert

public void insert(T item)

update

public void update(T item)

delete

protected void delete(java.lang.String key,
                      java.lang.String value)

delete

protected int delete(java.lang.String key,
                     java.util.ArrayList<java.lang.String> values)

delete

protected int delete(java.lang.String fieldName,
                     java.lang.String[] values)

deleteAllAsync

public void deleteAllAsync()

deleteAll

public void deleteAll()

findAll

public java.util.ArrayList<T> findAll()

finder methods

findWithLimit

public java.util.ArrayList<T> findWithLimit(int limit)

findByField

public T findByField(java.lang.String fieldName,
                     java.lang.String value)

findByField

public T findByField(java.lang.String fieldName,
                     long value)

findRandomByField

public T findRandomByField(java.lang.String fieldName,
                           long value)

findAllByField

public java.util.ArrayList<T> findAllByField(java.lang.String fieldName,
                                             java.lang.String value)

findAllByField

public java.util.ArrayList<T> findAllByField(java.lang.String[] fieldNames,
                                             java.lang.String[] values)

findAllByField

public java.util.ArrayList<T> findAllByField(java.lang.String[] fieldNames,
                                             java.lang.String[] values,
                                             int pageNo,
                                             java.lang.String order)

findAllByField

public java.util.ArrayList<T> findAllByField(java.lang.String[] fieldNames,
                                             java.lang.String[] values,
                                             int pageNo,
                                             java.lang.String order,
                                             java.lang.String search)

getFirstRecord

public T getFirstRecord()

isValidCursor

protected boolean isValidCursor(android.database.Cursor cursor)

getTableName

protected abstract java.lang.String getTableName()

loadObject

protected abstract T loadObject(android.database.Cursor cursor)

getContentValues

protected abstract android.content.ContentValues getContentValues(T t)

getFields

protected abstract java.util.HashMap<java.lang.String,BaseSqliteTable.FieldType> getFields()

getId

protected abstract java.lang.Long getId(T t)