com.salesforce.androidsdk.smartstore.store

Class SmartSqlHelper

java.lang.Object

com.salesforce.androidsdk.smartstore.store.SmartSqlHelper

public class SmartSqlHelper
extends java.lang.Object

SmartSqlHelper "smart" sql Helper Singleton class that provides helpful methods for converting/running "smart" sql

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SmartSqlHelper.SmartSqlException Exception thrown when smart sql failed to be parsed

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	SOUP
static java.util.regex.Pattern	SOUP_PATH_PATTERN
static java.lang.String	TABLE_DOT_JSON_EXTRACT_REGEXP

Constructor Summary

Constructors

Constructor and Description
SmartSqlHelper()

Method Summary

Modifier and Type	Method and Description
java.lang.String	convertSmartSql(SQLiteDatabase db, java.lang.String smartSql) Convert "smart" sql query to actual sql A "smart" sql query is a query where columns are of the form {soupName:path} and tables are of the form {soupName} NB: only select's are allowed only indexed path can be referenced (alternatively you can do {soupName:_soupEntryId} or {soupName:_soupLastModifiedDate} to get an entire soup element back, do {soupName:_soup}
static SmartSqlHelper	getInstance(SQLiteDatabase db) Returns the instance of this class associated with the database specified.

Methods inherited from class java.lang.Object

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

Field Detail

SOUP_PATH_PATTERN

public static final java.util.regex.Pattern SOUP_PATH_PATTERN

TABLE_DOT_JSON_EXTRACT_REGEXP

public static final java.lang.String TABLE_DOT_JSON_EXTRACT_REGEXP

See Also:

Constant Field Values

SOUP

public static final java.lang.String SOUP

See Also:

Constant Field Values

Constructor Detail

SmartSqlHelper

public SmartSqlHelper()

Method Detail

getInstance

public static SmartSqlHelper getInstance(SQLiteDatabase db)

Returns the instance of this class associated with the database specified.

Parameters:

db - Database.

Returns:

Instance of this class.

convertSmartSql

public java.lang.String convertSmartSql(SQLiteDatabase db,
                                        java.lang.String smartSql)

Convert "smart" sql query to actual sql A "smart" sql query is a query where columns are of the form {soupName:path} and tables are of the form {soupName} NB: only select's are allowed only indexed path can be referenced (alternatively you can do {soupName:_soupEntryId} or {soupName:_soupLastModifiedDate} to get an entire soup element back, do {soupName:_soup}

Parameters:

db -

smartSql -

Returns:

actual sql