Package org.javers.repository.sql.session

Class SelectBuilder

java.lang.Object

org.javers.repository.sql.session.SelectBuilder

public class SelectBuilder
extends Object

Method Summary

Modifier and Type	Method	Description
SelectBuilder	and(String columnName, Long value)
SelectBuilder	and(String columnName, String value)
SelectBuilder	and(String columnName, String operator, Parameter parameter)
SelectBuilder	and(String columnName, BigDecimal value)
SelectBuilder	and(String predicateSQL, Parameter... params)
SelectBuilder	andLike(String columnName, String value)
SelectBuilder	append(String moreSql, Parameter... params)
<T> List<T>	executeQuery(ObjectMapper<T> objectMapper)
SelectBuilder	from(String fromClauseSQL)
List<Parameter>	getParameters()
String	getQueryName()
SelectBuilder	limit(int limit, int offset)
SelectBuilder	orderByAsc(String columns)
SelectBuilder	orderByDesc(String columns)
List<Long>	queryForListOfLong()
long	queryForLong(String queryName)
Optional<BigDecimal>	queryForOptionalBigDecimal(String queryName)
Optional<Long>	queryForOptionalLong()
SelectBuilder	queryName(String queryName)
SelectBuilder	sql(String sql)
SelectBuilder	wrap(String leftSql, String rightSql, Parameter... params)

Methods inherited from class java.lang.Object

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

Method Details

sql

public SelectBuilder sql(String sql)

from

public SelectBuilder from(String fromClauseSQL)

and

public SelectBuilder and(String columnName,
 String operator,
 Parameter parameter)

and

public SelectBuilder and(String predicateSQL,
 Parameter... params)

and

public SelectBuilder and(String columnName,
 Long value)

andLike

public SelectBuilder andLike(String columnName,
 String value)

and

public SelectBuilder and(String columnName,
 String value)

and

public SelectBuilder and(String columnName,
 BigDecimal value)

limit

public SelectBuilder limit(int limit,
 int offset)

orderByDesc

public SelectBuilder orderByDesc(String columns)

orderByAsc

public SelectBuilder orderByAsc(String columns)

wrap

public SelectBuilder wrap(String leftSql,
 String rightSql,
 Parameter... params)

append

public SelectBuilder append(String moreSql,
 Parameter... params)

queryForLong

public long queryForLong(String queryName)

queryForOptionalBigDecimal

public Optional<BigDecimal> queryForOptionalBigDecimal(String queryName)

queryForOptionalLong

public Optional<Long> queryForOptionalLong()

queryForListOfLong

public List<Long> queryForListOfLong()

executeQuery

public <T> List<T> executeQuery(ObjectMapper<T> objectMapper)

queryName

public SelectBuilder queryName(String queryName)

getParameters

public List<Parameter> getParameters()

getQueryName

public String getQueryName()