Module org.jooq
Package org.jooq

Interface TableLike<R extends Record>

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      Table<R> asTable()
      The underlying table representation of this object.
      Table<R> asTable​(String alias)
      The underlying aliased table representation of this object.
      Table<R> asTable​(String alias, String... fieldAliases)
      The underlying aliased table representation of this object.
      Table<R> asTable​(String alias, BiFunction<? super Field<?>,​? super Integer,​? extends String> aliasFunction)
      The underlying aliased table representation of this object.
      Table<R> asTable​(String alias, Function<? super Field<?>,​? extends String> aliasFunction)
      The underlying aliased table representation of this object.
      Field<?> field​(int index)
      Get a specific field from this table, if this table knows its field references.
      <T> Field<T> field​(int index, Class<T> type)
      Get a specific field from this table and coerce it to type, if this table knows its field references.
      <T> Field<T> field​(int index, DataType<T> dataType)
      Get a specific field from this table and coerce it to dataType, if this table knows its field references.
      Field<?> field​(String name)
      Get a specific field from this table, if this table knows its field references.
      <T> Field<T> field​(String name, Class<T> type)
      Get a specific field from this table and coerce it to type, if this table knows its field references.
      <T> Field<T> field​(String name, DataType<T> dataType)
      Get a specific field from this table and coerce it to dataType, if this table knows its field references.
      <T> Field<T> field​(Field<T> field)
      Get a specific field from this table, if this table knows its field references.
      Field<?> field​(Name name)
      Get a specific field from this table, if this table knows its field references.
      <T> Field<T> field​(Name name, Class<T> type)
      Get a specific field from this table and coerce it to type, if this table knows its field references.
      <T> Field<T> field​(Name name, DataType<T> dataType)
      Get a specific field from this table and coerce it to dataType, if this table knows its field references.
      Field<?>[] fields()
      Get all fields from this table, if this table knows its field references, or an empty array otherwise.
      Field<?>[] fields​(int... fieldIndexes)
      Get all fields from this table, providing some field indexes, if this table knows its field references.
      Field<?>[] fields​(String... fieldNames)
      Get all fields from this table, providing some field names, if this table knows its field references.
      Field<?>[] fields​(Field<?>... fields)
      Get all fields from this table, providing some fields, if this table knows its field references.
      Field<?>[] fields​(Name... fieldNames)
      Get all fields from this table, providing some field names, if this table knows its field references.
      Row fieldsRow()
      Get this table's fields as a Row, if this table knows its field references.
      Stream<Field<?>> fieldStream()
      Get this table's fields as a Stream, if this table knows its field references.
      int indexOf​(String fieldName)
      Get a field's index from this table.
      int indexOf​(Field<?> field)
      Get a field's index from this table.
      int indexOf​(Name fieldName)
      Get a field's index from this table.
    • Method Detail

      • fieldsRow

        Row fieldsRow()
        Get this table's fields as a Row, if this table knows its field references.
      • fieldStream

        Stream<Field<?>> fieldStream()
        Get this table's fields as a Stream, if this table knows its field references.
      • field

        <T> Field<T> field​(Field<T> field)
        Get a specific field from this table, if this table knows its field references.

        This will return:

        • A field that is the same as the argument field (by identity comparison).
        • A field that is equal to the argument field (exact matching fully qualified name).
        • A field that is equal to the argument field (partially matching qualified name).
        • A field whose name is equal to the name of the argument field.
        • null otherwise.
        If several fields have the same name, the first one is returned and a warning is logged.
        See Also:
        Row.field(Field)
      • field

        Field<?> field​(String name)
        Get a specific field from this table, if this table knows its field references.
        See Also:
        Row.field(String)
      • field

        Field<?> field​(Name name)
        Get a specific field from this table, if this table knows its field references.
        See Also:
        Row.field(Name)
      • field

        <T> Field<T> field​(Name name,
                           Class<T> type)
        Get a specific field from this table and coerce it to type, if this table knows its field references.
        See Also:
        Row.field(Name, Class)
      • field

        Field<?> field​(int index)
        Get a specific field from this table, if this table knows its field references.
        See Also:
        Row.field(int)
      • field

        <T> Field<T> field​(int index,
                           Class<T> type)
        Get a specific field from this table and coerce it to type, if this table knows its field references.
        See Also:
        Row.field(int, Class)
      • field

        <T> Field<T> field​(int index,
                           DataType<T> dataType)
        Get a specific field from this table and coerce it to dataType, if this table knows its field references.
        See Also:
        Row.field(int, DataType)
      • fields

        Field<?>[] fields()
        Get all fields from this table, if this table knows its field references, or an empty array otherwise.
        See Also:
        Row.fields()
      • fields

        Field<?>[] fields​(Field<?>... fields)
        Get all fields from this table, providing some fields, if this table knows its field references.
        Returns:
        All available fields
        See Also:
        Row.fields(Field...)
      • fields

        Field<?>[] fields​(String... fieldNames)
        Get all fields from this table, providing some field names, if this table knows its field references.
        Returns:
        All available fields
        See Also:
        Row.fields(String...)
      • fields

        Field<?>[] fields​(Name... fieldNames)
        Get all fields from this table, providing some field names, if this table knows its field references.
        Returns:
        All available fields
        See Also:
        Row.fields(Name...)
      • fields

        Field<?>[] fields​(int... fieldIndexes)
        Get all fields from this table, providing some field indexes, if this table knows its field references.
        Returns:
        All available fields
        See Also:
        Row.fields(int...)
      • indexOf

        int indexOf​(Field<?> field)
        Get a field's index from this table.
        Parameters:
        field - The field to look for
        Returns:
        The field's index or -1 if the field is not contained in this table.
      • indexOf

        int indexOf​(String fieldName)
        Get a field's index from this table.
        Parameters:
        fieldName - The field name to look for
        Returns:
        The field's index or -1 if the field is not contained in this table.
      • indexOf

        int indexOf​(Name fieldName)
        Get a field's index from this table.
        Parameters:
        fieldName - The field name to look for
        Returns:
        The field's index or -1 if the field is not contained in this table
      • asTable

        @Support
        Table<R> asTable()
        The underlying table representation of this object.

        This method is useful for things like SELECT * FROM (SELECT * FROM x WHERE x.a = '1') WHERE ...