Interface KeysetQueryBuilder<X extends KeysetQueryBuilder<X>>

Type Parameters:
X - The concrete builder type
All Known Subinterfaces:
BaseCriteriaBuilder<T,​X>, BaseCTECriteriaBuilder<X>, BaseInsertCriteriaBuilder<T,​X>, BaseQueryBuilder<T,​X>, BaseSubqueryBuilder<X>, CriteriaBuilder<T>, FullQueryBuilder<T,​X>, FullSelectCTECriteriaBuilder<X>, InsertCriteriaBuilder<T>, LeafOngoingSetOperationCriteriaBuilder<X>, LeafOngoingSetOperationCTECriteriaBuilder<X>, LeafOngoingSetOperationSubqueryBuilder<X>, OngoingSetOperationCriteriaBuilder<T,​Y>, OngoingSetOperationCTECriteriaBuilder<T,​Y>, OngoingSetOperationSubqueryBuilder<T,​Y>, PaginatedCriteriaBuilder<T>, QueryBuilder<T,​X>, ReturningInsertCriteriaBuilder<T,​X>, SelectBaseCTECriteriaBuilder<X>, SelectCTECriteriaBuilder<X>, SelectRecursiveCTECriteriaBuilder<X>, StartOngoingSetOperationCriteriaBuilder<X,​Y>, StartOngoingSetOperationCTECriteriaBuilder<X,​Y>, StartOngoingSetOperationSubqueryBuilder<X,​Y>, SubqueryBuilder<T>

public interface KeysetQueryBuilder<X extends KeysetQueryBuilder<X>>
A base interface for builders that support keyset filtering.
Since:
1.0.0
Author:
Christian Beikov
  • Method Details

    • beforeKeyset

      KeysetBuilder<X> beforeKeyset()
      Uses the keyset which the keyset builder constructed to filter out rows that come after the keyset. Based on the order by expressions, the keyset builder should receive reference values for every used expression. The constructed keyset will be filtered out so this is like a "lower than" filter.
      Returns:
      The keyset builder for specifing the keyset
    • beforeKeyset

      X beforeKeyset​(Serializable... values)
      Like beforeKeyset() but maps the reference values by position instead of by expression. The order of the reference values has to match the order of the order by expressions.
      Parameters:
      values - The reference values
      Returns:
      The query builder for chaining calls
    • beforeKeyset

      X beforeKeyset​(Keyset keyset)
      Like beforeKeyset(java.io.Serializable...) but uses the given keyset as reference values. The order of the tuple values has to match the order of the order by expressions.
      Parameters:
      keyset - The reference keyset
      Returns:
      The query builder for chaining calls
    • afterKeyset

      KeysetBuilder<X> afterKeyset()
      Uses the keyset which the keyset builder constructed to filter out rows that come before the keyset. Based on the order by expressions, the keyset builder should receive reference values for every used expression. The constructed keyset will be filtered out so this is like a "greater than" filter.
      Returns:
      The keyset builder for specifing the keyset
    • afterKeyset

      X afterKeyset​(Serializable... values)
      Like afterKeyset() but maps the reference values by position instead of by expression. The order of the reference values has to match the order of the order by expressions.
      Parameters:
      values - The reference values
      Returns:
      The query builder for chaining calls
    • afterKeyset

      X afterKeyset​(Keyset keyset)
      Like afterKeyset(java.io.Serializable...) but uses the given keyset as reference values. The order of the tuple values has to match the order of the order by expressions.
      Parameters:
      keyset - The reference keyset
      Returns:
      The query builder for chaining calls