Package com.epam.ta.reportportal.commons.querygen

Class QueryBuilder

java.lang.Object

com.epam.ta.reportportal.commons.querygen.QueryBuilder

public class QueryBuilder
extends java.lang.Object

PostgreSQL query builder using JOOQ. Constructs PostgreSQL Query by provided filters.

Field Summary

Fields

Modifier and Type	Field	Description
static java.util.function.BiPredicate<FilterCondition,FilterTarget>	HAVING_CONDITION	Predicate that checks if filter condition should be applied with HAVING
static java.lang.String	STATISTICS_KEY	Key word for statistics criteria.

Method Summary

Modifier and Type	Method	Description
QueryBuilder	addCondition(org.jooq.Condition condition)	Adds condition to the query
QueryBuilder	addHavingCondition(org.jooq.Condition condition)	Adds statistics condition to the query
QueryBuilder	addJoinToEnd(org.jooq.TableLike<? extends org.jooq.Record> table, org.jooq.JoinType joinType, org.jooq.Condition condition)
QueryBuilder	addJointToStart(org.jooq.TableLike<? extends org.jooq.Record> table, org.jooq.JoinType joinType, org.jooq.Condition condition)
org.jooq.SelectQuery<? extends org.jooq.Record>	build()	Builds query
QuerySupplier	getQuerySupplier()
static QueryBuilder	newBuilder(FilterTarget target)
static QueryBuilder	newBuilder(Queryable queryable)
static QueryBuilder	newBuilder(Queryable queryable, java.util.Set<java.lang.String> fields)
static int	retrieveOffsetAndApplyBoundaries(org.springframework.data.domain.Pageable pageable)
QueryBuilder	with(int limit)	Add limit
QueryBuilder	with(org.jooq.Field<?> field, org.jooq.SortOrder sort)
QueryBuilder	with(org.springframework.data.domain.Pageable pageable)	Adds Pageable conditions
QueryBuilder	with(org.springframework.data.domain.Sort sort)	Convert properties to query criteria and add sorting Sort
QueryBuilder	withWrapperSort(org.springframework.data.domain.Sort sort)
QueryBuilder	wrap()	Joins inner query to load all columns after filtering
QueryBuilder	wrapExcludingFields(java.lang.String... excludingFields)	Joins inner query to load columns excluding provided fields after filtering

Methods inherited from class java.lang.Object

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

Field Detail

STATISTICS_KEY

public static final java.lang.String STATISTICS_KEY

Key word for statistics criteria. Query builder works a little bit in another way with statistics criteria. It implements kind of pivot using PostgerSQL possibilities

See Also:

Constant Field Values

HAVING_CONDITION

public static final java.util.function.BiPredicate<FilterCondition,FilterTarget> HAVING_CONDITION

Predicate that checks if filter condition should be applied with HAVING

Method Detail

newBuilder

public static QueryBuilder newBuilder(FilterTarget target)

newBuilder

public static QueryBuilder newBuilder(Queryable queryable)

newBuilder

public static QueryBuilder newBuilder(Queryable queryable,
                                      java.util.Set<java.lang.String> fields)

addJointToStart

public QueryBuilder addJointToStart(org.jooq.TableLike<? extends org.jooq.Record> table,
                                    org.jooq.JoinType joinType,
                                    org.jooq.Condition condition)

addJoinToEnd

public QueryBuilder addJoinToEnd(org.jooq.TableLike<? extends org.jooq.Record> table,
                                 org.jooq.JoinType joinType,
                                 org.jooq.Condition condition)

addCondition

public QueryBuilder addCondition(org.jooq.Condition condition)

Adds condition to the query

Parameters:

condition - Condition

Returns:

QueryBuilder

addHavingCondition

public QueryBuilder addHavingCondition(org.jooq.Condition condition)

Adds statistics condition to the query

Parameters:

condition - Condition

with

public QueryBuilder with(org.springframework.data.domain.Pageable pageable)

Adds Pageable conditions

Parameters:

pageable - Pageable

Returns:

QueryBuilder

with

public QueryBuilder with(int limit)

Add limit

Parameters:

limit - Limit

Returns:

QueryBuilder

with

public QueryBuilder with(org.springframework.data.domain.Sort sort)

Convert properties to query criteria and add sorting Sort

Parameters:

sort - Sort condition

Returns:

QueryBuilder

with

public QueryBuilder with(org.jooq.Field<?> field,
                         org.jooq.SortOrder sort)

getQuerySupplier

public QuerySupplier getQuerySupplier()

build

public org.jooq.SelectQuery<? extends org.jooq.Record> build()

Builds query

Returns:

Query

wrap

public QueryBuilder wrap()

Joins inner query to load all columns after filtering

Returns:

Query builder

wrapExcludingFields

public QueryBuilder wrapExcludingFields(java.lang.String... excludingFields)

Joins inner query to load columns excluding provided fields after filtering

Returns:

Query builder

withWrapperSort

public QueryBuilder withWrapperSort(org.springframework.data.domain.Sort sort)

retrieveOffsetAndApplyBoundaries

public static int retrieveOffsetAndApplyBoundaries(org.springframework.data.domain.Pageable pageable)