com.querydsl.sql.mysql

Class MySQLQuery<T>

java.lang.Object

com.querydsl.core.support.QueryBase<Q>

com.querydsl.core.support.FetchableQueryBase<T,Q>

com.querydsl.core.support.FetchableSubQueryBase<T,Q>

com.querydsl.sql.ProjectableSQLQuery<T,Q>

com.querydsl.sql.AbstractSQLQuery<T,MySQLQuery<T>>

com.querydsl.sql.mysql.MySQLQuery<T>

Type Parameters:

T - result type

All Implemented Interfaces:

Fetchable<T>, FetchableQuery<T,MySQLQuery<T>>, FilteredClause<MySQLQuery<T>>, Query<MySQLQuery<T>>, SimpleQuery<MySQLQuery<T>>, ExtendedSubQuery<T>, Expression<T>, SubQueryExpression<T>, SQLCommonQuery<MySQLQuery<T>>, Serializable

public class MySQLQuery<T>
extends AbstractSQLQuery<T,MySQLQuery<T>>

MySQLQuery provides MySQL related extensions to SQLQuery

Author:

tiwe

See Also:

SQLQuery, Serialized Form

Field Summary

Fields inherited from class com.querydsl.sql.AbstractSQLQuery

listeners, PARENT_CONTEXT, useLiterals

Fields inherited from class com.querydsl.sql.ProjectableSQLQuery

configuration, firstUnionSubQuery, union, unionAll

Fields inherited from class com.querydsl.core.support.QueryBase

MDC_PARAMETERS, MDC_QUERY, queryMixin

Constructor Summary

Constructors

Constructor and Description
MySQLQuery(Connection conn)
MySQLQuery(Connection conn, Configuration configuration)
MySQLQuery(Connection conn, Configuration configuration, QueryMetadata metadata)
MySQLQuery(Connection conn, SQLTemplates templates)
MySQLQuery(javax.inject.Provider<Connection> connProvider, Configuration configuration)
MySQLQuery(javax.inject.Provider<Connection> connProvider, Configuration configuration, QueryMetadata metadata)

Method Summary

Modifier and Type	Method and Description
MySQLQuery<T>	bigResult() For SQL_BIG_RESULT, MySQL directly uses disk-based temporary tables if needed, and prefers sorting to using a temporary table with a key on the GROUP BY elements.
MySQLQuery<T>	bufferResult() SQL_BUFFER_RESULT forces the result to be put into a temporary table.
MySQLQuery<T>	cache() SQL_CACHE tells MySQL to store the result in the query cache if it is cacheable and the value of the query_cache_type system variable is 2 or DEMAND.
MySQLQuery<T>	calcFoundRows() SQL_CALC_FOUND_ROWS tells MySQL to calculate how many rows there would be in the result set, disregarding any LIMIT clause.
MySQLQuery<T>	clone(Connection conn)
MySQLQuery<T>	forceIndex(String... indexes) You can use FORCE INDEX, which acts like USE INDEX (index_list) but with the addition that a table scan is assumed to be very expensive.
MySQLQuery<T>	highPriority() HIGH_PRIORITY gives the SELECT higher priority than a statement that updates a table.
MySQLQuery<T>	ignoreIndex(String... indexes) The alternative syntax IGNORE INDEX (index_list) can be used to tell MySQL to not use some particular index or indexes.
MySQLQuery<T>	into(String var) SELECT ...
MySQLQuery<T>	intoDumpfile(File file) SELECT ...
MySQLQuery<T>	intoOutfile(File file) SELECT ...
MySQLQuery<T>	lockInShareMode() Using LOCK IN SHARE MODE sets a shared lock that permits other transactions to read the examined rows but not to update or delete them.
MySQLQuery<T>	noCache() With SQL_NO_CACHE, the server does not use the query cache.
MySQLQuery<Tuple>	select(Expression<?>... exprs) Change the projection of this query
<U> MySQLQuery<U>	select(Expression<U> expr) Change the projection of this query
MySQLQuery<T>	smallResult() For SQL_SMALL_RESULT, MySQL uses fast temporary tables to store the resulting table instead of using sorting.
MySQLQuery<T>	straightJoin() STRAIGHT_JOIN forces the optimizer to join the tables in the order in which they are listed in the FROM clause.
MySQLQuery<T>	useIndex(String... indexes) By specifying USE INDEX (index_list), you can tell MySQL to use only one of the named indexes to find rows in the table.
MySQLQuery<T>	withRollup() The GROUP BY clause permits a WITH ROLLUP modifier that causes extra rows to be added to the summary output.

Methods inherited from class com.querydsl.sql.AbstractSQLQuery

addListener, as, as, cleanupMDC, clone, clone, createSerializer, endContext, fetch, fetchCount, fetchResults, forShare, forShare, forUpdate, getConfiguration, getResults, getResults, iterate, logQuery, onException, setParameters, setStatementOptions, setUseLiterals, startContext

Methods inherited from class com.querydsl.sql.ProjectableSQLQuery

accept, addFlag, addFlag, addFlag, addFlag, addJoinFlag, addJoinFlag, fetchOne, from, from, from, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, getSQL, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, join, join, join, join, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, on, on, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, serialize, toString, union, union, union, unionAll, unionAll, unionAll, with, with, with, withRecursive, withRecursive, withRecursive

Methods inherited from class com.querydsl.core.support.FetchableSubQueryBase

contains, contains, eq, eq, exists, getMetadata, getType, goe, goe, gt, gt, hashCode, in, in, isNotNull, isNull, loe, loe, lt, lt, ne, ne, notExists

Methods inherited from class com.querydsl.core.support.FetchableQueryBase

equals, fetchFirst, transform, uniqueResult

Methods inherited from class com.querydsl.core.support.QueryBase

distinct, groupBy, groupBy, having, having, limit, offset, orderBy, orderBy, restrict, set, where, where

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.querydsl.core.Query

groupBy, having

Methods inherited from interface com.querydsl.core.SimpleQuery

distinct, limit, offset, orderBy, restrict, set

Methods inherited from interface com.querydsl.core.FilteredClause

where

Methods inherited from interface com.querydsl.core.FetchableQuery

transform

Methods inherited from interface com.querydsl.core.Fetchable

fetchFirst

Constructor Detail

MySQLQuery

public MySQLQuery(Connection conn)

MySQLQuery

public MySQLQuery(Connection conn,
                  SQLTemplates templates)

MySQLQuery

public MySQLQuery(Connection conn,
                  Configuration configuration)

MySQLQuery

public MySQLQuery(Connection conn,
                  Configuration configuration,
                  QueryMetadata metadata)

MySQLQuery

public MySQLQuery(javax.inject.Provider<Connection> connProvider,
                  Configuration configuration,
                  QueryMetadata metadata)

MySQLQuery

public MySQLQuery(javax.inject.Provider<Connection> connProvider,
                  Configuration configuration)

Method Detail

bigResult

public MySQLQuery<T> bigResult()

For SQL_BIG_RESULT, MySQL directly uses disk-based temporary tables if needed, and prefers sorting to using a temporary table with a key on the GROUP BY elements.

Returns:

the current object

bufferResult

public MySQLQuery<T> bufferResult()

SQL_BUFFER_RESULT forces the result to be put into a temporary table. This helps MySQL free the table locks early and helps in cases where it takes a long time to send the result set to the client. This option can be used only for top-level SELECT statements, not for subqueries or following UNION.

Returns:

the current object

cache

public MySQLQuery<T> cache()

SQL_CACHE tells MySQL to store the result in the query cache if it is cacheable and the value of the query_cache_type system variable is 2 or DEMAND.

Returns:

the current object

calcFoundRows

public MySQLQuery<T> calcFoundRows()

SQL_CALC_FOUND_ROWS tells MySQL to calculate how many rows there would be in the result set, disregarding any LIMIT clause. The number of rows can then be retrieved with SELECT FOUND_ROWS().

Returns:

the current object

highPriority

public MySQLQuery<T> highPriority()

HIGH_PRIORITY gives the SELECT higher priority than a statement that updates a table. You should use this only for queries that are very fast and must be done at once.

Returns:

the current object

into

public MySQLQuery<T> into(String var)

SELECT ... INTO var_list selects column values and stores them into variables.

Parameters:

var - variable name

Returns:

the current object

intoDumpfile

public MySQLQuery<T> intoDumpfile(File file)

SELECT ... INTO DUMPFILE writes a single row to a file without any formatting.

Parameters:

file - file to write to

Returns:

the current object

intoOutfile

public MySQLQuery<T> intoOutfile(File file)

SELECT ... INTO OUTFILE writes the selected rows to a file. Column and line terminators c an be specified to produce a specific output format.

Parameters:

file - file to write to

Returns:

the current object

lockInShareMode

public MySQLQuery<T> lockInShareMode()

Using LOCK IN SHARE MODE sets a shared lock that permits other transactions to read the examined rows but not to update or delete them.

Returns:

the current object

noCache

public MySQLQuery<T> noCache()

With SQL_NO_CACHE, the server does not use the query cache. It neither checks the query cache to see whether the result is already cached, nor does it cache the query result.

Returns:

the current object

smallResult

public MySQLQuery<T> smallResult()

For SQL_SMALL_RESULT, MySQL uses fast temporary tables to store the resulting table instead of using sorting. This should not normally be needed.

Returns:

the current object

straightJoin

public MySQLQuery<T> straightJoin()

STRAIGHT_JOIN forces the optimizer to join the tables in the order in which they are listed in the FROM clause. You can use this to speed up a query if the optimizer joins the tables in nonoptimal order. STRAIGHT_JOIN also can be used in the table_references list.

Returns:

the current object

forceIndex

public MySQLQuery<T> forceIndex(String... indexes)

You can use FORCE INDEX, which acts like USE INDEX (index_list) but with the addition that a table scan is assumed to be very expensive. In other words, a table scan is used only if there is no way to use one of the given indexes to find rows in the table.

Parameters:

indexes - index names

Returns:

the current object

ignoreIndex

public MySQLQuery<T> ignoreIndex(String... indexes)

The alternative syntax IGNORE INDEX (index_list) can be used to tell MySQL to not use some particular index or indexes.

Parameters:

indexes - index names

Returns:

the current object

useIndex

public MySQLQuery<T> useIndex(String... indexes)

By specifying USE INDEX (index_list), you can tell MySQL to use only one of the named indexes to find rows in the table.

Parameters:

indexes - index names

Returns:

the current object

withRollup

public MySQLQuery<T> withRollup()

The GROUP BY clause permits a WITH ROLLUP modifier that causes extra rows to be added to the summary output. These rows represent higher-level (or super-aggregate) summary operations. ROLLUP thus enables you to answer questions at multiple levels of analysis with a single query. It can be used, for example, to provide support for OLAP (Online Analytical Processing) operations.

Returns:

the current object

clone

public MySQLQuery<T> clone(Connection conn)

Specified by:

clone in class AbstractSQLQuery<T,MySQLQuery<T>>

select

public <U> MySQLQuery<U> select(Expression<U> expr)

Description copied from interface: FetchableQuery

Change the projection of this query

Parameters:

expr - new projection

Returns:

the current object

select

public MySQLQuery<Tuple> select(Expression<?>... exprs)

Description copied from interface: FetchableQuery

Change the projection of this query

Parameters:

exprs - new projection

Returns:

the current object