public OraclePagingQueryProviderTests() { pagingQueryProvider = new OraclePagingQueryProvider(); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateRowNumSqlQuery(this, false, buildRowNumClause(pageSize)); }
@Override public String generateJumpToItemQuery(int itemIndex, int pageSize) { int page = itemIndex / pageSize; int offset = (page * pageSize); offset = offset == 0 ? 1 : offset; String sortKeySelect = this.getSortKeySelect(); return SqlPagingQueryUtils.generateRowNumSqlQueryWithNesting(this, sortKeySelect, sortKeySelect, false, "TMP_ROW_NUM = " + offset); }
private String getSortKeySelect() { StringBuilder sql = new StringBuilder(); String prefix = ""; for (Map.Entry<String, Order> sortKey : this.getSortKeys().entrySet()) { sql.append(prefix); prefix = ", "; sql.append(sortKey.getKey()); } return sql.toString(); }
private String getSortKeySelect() { StringBuilder sql = new StringBuilder(); String prefix = ""; for (Map.Entry<String, Order> sortKey : this.getSortKeys().entrySet()) { sql.append(prefix); prefix = ", "; sql.append(sortKey.getKey()); } return sql.toString(); }
case SQLSERVER: provider = new SqlServerPagingQueryProvider(); break; case MYSQL: provider = new MySqlPagingQueryProvider(); break; case ORACLE: provider = new OraclePagingQueryProvider(); break; case POSTGRES: provider = new PostgresPagingQueryProvider(); break; case SYBASE: provider = new SybasePagingQueryProvider(); break;
@Override public String generateRemainingPagesQuery(int pageSize) { return SqlPagingQueryUtils.generateRowNumSqlQuery(this, true, buildRowNumClause(pageSize)); }
@Override public String generateJumpToItemQuery(int itemIndex, int pageSize) { int page = itemIndex / pageSize; int offset = (page * pageSize); offset = offset == 0 ? 1 : offset; String sortKeySelect = this.getSortKeySelect(); return SqlPagingQueryUtils.generateRowNumSqlQueryWithNesting(this, sortKeySelect, sortKeySelect, false, "TMP_ROW_NUM = " + offset); }
case SQLSERVER: provider = new SqlServerPagingQueryProvider(); break; case MYSQL: provider = new MySqlPagingQueryProvider(); break; case ORACLE: provider = new OraclePagingQueryProvider(); break; case POSTGRES: provider = new PostgresPagingQueryProvider(); break; case SYBASE: provider = new SybasePagingQueryProvider(); break;
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateRowNumSqlQuery(this, false, buildRowNumClause(pageSize)); }
@Override public String generateRemainingPagesQuery(int pageSize) { return SqlPagingQueryUtils.generateRowNumSqlQuery(this, true, buildRowNumClause(pageSize)); }