Package org.springframework.data.r2dbc.core

Class StatementMapper.SelectSpec

java.lang.Object

org.springframework.data.r2dbc.core.StatementMapper.SelectSpec

Enclosing interface:

StatementMapper

public static class StatementMapper.SelectSpec
extends Object

SELECT specification.

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	SelectSpec(org.springframework.data.relational.core.sql.Table table, List<String> projectedFields, List<org.springframework.data.relational.core.sql.Expression> selectList, org.springframework.data.relational.core.query.CriteriaDefinition criteria, Sort sort, int limit, long offset, boolean distinct, org.springframework.data.relational.core.sql.LockMode lockMode)

Method Summary

Modifier and Type	Method	Description
static StatementMapper.SelectSpec	create(String table)	Create an SELECT specification for table.
static StatementMapper.SelectSpec	create(org.springframework.data.relational.core.sql.SqlIdentifier table)	Create an SELECT specification for table.
StatementMapper.SelectSpec	distinct()	Associate a result statement distinct with the select and create a new StatementMapper.SelectSpec.
StatementMapper.SelectSpec	doWithTable(BiFunction<org.springframework.data.relational.core.sql.Table,StatementMapper.SelectSpec,StatementMapper.SelectSpec> function)
org.springframework.data.relational.core.query.CriteriaDefinition	getCriteria()
int	getLimit()
org.springframework.data.relational.core.sql.LockMode	getLock()	The used lockmode
long	getOffset()
List<String>	getProjectedFields()	Deprecated. since 1.1, use getSelectList() instead.
List<org.springframework.data.relational.core.sql.Expression>	getSelectList()
Sort	getSort()
org.springframework.data.relational.core.sql.Table	getTable()
boolean	isDistinct()
StatementMapper.SelectSpec	limit(int limit)	Associate a result limit with the select and create a new StatementMapper.SelectSpec.
StatementMapper.SelectSpec	lock(org.springframework.data.relational.core.sql.LockMode lockMode)	Associate a lock mode with the select and create a new StatementMapper.SelectSpec.
StatementMapper.SelectSpec	offset(long offset)	Associate a result offset with the select and create a new StatementMapper.SelectSpec.
StatementMapper.SelectSpec	withCriteria(org.springframework.data.relational.core.query.CriteriaDefinition criteria)	Associate a Criteria with the select and return a new StatementMapper.SelectSpec.
StatementMapper.SelectSpec	withPage(Pageable page)	Associate a Pageable with the select and create a new StatementMapper.SelectSpec.
StatementMapper.SelectSpec	withProjection(String... projectedFields)	Associate projectedFields with the select and create a new StatementMapper.SelectSpec.
StatementMapper.SelectSpec	withProjection(Collection<org.springframework.data.relational.core.sql.Expression> projectedFields)	Associate projectedFields with the select and create a new StatementMapper.SelectSpec.
StatementMapper.SelectSpec	withProjection(org.springframework.data.relational.core.sql.Expression... expressions)	Associate expressions with the select list and create a new StatementMapper.SelectSpec.
StatementMapper.SelectSpec	withProjection(org.springframework.data.relational.core.sql.SqlIdentifier... projectedFields)	Associate projectedFields with the select and create a new StatementMapper.SelectSpec.
StatementMapper.SelectSpec	withSort(Sort sort)	Associate Sort with the select and create a new StatementMapper.SelectSpec.

Methods inherited from class java.lang.Object

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

Constructor Details

SelectSpec

protected SelectSpec(org.springframework.data.relational.core.sql.Table table,
 List<String> projectedFields,
 List<org.springframework.data.relational.core.sql.Expression> selectList,
 @Nullable
 org.springframework.data.relational.core.query.CriteriaDefinition criteria,
 Sort sort,
 int limit,
 long offset,
 boolean distinct,
 org.springframework.data.relational.core.sql.LockMode lockMode)

Method Details

create

public static StatementMapper.SelectSpec create(String table)

Create an SELECT specification for table.

Parameters:

table -

Returns:

the StatementMapper.SelectSpec.

create

public static StatementMapper.SelectSpec create(org.springframework.data.relational.core.sql.SqlIdentifier table)

Create an SELECT specification for table.

Parameters:

table -

Returns:

the StatementMapper.SelectSpec.

Since:

1.1

doWithTable

public StatementMapper.SelectSpec doWithTable(BiFunction<org.springframework.data.relational.core.sql.Table,StatementMapper.SelectSpec,StatementMapper.SelectSpec> function)

withProjection

public StatementMapper.SelectSpec withProjection(String... projectedFields)

Associate projectedFields with the select and create a new StatementMapper.SelectSpec.

Parameters:

projectedFields -

Returns:

the StatementMapper.SelectSpec.

Since:

1.1

withProjection

public StatementMapper.SelectSpec withProjection(org.springframework.data.relational.core.sql.SqlIdentifier... projectedFields)

Associate projectedFields with the select and create a new StatementMapper.SelectSpec.

Parameters:

projectedFields -

Returns:

the StatementMapper.SelectSpec.

Since:

1.1

withProjection

public StatementMapper.SelectSpec withProjection(org.springframework.data.relational.core.sql.Expression... expressions)

Associate expressions with the select list and create a new StatementMapper.SelectSpec.

Parameters:

expressions -

Returns:

the StatementMapper.SelectSpec.

Since:

1.1

withProjection

public StatementMapper.SelectSpec withProjection(Collection<org.springframework.data.relational.core.sql.Expression> projectedFields)

Associate projectedFields with the select and create a new StatementMapper.SelectSpec.

Parameters:

projectedFields -

Returns:

the StatementMapper.SelectSpec.

Since:

1.1

withCriteria

public StatementMapper.SelectSpec withCriteria(org.springframework.data.relational.core.query.CriteriaDefinition criteria)

Associate a Criteria with the select and return a new StatementMapper.SelectSpec.

Parameters:

criteria -

Returns:

the StatementMapper.SelectSpec.

withSort

public StatementMapper.SelectSpec withSort(Sort sort)

Associate Sort with the select and create a new StatementMapper.SelectSpec.

Parameters:

sort -

Returns:

the StatementMapper.SelectSpec.

withPage

public StatementMapper.SelectSpec withPage(Pageable page)

Associate a Pageable with the select and create a new StatementMapper.SelectSpec.

Parameters:

page -

Returns:

the StatementMapper.SelectSpec.

offset

public StatementMapper.SelectSpec offset(long offset)

Associate a result offset with the select and create a new StatementMapper.SelectSpec.

Parameters:

offset -

Returns:

the StatementMapper.SelectSpec.

limit

public StatementMapper.SelectSpec limit(int limit)

Associate a result limit with the select and create a new StatementMapper.SelectSpec.

Parameters:

limit -

Returns:

the StatementMapper.SelectSpec.

distinct

public StatementMapper.SelectSpec distinct()

Associate a result statement distinct with the select and create a new StatementMapper.SelectSpec.

Returns:

the StatementMapper.SelectSpec.

lock

public StatementMapper.SelectSpec lock(org.springframework.data.relational.core.sql.LockMode lockMode)

Associate a lock mode with the select and create a new StatementMapper.SelectSpec.

Parameters:

lockMode - the LockMode we want to use. This might be null

Returns:

the StatementMapper.SelectSpec.

getLock

@Nullable
public org.springframework.data.relational.core.sql.LockMode getLock()

The used lockmode

Returns:

might be null if no lockmode defined.

getTable

public org.springframework.data.relational.core.sql.Table getTable()

getProjectedFields

@Deprecated
public List<String> getProjectedFields()

Deprecated.

since 1.1, use getSelectList() instead.

Returns:

getSelectList

public List<org.springframework.data.relational.core.sql.Expression> getSelectList()

getCriteria

@Nullable
public org.springframework.data.relational.core.query.CriteriaDefinition getCriteria()

getSort

public Sort getSort()

getOffset

public long getOffset()

getLimit

public int getLimit()

isDistinct

public boolean isDistinct()