Module is.codion.framework.db.core
Package is.codion.framework.db

Interface EntityConnection.Select.Builder

Enclosing interface:
EntityConnection.Select
public static interface EntityConnection.Select.Builder
Builds a EntityConnection.Select.

  • Method Details

    • orderBy

      EntityConnection.Select.Builder orderBy(OrderBy orderBy)
      Sets the OrderBy for this condition
      Parameters:
      orderBy - the OrderBy to use when applying this condition
      Returns:
      this builder instance

    • limit

      EntityConnection.Select.Builder limit(Integer limit)
      Parameters:
      limit - the LIMIT to use for this condition, null for no limit
      Returns:
      this builder instance

    • offset

      EntityConnection.Select.Builder offset(Integer offset)
      Parameters:
      offset - the OFFSET to use for this condition, null for no offset
      Returns:
      this builder instance

    • forUpdate

      EntityConnection.Select.Builder forUpdate()
      Marks the Select instance as a FOR UPDATE query, this means the resulting rows will be locked by the given connection until unlocked by running another (non select for update) query on the same connection or performing an update. Note that marking this Select instance as for update, sets the EntityConnection.Select.fetchDepth() to zero, which can then be modified by setting it after setting forUpdate.
      Returns:
      this builder instance

    • fetchDepth

      EntityConnection.Select.Builder fetchDepth(int fetchDepth)
      Limit the levels of foreign keys to fetch
      Parameters:
      fetchDepth - the foreign key fetch depth limit
      Returns:
      this builder instance

    • fetchDepth

      EntityConnection.Select.Builder fetchDepth(ForeignKey foreignKey, int fetchDepth)
      Limit the levels of foreign keys to fetch via the given foreign key
      Parameters:
      foreignKey - the foreign key
      fetchDepth - the foreign key fetch depth limit
      Returns:
      this builder instance

    • attributes

      <T extends Attribute<?>> EntityConnection.Select.Builder attributes(T... attributes)
      Sets the attributes to include in the query result. An empty array means all attributes should be included. Note that primary key attribute values are always included.
      Type Parameters:
      T - the attribute type
      Parameters:
      attributes - the attributes to include
      Returns:
      this builder instance

    • attributes

      EntityConnection.Select.Builder attributes(Collection<? extends Attribute<?>> attributes)
      Sets the attributes to include in the query result. An empty Collection means all attributes should be included. Note that primary key attribute values are always included.
      Parameters:
      attributes - the attributes to include
      Returns:
      this builder instance

    • queryTimeout

      EntityConnection.Select.Builder queryTimeout(int queryTimeout)
      Parameters:
      queryTimeout - the query timeout, 0 for no timeout
      Returns:
      this builder instance

    • having

      EntityConnection.Select.Builder having(Condition having)
      The HAVING condition. Note that this condition must be based on aggregate function columns
      Parameters:
      having - the HAVING condition
      Returns:
      this builder instance
      See Also:

    • build

      EntityConnection.Select build()
      Returns:
      a new EntityConnection.Select instance based on this builder