com.birbit.android.jobqueue.persistentQueue.sqlite

Class SqlHelper

java.lang.Object

com.birbit.android.jobqueue.persistentQueue.sqlite.SqlHelper

public class SqlHelper
extends java.lang.Object

Helper class for SqliteJobQueue to generate sql queries and statements.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SqlHelper.ForeignKey
static class	SqlHelper.Order
static class	SqlHelper.Property

Constructor Summary

Constructors

Constructor and Description
SqlHelper(android.database.sqlite.SQLiteDatabase db, java.lang.String tableName, java.lang.String primaryKeyColumnName, int columnCount, java.lang.String tagsTableName, int tagsColumnCount, long sessionId)

Method Summary

Modifier and Type	Method and Description
static java.lang.String	create(java.lang.String tableName, SqlHelper.Property primaryKey, SqlHelper.Property... properties)
java.lang.String	createSelect(java.lang.String where, java.lang.Integer limit, SqlHelper.Order... orders)
java.lang.String	createSelectOneField(java.lang.String selectArg, java.lang.String where, java.lang.Integer limit, SqlHelper.Order... orders)
static java.lang.String	drop(java.lang.String tableName)
android.database.sqlite.SQLiteStatement	getCountStatement()
android.database.sqlite.SQLiteStatement	getDeleteJobTagsStatement()
android.database.sqlite.SQLiteStatement	getDeleteStatement()
android.database.sqlite.SQLiteStatement	getInsertOrReplaceStatement()
android.database.sqlite.SQLiteStatement	getInsertStatement()
android.database.sqlite.SQLiteStatement	getInsertTagsStatement()
android.database.sqlite.SQLiteStatement	getOnJobFetchedForRunningStatement()
void	resetDelayTimesTo(long newDelayTime)
void	truncate()
void	vacuum()

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlHelper

public SqlHelper(android.database.sqlite.SQLiteDatabase db,
                 java.lang.String tableName,
                 java.lang.String primaryKeyColumnName,
                 int columnCount,
                 java.lang.String tagsTableName,
                 int tagsColumnCount,
                 long sessionId)

Method Detail

create

public static java.lang.String create(java.lang.String tableName,
                                      SqlHelper.Property primaryKey,
                                      SqlHelper.Property... properties)

drop

public static java.lang.String drop(java.lang.String tableName)

getInsertStatement

public android.database.sqlite.SQLiteStatement getInsertStatement()

getInsertTagsStatement

public android.database.sqlite.SQLiteStatement getInsertTagsStatement()

getCountStatement

public android.database.sqlite.SQLiteStatement getCountStatement()

getInsertOrReplaceStatement

public android.database.sqlite.SQLiteStatement getInsertOrReplaceStatement()

getDeleteStatement

public android.database.sqlite.SQLiteStatement getDeleteStatement()

getDeleteJobTagsStatement

public android.database.sqlite.SQLiteStatement getDeleteJobTagsStatement()

getOnJobFetchedForRunningStatement

public android.database.sqlite.SQLiteStatement getOnJobFetchedForRunningStatement()

createSelect

public java.lang.String createSelect(java.lang.String where,
                                     java.lang.Integer limit,
                                     SqlHelper.Order... orders)

createSelectOneField

public java.lang.String createSelectOneField(java.lang.String selectArg,
                                             java.lang.String where,
                                             java.lang.Integer limit,
                                             SqlHelper.Order... orders)

truncate

public void truncate()

vacuum

public void vacuum()

resetDelayTimesTo

public void resetDelayTimesTo(long newDelayTime)