TableLike (jOOQ 3.9.6 API)

Type Parameters:

R - The record type

All Superinterfaces:

QueryPart, Serializable

All Known Subinterfaces:

CommonTableExpression<R>, Select<R>, SelectConditionStep<R>, SelectConnectByConditionStep<R>, SelectConnectByStep<R>, SelectDistinctOnStep<R>, SelectFinalStep<R>, SelectForUpdateOfStep<R>, SelectForUpdateStep<R>, SelectForUpdateWaitStep<R>, SelectFromStep<R>, SelectGroupByStep<R>, SelectHavingConditionStep<R>, SelectHavingStep<R>, SelectIntoStep<R>, SelectJoinStep<R>, SelectLimitAfterOffsetStep<R>, SelectLimitStep<R>, SelectOffsetStep<R>, SelectOnConditionStep<R>, SelectOptionalOnStep<R>, SelectOptionStep<R>, SelectOrderByStep<R>, SelectQuery<R>, SelectSeekLimitStep<R>, SelectSeekStep1<R,T1>, SelectSeekStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>, SelectSeekStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>, SelectSeekStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>, SelectSeekStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>, SelectSeekStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>, SelectSeekStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>, SelectSeekStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>, SelectSeekStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>, SelectSeekStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>, SelectSeekStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>, SelectSeekStep2<R,T1,T2>, SelectSeekStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>, SelectSeekStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>, SelectSeekStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>, SelectSeekStep3<R,T1,T2,T3>, SelectSeekStep4<R,T1,T2,T3,T4>, SelectSeekStep5<R,T1,T2,T3,T4,T5>, SelectSeekStep6<R,T1,T2,T3,T4,T5,T6>, SelectSeekStep7<R,T1,T2,T3,T4,T5,T6,T7>, SelectSeekStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>, SelectSeekStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>, SelectSeekStepN<R>, SelectSelectStep<R>, SelectStartWithStep<R>, SelectUnionStep<R>, SelectWhereStep<R>, SelectWindowStep<R>, Table<R>, TableOnConditionStep<R>, TableOptionalOnStep<R>

All Known Implementing Classes:

CustomTable, TableImpl
```
public interface TableLike<R extends Record>
extends QueryPart
```
An object that can behave like a table (a table-like object)

Author:

Lukas Eder

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and 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, java.util.function.BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)` The underlying aliased table representation of this object.
`Table<R>`	`asTable(String alias, java.util.function.Function<? super Field<?>,? extends String> aliasFunction)` The underlying aliased table representation of this object.
`Table<R>`	`asTable(String alias, String... fieldAliases)` The underlying aliased table representation of this object.
`<T> Field<T>`	`field(Field<T> field)` Get a specific field from this table.
`Field<?>`	`field(int index)` Get a specific field from this table.
`<T> Field<T>`	`field(int index, Class<T> type)` Get a specific field from this table and coerce it to `type`.
`<T> Field<T>`	`field(int index, DataType<T> dataType)` Get a specific field from this table and coerce it to `dataType`.
`Field<?>`	`field(Name name)` Get a specific field from this table.
`<T> Field<T>`	`field(Name name, Class<T> type)` Get a specific field from this table and coerce it to `type`.
`<T> Field<T>`	`field(Name name, DataType<T> dataType)` Get a specific field from this table and coerce it to `dataType`.
`Field<?>`	`field(String name)` Get a specific field from this table.
`<T> Field<T>`	`field(String name, Class<T> type)` Get a specific field from this table and coerce it to `type`.
`<T> Field<T>`	`field(String name, DataType<T> dataType)` Get a specific field from this table and coerce it to `dataType`.
`Field<?>[]`	`fields()` Get all fields from this table.
`Field<?>[]`	`fields(Field<?>... fields)` Get all fields from this table, providing some fields.
`Field<?>[]`	`fields(int... fieldIndexes)` Get all fields from this table, providing some field indexes.
`Field<?>[]`	`fields(Name... fieldNames)` Get all fields from this table, providing some field names.
`Field<?>[]`	`fields(String... fieldNames)` Get all fields from this table, providing some field names.
`Row`	`fieldsRow()` Get this table's fields as a `Row`.
`java.util.stream.Stream<Field<?>>`	`fieldStream()` Get this table's fields as a `Stream`.

Methods inherited from interface org.jooq.QueryPart
equals, hashCode, toString

- Method Detail
  - fieldsRow
```
Row fieldsRow()
```
    Get this table's fields as a Row.
  - fieldStream
```
java.util.stream.Stream<Field<?>> fieldStream()
```
    Get this table's fields as a Stream.
  - field
```
<T> Field<T> field(Field<T> field)
```
    Get a specific field from this table.
    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.
    
    See Also:
    
    Row.field(String)
  - field
```
<T> Field<T> field(String name,
                   Class<T> type)
```
    Get a specific field from this table and coerce it to type.
    
    See Also:
    
    Row.field(String, Class)
  - field
```
<T> Field<T> field(String name,
                   DataType<T> dataType)
```
    Get a specific field from this table and coerce it to dataType.
    
    See Also:
    
    Row.field(String, DataType)
  - field
```
Field<?> field(Name name)
```
    Get a specific field from this table.
    
    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.
    
    See Also:
    
    Row.field(Name, Class)
  - field
```
<T> Field<T> field(Name name,
                   DataType<T> dataType)
```
    Get a specific field from this table and coerce it to dataType.
    
    See Also:
    
    Row.field(Name, DataType)
  - field
```
Field<?> field(int index)
```
    Get a specific field from this table.
    
    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.
    
    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.
    
    See Also:
    
    Row.field(int, DataType)
  - fields
```
Field<?>[] fields()
```
    Get all fields from this table.
    
    See Also:
    
    Row.fields()
  - fields
```
Field<?>[] fields(Field<?>... fields)
```
    Get all fields from this table, providing some fields.
    
    Returns:
    
    All available fields
    
    See Also:
    
    Row.fields(Field...)
  - fields
```
Field<?>[] fields(String... fieldNames)
```
    Get all fields from this table, providing some field names.
    
    Returns:
    
    All available fields
    
    See Also:
    
    Row.fields(String...)
  - fields
```
Field<?>[] fields(Name... fieldNames)
```
    Get all fields from this table, providing some field names.
    
    Returns:
    
    All available fields
    
    See Also:
    
    Row.fields(Name...)
  - fields
```
Field<?>[] fields(int... fieldIndexes)
```
    Get all fields from this table, providing some field indexes.
    
    Returns:
    
    All available fields
    
    See Also:
    
    Row.fields(int...)
  - 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 ...
  - asTable
```
@Support
Table<R> asTable(String alias)
```
    The underlying aliased table representation of this object.
    
    See Also:
    
    Table.as(String)
  - asTable
```
@Support
Table<R> asTable(String alias,
                           String... fieldAliases)
```
    The underlying aliased table representation of this object.
    
    See Also:
    
    Table.as(String, String...)
  - asTable
```
@Support
Table<R> asTable(String alias,
                           java.util.function.Function<? super Field<?>,? extends String> aliasFunction)
```
    The underlying aliased table representation of this object.
    
    See Also:
    
    Table.as(String, Function)
  - asTable
```
@Support
Table<R> asTable(String alias,
                           java.util.function.BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)
```
    The underlying aliased table representation of this object.
    
    See Also:
    
    Table.as(String, BiFunction)

Interface TableLike<R extends Record>

Method Summary

Methods inherited from interface org.jooq.QueryPart

Method Detail

fieldsRow

fieldStream

field

field

field

field

field

field

field

field

field

field

fields

fields

fields

fields

fields

asTable

asTable

asTable

asTable

asTable