Uses of Class
net.aditsu.depeche.Query

Packages that use Query

Package	Description
net.aditsu.depeche

Uses of Query in net.aditsu.depeche

Methods in net.aditsu.depeche that return Query

Modifier and Type	Method and Description
Query	Query.copy()
Query	Query.desc(List<String> fields)
Query	Query.desc(String... fields)
Query	Query.distinct()
Query	Query.exclude(Condition cond)
Query	Query.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
Query	Query.exclude(SQLCondition cond) Adds the negation of a SQL condition to this query (using "AND" with an existing condition) and returns a new query
Query	Query.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
Query	Query.exclude(String name, String op, Serializable value) Adds a negative "name operator value" condition and returns a new query
Query	Query.excludeIn(String name, Collection<? extends Serializable> values) Adds a negative "name IN (values)" condition and returns a new query
Query	Query.field(String field, String alias)
Query	Query.fields(List<String> fields)
Query	Query.fields(List<String> fields, List<String> aliases)
Query	Query.fields(String... fields)
Query	Query.filter(Condition cond)
Query	Query.filter(KeyInfo keyInfo, Key key) Adds a condition to match a list of columns with a list of values, and returns a new query
Query	Query.filter(Record rec, KeyInfo cols)
Query	Query.filter(Record rec, String... cols)
Query	Query.filter(SQLCondition cond) Adds a SQL condition to this query (using "AND" with an existing condition) and returns a new query
Query	Query.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
Query	Query.filter(String name, String op, Serializable value) Adds a "name operator value" condition and returns a new query
Query	Query.filterIn(String name, Collection<? extends Serializable> values) Adds a "name IN (values)" condition and returns a new query
Query	Query.filterPK(List<Serializable> values) Adds a condition that matches the primary key columns of the query's table to the given values and returns a new query
Query	Query.filterPK(Serializable... values) Adds a condition that matches the primary key columns of the query's table to the given values and returns a new query
Query	Record.getChildren(FKey expkey) Returns a query for getting the child records linked from this one through an exported key
Query	Record.getChildren(String name) Returns a query for getting the child records linked from this one through an exported key
Query	Record.getChildrenFrom(String table) Returns a query for getting the child records from a given table (linked from this one through an exported key)
Query	Record.getParent(FKey fkey) Returns a query for getting the parent record linked from this one through a foreign key
Query	Record.getParent(String name) Returns a query for getting the parent record linked from this one through a foreign key
Query	Record.getParentFrom(String table) Returns a query for getting the parent record from a given table (linked from this one through a foreign key)
Query	Record.getParentThrough(String column) Returns a query for getting the parent record linked from this one through a given column
Query	Query.join(Join join) Adds the given join object to the query's joins and returns a new query
Query	Query.join(JoinType type, String table, String fld1, String fld2) Adds a join of a given type, with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are quoted
Query	Query.join(String table, String fld1, String fld2) Adds an inner join with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are quoted
Query	Query.joinParent(FKey fk) Adds an inner join with a parent table, linked through the given foreign key
Query	Query.joinParent(JoinType type, FKey fk) Adds a join of a given type, with a parent table, linked through the given foreign key
Query	Query.joinParentFrom(JoinType type, String table) Adds a join of a given type, with the given parent table, linked through a foreign key
Query	Query.joinParentFrom(String table) Adds an inner join with the given parent table, linked through a foreign key
Query	Query.joinParents() Adds inner joins with all parent tables, linked through foreign keys
Query	Query.joinParents(JoinType type) Adds joins of a given type, with all parent tables, linked through foreign keys
Query	Query.joinParentThrough(JoinType type, String column) Adds a join of a given type, with a parent table, linked through the given column
Query	Query.joinParentThrough(String column) Adds an inner join with a parent table, linked through the given column
Query	Query.leftJoin(String table, String fld1, String fld2) Adds a left join with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are quoted
Query	Query.leftJoinParent(FKey fk) Adds a left join with a parent table, linked through the given foreign key
Query	Query.leftJoinParentFrom(String table) Adds a left join with the given parent table, linked through a foreign key
Query	Query.leftJoinParents() Adds left joins with all parent tables, linked through foreign keys
Query	Query.leftJoinParentThrough(String column) Adds a left join with a parent table, linked through the given column
Query	Query.limit(long x)
Query	Query.lock(RowLock rowLock) Sets the given row lock (for SELECT) and returns a new query
Query	Query.offset(long x)
Query	Query.order(List<String> fields)
Query	Query.order(String... fields)
Query	Provider.query() Creates a new query without a table specified
Query	Provider.query(Record rec) Creates a new query that matches a given record
Query	Provider.query(SQLQuery q, String alias) Creates a new query that uses a given query as a subquery
Query	Provider.query(String table) Creates a new query for a given table
Query	Provider.query(Table table) Creates a new query for a given table
Query	Query.rawFields(String... fields) Adds the given raw SQL expressions to the "SELECT" clause and returns a new query
Query	Query.rawFilter(String sql, Serializable... params) Creates a custom condition and adds it to this query (using "AND" with an existing condition) and returns a new query
Query	Query.rawJoin(String table, String fld1, String fld2) Adds an inner join with a given table, with the condition that the two given fields are equal, and returns a new query; all parameters are taken as raw SQL expressions
Query	Query.rawOrder(String... fields) Adds the given raw SQL expressions to the "ORDER BY" clause and returns a new query
Query	Query.rawSet(String name, Serializable value) Adds a field value (for INSERT or UPDATE) using a raw expression for the field, and returns a new query
Query	Query.select()
Query	Query.select(Conn conn)
Query	Query.set(String name, Serializable value) Adds a field value (for INSERT or UPDATE) and returns a new query
Query	Query.setExpr(String fieldExpr, String valueExpr, Serializable... params) Adds a field value (for INSERT or UPDATE) using raw expressions for both the field and the value, and returns a new query
Query	Query.table(String tableName) Sets the table to be queried and returns a new query
Query	Query.table(Table t) Sets the table to be queried and returns a new query