| Modifier and Type | Method and Description |
|---|---|
Where |
Where.and(String columnName,
Operator operator,
BigDecimal value)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical and.
|
Where |
Where.and(String columnName,
Operator operator,
Boolean value)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical and.
|
Where |
Where.and(String columnName,
Operator operator,
Instant value)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical and.
|
Where |
Where.and(String columnName,
Operator operator,
Long value)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical and.
|
Where |
Where.and(String columnName,
Operator operator,
String value)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical and.
|
<T> Where |
Where.and(String columnName,
Operator operator,
T value,
GenericColumn<T> column)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical and.
|
Where |
Where.and(Where subWhere)
Add a new predicate to the existing object by connecting the
existing predicates to the passed argument with a logical and
operation.
|
static Where |
Where.inBigDecimal(String columnName,
List<BigDecimal> elements)
Generates an
IN clause applying to the specified column and
including the passed list of numbers. |
static <T> Where |
Where.inColumn(String columnName,
GenericColumn<T> column,
List<T> elements)
Generates an
IN clause applying to the specified column and
including the passed list of elements. |
static Where |
Where.inInstant(String columnName,
List<Instant> elements)
Generates an
IN clause applying to the specified column and
including the passed list of dates. |
static Where |
Where.inLong(String columnName,
List<Long> elements)
Generates an
IN clause applying to the specified column and
including the passed list of numbers. |
static Where |
Where.inString(String columnName,
List<String> elements)
Generates an
IN clause applying to the specified column and
including the passed list of strings. |
static Where |
Where.isNotNull(String columnName)
Creates a new object with a single predicate testing whether
a column is not null.
|
static Where |
Where.isNull(String columnName)
Creates a new object with a single predicate testing whether
a column is null.
|
static Where |
Where.notInBigDecimal(String columnName,
List<BigDecimal> elements)
Generates a
NOT IN clause applying to the specified column and
excluding the passed list of numbers. |
static <T> Where |
Where.notInColumn(String columnName,
GenericColumn<T> column,
List<T> elements)
Generates a
NOT IN clause applying to the specified column and
excluding the passed list of elements. |
static Where |
Where.notInInstant(String columnName,
List<Instant> elements)
Generates a
NOT IN clause applying to the specified column and
excluding the passed list of dates. |
static Where |
Where.notInLong(String columnName,
List<Long> elements)
Generates a
NOT IN clause applying to the specified column and
excluding the passed list of numbers. |
static Where |
Where.notInString(String columnName,
List<String> elements)
Generates a
NOT IN clause applying to the specified column and
excluding the passed list of strings. |
Where |
Where.or(String columnName,
Operator operator,
BigDecimal value)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical or.
|
Where |
Where.or(String columnName,
Operator operator,
Boolean value)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical or.
|
Where |
Where.or(String columnName,
Operator operator,
Instant value)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical or.
|
Where |
Where.or(String columnName,
Operator operator,
Long value)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical or.
|
Where |
Where.or(String columnName,
Operator operator,
String value)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical or.
|
<T> Where |
Where.or(String columnName,
Operator operator,
T value,
GenericColumn<T> column)
Add a new predicate to the existing object by connecting the
existing predicates to the new one with a logical or.
|
Where |
Where.or(Where subWhere)
Add a new predicate to the existing object by connecting the
existing predicates to the passed argument with a logical or
operation.
|
static Where |
Where.where()
Factory method equivalent to
new Where(). |
static Where |
Where.where(String columnName,
Operator operator,
BigDecimal value)
Factory method equivalent to
new Where(columnName, operator, value). |
static Where |
Where.where(String columnName,
Operator operator,
Boolean value)
Factory method equivalent to
new Where(columnName, operator, value). |
static Where |
Where.where(String columnName,
Operator operator,
Instant value)
Factory method equivalent to
new Where(columnName, operator, value). |
static Where |
Where.where(String columnName,
Operator operator,
Long value)
Factory method equivalent to
new Where(columnName, operator, value). |
static Where |
Where.where(String columnName,
Operator operator,
String value)
Factory method equivalent to
new Where(columnName, operator, value). |
static <T> Where |
Where.where(String columnName,
Operator operator,
T value,
GenericColumn<T> column)
Factory method equivalent to
new Where(columnName, operator, value, column). |
static Where |
Where.where(Where subWhere)
Factory method equivalent to
new Where(subWhere). |
| Modifier and Type | Method and Description |
|---|---|
Where |
Where.and(Where subWhere)
Add a new predicate to the existing object by connecting the
existing predicates to the passed argument with a logical and
operation.
|
<T> T |
KeylessDao.foldingSelect(T identity,
BiFunction<T,ENTITY,T> accumulator,
Where where)
Computes a result based on the entities found by a select statement
without realizing the entire list of found entities in memory.
|
<T> T |
AbstractDao.foldingSelect(T identity,
BiFunction<T,ENTITY,T> accumulator,
Where where) |
Where |
Where.or(Where subWhere)
Add a new predicate to the existing object by connecting the
existing predicates to the passed argument with a logical or
operation.
|
BigDecimal |
KeylessDao.runBigDecimalFunction(SqlFunction function,
String columnName,
Where where)
Computes an aggregated BigDecimal value, based on the select criteria specified
and the given SqlFunction and column name.
|
BigDecimal |
AbstractDao.runBigDecimalFunction(SqlFunction function,
String columnName,
Where where) |
BigDecimal |
SqlRunner.runBigDecimalFunction(String sql,
Where where) |
Long |
KeylessDao.runLongFunction(SqlFunction function,
String columnName,
Where where)
Computes an aggregated
Long value, based on the select criteria specified
and the given SqlFunction and column name. |
Long |
AbstractDao.runLongFunction(SqlFunction function,
String columnName,
Where where) |
Long |
SqlRunner.runLongFunction(String sql,
Where where) |
List<ENTITY> |
KeylessDao.select(Where where)
Run a select in the data store for entities matching the given where predicates.
|
List<ENTITY> |
AbstractDao.select(Where where) |
String |
SqlBuilder.select(Where where) |
String |
Queries.select(Where where) |
List<ENTITY> |
KeylessDao.select(Where where,
Order order)
Run a select in the data store for entities matching the given where predicates
returned in the order specified.
|
List<ENTITY> |
AbstractDao.select(Where where,
Order order) |
String |
SqlBuilder.select(Where where,
Order order) |
<T,U,V> List<Triplet<T,U,V>> |
KeylessDao.selectDistinct(String firstColumnName,
String secondColumnName,
String thirdColumnName,
Where where)
Select unique value triplets from the database for a particular triplet of columns.
|
<T,U,V> List<Triplet<T,U,V>> |
AbstractDao.selectDistinct(String firstColumnName,
String secondColumnName,
String thirdColumnName,
Where where) |
<T,U> List<Pair<T,U>> |
KeylessDao.selectDistinct(String firstColumnName,
String secondColumnName,
Where where)
Select unique value pairs from the database for a particular pair of columns.
|
<T,U> List<Pair<T,U>> |
AbstractDao.selectDistinct(String firstColumnName,
String secondColumnName,
Where where) |
<T> List<T> |
KeylessDao.selectDistinct(String columnName,
Where where)
Select unique values from the database for a particular column.
|
<T> List<T> |
AbstractDao.selectDistinct(String columnName,
Where where) |
<T> List<T> |
SqlRunner.selectDistinct(String sql,
Where where,
Function<ResultSet,T> resultParser) |
String |
SqlBuilder.selectDistinct(Where where,
String... columnNames) |
String |
SqlBuilder.selectFunction(SqlFunction function,
String columnName,
Where where) |
ENTITY |
KeylessDao.selectOne(Where where)
Select a single record from the database by some search criteria.
|
ENTITY |
AbstractDao.selectOne(Where where) |
String |
SqlBuilder.selectPrimaryKey(Where where) |
List<BUILDER> |
SqlRunner.selectWhereStandard(String sql,
Supplier<BUILDER> supplier,
List<? extends ChildrenDescriptor<ENTITY,?,BUILDER,?>> childrenDescriptors,
Where where) |
static Where |
Where.where(Where subWhere)
Factory method equivalent to
new Where(subWhere). |
| Constructor and Description |
|---|
Where(Where subWhere)
Creates a new
Where instance that is grouped,
that is, when the SQL where clause is generated, whatever is
inside the passed where instance will be wrapped inside
parentheses. |
Copyright © 2019. All rights reserved.