/** * Execute a single SQL statement, this method acquires a connection from the the pool and executes the SQL * statement and returns it back after the execution. * @param sql the statement to execute * @param handler the result handler * @return self */ public io.vertx.rxjava.ext.sql.SQLClient query(String sql, Handler<AsyncResult<ResultSet>> handler) { delegate.query(sql, handler); return this; }
/** * Execute a single SQL statement, this method acquires a connection from the the pool and executes the SQL * statement and returns it back after the execution. * @param sql the statement to execute * @param handler the result handler * @return self */ public io.vertx.rxjava.ext.sql.SQLClient query(String sql, Handler<AsyncResult<ResultSet>> handler) { delegate.query(sql, handler); return this; }
public static io.vertx.ext.sql.SQLClient query(io.vertx.ext.sql.SQLClient j_receiver, java.lang.String sql, io.vertx.core.Handler<io.vertx.core.AsyncResult<java.util.Map<String, Object>>> handler) { io.vertx.core.impl.ConversionHelper.fromObject(j_receiver.query(sql, handler != null ? new io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.ext.sql.ResultSet>>() { public void handle(io.vertx.core.AsyncResult<io.vertx.ext.sql.ResultSet> ar) { handler.handle(ar.map(event -> event != null ? io.vertx.core.impl.ConversionHelper.fromJsonObject(event.toJson()) : null)); } } : null)); return j_receiver; } public static io.vertx.ext.sql.SQLClient queryStreamWithParams(io.vertx.ext.sql.SQLClient j_receiver, java.lang.String sql, java.util.List<Object> params, io.vertx.core.Handler<io.vertx.core.AsyncResult<io.vertx.ext.sql.SQLRowStream>> handler) {
@Test public void testSelectOneShotFail() { String sql = "SELECTA ID, FNAME, LNAME FROM select_table ORDER BY ID"; client.query(sql, query -> { assertTrue(query.failed()); testComplete(); }); await(); }
@Test public void testSelectOneContext() { Context context = vertx.getOrCreateContext(); context.runOnContext(v -> { client.query("VALUES (CURRENT_TIMESTAMP)", onSuccess(query -> { assertEquals(context, vertx.getOrCreateContext()); testComplete(); })); }); await(); }
@Test public void testSelectOneShot() { String sql = "SELECT ID, FNAME, LNAME FROM select_table ORDER BY ID"; client.query(sql, query -> { assertFalse(query.failed()); final ResultSet resultSet = query.result(); assertNotNull(resultSet); assertEquals(2, resultSet.getResults().size()); assertEquals("ID", resultSet.getColumnNames().get(0)); assertEquals("FNAME", resultSet.getColumnNames().get(1)); assertEquals("LNAME", resultSet.getColumnNames().get(2)); JsonArray result0 = resultSet.getResults().get(0); assertEquals(1, (int) result0.getInteger(0)); assertEquals("john", result0.getString(1)); assertEquals("doe", result0.getString(2)); JsonArray result1 = resultSet.getResults().get(1); assertEquals(2, (int) result1.getInteger(0)); assertEquals("jane", result1.getString(1)); assertEquals("doe", result1.getString(2)); testComplete(); }); await(); }