@Test public void testUsingUUIDsInTables(TestContext context) { Async async = context.async(); final UUID uuid = UUID.randomUUID(); final String name = "xyz"; client.getConnection(ar -> { ensureSuccess(context, ar); conn = ar.result(); setupTableWithUUIDs(conn, ar2 -> { ensureSuccess(context, ar2); conn.queryWithParams("INSERT INTO test_table (some_uuid, name) VALUES (?, ?)", new JsonArray().add(uuid.toString()).add(name), ar3 -> { ensureSuccess(context, ar3); conn.queryWithParams("SELECT some_uuid FROM test_table WHERE name = ?", new JsonArray().add(name), ar4 -> { ensureSuccess(context, ar4); ResultSet resultSet = ar4.result(); context.assertEquals(1, resultSet.getNumRows()); context.assertEquals("some_uuid", resultSet.getColumnNames().get(0)); context.assertEquals(new JsonObject().put("some_uuid", uuid.toString()), resultSet.getRows().get(0)); async.complete(); }); }); }); }); }
@Test public void testUsingUUIDsInTables(TestContext context) { Async async = context.async(); final UUID uuid = UUID.randomUUID(); final String name = "xyz"; client.getConnection(ar -> { ensureSuccess(context, ar); conn = ar.result(); setupTableWithUUIDs(conn, ar2 -> { ensureSuccess(context, ar2); conn.queryWithParams("INSERT INTO test_table (some_uuid, name) VALUES (?, ?)", new JsonArray().add(uuid.toString()).add(name), ar3 -> { ensureSuccess(context, ar3); conn.queryWithParams("SELECT some_uuid FROM test_table WHERE name = ?", new JsonArray().add(name), ar4 -> { ensureSuccess(context, ar4); ResultSet resultSet = ar4.result(); context.assertEquals(1, resultSet.getNumRows()); context.assertEquals("some_uuid", resultSet.getColumnNames().get(0)); context.assertEquals(new JsonObject().put("some_uuid", uuid.toString()), resultSet.getRows().get(0)); async.complete(); }); }); }); }); }
@Test public void testUsingUUIDsInTables(TestContext context) { Async async = context.async(); final UUID uuid = UUID.randomUUID(); final String name = "xyz"; client.getConnection(ar -> { ensureSuccess(context, ar); conn = ar.result(); setupTableWithUUIDs(conn, ar2 -> { ensureSuccess(context, ar2); conn.queryWithParams("INSERT INTO test_table (some_uuid, name) VALUES (?, ?)", new JsonArray().add(uuid.toString()).add(name), ar3 -> { ensureSuccess(context, ar3); conn.queryWithParams("SELECT some_uuid FROM test_table WHERE name = ?", new JsonArray().add(name), ar4 -> { ensureSuccess(context, ar4); ResultSet resultSet = ar4.result(); context.assertEquals(1, resultSet.getNumRows()); context.assertEquals("some_uuid", resultSet.getColumnNames().get(0)); context.assertEquals(new JsonObject().put("some_uuid", uuid.toString()), resultSet.getRows().get(0)); async.complete(); }); }); }); }); }