net.aditsu.depeche

Interface DynamicQuery

All Superinterfaces:

Collection<Record>, IQuery, Iterable<Record>, List<Record>, Serializable

All Known Implementing Classes:

LocalQuery, Query

public interface DynamicQuery
extends IQuery

Query that can be built dynamically

Author:

aditsu

Method Summary

Methods

Modifier and Type	Method and Description
DynamicQuery	copy() Returns a copy of this query, without any cached results
int	count() Counts the records matched by this query, without necessarily selecting them, and returns the result as an int (for more than 2 billion records use longCount())
DynamicQuery	desc(List<String> fields) Adds the given fields (descending) to the list of fields to sort by, and returns a new query
DynamicQuery	desc(String... fields) Adds the given fields (descending) to the list of fields to sort by, and returns a new query
DynamicQuery	distinct() Adds the "DISTINCT" clause to the query, and returns a new query
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	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	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	exclude(String name, String op, Serializable value) Adds a negative "name operator value" condition and returns a new query
DynamicQuery	excludeIn(String name, Collection<? extends Serializable> list) Adds a negative "name IN (values)" condition and returns a new query
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	fields(List<String> fields) Adds the given fields to the list of fields to select in each record, and returns a new query
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	fields(String... fields) Adds the given fields to the list of fields to select in each record, and returns a new query
DynamicQuery	filter(Condition cond) Adds a condition to this query (using "AND" with an existing condition) and returns a new query
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	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	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	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	filter(String name, String op, Serializable value) Adds a "name operator value" condition and returns a new query
DynamicQuery	filterIn(String name, Collection<? extends Serializable> list) Adds a "name IN (values)" condition and returns a new query
DynamicQuery	limit(long x) Limits the number of records to select and returns a new query
long	longCount() Counts the records matched by this query, without necessarily selecting them, and returns the result as a long
DynamicQuery	offset(long x) Sets the offset of the first record to select (i.e.
DynamicQuery	order(List<String> fields) Adds the given fields (ascending) to the list of fields to sort by, and returns a new query
DynamicQuery	order(String... fields) Adds the given fields (ascending) to the list of fields to sort by, and returns a new query

Methods inherited from interface net.aditsu.depeche.IQuery

clearData, getColumn, getColumn, getColumn, getColumn, getColumnInfo, getLocalQuery, getOneRecord, getRecord, hasRun, select

Methods inherited from interface java.util.List

add, add, addAll, addAll, clear, contains, containsAll, equals, get, hashCode, indexOf, isEmpty, iterator, lastIndexOf, listIterator, listIterator, remove, remove, removeAll, retainAll, set, size, subList, toArray, toArray

Method Detail

copy

DynamicQuery copy()

Returns a copy of this query, without any cached results

filter

DynamicQuery filter(Condition cond)

Adds a condition to this query (using "AND" with an existing condition) and returns a new query

exclude

DynamicQuery exclude(Condition cond)

Adds the negation of a condition to this query (using "AND" with an existing condition) and returns a new query

filter

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

filter

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

filter

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

filter

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

exclude

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

exclude

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

filter

DynamicQuery filter(String name,
                  String op,
                  Serializable value)

Adds a "name operator value" condition and returns a new query

exclude

DynamicQuery exclude(String name,
                   String op,
                   Serializable value)

Adds a negative "name operator value" condition and returns a new query

filterIn

DynamicQuery filterIn(String name,
                    Collection<? extends Serializable> list)

Adds a "name IN (values)" condition and returns a new query

excludeIn

DynamicQuery excludeIn(String name,
                     Collection<? extends Serializable> list)

Adds a negative "name IN (values)" condition and returns a new query

limit

DynamicQuery limit(long x)

Limits the number of records to select and returns a new query

offset

DynamicQuery offset(long x)

Sets the offset of the first record to select (i.e. number of records to skip), and returns a new query

order

DynamicQuery order(String... fields)

Adds the given fields (ascending) to the list of fields to sort by, and returns a new query

order

DynamicQuery order(List<String> fields)

Adds the given fields (ascending) to the list of fields to sort by, and returns a new query

desc

DynamicQuery desc(String... fields)

Adds the given fields (descending) to the list of fields to sort by, and returns a new query

desc

DynamicQuery desc(List<String> fields)

Adds the given fields (descending) to the list of fields to sort by, and returns a new query

fields

DynamicQuery fields(String... fields)

Adds the given fields to the list of fields to select in each record, and returns a new query

fields

DynamicQuery fields(List<String> fields)

Adds the given fields to the list of fields to select in each record, and returns a new query

field

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

fields

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

distinct

DynamicQuery distinct()

Adds the "DISTINCT" clause to the query, and returns a new query

count

int count()

Counts the records matched by this query, without necessarily selecting them, and returns the result as an int (for more than 2 billion records use longCount())

longCount

long longCount()

Counts the records matched by this query, without necessarily selecting them, and returns the result as a long