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.