Package com.suncode.pwfl.search.sql

Class SQLBuilder

java.lang.Object

com.suncode.pwfl.search.sql.SQLBuilder

public class SQLBuilder
extends Object

Pozwala stworzyć definicję zapytania SQL

Author:

Paweł Rosolak 5 lut 2014

Constructor Summary

Constructors

Constructor	Description
SQLBuilder()
SQLBuilder(String query)
SQLBuilder(String query, Map<String,org.hibernate.type.Type> scalars, List<SQLFilter> filters)

Method Summary

Modifier and Type	Method	Description
void	addFilter(SQLFilter filter)
void	addScalar(String alias, Type type)
void	addScalar(String alias, org.hibernate.type.Type type)
void	addSorter(Sorter sorter)
String	buildQuery()
String	buildQuery(String baseQuery)
String	getCountQuery()
List<SQLFilter>	getFilters()
Map<String,Object>	getParameters()
Map<String,Collection<Object>>	getParametersList()
String	getQuery()
Map<String,org.hibernate.type.Type>	getScalars()
List<Sorter>	getSorters()
boolean	isUseScalars()
static SQLBuilder	newByWrappers(String query, Map<String,Type> wrappedScalars, List<SQLFilter> filters)
void	setCountQuery(String countQuery)
void	setFilters(List<SQLFilter> filters)
void	setFilters(Map<String,Object> params)
void	setParameter(String alias, Object value)
void	setParameterList(String alias, Collection<Object> value)
void	setParameters(List<SQLFilter> filters)
void	setParameters(Map<String,Object> parameters)
void	setParametersList(Map<String,Collection<Object>> parametersList)
void	setQuery(String query)
void	setScalars(Map<String,org.hibernate.type.Type> scalars)
void	setScalarsByWrappers(Map<String,Type> scalars)
void	setSorters(List<Sorter> sorters)
void	setUseScalars(boolean useScalars)

Methods inherited from class java.lang.Object

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

Constructor Details

SQLBuilder

public SQLBuilder()

SQLBuilder

public SQLBuilder(String query)

SQLBuilder

public SQLBuilder(String query,
 Map<String,org.hibernate.type.Type> scalars,
 List<SQLFilter> filters)

Method Details

newByWrappers

public static SQLBuilder newByWrappers(String query,
 Map<String,Type> wrappedScalars,
 List<SQLFilter> filters)

getQuery

public String getQuery()

setQuery

public void setQuery(String query)

isUseScalars

public boolean isUseScalars()

setUseScalars

public void setUseScalars(boolean useScalars)

getScalars

public Map<String,org.hibernate.type.Type> getScalars()

setScalars

public void setScalars(Map<String,org.hibernate.type.Type> scalars)

setScalarsByWrappers

public void setScalarsByWrappers(Map<String,Type> scalars)

getFilters

public List<SQLFilter> getFilters()

setFilters

public void setFilters(List<SQLFilter> filters)

setFilters

public void setFilters(Map<String,Object> params)

addScalar

public void addScalar(String alias,
 org.hibernate.type.Type type)

addScalar

public void addScalar(String alias,
 Type type)

getSorters

public List<Sorter> getSorters()

setSorters

public void setSorters(List<Sorter> sorters)

getParameters

public Map<String,Object> getParameters()

setParameters

public void setParameters(Map<String,Object> parameters)

setParameter

public void setParameter(String alias,
 Object value)

getParametersList

public Map<String,Collection<Object>> getParametersList()

setParametersList

public void setParametersList(Map<String,Collection<Object>> parametersList)

setParameterList

public void setParameterList(String alias,
 Collection<Object> value)

addFilter

public void addFilter(SQLFilter filter)

setParameters

public void setParameters(List<SQLFilter> filters)

addSorter

public void addSorter(Sorter sorter)

buildQuery

public String buildQuery()

buildQuery

public String buildQuery(String baseQuery)

getCountQuery

public String getCountQuery()

setCountQuery

public void setCountQuery(String countQuery)