@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, false, buildTopClause(pageSize)); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, false, buildTopClause(pageSize)); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, false, buildTopClause(pageSize)); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, false, buildTopClause(pageSize)); }
@Override public String generateRemainingPagesQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, true, buildTopClause(pageSize)); }
@Override public String generateRemainingPagesQuery(int pageSize) { if(StringUtils.hasText(getGroupClause())) { return SqlPagingQueryUtils.generateGroupedTopSqlQuery(this, true, buildTopClause(pageSize)); } else { return SqlPagingQueryUtils.generateTopSqlQuery(this, true, buildTopClause(pageSize)); } }
@Override public String generateRemainingPagesQuery(int pageSize) { if(StringUtils.hasText(getGroupClause())) { return SqlPagingQueryUtils.generateGroupedTopSqlQuery(this, true, buildTopClause(pageSize)); } else { return SqlPagingQueryUtils.generateTopSqlQuery(this, true, buildTopClause(pageSize)); } }
@Override public String generateRemainingPagesQuery(int pageSize) { if(StringUtils.hasText(getGroupClause())) { return SqlPagingQueryUtils.generateGroupedTopSqlQuery(this, true, buildTopClause(pageSize)); } else { return SqlPagingQueryUtils.generateTopSqlQuery(this, true, buildTopClause(pageSize)); } }
@Test public void testGenerateTopSqlQuery() { AbstractSqlPagingQueryProvider qp = new TestSqlPagingQueryProvider("FOO", "BAR", sortKeys); assertEquals("SELECT TOP 100 FOO FROM BAR ORDER BY ID ASC", SqlPagingQueryUtils.generateTopSqlQuery(qp, false, "TOP 100")); assertEquals("SELECT TOP 100 FOO FROM BAR WHERE ((ID > ?)) ORDER BY ID ASC", SqlPagingQueryUtils .generateTopSqlQuery(qp, true, "TOP 100")); qp.setWhereClause("BAZ IS NOT NULL"); assertEquals("SELECT TOP 100 FOO FROM BAR WHERE BAZ IS NOT NULL ORDER BY ID ASC", SqlPagingQueryUtils .generateTopSqlQuery(qp, false, "TOP 100")); assertEquals("SELECT TOP 100 FOO FROM BAR WHERE (BAZ IS NOT NULL) AND ((ID > ?)) ORDER BY ID ASC", SqlPagingQueryUtils.generateTopSqlQuery(qp, true, "TOP 100")); }
@Test public void testGenerateTopSqlQueryDescending() { sortKeys.put("ID", Order.DESCENDING); AbstractSqlPagingQueryProvider qp = new TestSqlPagingQueryProvider("FOO", "BAR", sortKeys); assertEquals("SELECT TOP 100 FOO FROM BAR ORDER BY ID DESC", SqlPagingQueryUtils.generateTopSqlQuery(qp, false, "TOP 100")); assertEquals("SELECT TOP 100 FOO FROM BAR WHERE ((ID < ?)) ORDER BY ID DESC", SqlPagingQueryUtils .generateTopSqlQuery(qp, true, "TOP 100")); qp.setWhereClause("BAZ IS NOT NULL"); assertEquals("SELECT TOP 100 FOO FROM BAR WHERE BAZ IS NOT NULL ORDER BY ID DESC", SqlPagingQueryUtils .generateTopSqlQuery(qp, false, "TOP 100")); assertEquals("SELECT TOP 100 FOO FROM BAR WHERE (BAZ IS NOT NULL) AND ((ID < ?)) ORDER BY ID DESC", SqlPagingQueryUtils.generateTopSqlQuery(qp, true, "TOP 100")); }
@Override public String generateRemainingPagesQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, true, buildTopClause(pageSize)); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, false, buildTopClause(pageSize)); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, false, buildTopClause(pageSize)); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, false, buildTopClause(pageSize)); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, false, buildTopClause(pageSize)); }
@Override public String generateRemainingPagesQuery(int pageSize) { if(StringUtils.hasText(getGroupClause())) { return SqlPagingQueryUtils.generateGroupedTopSqlQuery(this, true, buildTopClause(pageSize)); } else { return SqlPagingQueryUtils.generateTopSqlQuery(this, true, buildTopClause(pageSize)); } }
@Override public String generateRemainingPagesQuery(int pageSize) { if(StringUtils.hasText(getGroupClause())) { return SqlPagingQueryUtils.generateGroupedTopSqlQuery(this, true, buildTopClause(pageSize)); } else { return SqlPagingQueryUtils.generateTopSqlQuery(this, true, buildTopClause(pageSize)); } }
@Override public String generateRemainingPagesQuery(int pageSize) { if(StringUtils.hasText(getGroupClause())) { return SqlPagingQueryUtils.generateGroupedTopSqlQuery(this, true, buildTopClause(pageSize)); } else { return SqlPagingQueryUtils.generateTopSqlQuery(this, true, buildTopClause(pageSize)); } }