Package com.valqueries.automapper

Class TokenQueryImpl

java.lang.Object

com.valqueries.automapper.TokenQueryImpl

All Implemented Interfaces:

TokenQuery, TokenSubQuery, Setter, AutoCloseable

public class TokenQueryImpl
extends Object
implements TokenQuery, Setter, AutoCloseable

Constructor Summary

Constructors

Constructor	Description
TokenQueryImpl(TableToken tableToken, ITransactionContext transactionContext, SqlDialect dialect)

Method Summary

Modifier and Type	Method	Description
TokenQuery	and(Consumer<TokenSubQuery> andGroup)	Add an AND group to your query.
void	close()
long	count()	Count the rows matching the query
CrudRepository.CrudUpdateResult	delete()	Delete the rows matching the query.
TokenQuery	eq(Token field, Object value)	Match if the value of a field equals the specified value.
TokenQuery	gt(Token field, Object value)	Match if the value of a field is greater than the specified value.
TokenQuery	gte(Token field, Object value)	Match if the value of a field is greater than or equal to the specified value.
TokenQuery	in(Token field, Object... values)	Match if the value of a field is in the specified collection of values.
TokenQuery	in(Token field, Collection<?> values)	Match if the value of a field is in the specified collection of values.
TokenQuery	isNotNull(Token field)	Match if the value of a field is not null.
TokenQuery	isNull(Token field)	Match if the value of a field is null.
TokenQuery	like(Token field, String value)	Match if the value of a field matches the specified pattern.
TokenQuery	limit(int limit)	Limit the results to the given number of rows.
TokenQuery	limit(int offset, int limit)	Limit the results to the given number of rows, starting at the given offset.
TokenQuery	lt(Token field, Object value)	Match if the value of a field is less than the specified value.
TokenQuery	lte(Token field, Object value)	Match if the value of a field is less than or equal to the specified value.
TokenQuery	notEq(Token field, Object value)	Match if the value of a field does not equal the specified value.
TokenQuery	notLike(Token field, String value)	Match if the value of a field does not match the specified pattern.
TokenQuery	or(Consumer<TokenSubQuery> orGroup)	Add an OR group to your query.
<R> List<R>	select(IRowMapper<R> rowMapper)	Select the rows matching the query.
void	set(IStatement statement)
TokenQuery	sortAscending(Token field)	Sort the results by the given field in ascending order.
TokenQuery	sortDescending(Token field)	Sort the results by the given field in descending order.
CrudRepository.CrudUpdateResult	update(Consumer<TokenUpdate> updater)	Update the rows matching the query.

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.valqueries.automapper.TokenQuery

eq, gt, gte, in, in, isNotNull, isNull, like, lt, lte, notEq, notLike, sortAscending, sortDescending

Constructor Details

TokenQueryImpl

public TokenQueryImpl(TableToken tableToken,
 ITransactionContext transactionContext,
 SqlDialect dialect)

Method Details

or

public TokenQuery or(Consumer<TokenSubQuery> orGroup)

Description copied from interface: TokenQuery

Add an OR group to your query. The statements in this group will be OR-ed together.

Example:

 query.or(or -> or.eq(Person::getName, "Bob").eq(Person::getAge, 42));
 

Will result into the following SQL: `WHERE (name = 'Bob' OR age = 42)`

Specified by:

or in interface TokenQuery

Specified by:

or in interface TokenSubQuery

Parameters:

orGroup - uses temporary TokenSubQuery to specify statements in the OR group

Returns:

this query, for chaining

and

public TokenQuery and(Consumer<TokenSubQuery> andGroup)

Description copied from interface: TokenQuery

Add an AND group to your query. The statements in this group will be AND-ed together. Note that statements are AND-ed by default, this method is meant to be used inside an OR group.

Example:

 query.or(or -> or.eq(Person::getName, "Alice").and(and -> and.eq(Person::getName, "Bob").eq(Person::getAge, 42)));
 

Will result into the following SQL: `WHERE (name = 'Alice OR (name = 'Bob' AND age = 42))`.

Specified by:

and in interface TokenQuery

Specified by:

and in interface TokenSubQuery

Parameters:

andGroup - uses temporary TokenSubQuery to specify statements in the AND group

Returns:

this query, for chaining

eq

public TokenQuery eq(Token field,
 Object value)

Description copied from interface: TokenQuery

Match if the value of a field equals the specified value. If you want to match null values, you have to use TokenQuery.isNull(Token).

Example:

 query.eq(Token.get("name"), "Bob")
 

This will match people with the name "Bob".

Specified by:

eq in interface TokenQuery

Specified by:

eq in interface TokenSubQuery

Parameters:

field - the field to match

value - the value to match

Returns:

the query, for chaining

notEq

public TokenQuery notEq(Token field,
 Object value)

Description copied from interface: TokenQuery

Match if the value of a field does not equal the specified value. If you want to match non-null values, you have to use TokenQuery.isNotNull(Token).

Example:

 query.notEq(Token.get("name"), "Bob")
 

This will match people whose name is not "Bob".

Specified by:

notEq in interface TokenQuery

Specified by:

notEq in interface TokenSubQuery

Parameters:

field - the field to match

value - the value to match

Returns:

the query, for chaining

in

public TokenQuery in(Token field,
 Collection<?> values)

Description copied from interface: TokenQuery

Match if the value of a field is in the specified collection of values.

Example:

 query.in(Token.get("name"), List.of("Bob", "Alice"))
 

This will match people with the name "Bob" or "Alice".

Specified by:

in in interface TokenQuery

Specified by:

in in interface TokenSubQuery

Parameters:

field - the field to match

values - the values to match

Returns:

the query, for chaining

in

public TokenQuery in(Token field,
 Object... values)

Description copied from interface: TokenQuery

Match if the value of a field is in the specified collection of values.

Example:

 query.in(Token.get("name"), "Bob", "Alice")
 

This will match people with the name "Bob" or "Alice".

Specified by:

in in interface TokenQuery

Specified by:

in in interface TokenSubQuery

Parameters:

field - the field to match

values - the values to match

Returns:

the query, for chaining

like

public TokenQuery like(Token field,
 String value)

Description copied from interface: TokenQuery

Match if the value of a field matches the specified pattern.

Example:

 query.like(Token.get("name"), "%ed")
 

This will match people whose name ends with "ed".

Specified by:

like in interface TokenQuery

Specified by:

like in interface TokenSubQuery

Parameters:

field - the field to match

value - the pattern to match

Returns:

the query, for chaining

notLike

public TokenQuery notLike(Token field,
 String value)

Description copied from interface: TokenQuery

Match if the value of a field does not match the specified pattern.

Example:

     query.notLike(Token.get("name"), "%ed")
     

This will match people whose name does not end with "ed".

Specified by:

notLike in interface TokenQuery

Specified by:

notLike in interface TokenSubQuery

Parameters:

field - the field to match

value - the pattern to match

Returns:

the query, for chaining

gt

public TokenQuery gt(Token field,
 Object value)

Description copied from interface: TokenQuery

Match if the value of a field is greater than the specified value.

Example:

 query.gt(Token.get("age"), 18)
 

This will match people older than 18.

Specified by:

gt in interface TokenQuery

Specified by:

gt in interface TokenSubQuery

Parameters:

field - the field to compare

value - the value to compare to

Returns:

the query, for chaining

gte

public TokenQuery gte(Token field,
 Object value)

Description copied from interface: TokenQuery

Match if the value of a field is greater than or equal to the specified value.

Example:

 query.gte(Token.get("age"), 18)
 

This will match people 18 or older.

Specified by:

gte in interface TokenQuery

Specified by:

gte in interface TokenSubQuery

Parameters:

field - the field to compare

value - the value to compare to

Returns:

the query, for chaining

lt

public TokenQuery lt(Token field,
 Object value)

Description copied from interface: TokenQuery

Match if the value of a field is less than the specified value.

Example:

 query.lt(Token.get("age"), 18)
 

This will match people younger than 18.

Specified by:

lt in interface TokenQuery

Specified by:

lt in interface TokenSubQuery

Parameters:

field - the field to compare

value - the value to compare to

Returns:

the query, for chaining

lte

public TokenQuery lte(Token field,
 Object value)

Description copied from interface: TokenQuery

Match if the value of a field is less than or equal to the specified value.

Example:

 query.lte(Token.get("age"), 18)
 

This will match people 18 or younger.

Specified by:

lte in interface TokenQuery

Specified by:

lte in interface TokenSubQuery

Parameters:

field - the field to compare

value - the value to compare to

Returns:

the query, for chaining

isNull

public TokenQuery isNull(Token field)

Description copied from interface: TokenQuery

Match if the value of a field is null.

Example:

 query.isNull(Token.get("email"))
 

This will match people whose email is null.

Note: if the model class has fields of primitive type, they won't be null, even if the database contains NULL values. In this case isNull will still match correctly based on the values in the database.

Specified by:

isNull in interface TokenQuery

Specified by:

isNull in interface TokenSubQuery

Parameters:

field - the field to check

Returns:

the query, for chaining

isNotNull

public TokenQuery isNotNull(Token field)

Description copied from interface: TokenQuery

Match if the value of a field is not null.

Example:

 query.isNotNull(Token.get("email"))
 

This will match people whose email is not null.

Note: if the model class has fields of primitive type, they won't be null, even if the database contains NULL values. In this case isNotNull will still match correctly based on the values in the database.

Specified by:

isNotNull in interface TokenQuery

Specified by:

isNotNull in interface TokenSubQuery

Parameters:

field - the field to check

Returns:

the query, for chaining

sortAscending

public TokenQuery sortAscending(Token field)

Description copied from interface: TokenQuery

Sort the results by the given field in ascending order.

Example:

 query.sortAscending(Person::getAge)
 

This will sort the results by age in ascending order.

Specified by:

sortAscending in interface TokenQuery

Parameters:

field - the filed to sort by

Returns:

the query, for chaining

sortDescending

public TokenQuery sortDescending(Token field)

Description copied from interface: TokenQuery

Sort the results by the given field in descending order.

Example:

 query.sortDescending(Person::getAge)
 

This will sort the results by age in descending order.

Specified by:

sortDescending in interface TokenQuery

Parameters:

field - the filed to sort by

Returns:

the query, for chaining

limit

public TokenQuery limit(int limit)

Description copied from interface: TokenQuery

Limit the results to the given number of rows.

Example:

 query.limit(10)
 

This will return the first 10 rows.

Specified by:

limit in interface TokenQuery

Parameters:

limit - the number of rows to return

Returns:

the query, for chaining

See Also:

• TokenQuery.limit(int, int)

limit

public TokenQuery limit(int offset,
 int limit)

Description copied from interface: TokenQuery

Limit the results to the given number of rows, starting at the given offset.

Offset is 0-based (the first row is 0).

Offset is inclusive, limit is the size of the returned collection.

Example:

 query.limit(10, 20)
 

This will return rows 10, 11, 12, ..., 29.

Specified by:

limit in interface TokenQuery

Parameters:

offset - the offset to start at

limit - the number of rows to return

Returns:

the query, for chaining

select

public <R> List<R> select(IRowMapper<R> rowMapper)

Description copied from interface: TokenQuery

Select the rows matching the query.

This is a terminal operation. As such, the query should not be reused after this method is called.

Specified by:

select in interface TokenQuery

Type Parameters:

R - the type of the objects returned by the mapper

Parameters:

rowMapper - the mapper converting each row of the result into an object that will be returned

Returns:

list of objects returned by the mapper

count

public long count()

Description copied from interface: TokenQuery

Count the rows matching the query

Specified by:

count in interface TokenQuery

Returns:

the number of rows matching the query

update

public CrudRepository.CrudUpdateResult update(Consumer<TokenUpdate> updater)

Description copied from interface: TokenQuery

Update the rows matching the query.

This is a terminal operation. As such, the query should not be reused after this method is called.

Specified by:

update in interface TokenQuery

Parameters:

updater - uses the TokenUpdate to specify the update operation

Returns:

a CrudRepository.CrudUpdateResult with the number of rows affected

delete

public CrudRepository.CrudUpdateResult delete()

Description copied from interface: TokenQuery

Delete the rows matching the query.

This is a terminal operation. As such, the query should not be reused after this method is called.

Specified by:

delete in interface TokenQuery

Returns:

a CrudRepository.CrudUpdateResult with the number of rows affected

set

public void set(IStatement statement)

Specified by:

set in interface Setter

close

public void close()

Specified by:

close in interface AutoCloseable