Class SqlPagingQueryUtils
java.lang.Object
org.springframework.cloud.task.repository.database.support.SqlPagingQueryUtils
Utility class that generates the actual SQL statements used by query providers.
- Author:
- Glenn Renfro
-
Method Summary
Modifier and TypeMethodDescriptionstatic StringbuildSortClause(Map<String, org.springframework.batch.item.database.Order> sortKeys) Generates ORDER BY attributes based on the sort keys.static StringGenerates ORDER BY attributes based on the sort keys.static voidbuildWhereClause(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, StringBuilder sql) Generates WHERE clause for queries that require sub selects.static StringgenerateLimitJumpToQuery(AbstractSqlPagingQueryProvider provider, String limitClause) Generate SQL query string using a LIMIT clause.static StringgenerateTopJumpToQuery(AbstractSqlPagingQueryProvider provider, String topClause) Generate SQL query string using a TOP clause.
-
Method Details
-
generateLimitJumpToQuery
public static String generateLimitJumpToQuery(AbstractSqlPagingQueryProvider provider, String limitClause) Generate SQL query string using a LIMIT clause.- Parameters:
provider-AbstractSqlPagingQueryProviderproviding the implementation specificslimitClause- the implementation specific top clause to be used- Returns:
- the generated query
-
generateTopJumpToQuery
public static String generateTopJumpToQuery(AbstractSqlPagingQueryProvider provider, String topClause) Generate SQL query string using a TOP clause.- Parameters:
provider-AbstractSqlPagingQueryProviderproviding the implementation specificstopClause- the implementation specific top clause to be used- Returns:
- the generated query
-
buildWhereClause
public static void buildWhereClause(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, StringBuilder sql) Generates WHERE clause for queries that require sub selects.- Parameters:
provider- the paging query provider that will provide the base where clauseremainingPageQuery- if true assumes more will be appended to where clausesql- the sql statement to be appended.
-
buildSortClause
Generates ORDER BY attributes based on the sort keys.- Parameters:
provider-AbstractSqlPagingQueryProviderproviding the implementation specifics- Returns:
- a String that can be appended to an ORDER BY clause.
-
buildSortClause
public static String buildSortClause(Map<String, org.springframework.batch.item.database.Order> sortKeys) Generates ORDER BY attributes based on the sort keys.- Parameters:
sortKeys- generates order by clause from map- Returns:
- a String that can be appended to an ORDER BY clause.
-