Package | Description |
---|---|
org.apache.oozie.util.db |
Modifier and Type | Method and Description |
---|---|
static SqlStatement.Condition |
SqlStatement.and(SqlStatement.Condition... conds)
Logical AND condition Generator
|
static SqlStatement.Condition |
SqlStatement.between(Schema.Column column,
Object lVal,
Object rVal)
BETWEEN range checking statement
|
static SqlStatement.Condition |
SqlStatement.greaterThan(Schema.Column column,
Object value)
Generate Condition statement for GREATER THAN condition checking
|
static SqlStatement.Condition |
SqlStatement.greaterThanOrEqual(Schema.Column column,
Object value)
Generate Condition statement for GREATER THAN OR EQUAL condition checking
|
static SqlStatement.Condition |
SqlStatement.in(Schema.Column column,
Object... values)
IN Condition for checking multiple values
|
static SqlStatement.Condition |
SqlStatement.in(Schema.Column column,
SqlStatement.Select select)
Sub query with IN condition
|
static SqlStatement.Condition |
SqlStatement.isEqual(Schema.Column column,
Object value)
Generate Condition statement for equality check
|
static SqlStatement.Condition |
SqlStatement.isLike(Schema.Column column,
String value)
Generate condition statement for IS LIKE
|
static SqlStatement.Condition |
SqlStatement.isNotEqual(Schema.Column column,
Object value)
Generate InEquality Condition statement
|
static SqlStatement.Condition |
SqlStatement.isNotLike(Schema.Column column,
String value)
Generates condition statement for IS NOT LIKE
|
static SqlStatement.Condition |
SqlStatement.isNotNull(Schema.Column column)
Generate condition statement for IS NOT NULL
|
static SqlStatement.Condition |
SqlStatement.isNull(Schema.Column column)
Generate condition statement for IS NULL
|
static SqlStatement.Condition |
SqlStatement.lessThan(Schema.Column column,
Object value)
Generate Condition statement for LESS THAN condition checking
|
static SqlStatement.Condition |
SqlStatement.lessThanOrEqual(Schema.Column column,
Object value)
Generate Condition statement for LESS THAN OR EQUAL condition checking
|
static SqlStatement.Condition |
SqlStatement.notBetween(Schema.Column column,
Object lVal,
Object rVal)
NOT BETWEEN range checking statement
|
static SqlStatement.Condition |
SqlStatement.notIn(Schema.Column column,
Object... values)
NOT IN Condition for checking multiple values
|
static SqlStatement.Condition |
SqlStatement.notIn(Schema.Column column,
SqlStatement.Select select)
Sub query with NOT IN condition
|
static SqlStatement.Condition |
SqlStatement.or(SqlStatement.Condition... conds)
Logical OR condition generator
|
Modifier and Type | Method and Description |
---|---|
static SqlStatement.Condition |
SqlStatement.and(SqlStatement.Condition... conds)
Logical AND condition Generator
|
static SqlStatement.Condition |
SqlStatement.or(SqlStatement.Condition... conds)
Logical OR condition generator
|
SqlStatement.Select |
SqlStatement.Select.where(SqlStatement.Condition condition)
Set the condition for where clause
|
SqlStatement.Delete |
SqlStatement.Delete.where(SqlStatement.Condition condition)
Set the where clause for DELETE
|
SqlStatement.Update |
SqlStatement.Update.where(SqlStatement.Condition condition)
Set condition for updating
|
Copyright © 2018 Apache Software Foundation. All rights reserved.