Package ru.cg.webbpm.modules.security.api.impl.dao.jooq.util

Class JooqQueryUtils

java.lang.Object
ru.cg.webbpm.modules.security.api.impl.dao.jooq.util.JooqQueryUtils
public final class JooqQueryUtils extends Object
Author:
latypov

  • Method Summary

    Modifier and Type
    Method
    Description
    protected static <T extends org.jooq.Record>
    org.jooq.SelectOrderByStep<T>
    applyCondition(org.jooq.SelectConditionStep<T> selectConditionStep, org.jooq.Condition condition)
    Applies condition according to passed select condition step.
    static <T extends org.jooq.Record>
    org.jooq.SelectOrderByStep<T>
    applyCondition(org.jooq.SelectWhereStep<T> selectWhereStep, org.jooq.Condition condition)
    Applies condition according to passed select where step.
    static <T extends org.jooq.Record>
    org.jooq.SelectForUpdateStep<T>
    applyLimits(org.jooq.SelectLimitStep<T> selectLimitStep, Integer offset, Integer limit)
    Applies limits and offset according to passed select limit step.
    static <T extends org.jooq.Record>
    org.jooq.SelectForUpdateStep<T>
    applyLoadOptions(org.jooq.SelectConditionStep<T> selectConditionStep, LoadOptions loadOptions)
    Applies load options according to passed select condition step.
    static <T extends org.jooq.Record>
    org.jooq.SelectForUpdateStep<T>
    applyLoadOptions(org.jooq.SelectWhereStep<T> selectWhereStep, LoadOptions loadOptions)
    Applies load options according to passed select where step.
    static <T extends org.jooq.Record>
    org.jooq.SelectForUpdateStep<T>
    applyNonPageableLoadOptions(org.jooq.SelectConditionStep<T> selectConditionStep, NonPageableLoadOptions loadOptions)
    Applies load options without limit and offset according to passed select condition step.
    static <T extends org.jooq.Record>
    org.jooq.SelectForUpdateStep<T>
    applyNonPageableLoadOptions(org.jooq.SelectWhereStep<T> selectWhereStep, NonPageableLoadOptions loadOptions)
    Applies load options without limit and offset according to passed select where step.

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

  • Method Details

    • applyLoadOptions

      public static <T extends org.jooq.Record> org.jooq.SelectForUpdateStep<T> applyLoadOptions(org.jooq.SelectConditionStep<T> selectConditionStep, LoadOptions loadOptions)
      Applies load options according to passed select condition step.
      Type Parameters:
      T - describes type parameter.
      Parameters:
      selectConditionStep - indicates select condition properties.
      loadOptions - indicates set of options. Instance of LoadOptions type.
      Returns:
      select for update step.

    • applyNonPageableLoadOptions

      public static <T extends org.jooq.Record> org.jooq.SelectForUpdateStep<T> applyNonPageableLoadOptions(org.jooq.SelectConditionStep<T> selectConditionStep, NonPageableLoadOptions loadOptions)
      Applies load options without limit and offset according to passed select condition step.
      Type Parameters:
      T - describes type parameter.
      Parameters:
      selectConditionStep - indicates select condition properties.
      loadOptions - indicates set of options. Instance of NonPageableLoadOptions type.
      Returns:
      select for update step.

    • applyLoadOptions

      public static <T extends org.jooq.Record> org.jooq.SelectForUpdateStep<T> applyLoadOptions(org.jooq.SelectWhereStep<T> selectWhereStep, LoadOptions loadOptions)
      Applies load options according to passed select where step.
      Type Parameters:
      T - describes type parameter.
      Parameters:
      selectWhereStep - indicates select where step properties. Instance of SelectWhereStep type.
      loadOptions - indicates set of options. Instance of LoadOptions type.
      Returns:
      select for update step.

    • applyNonPageableLoadOptions

      public static <T extends org.jooq.Record> org.jooq.SelectForUpdateStep<T> applyNonPageableLoadOptions(org.jooq.SelectWhereStep<T> selectWhereStep, NonPageableLoadOptions loadOptions)
      Applies load options without limit and offset according to passed select where step.
      Type Parameters:
      T - describes type parameter.
      Parameters:
      selectWhereStep - indicates select where step properties. Instance of SelectWhereStep type.
      loadOptions - indicates set of options. Instance of NonPageableLoadOptions type.
      Returns:
      select for update step.

    • applyCondition

      protected static <T extends org.jooq.Record> org.jooq.SelectOrderByStep<T> applyCondition(org.jooq.SelectConditionStep<T> selectConditionStep, org.jooq.Condition condition)
      Applies condition according to passed select condition step.
      Type Parameters:
      T - describes type parameter.
      Parameters:
      selectConditionStep - indicates select condition properties.
      condition - indicates passed condition properties. Instance of Condition type.
      Returns:
      select order by step.

    • applyCondition

      public static <T extends org.jooq.Record> org.jooq.SelectOrderByStep<T> applyCondition(org.jooq.SelectWhereStep<T> selectWhereStep, org.jooq.Condition condition)
      Applies condition according to passed select where step.
      Type Parameters:
      T - describes type parameter.
      Parameters:
      selectWhereStep - indicates select where properties.
      condition - indicates passed condition properties. Instance of Condition type.
      Returns:
      select order by step.

    • applyLimits

      public static <T extends org.jooq.Record> org.jooq.SelectForUpdateStep<T> applyLimits(org.jooq.SelectLimitStep<T> selectLimitStep, Integer offset, Integer limit)
      Applies limits and offset according to passed select limit step.
      Type Parameters:
      T - describes type parameter.
      Parameters:
      selectLimitStep - indicates select limit properties.
      offset - num that indicates the quantity of omitted values. Instance of Integer type.
      limit - num that indicates the limit of received requested values. Instance of Integer type.
      Returns:
      select for update step.