@Override public String generateJumpToItemQuery(int itemIndex, int pageSize) { int page = itemIndex / pageSize; int offset = (page * pageSize) - 1; offset = offset<0 ? 0 : offset; String limitClause = new StringBuilder().append("LIMIT 1 OFFSET ").append(offset).toString(); return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause); }
@Override public String generateJumpToItemQuery(int itemIndex, int pageSize) { int page = itemIndex / pageSize; int offset = (page * pageSize) - 1; offset = offset<0 ? 0 : offset; String limitClause = new StringBuilder().append("LIMIT ").append(offset).append(", 1").toString(); return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause); }
@Override public String generateJumpToItemQuery(int itemIndex, int pageSize) { int page = itemIndex / pageSize; int offset = (page * pageSize) - 1; offset = offset<0 ? 0 : offset; String limitClause = new StringBuilder().append("LIMIT ").append(offset).append(", 1").toString(); return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause); }
@Test public void testGenerateLimitJumpToQuery() { AbstractSqlPagingQueryProvider qp = new TestSqlPagingQueryProvider("FOO", "BAR", sortKeys); assertEquals("SELECT ID FROM BAR ORDER BY ID ASC LIMIT 100, 1", SqlPagingQueryUtils .generateLimitJumpToQuery(qp, "LIMIT 100, 1")); qp.setWhereClause("BAZ IS NOT NULL"); assertEquals("SELECT ID FROM BAR WHERE BAZ IS NOT NULL ORDER BY ID ASC LIMIT 100, 1", SqlPagingQueryUtils.generateLimitJumpToQuery(qp, "LIMIT 100, 1")); }
@Test public void testGenerateLimitJumpQueryDescending() { sortKeys.put("ID", Order.DESCENDING); AbstractSqlPagingQueryProvider qp = new TestSqlPagingQueryProvider("FOO", "BAR", sortKeys); String query = SqlPagingQueryUtils.generateLimitJumpToQuery(qp, "LIMIT 100, 1"); assertTrue("Wrong query: " + query, query.contains("ID DESC")); assertEquals("Wrong query: " + query, 0, StringUtils.countOccurrencesOf(query, "ASC")); assertEquals("Wrong query: " + query, 1, StringUtils.countOccurrencesOf(query, "DESC")); qp.setWhereClause("BAZ IS NOT NULL"); assertTrue("Wrong query: " + query, query.contains("ID DESC")); }
@Override public String generateJumpToItemQuery(int itemIndex, int pageSize) { int page = itemIndex / pageSize; int offset = (page * pageSize) - 1; offset = offset<0 ? 0 : offset; String limitClause = new StringBuilder().append("LIMIT 1 OFFSET ").append(offset).toString(); return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause); }
@Override public String generateJumpToItemQuery(int itemIndex, int pageSize) { int page = itemIndex / pageSize; int offset = (page * pageSize) - 1; offset = offset<0 ? 0 : offset; String limitClause = new StringBuilder().append("LIMIT ").append(offset).append(", 1").toString(); return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause); }
@Override public String generateJumpToItemQuery(int itemIndex, int pageSize) { int page = itemIndex / pageSize; int offset = (page * pageSize) - 1; offset = offset<0 ? 0 : offset; String limitClause = new StringBuilder().append("LIMIT ").append(offset).append(", 1").toString(); return SqlPagingQueryUtils.generateLimitJumpToQuery(this, limitClause); }