SQLiteConditionBuilder

java.lang.Object
- net.akaish.kitty.orm.query.conditions.SQLiteConditionBuilder

public class SQLiteConditionBuilder
extends java.lang.Object

Author:: akaish (Denis Bogomolov)

Field Summary

Fields
Modifier and Type	Field and Description
`static java.lang.String`	`MODEL_FIELD_END`
`static java.lang.String`	`MODEL_FIELD_START`
`static java.lang.String`	`WHERE`
`static java.lang.String`	`WHSP_STR`

Constructor Summary

Constructors
Constructor and Description

SQLiteConditionBuilder()

Constructors
Constructor and Description
`SQLiteConditionBuilder()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`SQLiteConditionBuilder`	`addArbitrarySQLExpression(java.lang.String ArbitrarySQLExp)` Adds any arbitrary item to condition
`SQLiteConditionBuilder`	`addColumn(java.lang.String columnName)` Adds column name to condition (e.g. ), if you want to use Java variables described with `KITTY_COLUMN`, use `addField(String, Class)` instead
`SQLiteConditionBuilder`	`addField(java.lang.String fieldName, java.lang.Class modelClass)` Adds column name associated with fieldName via `KITTY_COLUMN` annotation May throw `KittyRuntimeException`, which is just runtime exception, if provided fieldName doesn't exists in provided modelClass or if provided fieldName doesn't described with `KITTY_COLUMN` annotation
`SQLiteConditionBuilder`	`addObjectValue(java.lang.Object value)`
`SQLiteConditionBuilder`	`addOperator(SQLiteOperator logic)` Adds some logic operators for SQL condition, described in `SQLiteOperator` `SQLiteOperator` has only common used operators, so, for something rare for common logic use `addArbitrarySQLExpression(String)` Alias for `addSQLOperator(SQLiteOperator)`
`SQLiteConditionBuilder`	`addOperator(java.lang.String logic)` Adds some logic operators for SQL condition, described in `SQLiteOperator` `SQLiteOperator` has only common used operators, so, for something rare for common logic use `addArbitrarySQLExpression(String)` Case insensitive, so "and" and "AND" and even "AnD" is OK Alias for `addSQLOperator(String)`
`SQLiteConditionBuilder`	`addSQLOperator(SQLiteOperator logic)` Adds some logic operators for SQL condition, described in `SQLiteOperator` `SQLiteOperator` has only common used operators, so, for something rare for common logic use `addArbitrarySQLExpression(String)`
`SQLiteConditionBuilder`	`addSQLOperator(java.lang.String logic)` Adds some logic operators for SQL condition, described in `SQLiteOperator` `SQLiteOperator` has only common used operators, so, for something rare for common logic use `addArbitrarySQLExpression(String)` Case insensitive, so "and" and "AND" and even "AnD" is OK
`SQLiteConditionBuilder`	`addValue(boolean value)`
`SQLiteConditionBuilder`	`addValue(java.lang.Boolean value)`
`SQLiteConditionBuilder`	`addValue(byte value)`
`SQLiteConditionBuilder`	`addValue(java.lang.Byte value)`
`SQLiteConditionBuilder`	`addValue(double value)`
`SQLiteConditionBuilder`	`addValue(java.lang.Double value)`
`SQLiteConditionBuilder`	`addValue(float value)`
`SQLiteConditionBuilder`	`addValue(java.lang.Float value)`
`SQLiteConditionBuilder`	`addValue(int value)`
`SQLiteConditionBuilder`	`addValue(java.lang.Integer value)`
`SQLiteConditionBuilder`	`addValue(long value)`
`SQLiteConditionBuilder`	`addValue(java.lang.Long value)`
`SQLiteConditionBuilder`	`addValue(short value)`
`SQLiteConditionBuilder`	`addValue(java.lang.Short value)`
`SQLiteConditionBuilder`	`addValue(java.lang.String value)`
`SQLiteCondition`	`build()` Resets builder and return SQL condition
`static SQLiteCondition`	`fromSQL(java.lang.String conditionStr, java.lang.Class<? extends KittyModel> modelClass, java.lang.Object... params)` Generates `SQLiteCondition` from SQLite string and provided params.
`java.lang.String`	`getConditionSQLString()` Returns sql condition String set with setters
`java.lang.String[]`	`getConditionValues()` Returns string values to be used in prepared sql condition
`void`	`newSQLiteCondition()` Makes this builder ready for new sql condition If you are crazy about memory usage optimization, use `newSQLiteCondition(int)` for using buffer capacity you actually need
`void`	`newSQLiteCondition(int conditionStringBufferCapacity)` Makes this builder ready for new sql condition

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - WHERE
```
public static final java.lang.String WHERE
```
    See Also:
    
    Constant Field Values
  - MODEL_FIELD_START
```
public static final java.lang.String MODEL_FIELD_START
```
    See Also:
    
    Constant Field Values
  - MODEL_FIELD_END
```
public static final java.lang.String MODEL_FIELD_END
```
    See Also:
    
    Constant Field Values
  - WHSP_STR
```
public static final java.lang.String WHSP_STR
```
    See Also:
    
    Constant Field Values
- Constructor Detail
  - SQLiteConditionBuilder
```
public SQLiteConditionBuilder()
```
- Method Detail
  - newSQLiteCondition
```
public void newSQLiteCondition()
```
    Makes this builder ready for new sql condition If you are crazy about memory usage optimization, use newSQLiteCondition(int) for using buffer capacity you actually need
  - newSQLiteCondition
```
public void newSQLiteCondition(int conditionStringBufferCapacity)
```
    Makes this builder ready for new sql condition
    
    Parameters:
    
    conditionStringBufferCapacity - - size of StringBuffer that would be used
  - addField
```
public SQLiteConditionBuilder addField(java.lang.String fieldName,
                                       java.lang.Class modelClass)
```
    Adds column name associated with fieldName via KITTY_COLUMN annotation May throw KittyRuntimeException, which is just runtime exception, if provided fieldName doesn't exists in provided modelClass or if provided fieldName doesn't described with KITTY_COLUMN annotation
    
    Parameters:
    
    fieldName -
    
    modelClass -
    
    Returns:
  - addSQLOperator
```
public SQLiteConditionBuilder addSQLOperator(SQLiteOperator logic)
```
    Adds some logic operators for SQL condition, described in SQLiteOperator SQLiteOperator has only common used operators, so, for something rare for common logic use addArbitrarySQLExpression(String)
    
    Parameters:
    
    logic -
    
    Returns:
  - addSQLOperator
```
public SQLiteConditionBuilder addSQLOperator(java.lang.String logic)
```
    Adds some logic operators for SQL condition, described in SQLiteOperator SQLiteOperator has only common used operators, so, for something rare for common logic use addArbitrarySQLExpression(String)
    Case insensitive, so "and" and "AND" and even "AnD" is OK
    
    Parameters:
    
    logic -
    
    Returns:
  - addOperator
```
public SQLiteConditionBuilder addOperator(java.lang.String logic)
```
    Adds some logic operators for SQL condition, described in SQLiteOperator SQLiteOperator has only common used operators, so, for something rare for common logic use addArbitrarySQLExpression(String)
    Case insensitive, so "and" and "AND" and even "AnD" is OK
    Alias for addSQLOperator(String)
    
    Parameters:
    
    logic -
    
    Returns:
  - addOperator
```
public SQLiteConditionBuilder addOperator(SQLiteOperator logic)
```
    Adds some logic operators for SQL condition, described in SQLiteOperator SQLiteOperator has only common used operators, so, for something rare for common logic use addArbitrarySQLExpression(String)
    Alias for addSQLOperator(SQLiteOperator)
    
    Parameters:
    
    logic -
    
    Returns:
  - addColumn
```
public SQLiteConditionBuilder addColumn(java.lang.String columnName)
```
    Adds column name to condition (e.g. ), if you want to use Java variables described with KITTY_COLUMN, use addField(String, Class) instead
    
    Parameters:
    
    columnName -
    
    Returns:
  - addArbitrarySQLExpression
```
public SQLiteConditionBuilder addArbitrarySQLExpression(java.lang.String ArbitrarySQLExp)
```
    Adds any arbitrary item to condition
    
    Parameters:
    
    ArbitrarySQLExp -
    
    Returns:
  - addValue
```
public SQLiteConditionBuilder addValue(java.lang.String value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(java.lang.Boolean value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(boolean value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(int value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(java.lang.Integer value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(byte value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(java.lang.Byte value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(double value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(java.lang.Double value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(long value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(java.lang.Long value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(short value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(java.lang.Short value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(float value)
```
  - addValue
```
public SQLiteConditionBuilder addValue(java.lang.Float value)
```
  - addObjectValue
```
public SQLiteConditionBuilder addObjectValue(java.lang.Object value)
```
  - getConditionSQLString
```
public java.lang.String getConditionSQLString()
```
    Returns sql condition String set with setters
    
    Returns:
  - getConditionValues
```
public java.lang.String[] getConditionValues()
```
    Returns string values to be used in prepared sql condition
    
    Returns:
  - build
```
public SQLiteCondition build()
```
    Resets builder and return SQL condition
    
    Returns:
  - fromSQL
```
public static final SQLiteCondition fromSQL(java.lang.String conditionStr,
                                            java.lang.Class<? extends KittyModel> modelClass,
                                            java.lang.Object... params)
```
    Generates SQLiteCondition from SQLite string and provided params.
    Example:
    fromSQL("column_name_one = ? AND id = ?", null, columnNameOneValue, id)
    If you wish use model fieldName, you may use following syntax:
    fromSQL("#?columnNameOne; = ? AND id = ?", MyModelImplementation.class, columnNameOneValue, id)
    In this case passing not null modelClass parameter is required.
    
    Parameters:
    
    conditionStr - SQLite condition string with ? placeholders for parameters
    
    modelClass - model class, required if you pass model field name instead column names using #?modelField; syntax
    
    params - parameters to be used with query
    
    Returns:
    
    SQLiteCondition from SQLite string and provided params.

Class SQLiteConditionBuilder

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

WHERE

MODEL_FIELD_START

MODEL_FIELD_END

WHSP_STR

Constructor Detail

SQLiteConditionBuilder

Method Detail

newSQLiteCondition

newSQLiteCondition

addField

addSQLOperator

addSQLOperator

addOperator

addOperator

addColumn

addArbitrarySQLExpression

addValue

addValue

addValue

addValue

addValue

addValue

addValue

addValue

addValue

addValue

addValue

addValue

addValue

addValue

addValue

addObjectValue

getConditionSQLString

getConditionValues

build

fromSQL