Package io.vertx.reactivex.sqlclient.templates

Class SqlTemplate<I,​R>

  • public class SqlTemplate<I,​R>
extends Object
    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 Detail

      • __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 Detail

      • 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 Detail

      • hashCode

        public int hashCode()
        Overrides:
        hashCode in class Object

      • 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

      • 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 Map 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

      • 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,
                                                             io.vertx.lang.rx.TypeArg<I> __typeArg_I,
                                                             io.vertx.lang.rx.TypeArg<R> __typeArg_R)