| Package | Description |
|---|---|
| net.aditsu.depeche |
| Modifier and Type | Class and Description |
|---|---|
class |
LocalQuery
|
class |
Query
Query with dynamic SQL building
|
| Modifier and Type | Method and Description |
|---|---|
DynamicQuery |
DynamicQuery.copy()
Returns a copy of this query, without any cached results
|
DynamicQuery |
DynamicQuery.desc(List<String> fields)
Adds the given fields (descending) to the list of fields to sort by, and returns a new query
|
DynamicQuery |
DynamicQuery.desc(String... fields)
Adds the given fields (descending) to the list of fields to sort by, and returns a new query
|
DynamicQuery |
DynamicQuery.distinct()
Adds the "DISTINCT" clause to the query, and returns a new query
|
DynamicQuery |
DynamicQuery.exclude(Condition cond)
Adds the negation of a condition to this query (using "AND" with an existing condition)
and returns a new query
|
DynamicQuery |
DynamicQuery.exclude(KeyInfo keyInfo,
Key key)
Adds a condition to NOT match a list of columns with a list of values, and returns a new query
|
DynamicQuery |
DynamicQuery.exclude(String name,
Serializable value)
Adds a condition that the column with the given name should NOT have the given value, and returns a new query
|
DynamicQuery |
DynamicQuery.exclude(String name,
String op,
Serializable value)
Adds a negative "name operator value" condition and returns a new query
|
DynamicQuery |
DynamicQuery.excludeIn(String name,
Collection<? extends Serializable> list)
Adds a negative "name IN (values)" condition and returns a new query
|
DynamicQuery |
DynamicQuery.field(String field,
String alias)
Adds "field AS alias" to the list of fields to select in each record, and returns a new query
|
DynamicQuery |
DynamicQuery.fields(List<String> fields)
Adds the given fields to the list of fields to select in each record, and returns a new query
|
DynamicQuery |
DynamicQuery.fields(List<String> fields,
List<String> aliases)
Adds the given fields with the given aliases to the list of fields to select in each record, and returns a new query
|
DynamicQuery |
DynamicQuery.fields(String... fields)
Adds the given fields to the list of fields to select in each record, and returns a new query
|
DynamicQuery |
DynamicQuery.filter(Condition cond)
Adds a condition to this query (using "AND" with an existing condition) and returns a new query
|
DynamicQuery |
DynamicQuery.filter(KeyInfo keyInfo,
Key key)
Adds a condition to match a list of columns with a list of values, and returns a new query
|
DynamicQuery |
DynamicQuery.filter(Record rec,
KeyInfo cols)
Adds a condition to match a list of columns with a list of corresponding values from a Record,
and returns a new query
|
DynamicQuery |
DynamicQuery.filter(Record rec,
String... cols)
Adds a condition to match a list of columns with a list of corresponding values from a Record,
and returns a new query
|
DynamicQuery |
DynamicQuery.filter(String name,
Serializable value)
Adds a condition that the column with the given name should have the given value, and returns a new query
|
DynamicQuery |
DynamicQuery.filter(String name,
String op,
Serializable value)
Adds a "name operator value" condition and returns a new query
|
DynamicQuery |
DynamicQuery.filterIn(String name,
Collection<? extends Serializable> list)
Adds a "name IN (values)" condition and returns a new query
|
DynamicQuery |
DynamicQuery.limit(long x)
Limits the number of records to select and returns a new query
|
DynamicQuery |
DynamicQuery.offset(long x)
Sets the offset of the first record to select (i.e.
|
DynamicQuery |
DynamicQuery.order(List<String> fields)
Adds the given fields (ascending) to the list of fields to sort by, and returns a new query
|
DynamicQuery |
DynamicQuery.order(String... fields)
Adds the given fields (ascending) to the list of fields to sort by, and returns a new query
|