public final class SqlPagingQueryUtils extends Object
Modifier and Type | Method and Description |
---|---|
static String |
buildSortClause(AbstractSqlPagingQueryProvider provider)
Generates ORDER BY attributes based on the sort keys.
|
static String |
buildSortClause(Map<String,org.springframework.batch.item.database.Order> sortKeys)
Generates ORDER BY attributes based on the sort keys.
|
static void |
buildWhereClause(AbstractSqlPagingQueryProvider provider,
boolean remainingPageQuery,
StringBuilder sql)
Generates WHERE clause for queries that require sub selects.
|
static String |
generateLimitJumpToQuery(AbstractSqlPagingQueryProvider provider,
String limitClause)
Generate SQL query string using a LIMIT clause.
|
static String |
generateTopJumpToQuery(AbstractSqlPagingQueryProvider provider,
String topClause)
Generate SQL query string using a TOP clause.
|
public static String generateLimitJumpToQuery(AbstractSqlPagingQueryProvider provider, String limitClause)
provider
- AbstractSqlPagingQueryProvider
providing the implementation
specificslimitClause
- the implementation specific top clause to be usedpublic static String generateTopJumpToQuery(AbstractSqlPagingQueryProvider provider, String topClause)
provider
- AbstractSqlPagingQueryProvider
providing the implementation
specificstopClause
- the implementation specific top clause to be usedpublic static void buildWhereClause(AbstractSqlPagingQueryProvider provider, boolean remainingPageQuery, StringBuilder sql)
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.public static String buildSortClause(AbstractSqlPagingQueryProvider provider)
provider
- AbstractSqlPagingQueryProvider
providing the implementation
specificsCopyright © 2019 Pivotal Software, Inc.. All rights reserved.