com.path.android.jobqueue.persistentQueue.sqlite
Class SqlHelper

java.lang.Object
  com.path.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

static class	SqlHelper.Order
static class	SqlHelper.Property

Constructor Summary

SqlHelper(SQLiteDatabase db, java.lang.String tableName, java.lang.String primaryKeyColumnName, int columnCount, long sessionId)

Method Summary

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)
static java.lang.String	drop(java.lang.String tableName)
SQLiteStatement	getCountStatement()
SQLiteStatement	getDeleteStatement()
SQLiteStatement	getInsertOrReplaceStatement()
SQLiteStatement	getInsertStatement()
SQLiteStatement	getNextJobDelayedUntilWithNetworkStatement()
SQLiteStatement	getNextJobDelayedUntilWithoutNetworkStatement()
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(SQLiteDatabase db,
                 java.lang.String tableName,
                 java.lang.String primaryKeyColumnName,
                 int columnCount,
                 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 SQLiteStatement getInsertStatement()

getCountStatement

public SQLiteStatement getCountStatement()

getInsertOrReplaceStatement

public SQLiteStatement getInsertOrReplaceStatement()

getDeleteStatement

public SQLiteStatement getDeleteStatement()

getOnJobFetchedForRunningStatement

public SQLiteStatement getOnJobFetchedForRunningStatement()

getNextJobDelayedUntilWithNetworkStatement

public SQLiteStatement getNextJobDelayedUntilWithNetworkStatement()

getNextJobDelayedUntilWithoutNetworkStatement

public SQLiteStatement getNextJobDelayedUntilWithoutNetworkStatement()

createSelect

public java.lang.String createSelect(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)