io.vertx.rxjava.ext.sql.SQLOperations Maven / Gradle / Ivy
/*
* Copyright 2014 Red Hat, Inc.
*
* Red Hat licenses this file to you under the Apache License, version 2.0
* (the "License"); you may not use this file except in compliance with the
* License. You may obtain a copy of the License at:
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
* WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
* License for the specific language governing permissions and limitations
* under the License.
*/
package io.vertx.rxjava.ext.sql;
import rx.Observable;
import rx.Single;
import io.vertx.rx.java.RxHelper;
import io.vertx.rx.java.WriteStreamSubscriber;
import io.vertx.rx.java.SingleOnSubscribeAdapter;
import java.util.Map;
import java.util.Set;
import java.util.List;
import java.util.Iterator;
import java.util.function.Function;
import java.util.stream.Collectors;
import io.vertx.core.Handler;
import io.vertx.core.AsyncResult;
import io.vertx.core.json.JsonObject;
import io.vertx.core.json.JsonArray;
import io.vertx.lang.rx.RxGen;
import io.vertx.lang.rx.TypeArg;
import io.vertx.lang.rx.MappingIterator;
/**
* Represents a SQL query interface to a database
*
*
* NOTE: This class has been automatically generated from the {@link io.vertx.ext.sql.SQLOperations original} non RX-ified interface using Vert.x codegen.
*/
@RxGen(io.vertx.ext.sql.SQLOperations.class)
public interface SQLOperations {
io.vertx.ext.sql.SQLOperations getDelegate();
/**
* Executes the given SQL SELECT statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param resultHandler the handler which is called once the operation completes. It will return a ResultSet.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations query(String sql, Handler> resultHandler);
/**
* Executes the given SQL SELECT statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations query(String sql);
/**
* Executes the given SQL SELECT statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @return
*/
public Single rxQuery(String sql);
/**
* Executes the given SQL SELECT prepared statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @param resultHandler the handler which is called once the operation completes. It will return a ResultSet.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryWithParams(String sql, JsonArray params, Handler> resultHandler);
/**
* Executes the given SQL SELECT prepared statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryWithParams(String sql, JsonArray params);
/**
* Executes the given SQL SELECT prepared statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @return
*/
public Single rxQueryWithParams(String sql, JsonArray params);
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param handler the handler which is called once the operation completes. It will return a SQLRowStream.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryStream(String sql, Handler> handler);
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryStream(String sql);
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @return
*/
public Single rxQueryStream(String sql);
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @param handler the handler which is called once the operation completes. It will return a SQLRowStream.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryStreamWithParams(String sql, JsonArray params, Handler> handler);
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryStreamWithParams(String sql, JsonArray params);
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @return
*/
public Single rxQueryStreamWithParams(String sql, JsonArray params);
/**
* Execute a one shot SQL statement that returns a single SQL row. This method will reduce the boilerplate code by
* getting a connection from the pool (this object) and return it back after the execution. Only the first result
* from the result set is returned.
* @param sql the statement to execute
* @param handler the result handler
* @return self
*/
public io.vertx.rxjava.ext.sql.SQLOperations querySingle(String sql, Handler> handler);
/**
* Execute a one shot SQL statement that returns a single SQL row. This method will reduce the boilerplate code by
* getting a connection from the pool (this object) and return it back after the execution. Only the first result
* from the result set is returned.
* @param sql the statement to execute
* @return self
*/
public io.vertx.rxjava.ext.sql.SQLOperations querySingle(String sql);
/**
* Execute a one shot SQL statement that returns a single SQL row. This method will reduce the boilerplate code by
* getting a connection from the pool (this object) and return it back after the execution. Only the first result
* from the result set is returned.
* @param sql the statement to execute
* @return self
*/
public Single rxQuerySingle(String sql);
/**
* Execute a one shot SQL statement with arguments that returns a single SQL row. This method will reduce the
* boilerplate code by getting a connection from the pool (this object) and return it back after the execution.
* Only the first result from the result set is returned.
* @param sql the statement to execute
* @param arguments the arguments
* @param handler the result handler
* @return self
*/
public io.vertx.rxjava.ext.sql.SQLOperations querySingleWithParams(String sql, JsonArray arguments, Handler> handler);
/**
* Execute a one shot SQL statement with arguments that returns a single SQL row. This method will reduce the
* boilerplate code by getting a connection from the pool (this object) and return it back after the execution.
* Only the first result from the result set is returned.
* @param sql the statement to execute
* @param arguments the arguments
* @return self
*/
public io.vertx.rxjava.ext.sql.SQLOperations querySingleWithParams(String sql, JsonArray arguments);
/**
* Execute a one shot SQL statement with arguments that returns a single SQL row. This method will reduce the
* boilerplate code by getting a connection from the pool (this object) and return it back after the execution.
* Only the first result from the result set is returned.
* @param sql the statement to execute
* @param arguments the arguments
* @return self
*/
public Single rxQuerySingleWithParams(String sql, JsonArray arguments);
/**
* Executes the given SQL statement which may be an INSERT, UPDATE, or DELETE
* statement.
* @param sql the SQL to execute. For example INSERT INTO table ...
* @param resultHandler the handler which is called once the operation completes.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations update(String sql, Handler> resultHandler);
/**
* Executes the given SQL statement which may be an INSERT, UPDATE, or DELETE
* statement.
* @param sql the SQL to execute. For example INSERT INTO table ...
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations update(String sql);
/**
* Executes the given SQL statement which may be an INSERT, UPDATE, or DELETE
* statement.
* @param sql the SQL to execute. For example INSERT INTO table ...
* @return
*/
public Single rxUpdate(String sql);
/**
* Executes the given prepared statement which may be an INSERT, UPDATE, or DELETE
* statement with the given parameters
* @param sql the SQL to execute. For example INSERT INTO table ...
* @param params these are the parameters to fill the statement.
* @param resultHandler the handler which is called once the operation completes.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations updateWithParams(String sql, JsonArray params, Handler> resultHandler);
/**
* Executes the given prepared statement which may be an INSERT, UPDATE, or DELETE
* statement with the given parameters
* @param sql the SQL to execute. For example INSERT INTO table ...
* @param params these are the parameters to fill the statement.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations updateWithParams(String sql, JsonArray params);
/**
* Executes the given prepared statement which may be an INSERT, UPDATE, or DELETE
* statement with the given parameters
* @param sql the SQL to execute. For example INSERT INTO table ...
* @param params these are the parameters to fill the statement.
* @return
*/
public Single rxUpdateWithParams(String sql, JsonArray params);
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
* @param sql the SQL to execute. For example {call getEmpName}.
* @param resultHandler the handler which is called once the operation completes. It will return a ResultSet.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations call(String sql, Handler> resultHandler);
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
* @param sql the SQL to execute. For example {call getEmpName}.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations call(String sql);
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
* @param sql the SQL to execute. For example {call getEmpName}.
* @return
*/
public Single rxCall(String sql);
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
*
* The index of params and outputs are important for both arrays, for example when dealing with a prodecure that
* takes the first 2 arguments as input values and the 3 arg as an output then the arrays should be like:
*
*
* params = [VALUE1, VALUE2, null]
* outputs = [null, null, "VARCHAR"]
*
* @param sql the SQL to execute. For example {call getEmpName (?, ?)}.
* @param params these are the parameters to fill the statement.
* @param outputs these are the outputs to fill the statement.
* @param resultHandler the handler which is called once the operation completes. It will return a ResultSet.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations callWithParams(String sql, JsonArray params, JsonArray outputs, Handler> resultHandler);
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
*
* The index of params and outputs are important for both arrays, for example when dealing with a prodecure that
* takes the first 2 arguments as input values and the 3 arg as an output then the arrays should be like:
*
*
* params = [VALUE1, VALUE2, null]
* outputs = [null, null, "VARCHAR"]
*
* @param sql the SQL to execute. For example {call getEmpName (?, ?)}.
* @param params these are the parameters to fill the statement.
* @param outputs these are the outputs to fill the statement.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations callWithParams(String sql, JsonArray params, JsonArray outputs);
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
*
* The index of params and outputs are important for both arrays, for example when dealing with a prodecure that
* takes the first 2 arguments as input values and the 3 arg as an output then the arrays should be like:
*
*
* params = [VALUE1, VALUE2, null]
* outputs = [null, null, "VARCHAR"]
*
* @param sql the SQL to execute. For example {call getEmpName (?, ?)}.
* @param params these are the parameters to fill the statement.
* @param outputs these are the outputs to fill the statement.
* @return
*/
public Single rxCallWithParams(String sql, JsonArray params, JsonArray outputs);
public static SQLOperations newInstance(io.vertx.ext.sql.SQLOperations arg) {
return arg != null ? new SQLOperationsImpl(arg) : null;
}
}
class SQLOperationsImpl implements SQLOperations {
private final io.vertx.ext.sql.SQLOperations delegate;
public SQLOperationsImpl(io.vertx.ext.sql.SQLOperations delegate) {
this.delegate = delegate;
}
public SQLOperationsImpl(Object delegate) {
this.delegate = (io.vertx.ext.sql.SQLOperations)delegate;
}
public io.vertx.ext.sql.SQLOperations getDelegate() {
return delegate;
}
/**
* Executes the given SQL SELECT statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param resultHandler the handler which is called once the operation completes. It will return a ResultSet.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations query(String sql, Handler> resultHandler) {
delegate.query(sql, resultHandler);
return this;
}
/**
* Executes the given SQL SELECT statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations query(String sql) {
return
query(sql, ar -> { });
}
/**
* Executes the given SQL SELECT statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @return
*/
public Single rxQuery(String sql) {
return Single.create(new SingleOnSubscribeAdapter<>(fut -> {
query(sql, fut);
}));
}
/**
* Executes the given SQL SELECT prepared statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @param resultHandler the handler which is called once the operation completes. It will return a ResultSet.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryWithParams(String sql, JsonArray params, Handler> resultHandler) {
delegate.queryWithParams(sql, params, resultHandler);
return this;
}
/**
* Executes the given SQL SELECT prepared statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryWithParams(String sql, JsonArray params) {
return
queryWithParams(sql, params, ar -> { });
}
/**
* Executes the given SQL SELECT prepared statement which returns the results of the query.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @return
*/
public Single rxQueryWithParams(String sql, JsonArray params) {
return Single.create(new SingleOnSubscribeAdapter<>(fut -> {
queryWithParams(sql, params, fut);
}));
}
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param handler the handler which is called once the operation completes. It will return a SQLRowStream.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryStream(String sql, Handler> handler) {
delegate.queryStream(sql, new Handler>() {
public void handle(AsyncResult ar) {
if (ar.succeeded()) {
handler.handle(io.vertx.core.Future.succeededFuture(io.vertx.rxjava.ext.sql.SQLRowStream.newInstance((io.vertx.ext.sql.SQLRowStream)ar.result())));
} else {
handler.handle(io.vertx.core.Future.failedFuture(ar.cause()));
}
}
});
return this;
}
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryStream(String sql) {
return
queryStream(sql, ar -> { });
}
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @return
*/
public Single rxQueryStream(String sql) {
return Single.create(new SingleOnSubscribeAdapter<>(fut -> {
queryStream(sql, fut);
}));
}
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @param handler the handler which is called once the operation completes. It will return a SQLRowStream.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryStreamWithParams(String sql, JsonArray params, Handler> handler) {
delegate.queryStreamWithParams(sql, params, new Handler>() {
public void handle(AsyncResult ar) {
if (ar.succeeded()) {
handler.handle(io.vertx.core.Future.succeededFuture(io.vertx.rxjava.ext.sql.SQLRowStream.newInstance((io.vertx.ext.sql.SQLRowStream)ar.result())));
} else {
handler.handle(io.vertx.core.Future.failedFuture(ar.cause()));
}
}
});
return this;
}
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations queryStreamWithParams(String sql, JsonArray params) {
return
queryStreamWithParams(sql, params, ar -> { });
}
/**
* Executes the given SQL SELECT statement which returns the results of the query as a read stream.
* @param sql the SQL to execute. For example SELECT * FROM table ....
* @param params these are the parameters to fill the statement.
* @return
*/
public Single rxQueryStreamWithParams(String sql, JsonArray params) {
return Single.create(new SingleOnSubscribeAdapter<>(fut -> {
queryStreamWithParams(sql, params, fut);
}));
}
/**
* Execute a one shot SQL statement that returns a single SQL row. This method will reduce the boilerplate code by
* getting a connection from the pool (this object) and return it back after the execution. Only the first result
* from the result set is returned.
* @param sql the statement to execute
* @param handler the result handler
* @return self
*/
public io.vertx.rxjava.ext.sql.SQLOperations querySingle(String sql, Handler> handler) {
delegate.querySingle(sql, handler);
return this;
}
/**
* Execute a one shot SQL statement that returns a single SQL row. This method will reduce the boilerplate code by
* getting a connection from the pool (this object) and return it back after the execution. Only the first result
* from the result set is returned.
* @param sql the statement to execute
* @return self
*/
public io.vertx.rxjava.ext.sql.SQLOperations querySingle(String sql) {
return
querySingle(sql, ar -> { });
}
/**
* Execute a one shot SQL statement that returns a single SQL row. This method will reduce the boilerplate code by
* getting a connection from the pool (this object) and return it back after the execution. Only the first result
* from the result set is returned.
* @param sql the statement to execute
* @return self
*/
public Single rxQuerySingle(String sql) {
return Single.create(new SingleOnSubscribeAdapter<>(fut -> {
querySingle(sql, fut);
}));
}
/**
* Execute a one shot SQL statement with arguments that returns a single SQL row. This method will reduce the
* boilerplate code by getting a connection from the pool (this object) and return it back after the execution.
* Only the first result from the result set is returned.
* @param sql the statement to execute
* @param arguments the arguments
* @param handler the result handler
* @return self
*/
public io.vertx.rxjava.ext.sql.SQLOperations querySingleWithParams(String sql, JsonArray arguments, Handler> handler) {
delegate.querySingleWithParams(sql, arguments, handler);
return this;
}
/**
* Execute a one shot SQL statement with arguments that returns a single SQL row. This method will reduce the
* boilerplate code by getting a connection from the pool (this object) and return it back after the execution.
* Only the first result from the result set is returned.
* @param sql the statement to execute
* @param arguments the arguments
* @return self
*/
public io.vertx.rxjava.ext.sql.SQLOperations querySingleWithParams(String sql, JsonArray arguments) {
return
querySingleWithParams(sql, arguments, ar -> { });
}
/**
* Execute a one shot SQL statement with arguments that returns a single SQL row. This method will reduce the
* boilerplate code by getting a connection from the pool (this object) and return it back after the execution.
* Only the first result from the result set is returned.
* @param sql the statement to execute
* @param arguments the arguments
* @return self
*/
public Single rxQuerySingleWithParams(String sql, JsonArray arguments) {
return Single.create(new SingleOnSubscribeAdapter<>(fut -> {
querySingleWithParams(sql, arguments, fut);
}));
}
/**
* Executes the given SQL statement which may be an INSERT, UPDATE, or DELETE
* statement.
* @param sql the SQL to execute. For example INSERT INTO table ...
* @param resultHandler the handler which is called once the operation completes.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations update(String sql, Handler> resultHandler) {
delegate.update(sql, resultHandler);
return this;
}
/**
* Executes the given SQL statement which may be an INSERT, UPDATE, or DELETE
* statement.
* @param sql the SQL to execute. For example INSERT INTO table ...
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations update(String sql) {
return
update(sql, ar -> { });
}
/**
* Executes the given SQL statement which may be an INSERT, UPDATE, or DELETE
* statement.
* @param sql the SQL to execute. For example INSERT INTO table ...
* @return
*/
public Single rxUpdate(String sql) {
return Single.create(new SingleOnSubscribeAdapter<>(fut -> {
update(sql, fut);
}));
}
/**
* Executes the given prepared statement which may be an INSERT, UPDATE, or DELETE
* statement with the given parameters
* @param sql the SQL to execute. For example INSERT INTO table ...
* @param params these are the parameters to fill the statement.
* @param resultHandler the handler which is called once the operation completes.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations updateWithParams(String sql, JsonArray params, Handler> resultHandler) {
delegate.updateWithParams(sql, params, resultHandler);
return this;
}
/**
* Executes the given prepared statement which may be an INSERT, UPDATE, or DELETE
* statement with the given parameters
* @param sql the SQL to execute. For example INSERT INTO table ...
* @param params these are the parameters to fill the statement.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations updateWithParams(String sql, JsonArray params) {
return
updateWithParams(sql, params, ar -> { });
}
/**
* Executes the given prepared statement which may be an INSERT, UPDATE, or DELETE
* statement with the given parameters
* @param sql the SQL to execute. For example INSERT INTO table ...
* @param params these are the parameters to fill the statement.
* @return
*/
public Single rxUpdateWithParams(String sql, JsonArray params) {
return Single.create(new SingleOnSubscribeAdapter<>(fut -> {
updateWithParams(sql, params, fut);
}));
}
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
* @param sql the SQL to execute. For example {call getEmpName}.
* @param resultHandler the handler which is called once the operation completes. It will return a ResultSet.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations call(String sql, Handler> resultHandler) {
delegate.call(sql, resultHandler);
return this;
}
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
* @param sql the SQL to execute. For example {call getEmpName}.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations call(String sql) {
return
call(sql, ar -> { });
}
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
* @param sql the SQL to execute. For example {call getEmpName}.
* @return
*/
public Single rxCall(String sql) {
return Single.create(new SingleOnSubscribeAdapter<>(fut -> {
call(sql, fut);
}));
}
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
*
* The index of params and outputs are important for both arrays, for example when dealing with a prodecure that
* takes the first 2 arguments as input values and the 3 arg as an output then the arrays should be like:
*
*
* params = [VALUE1, VALUE2, null]
* outputs = [null, null, "VARCHAR"]
*
* @param sql the SQL to execute. For example {call getEmpName (?, ?)}.
* @param params these are the parameters to fill the statement.
* @param outputs these are the outputs to fill the statement.
* @param resultHandler the handler which is called once the operation completes. It will return a ResultSet.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations callWithParams(String sql, JsonArray params, JsonArray outputs, Handler> resultHandler) {
delegate.callWithParams(sql, params, outputs, resultHandler);
return this;
}
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
*
* The index of params and outputs are important for both arrays, for example when dealing with a prodecure that
* takes the first 2 arguments as input values and the 3 arg as an output then the arrays should be like:
*
*
* params = [VALUE1, VALUE2, null]
* outputs = [null, null, "VARCHAR"]
*
* @param sql the SQL to execute. For example {call getEmpName (?, ?)}.
* @param params these are the parameters to fill the statement.
* @param outputs these are the outputs to fill the statement.
* @return
*/
public io.vertx.rxjava.ext.sql.SQLOperations callWithParams(String sql, JsonArray params, JsonArray outputs) {
return
callWithParams(sql, params, outputs, ar -> { });
}
/**
* Calls the given SQL PROCEDURE which returns the result from the procedure.
*
* The index of params and outputs are important for both arrays, for example when dealing with a prodecure that
* takes the first 2 arguments as input values and the 3 arg as an output then the arrays should be like:
*
*
* params = [VALUE1, VALUE2, null]
* outputs = [null, null, "VARCHAR"]
*
* @param sql the SQL to execute. For example {call getEmpName (?, ?)}.
* @param params these are the parameters to fill the statement.
* @param outputs these are the outputs to fill the statement.
* @return
*/
public Single rxCallWithParams(String sql, JsonArray params, JsonArray outputs) {
return Single.create(new SingleOnSubscribeAdapter<>(fut -> {
callWithParams(sql, params, outputs, fut);
}));
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy