Examples with RowSet io.vertx.sqlclient.RowSet used on opensource projects

Example 11 with RowSet

use of io.vertx.sqlclient.RowSet in project raml-module-builder by folio-org.

the class PostgresClientIT method updateWithCriterion.

@Test
public void updateWithCriterion(TestContext context) {
    Criterion criterion = new Criterion().addCriterion(new Criteria().addField("'key'").setOperation("=").setVal("x"));
    createFoo(context).save(FOO, xPojo, context.asyncAssertSuccess(save -> {
        postgresClient.update(FOO, singleQuotePojo, criterion, true, context.asyncAssertSuccess(rowSet -> {
            assertThat(rowSet.rowCount(), is(1));
            postgresClient.update(FOO, xPojo, criterion, true, context.asyncAssertSuccess(rowSet2 -> {
                assertThat(rowSet2.rowCount(), is(0));
            }));
        }));
    }));
}

Example 12 with RowSet

use of io.vertx.sqlclient.RowSet in project raml-module-builder by folio-org.

the class PostgresClientIT method updateWithWhereClause.

@Test
public void updateWithWhereClause(TestContext context) {
    String where = "WHERE jsonb->>'key'='x'";
    createFoo(context).save(FOO, xPojo, context.asyncAssertSuccess(save -> {
        postgresClient.update(FOO, singleQuotePojo, "jsonb", where, true, context.asyncAssertSuccess(rowSet -> {
            assertThat(rowSet.rowCount(), is(1));
            postgresClient.update(FOO, xPojo, "jsonb", where, true, context.asyncAssertSuccess(rowSet2 -> {
                assertThat(rowSet2.rowCount(), is(0));
            }));
        }));
    }));
}

Example 13 with RowSet

use of io.vertx.sqlclient.RowSet in project raml-module-builder by folio-org.

the class PostgresClientIT method selectReturnEmptySet.

@Test
public void selectReturnEmptySet(TestContext context) {
    RowSet rowSet = new LocalRowSet(0);
    Promise<RowSet<Row>> promise = Promise.promise();
    promise.complete(rowSet);
    PostgresClient.selectReturn(promise.future(), context.asyncAssertSuccess(res -> context.assertEquals(null, res)));
}

Example 14 with RowSet

use of io.vertx.sqlclient.RowSet in project raml-module-builder by folio-org.

the class PostgresClientIT method postgresClientQueryFails.

/**
 * @return a PostgresClient where invoking SQLConnection::update, SQLConnection::updateWithParams or
 * SQLConnection::queryWithParams will report a failure via the resultHandler.
 */
private PostgresClient postgresClientQueryFails() {
    PgConnection pgConnection = new PgConnection() {

        @Override
        public PgConnection notificationHandler(Handler<PgNotification> handler) {
            return this;
        }

        @Override
        public PgConnection cancelRequest(Handler<AsyncResult<Void>> handler) {
            handler.handle(Future.failedFuture("cancelRequestFails"));
            return this;
        }

        @Override
        public int processId() {
            return 0;
        }

        @Override
        public int secretKey() {
            return 0;
        }

        @Override
        public PgConnection prepare(String s, Handler<AsyncResult<PreparedStatement>> handler) {
            prepare(s).onComplete(handler);
            return null;
        }

        @Override
        public Future<PreparedStatement> prepare(String s) {
            return Future.failedFuture("preparedFails");
        }

        @Override
        public SqlConnection prepare(String sql, PrepareOptions options, Handler<AsyncResult<PreparedStatement>> handler) {
            prepare(sql, options).onComplete(handler);
            return null;
        }

        @Override
        public Future<PreparedStatement> prepare(String sql, PrepareOptions options) {
            return prepare(sql);
        }

        @Override
        public PgConnection exceptionHandler(Handler<Throwable> handler) {
            return null;
        }

        @Override
        public PgConnection closeHandler(Handler<Void> handler) {
            return null;
        }

        @Override
        public void begin(Handler<AsyncResult<Transaction>> handler) {
        }

        @Override
        public Future<Transaction> begin() {
            return null;
        }

        @Override
        public boolean isSSL() {
            return false;
        }

        @Override
        public void close(Handler<AsyncResult<Void>> handler) {
        }

        @Override
        public Query<RowSet<Row>> query(String s) {
            return new Query<RowSet<Row>>() {

                @Override
                public void execute(Handler<AsyncResult<RowSet<Row>>> handler) {
                    handler.handle(execute());
                }

                @Override
                public Future<RowSet<Row>> execute() {
                    return Future.failedFuture("queryFails");
                }

                @Override
                public <R> Query<SqlResult<R>> collecting(Collector<Row, ?, R> collector) {
                    return null;
                }

                @Override
                public <U> Query<RowSet<U>> mapping(Function<Row, U> function) {
                    return null;
                }
            };
        }

        @Override
        public PreparedQuery<RowSet<Row>> preparedQuery(String sql, PrepareOptions options) {
            return preparedQuery(sql);
        }

        @Override
        public PreparedQuery<RowSet<Row>> preparedQuery(String s) {
            throw new RuntimeException("queryFails");
        }

        @Override
        public Future<Void> close() {
            return null;
        }

        @Override
        public DatabaseMetadata databaseMetadata() {
            return null;
        }
    };
    PgPool client = new PgPoolBase() {

        @Override
        public Future<SqlConnection> getConnection() {
            return Future.succeededFuture(pgConnection);
        }
    };
    try {
        PostgresClient postgresClient = new PostgresClient(vertx, TENANT);
        postgresClient.setClient(client);
        return postgresClient;
    } catch (Exception e) {
        throw new RuntimeException(e);
    }
}

Example 15 with RowSet

use of io.vertx.sqlclient.RowSet in project raml-module-builder by folio-org.

the class PostgresClientIT method updateWithCqlWrapper.

@Test
public void updateWithCqlWrapper(TestContext context) throws Exception {
    CQLWrapper cqlWrapper = new CQLWrapper(new CQL2PgJSON("jsonb"), "key=x");
    createFoo(context).save(FOO, xPojo, context.asyncAssertSuccess(save -> {
        postgresClient.update(FOO, singleQuotePojo, cqlWrapper, true, context.asyncAssertSuccess(rowSet -> {
            assertThat(rowSet.rowCount(), is(1));
            postgresClient.update(FOO, xPojo, cqlWrapper, true, context.asyncAssertSuccess(rowSet2 -> {
                assertThat(rowSet2.rowCount(), is(0));
            }));
        }));
    }));
}