com.abubusoft.kripton.android.annotation

Annotation Type BindSqlUpdate

@Retention(value=RUNTIME)
 @Target(value=METHOD)
public @interface BindSqlUpdate

Optional Element Summary

Optional Elements

Modifier and Type	Optional Element and Description
ConflictAlgorithmType	conflictAlgorithm Type of UPDATE.
String[]	excludedFields properties to exclude from UPDATE command
String[]	fields properties to include into UPDATE command
String	jql JQL value.
String	where where conditions

Element Detail

conflictAlgorithm

public abstract ConflictAlgorithmType conflictAlgorithm

Type of UPDATE. Default value is NONE. See here for more info.

Returns:

type of insert.

Default:

com.abubusoft.kripton.android.sqlite.ConflictAlgorithmType.NONE

fields

public abstract String[] fields

properties to include into UPDATE command

Returns:

property's names to include

Default:

{}

excludedFields

public abstract String[] excludedFields

properties to exclude from UPDATE command

Returns:

property's names to exclude

Default:

{}

where

public abstract String where

where conditions

Returns:

where conditions

Default:

""

jql

public abstract String jql

JQL value. With this attribute, it is possibile to specify directly the JQL code. JQL means that you can write SQL using field's names and class name indeed of column and table names. Moreover, it is possibile to specify where to use the dynamic parts of query through dynamic statements like DYNAMIC_WHERE, DYNAMIC_ORDER_BY, DYNAMIC_PAGE_SIZE, DYNAMIC_PAGE_OFFSET, encapsulated in #{ }

For example, for a select statement, you can write:

 SELECT * FROM media WHERE mediaId IN (SELECT mediaId FROM fav WHERE #{DYNAMIC_WHERE}) ORDER BY indx DESC LIMIT 0, 100 
 

If you use this attribute, no other attributes can be defined for the annotation.

Returns:

JQL code specified by user

Default:

""