Package io.github.zero88.jooqx

Interface DSLAdapter

public interface DSLAdapter
DSL adapter
Since:
1.0.0

  • Method Summary

    Static Methods
    Modifier and Type
    Method
    Description
    static SelectCount
    fetchCount()
    Fetch count
    static SelectCount
    fetchCount(@NotNull org.jooq.TableLike<org.jooq.Record1<Integer>> table)
    Fetch count
    static SelectExists
    fetchExists()
    Fetch exists
    static SelectExists
    fetchExists(@NotNull org.jooq.TableLike<org.jooq.Record1<Integer>> table)
    Fetch exists
    static SelectJsonArray
    fetchJsonArray(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table)
    Fetch result by a table of the query context then map into json array
    static SelectJsonArray
    fetchJsonArray(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table, io.vertx.core.spi.json.JsonCodec codec)
    Fetch result by a table of the query context then map into json array
    static SelectOne<io.vertx.core.json.JsonObject>
    fetchJsonObject(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table)
    Fetch one row to json object
    static SelectOne<io.vertx.core.json.JsonObject>
    fetchJsonObject(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table, io.vertx.core.spi.json.JsonCodec codec)
    Fetch one row to json object
    static <REC extends org.jooq.Record>
    SelectOne<JsonRecord<REC>>
    fetchJsonRecord(@NotNull org.jooq.TableLike<REC> table)
    Fetch one row to JsonRecord
    static <REC extends org.jooq.Record>
    SelectList<JsonRecord<REC>>
    fetchJsonRecords(@NotNull org.jooq.TableLike<REC> table)
    Fetch many Json record
    static <R> SelectList<R>
    fetchMany(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull Class<R> outputClass)
    Fetch many records by a table of the query context then map to custom type by given output class
    static SelectList<org.jooq.Record>
    fetchMany(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull Collection<org.jooq.Field<?>> fields)
    Fetch many by a table of the query context then map into target fields
    static <REC extends org.jooq.Record>
    SelectList<REC>
    fetchMany(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table, REC record)
    Fetch many by a table of the query context then map to another record type
    static <R extends org.jooq.Record, T extends org.jooq.Table<R>>
    SelectList<R>
    fetchMany(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table, T toTable)
    Fetch many by a table of the query context then map into target record that defines in target table
    static SelectList<org.jooq.Record>
    fetchMany(org.jooq.Field<?>... fields)
    Fetch many records by fields
    static <REC extends org.jooq.Record>
    SelectList<REC>
    fetchMany(REC record)
    Fetch many records by the record definition
    static <T extends org.jooq.Table<REC>, REC extends org.jooq.Record>
    SelectList<REC>
    fetchMany(T table)
    Fetch many
    static <R> SelectOne<R>
    fetchOne(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull Class<R> outputClass)
    Fetch one record by a table of the query context then map to custom type by given output class
    static SelectOne<org.jooq.Record>
    fetchOne(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull Collection<org.jooq.Field<?>> fields)
    Fetch one record by a table of the query context then map into target fields
    static <REC extends org.jooq.Record>
    SelectOne<REC>
    fetchOne(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table, REC record)
    Fetch one record by a table of the query context then map to another record type
    static <R extends org.jooq.Record, T extends org.jooq.Table<R>>
    SelectOne<R>
    fetchOne(@NotNull org.jooq.TableLike<? extends org.jooq.Record> table, T toTable)
    Fetch one record by a table of the query context then map into target record that defines in target table
    static SelectOne<org.jooq.Record>
    fetchOne(org.jooq.Field<?>... fields)
    Fetch one record by fields
    static <REC extends org.jooq.Record>
    SelectOne<REC>
    fetchOne(REC record)
    Fetch one record by the record definition
    static <T extends org.jooq.Table<REC>, REC extends org.jooq.Record>
    SelectOne<REC>
    fetchOne(T table)
    Fetch one

  • Method Details

    • fetchCount

      static SelectCount fetchCount()
      Fetch count
      Returns:
      select count
      Since:
      2.0.0
      See Also:

    • fetchCount

      static SelectCount fetchCount(@NotNull @NotNull org.jooq.TableLike<org.jooq.Record1<Integer>> table)
      Fetch count
      Parameters:
      table - a query table context
      Returns:
      select count
      Since:
      1.0.0
      See Also:

    • fetchExists

      static SelectExists fetchExists()
      Fetch exists
      Returns:
      select exists
      Since:
      2.0.0
      See Also:

    • fetchExists

      static SelectExists fetchExists(@NotNull @NotNull org.jooq.TableLike<org.jooq.Record1<Integer>> table)
      Fetch exists
      Parameters:
      table - a query table context
      Returns:
      select exists
      Since:
      1.0.0
      See Also:

    • fetchJsonRecord

      static <REC extends org.jooq.Record> SelectOne<JsonRecord<REC>> fetchJsonRecord(@NotNull @NotNull org.jooq.TableLike<REC> table)
      Fetch one row to JsonRecord
      Parameters:
      table - a query table context
      Returns:
      select one adapter
      Since:
      1.0.0
      See Also:

    • fetchJsonObject

      static SelectOne<io.vertx.core.json.JsonObject> fetchJsonObject(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table)
      Fetch one row to json object
      Parameters:
      table - a query table context
      Returns:
      select json object adapter
      Since:
      2.0.0

    • fetchJsonObject

      static SelectOne<io.vertx.core.json.JsonObject> fetchJsonObject(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table, io.vertx.core.spi.json.JsonCodec codec)
      Fetch one row to json object
      Parameters:
      table - a query table context
      codec - a Json codec
      Returns:
      select json object adapter
      Since:
      2.0.0
      See Also:
      • JsonCodec

    • fetchOne

      static <T extends org.jooq.Table<REC>, REC extends org.jooq.Record> SelectOne<REC> fetchOne(@NotNull T table)
      Fetch one
      Type Parameters:
      T - Type of jOOQ Table in Query context
      Parameters:
      table - a query table context
      Returns:
      select one adapter
      Since:
      1.0.0
      See Also:
      • TableLike

    • fetchOne

      static <REC extends org.jooq.Record> SelectOne<REC> fetchOne(@NotNull REC record)
      Fetch one record by the record definition
      Type Parameters:
      REC - Type of output jOOQ record
      Parameters:
      record - record
      Returns:
      select one adapter
      Since:
      2.0.0
      See Also:
      • Record

    • fetchOne

      static <REC extends org.jooq.Record> SelectOne<REC> fetchOne(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull REC record)
      Fetch one record by a table of the query context then map to another record type
      Type Parameters:
      REC - Type of output jOOQ record
      Parameters:
      table - a query table context
      record - record
      Returns:
      select one adapter
      Since:
      1.0.0
      See Also:
      • TableLike
      • Record

    • fetchOne

      static SelectOne<org.jooq.Record> fetchOne(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull @NotNull Collection<org.jooq.Field<?>> fields)
      Fetch one record by a table of the query context then map into target fields
      Parameters:
      table - a query table context
      fields - a given target fields
      Returns:
      select one adapter
      Since:
      1.0.0
      See Also:
      • TableLike
      • Field

    • fetchOne

      static SelectOne<org.jooq.Record> fetchOne(org.jooq.Field<?>... fields)
      Fetch one record by fields
      Parameters:
      fields - given fields
      Returns:
      select one adapter
      Since:
      2.0.0
      See Also:
      • Field

    • fetchOne

      static <R> SelectOne<R> fetchOne(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull @NotNull Class<R> outputClass)
      Fetch one record by a table of the query context then map to custom type by given output class
      Type Parameters:
      R - Type ot output class
      Parameters:
      table - a query table context
      outputClass - given output class
      Returns:
      select one adapter
      Since:
      1.0.0
      See Also:
      • TableLike
      • Record

    • fetchOne

      static <R extends org.jooq.Record, T extends org.jooq.Table<R>> SelectOne<R> fetchOne(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull T toTable)
      Fetch one record by a table of the query context then map into target record that defines in target table
      Type Parameters:
      R - Type of expectation record
      T - Type of expectation table
      Parameters:
      table - a query table context
      toTable - a target table
      Returns:
      select one adapter
      Since:
      1.0.0
      See Also:
      • TableLike

    • fetchJsonRecords

      static <REC extends org.jooq.Record> SelectList<JsonRecord<REC>> fetchJsonRecords(@NotNull @NotNull org.jooq.TableLike<REC> table)
      Fetch many Json record
      Parameters:
      table - a query table context
      Returns:
      select many adapter
      Since:
      1.0.0
      See Also:

    • fetchMany

      static <T extends org.jooq.Table<REC>, REC extends org.jooq.Record> SelectList<REC> fetchMany(@NotNull T table)
      Fetch many
      Type Parameters:
      T - Type of jOOQ Table in Query context
      Parameters:
      table - a query table context
      Returns:
      select many adapter
      Since:
      1.0.0
      See Also:
      • TableLike
      • Record

    • fetchMany

      static <REC extends org.jooq.Record> SelectList<REC> fetchMany(@NotNull REC record)
      Fetch many records by the record definition
      Type Parameters:
      REC - Type of record
      Parameters:
      record - record
      Returns:
      select many adapter
      Since:
      2.0.0
      See Also:
      • Record

    • fetchMany

      static <REC extends org.jooq.Record> SelectList<REC> fetchMany(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull REC record)
      Fetch many by a table of the query context then map to another record type
      Type Parameters:
      REC - Type of record
      Parameters:
      table - a query table context
      record - record
      Returns:
      select many adapter
      Since:
      1.0.0
      See Also:
      • TableLike
      • Record

    • fetchMany

      static SelectList<org.jooq.Record> fetchMany(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull @NotNull Collection<org.jooq.Field<?>> fields)
      Fetch many by a table of the query context then map into target fields
      Parameters:
      table - a query table context
      fields - given fields
      Returns:
      select many adapter
      Since:
      1.0.0
      See Also:
      • TableLike

    • fetchMany

      static SelectList<org.jooq.Record> fetchMany(org.jooq.Field<?>... fields)
      Fetch many records by fields
      Parameters:
      fields - the given fields
      Returns:
      select many adapter
      Since:
      2.0.0
      See Also:
      • Field

    • fetchMany

      static <R> SelectList<R> fetchMany(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull @NotNull Class<R> outputClass)
      Fetch many records by a table of the query context then map to custom type by given output class
      Type Parameters:
      R - Type ot output class
      Parameters:
      table - a query table context
      outputClass - a given output class
      Returns:
      select many adapter
      Since:
      1.0.0
      See Also:
      • TableLike

    • fetchMany

      static <R extends org.jooq.Record, T extends org.jooq.Table<R>> SelectList<R> fetchMany(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table, @NotNull T toTable)
      Fetch many by a table of the query context then map into target record that defines in target table
      Type Parameters:
      R - Type of record
      T - Type of expectation table
      Parameters:
      table - a query table context
      toTable - a target table
      Returns:
      select many adapter
      Since:
      1.0.0
      See Also:
      • TableLike
      • Record

    • fetchJsonArray

      static SelectJsonArray fetchJsonArray(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table)
      Fetch result by a table of the query context then map into json array
      Parameters:
      table - a query table context
      Returns:
      select json array adapter
      Since:
      2.0.0
      See Also:

    • fetchJsonArray

      static SelectJsonArray fetchJsonArray(@NotNull @NotNull org.jooq.TableLike<? extends org.jooq.Record> table, io.vertx.core.spi.json.JsonCodec codec)
      Fetch result by a table of the query context then map into json array
      Parameters:
      table - a query table context
      codec - a Json codec
      Returns:
      select json array adapter
      Since:
      2.0.0
      See Also: