Class SqlTemplate<I,R>

java.lang.Object
io.vertx.reactivex.sqlclient.templates.SqlTemplate<I,R>
All Implemented Interfaces:
io.vertx.lang.rx.RxDelegate
public class SqlTemplate<I,R> extends Object implements io.vertx.lang.rx.RxDelegate
An SQL template.

SQL templates are useful for interacting with a relational database.

SQL templates execute queries using named instead of positional parameters. Query execution is parameterized by a map of string to objects instead of a Tuple. The default source of parameters is a simple map, a user defined mapping can be used instead given it maps the source to such a map.

SQL template default results are , a user defined mapping can be used instead, mapping the result set to a of the mapped type.

NOTE: This class has been automatically generated from the original non RX-ified interface using Vert.x codegen.

  • Field Details

    • __TYPE_ARG

      public static final io.vertx.lang.rx.TypeArg<SqlTemplate> __TYPE_ARG

    • __typeArg_0

      public final io.vertx.lang.rx.TypeArg<I> __typeArg_0

    • __typeArg_1

      public final io.vertx.lang.rx.TypeArg<R> __typeArg_1

  • Constructor Details

    • SqlTemplate

      public SqlTemplate(SqlTemplate delegate)

    • SqlTemplate

      public SqlTemplate(Object delegate, io.vertx.lang.rx.TypeArg<I> typeArg_0, io.vertx.lang.rx.TypeArg<R> typeArg_1)

  • Method Details

    • toString

      public String toString()
      Overrides:
      toString in class Object

    • equals

      public boolean equals(Object o)
      Overrides:
      equals in class Object

    • hashCode

      public int hashCode()
      Overrides:
      hashCode in class Object

    • getDelegate

      public SqlTemplate getDelegate()
      Specified by:
      getDelegate in interface io.vertx.lang.rx.RxDelegate

    • forQuery

      public static SqlTemplate<Map<String,Object>, RowSet<Row>> forQuery(SqlClient client, String template)
      Create an SQL template for query purpose consuming map parameters and returning .
      Parameters:
      client - the wrapped SQL client
      template - the template query string
      Returns:
      the template

    • forUpdate

      public static SqlTemplate<Map<String,Object>, SqlResult<Void>> forUpdate(SqlClient client, String template)
      Create an SQL template for query purpose consuming map parameters and returning void.
      Parameters:
      client - the wrapped SQL client
      template - the template update string
      Returns:
      the template

    • sql

      public String sql()
      Returns:
      the computed SQL for this template

    • mapFrom

      public <T> SqlTemplate<T,R> mapFrom(TupleMapper<T> mapper)
      Set a parameters user defined mapping function.

      At query execution, the mapper is called to map the parameters object to a Tuple that configures the prepared query.

      Parameters:
      mapper - the mapping function
      Returns:
      a new template

    • mapFrom

      public <T> SqlTemplate<T,R> mapFrom(Class<T> type)
      Set a parameters user defined class mapping.

      At query execution, the parameters object is is mapped to a Mapinvalid input: '<'String, Object> that configures the prepared query.

      This feature relies on JsonObject feature. This likely requires to use Jackson databind in the project.

      Parameters:
      type - the mapping type
      Returns:
      a new template

    • mapTo

      public <U> SqlTemplate<I, RowSet<U>> mapTo(RowMapper<U> mapper)
      Set a row user defined mapping function.

      When the query execution completes, the mapper function is called to map the resulting rows to objects.

      Parameters:
      mapper - the mapping function
      Returns:
      a new template

    • mapTo

      public <U> SqlTemplate<I, RowSet<U>> mapTo(Class<U> type)
      Set a row user defined mapping function.

      When the query execution completes, resulting rows are mapped to type instances.

      This feature relies on JsonObject feature. This likely requires to use Jackson databind in the project.

      Parameters:
      type - the mapping type
      Returns:
      a new template

    • withClient

      public SqlTemplate<I,R> withClient(SqlClient client)
      Returns a new template, using the specified client.

      This method does not compute the template query again, so it can be useful to execute a template on a specific SqlConnection. For example, after starting a transaction: 

        // Typically stored as a verticle field
  // So that heavy computation of the template happens once
  SqlTemplateinvalid input: '<'Mapinvalid input: '<'String, Object>, RowSet> template = SqlTemplate
    .forQuery(pool, "SELECT id, randomnumber FROM tmp_world")
    .mapTo(World.class);

  // Executing the template inside a transaction
  Futureinvalid input: '<'RowSet> future = pool.withTransaction(conn -> template.withClient(conn).execute(Map.of()));
      Parameters:
      client - the client that will execute requests
      Returns:
      a new template

    • execute

      public Future<R> execute(I params)
      Execute the query with the parameters
      Parameters:
      params - the query parameters
      Returns:
      a future notified with the result

    • rxExecute

      public Single<R> rxExecute(I params)
      Execute the query with the parameters
      Parameters:
      params - the query parameters
      Returns:
      a future notified with the result

    • executeBatch

      public Future<R> executeBatch(List<I> batch)
      Execute a batch query with the batch.

      Each item in the batch is mapped to a tuple.

      Parameters:
      batch - the batch
      Returns:
      a future notified with the result

    • rxExecuteBatch

      public Single<R> rxExecuteBatch(List<I> batch)
      Execute a batch query with the batch.

      Each item in the batch is mapped to a tuple.

      Parameters:
      batch - the batch
      Returns:
      a future notified with the result

    • newInstance

      public static <I,R> SqlTemplate<I,R> newInstance(SqlTemplate arg)

    • newInstance

      public static <I,R> SqlTemplate<I,R> newInstance(SqlTemplate arg, io.vertx.lang.rx.TypeArg<I> __typeArg_I, io.vertx.lang.rx.TypeArg<R> __typeArg_R)