/** * 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<AsyncResult<JsonArray>> 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 * @param handler the result handler * @return self */ public io.vertx.rxjava.ext.sql.SQLOperations querySingle(String sql, Handler<AsyncResult<JsonArray>> handler) { delegate.querySingle(sql, handler); return this; }
public static io.vertx.ext.sql.SQLOperations querySingle(io.vertx.ext.sql.SQLClient j_receiver, java.lang.String sql, io.vertx.core.Handler<io.vertx.core.AsyncResult<java.util.List<Object>>> handler) { io.vertx.core.impl.ConversionHelper.fromObject(j_receiver.querySingle(sql, handler != null ? new io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.core.json.JsonArray>>() { public void handle(io.vertx.core.AsyncResult<io.vertx.core.json.JsonArray> ar) { handler.handle(ar.map(event -> io.vertx.core.impl.ConversionHelper.fromJsonArray(event))); } } : null)); return j_receiver; } public static io.vertx.ext.sql.SQLOperations querySingleWithParams(io.vertx.ext.sql.SQLClient j_receiver, java.lang.String sql, java.util.List<Object> arguments, io.vertx.core.Handler<io.vertx.core.AsyncResult<java.util.List<Object>>> handler) {
@Test public void testSelectOneShotSingle() { String sql = "SELECT ID, FNAME, LNAME FROM select_table WHERE ID = 2"; client.querySingle(sql, query -> { assertFalse(query.failed()); final JsonArray row = query.result(); assertNotNull(row); assertEquals(2, (int) row.getInteger(0)); assertEquals("jane", row.getString(1)); assertEquals("doe", row.getString(2)); testComplete(); }); await(); }