public PostgresPagingQueryProviderTests() { pagingQueryProvider = new PostgresPagingQueryProvider(); }
@Override public String generateRemainingPagesQuery(int pageSize) { if(StringUtils.hasText(getGroupClause())) { return SqlPagingQueryUtils.generateLimitGroupedSqlQuery(this, true, buildLimitClause(pageSize)); } else { return SqlPagingQueryUtils.generateLimitSqlQuery(this, true, buildLimitClause(pageSize)); } }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateLimitSqlQuery(this, false, buildLimitClause(pageSize)); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateLimitSqlQuery(this, false, buildLimitClause(pageSize)); }
@Override public String generateRemainingPagesQuery(int pageSize) { if(StringUtils.hasText(getGroupClause())) { return SqlPagingQueryUtils.generateLimitGroupedSqlQuery(this, true, buildLimitClause(pageSize)); } else { return SqlPagingQueryUtils.generateLimitSqlQuery(this, true, buildLimitClause(pageSize)); } }
case MYSQL: provider = new MySqlPagingQueryProvider(); break; case ORACLE: provider = new OraclePagingQueryProvider(); break; case POSTGRES: provider = new PostgresPagingQueryProvider(); break; case SYBASE: provider = new SybasePagingQueryProvider(); break; case SQLITE: provider = new SqlitePagingQueryProvider(); 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; case SQLITE: provider = new SqlitePagingQueryProvider(); break;