| Package | mx.data |
| Class | public class SQLiteOfflineAdapter |
| Inheritance | SQLiteOfflineAdapter  DataServiceOfflineAdapter Object |
| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
Override the getQueryCriteria() method and possibly the getQueryCriteriaParameters() to implement
custom local queries.
Hide Inherited Public Properties
Show Inherited Public Properties| Method | Defined By | ||
|---|---|---|---|
| SQLiteOfflineAdapter | |||
[override] | SQLiteOfflineAdapter | ||
 |
Begins a transaction on the localStore. | DataServiceOfflineAdapter | |
|
Closes the localStore associated with this adapter. | DataServiceOfflineAdapter | |
| commit(dispatcher:IEventDispatcher = null, token:mx.rpc:AsyncToken = null, faultsOnly:Boolean = false):void
Commits any current changes to the local store. | DataServiceOfflineAdapter | |
|
Connect to the specified cache. | DataServiceOfflineAdapter | |
[override] | SQLiteOfflineAdapter | ||
|
Deletes the specified set of offine items with the matching uids from the local store. | DataServiceOfflineAdapter | |
executeOfflineQuery(propSpecifier:PropertySpecifier, args:Array, startIndex:int, numItems:int):mx.rpc:AsyncToken [override]
Used with SQLite adapters to execute dynamic queries locally. | SQLiteOfflineAdapter | ||
|
Returns the current fills that have been cached in the local store. | DataServiceOfflineAdapter | |
[override] | SQLiteOfflineAdapter | ||
[override] | SQLiteOfflineAdapter | ||
|
Restores the message cache from the offline store. | DataServiceOfflineAdapter | |
|
Indicates whether an object has a specified property defined. | Object | |
|
Initialize the cacheId store. | DataServiceOfflineAdapter | |
initializeOfflineMetadata(metadata:Metadata):void [override] | SQLiteOfflineAdapter | ||
|
Returns true if the local store is "connected"; for example, if the local database is open. | DataServiceOfflineAdapter | |
|
Indicates whether an instance of the Object class is in the prototype chain of the object specified
as the parameter. | Object | |
[override]
Indicates whether the adapter supports query execution. | SQLiteOfflineAdapter | ||
|
Indicates whether the specified property exists and is enumerable. | Object | |
|
Restores queries. | DataServiceOfflineAdapter | |
|
Look up the metadata for a given destination. | DataServiceOfflineAdapter | |
|
Rolls back any current changes on the local store. | DataServiceOfflineAdapter | |
[override] | SQLiteOfflineAdapter | ||
|
Saves the pending uncommitted messages and unmerges messages. | DataServiceOfflineAdapter | |
|
Save the meta data configuration for a given destination. | DataServiceOfflineAdapter | |
|
Saves queries to be replayed offline later. | DataServiceOfflineAdapter | |
|
Sets the availability of a dynamic property for loop operations. | Object | |
|
Returns the string representation of this object, formatted according to locale-specific conventions. | Object | |
|
Returns the string representation of the specified object. | Object | |
[override]
Used to update a particular item with the properties that were updated to the offline store. | SQLiteOfflineAdapter | ||
[override]
Used to update the items that were modified to the local store. | SQLiteOfflineAdapter | ||
|
Returns the primitive value of the specified object. | Object | |
| Method | Defined By | ||
|---|---|---|---|
Returns the column name for the specified field, or null if there is no column for
the field. | SQLiteOfflineAdapter | ||
OfflineAdapter implementations should override this method with an implementation
that returns an appropriate SQL WHERE clause for a given set of fill parameters. | SQLiteOfflineAdapter | ||
OfflineAdapter implementation should override this method with an implementation
that returns the values used to substitute parameters in the WHERE clause from
getQueryCriteria. | SQLiteOfflineAdapter | ||
OfflineAdapter implementations should override this method with an implementation
that returns an appropriate SQL ORDER BY clause for a given set of fill parameters. | SQLiteOfflineAdapter | ||
Returns the column name for the specified path. | SQLiteOfflineAdapter | ||
Walk the specified path to find the table responsible for the property path. | SQLiteOfflineAdapter | ||
Returns the column that contains the entity item UID values. | SQLiteOfflineAdapter | ||
internalExecuteOfflineQuery(sqlText:String, parameters:Object, startIndex:int, numItems:int):mx.rpc:AsyncToken
Executes a SQL query against the local store and returns a collection of strongly typed items. | SQLiteOfflineAdapter | ||
SQLiteOfflineAdapter | () | Constructor |
public function SQLiteOfflineAdapter()addOfflineItem | () | method |
deleteOfflineItem | () | method |
executeOfflineQuery | () | method |
override public function executeOfflineQuery(propSpecifier:PropertySpecifier, args:Array, startIndex:int, numItems:int):mx.rpc:AsyncToken| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
Used with SQLite adapters to execute dynamic queries locally.
The default implementation of this function will build a SQL statement for the query in the following manner:
- The SELECT clause will be based on the passed-in property specifier.
-
The WHERE clause will be determined by an invocation to
getQueryCriteria(), which custom implementations should override to return the appropriate WHERE clause for a given set of fill parameters. - The LIMIT (range of selected items) clause will be determined by the start index and number of items arguments.
Once the whole SQL statement has been constructed, it is passed to
internalExecuteOfflineQuery for execution.
Custom implementations should only override this method if they want to perform the full SQL statement creation process on their own.
Parameters
propSpecifier:PropertySpecifier — property specifier determines the SELECT clause for the query
| |
args:Array — fill arguments used by custom implementations to determine the WHERE clause for the query
| |
startIndex:int — start index for a paged query
| |
numItems:int — number of items to retrieve for a paged query or -1 to retrieve all.
|
mx.rpc:AsyncToken — AsyncToken with the result being an array of strongly typed items
|
getFieldColumnName | () | method |
protected function getFieldColumnName(fieldName:String):String| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
Returns the column name for the specified field, or null if there is no column for the field.
By default the column name is the same as the field name, unless it conflicts with an SQLite keyword, in which case it is prefixed with an _.
Parameters
fieldName:String |
String |
getItemReferenceIds | () | method |
getItems | () | method |
override public function getItems(uidArray:Array):DictionaryParameters
uidArray:Array |
Dictionary |
getQueryCriteria | () | method |
protected function getQueryCriteria(args:Array):String| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
OfflineAdapter implementations should override this method with an implementation that returns an appropriate SQL WHERE clause for a given set of fill parameters. The WHERE clause should conform to the schema generated for the offline store for the destination in context. The convention for this schema is that item-class property names are mapped one-to-one to the column names of their storage tables.
Note that the WHERE clause may refer only to columns of the table backing items for the destination in context.
This method is called by executeOfflineQuery in order to determine
the WHERE clause to use for the query being executed.
Parameters
args:Array — fill parameters.
|
String — SQL WHERE clause for the corresponding fill parameters. Returns null if no WHERE
clause need be used for the corresponding fill paramters. Default implementation returns
null for all fill parameters.
|
getQueryCriteriaParameters | () | method |
protected function getQueryCriteriaParameters(args:Array):Object| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
OfflineAdapter implementation should override this method with an implementation
that returns the values used to substitute parameters in the WHERE clause from
getQueryCriteria.
This method is called by the executeOfflineQuery() method to determine
the substitutions that are required for the query being executed.
Parameters
args:Array — fill parameters.
|
Object — Object with key-value pairs. The keys represent the names of the parameters to
replace and the values correspond to the substitution values. Positional parameters
can be substituted using integer keys. Default implementation returns null.
|
getQueryOrder | () | method |
protected function getQueryOrder(args:Array):String| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
OfflineAdapter implementations should override this method with an implementation that returns an appropriate SQL ORDER BY clause for a given set of fill parameters. The ORDER BY clause should conform to the schema generated for the offline store for the destination in context. The convention for this schema is that item-class property names are mapped one-to-one to the column names of their storage tables. Note that the ORDER BY clause can refer only to columns of the table backing items for the destination in context.
This method is called by the executeOfflineQuery() method to determine
the ORDER BY clause to use for the query being executed.
Parameters
args:Array — fill parameters.
|
String — SQL ORDER BY clause for the corresponding fill parameters. Default implementation returns
the column name for the UID.
|
getTargetColumnName | () | method |
protected function getTargetColumnName(referencePath:Array):String| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
Returns the column name for the specified path. Note that the column name might be stored in a different table. This routine is mainly used to assist model-generated code.
Parameters
referencePath:Array — path
|
String — the column name that corresponds to the path, or null if there is none
|
getTargetTableName | () | method |
protected function getTargetTableName(referencePath:Array):String| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
Walk the specified path to find the table responsible for the property path. This routine is mainly used to assist model-generated code.
Parameters
referencePath:Array — path
|
String — the table name
|
getUIDColumnName | () | method |
initializeOfflineMetadata | () | method |
override public function initializeOfflineMetadata(metadata:Metadata):voidParameters
metadata:Metadata |
internalExecuteOfflineQuery | () | method |
protected function internalExecuteOfflineQuery(sqlText:String, parameters:Object, startIndex:int, numItems:int):mx.rpc:AsyncToken| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
Executes a SQL query against the local store and returns a collection of strongly typed items.
Parameters
sqlText:String — SQL clause to use during query exectuion, as determined by the executeOfflineQuery() method
with the help of the getQueryCriteria() method
| |
parameters:Object — map of key-value pairs used for parameter replacements
| |
startIndex:int — the starting index for paging
| |
numItems:int — number of items to get or -1 if everything should be returned
|
mx.rpc:AsyncToken — AsyncToken with the result being an array of strongly typed items
|
isQuerySupported | () | method |
override public function isQuerySupported():Boolean| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
Indicates whether the adapter supports query execution. To support
query execution, implementations of this adapter must implement
the getQueryCriteria() method or override the executeOfflineQuery() method
By default, the value is set to false.
Boolean —
|
saveItems | () | method |
updateOfflineItem | () | method |
override public function updateOfflineItem(item:Object, propChangeList:Array):void| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
Used to update a particular item with the properties that were updated to the offline store.
Parameters
item:Object | |
propChangeList:Array |
updateOfflineItems | () | method |
override public function updateOfflineItems(itemUpdates:Dictionary):void| Language Version: | ActionScript 3.0 |
| Product Version: | LiveCycle Data Services for Java EE 3.1 |
| Runtime Versions: | Flash Player 9, AIR 1.1 |
Used to update the items that were modified to the local store. It takes in a dictionary where the key passed in is the updated item self and the value would be a array of the properties changes.
Parameters
itemUpdates:Dictionary |
Wed Nov 21 2018, 06:34 AM -08:00