provider.setSortKeys(sortKeys); if (StringUtils.hasText(selectClause)) { provider.setSelectClause(selectClause);
@Before public void setUp() { if (pagingQueryProvider == null) { throw new IllegalArgumentException("pagingQueryProvider can't be null"); } pagingQueryProvider.setSelectClause("id, name, age"); pagingQueryProvider.setFromClause("foo"); pagingQueryProvider.setWhereClause("bar = 1"); Map<String, Order> sortKeys = new LinkedHashMap<>(); sortKeys.put("id", Order.ASCENDING); pagingQueryProvider.setSortKeys(sortKeys); pageSize = 100; }
sortKeys.put("CODE", Order.DESCENDING); queryProvider.setSortKeys(sortKeys); queryProvider.setSelectClause("select NAME, CODE, sum(VALUE)"); queryProvider.setGroupClause("NAME, CODE");
provider.setSelectClause(this.selectClause); provider.setFromClause(this.fromClause); provider.setWhereClause(this.whereClause);
@Test public void testFirstPageSqlWithAliases() { Map<String, Order> sorts = new HashMap<>(); sorts.put("owner.id", Order.ASCENDING); this.pagingQueryProvider = new MySqlPagingQueryProvider(); this.pagingQueryProvider.setSelectClause("SELECT owner.id as ownerid, first_name, last_name, dog_name "); this.pagingQueryProvider.setFromClause("FROM dog_owner owner INNER JOIN dog ON owner.id = dog.id "); this.pagingQueryProvider.setSortKeys(sorts); String firstPage = this.pagingQueryProvider.generateFirstPageQuery(5); String jumpToItemQuery = this.pagingQueryProvider.generateJumpToItemQuery(7, 5); String remainingPagesQuery = this.pagingQueryProvider.generateRemainingPagesQuery(5); assertEquals("SELECT owner.id as ownerid, first_name, last_name, dog_name FROM dog_owner owner INNER JOIN dog ON owner.id = dog.id ORDER BY owner.id ASC LIMIT 5", firstPage); assertEquals("SELECT owner.id FROM dog_owner owner INNER JOIN dog ON owner.id = dog.id ORDER BY owner.id ASC LIMIT 4, 1", jumpToItemQuery); assertEquals("SELECT owner.id as ownerid, first_name, last_name, dog_name FROM dog_owner owner INNER JOIN dog ON owner.id = dog.id WHERE ((owner.id > ?)) ORDER BY owner.id ASC LIMIT 5", remainingPagesQuery); }
provider.setSelectClause("SELECT ID, FIRST, SECOND, THIRD"); provider.setFromClause("FOO"); provider.setSortKeys(sortKeys);
provider.setSortKeys(sortKeys); if (StringUtils.hasText(selectClause)) { provider.setSelectClause(selectClause);
provider.setSelectClause(this.selectClause); provider.setFromClause(this.fromClause); provider.setWhereClause(this.whereClause);