com.querydsl.sql.mysql

Class MySQLQueryFactory

java.lang.Object

com.querydsl.sql.AbstractSQLQueryFactory<MySQLQuery<?>>

com.querydsl.sql.mysql.MySQLQueryFactory

All Implemented Interfaces:

QueryFactory<MySQLQuery<?>>, SQLCommonQueryFactory<MySQLQuery<?>,SQLDeleteClause,SQLUpdateClause,SQLInsertClause,SQLMergeClause>

public class MySQLQueryFactory
extends AbstractSQLQueryFactory<MySQLQuery<?>>

MySQL specific implementation of SQLQueryFactory

Author:

tiwe

Field Summary

Fields inherited from class com.querydsl.sql.AbstractSQLQueryFactory

configuration, connection

Constructor Summary

Constructors

Constructor and Description
MySQLQueryFactory(Configuration configuration, java.util.function.Supplier<java.sql.Connection> connection)
MySQLQueryFactory(SQLTemplates templates, java.util.function.Supplier<java.sql.Connection> connection)
MySQLQueryFactory(java.util.function.Supplier<java.sql.Connection> connection)

Method Summary

Modifier and Type	Method and Description
SQLInsertClause	insertIgnore(RelationalPath<?> entity) Create a INSERT IGNORE INTO clause
SQLInsertClause	insertOnDuplicateKeyUpdate(RelationalPath<?> entity, Expression<?>... clauses) Create a INSERT ...
SQLInsertClause	insertOnDuplicateKeyUpdate(RelationalPath<?> entity, Expression<?> clause) Create a INSERT ...
SQLInsertClause	insertOnDuplicateKeyUpdate(RelationalPath<?> entity, java.lang.String clause) Create a INSERT ...
MySQLQuery<?>	query() Create a new Query
MySQLReplaceClause	replace(RelationalPath<?> entity)
MySQLQuery<Tuple>	select(Expression<?>... exprs) Create a new SQL query with the given projection
<T> MySQLQuery<T>	select(Expression<T> expr) Create a new SQL query with the given projection
MySQLQuery<Tuple>	selectDistinct(Expression<?>... exprs) Create a new SQL query with the given projection
<T> MySQLQuery<T>	selectDistinct(Expression<T> expr) Create a new SQL query with the given projection
<T> MySQLQuery<T>	selectFrom(RelationalPath<T> expr) Create a new SQL query with the given projection and source
MySQLQuery<java.lang.Integer>	selectOne() Create a new SQL query with one as the projection
MySQLQuery<java.lang.Integer>	selectZero() Create a new SQL query with zero as the projection

Methods inherited from class com.querydsl.sql.AbstractSQLQueryFactory

delete, from, from, from, getConfiguration, getConnection, insert, merge, update

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MySQLQueryFactory

public MySQLQueryFactory(Configuration configuration,
                         java.util.function.Supplier<java.sql.Connection> connection)

MySQLQueryFactory

public MySQLQueryFactory(java.util.function.Supplier<java.sql.Connection> connection)

MySQLQueryFactory

public MySQLQueryFactory(SQLTemplates templates,
                         java.util.function.Supplier<java.sql.Connection> connection)

Method Detail

insertIgnore

public SQLInsertClause insertIgnore(RelationalPath<?> entity)

Create a INSERT IGNORE INTO clause

Parameters:

entity - table to insert to

Returns:

insert clause

insertOnDuplicateKeyUpdate

public SQLInsertClause insertOnDuplicateKeyUpdate(RelationalPath<?> entity,
                                                  java.lang.String clause)

Create a INSERT ... ON DUPLICATE KEY UPDATE clause

Parameters:

entity - table to insert to

clause - clause

Returns:

insert clause

insertOnDuplicateKeyUpdate

public SQLInsertClause insertOnDuplicateKeyUpdate(RelationalPath<?> entity,
                                                  Expression<?> clause)

Create a INSERT ... ON DUPLICATE KEY UPDATE clause

Parameters:

entity - table to insert to

clause - clause

Returns:

insert clause

insertOnDuplicateKeyUpdate

public SQLInsertClause insertOnDuplicateKeyUpdate(RelationalPath<?> entity,
                                                  Expression<?>... clauses)

Create a INSERT ... ON DUPLICATE KEY UPDATE clause

Parameters:

entity - table to insert to

clauses - clauses

Returns:

insert clause

query

public MySQLQuery<?> query()

Description copied from interface: QueryFactory

Create a new Query

Returns:

new query

replace

public MySQLReplaceClause replace(RelationalPath<?> entity)

select

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

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection

Specified by:

select in class AbstractSQLQueryFactory<MySQLQuery<?>>

Type Parameters:

T - type of the projection

Parameters:

expr - projection

Returns:

select(expr)

select

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

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection

Specified by:

select in class AbstractSQLQueryFactory<MySQLQuery<?>>

Parameters:

exprs - projection

Returns:

select(exprs)

selectDistinct

public <T> MySQLQuery<T> selectDistinct(Expression<T> expr)

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection

Specified by:

selectDistinct in class AbstractSQLQueryFactory<MySQLQuery<?>>

Type Parameters:

T - type of the projection

Parameters:

expr - distinct projection

Returns:

select(distinct expr)

selectDistinct

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

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection

Specified by:

selectDistinct in class AbstractSQLQueryFactory<MySQLQuery<?>>

Parameters:

exprs - distinct projection

Returns:

select(distinct exprs)

selectZero

public MySQLQuery<java.lang.Integer> selectZero()

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with zero as the projection

Specified by:

selectZero in class AbstractSQLQueryFactory<MySQLQuery<?>>

Returns:

select(0)

selectOne

public MySQLQuery<java.lang.Integer> selectOne()

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with one as the projection

Specified by:

selectOne in class AbstractSQLQueryFactory<MySQLQuery<?>>

Returns:

select(1)

selectFrom

public <T> MySQLQuery<T> selectFrom(RelationalPath<T> expr)

Description copied from class: AbstractSQLQueryFactory

Create a new SQL query with the given projection and source

Specified by:

selectFrom in class AbstractSQLQueryFactory<MySQLQuery<?>>

Type Parameters:

T - type of the projection

Parameters:

expr - query source and projection

Returns:

select(expr).from(expr)