@Test public void testInsertedIds(TestContext context) { String name1 = "Adele"; String name2 = "Betty"; Async async = context.async(); client.getConnection(ar -> { ensureSuccess(context, ar); conn = ar.result(); setupAutoIncrementTable(conn, ar2 -> { ensureSuccess(context, ar2); conn.queryWithParams("INSERT INTO test_table (name) VALUES (?) RETURNING id", new JsonArray().add(name1), ar3 -> { ensureSuccess(context, ar3); ResultSet updateResult1 = ar3.result(); long id1 = updateResult1.getResults().get(0).getLong(0); conn.queryWithParams("INSERT INTO test_table (name) VALUES (?) RETURNING id", new JsonArray().add(name2), ar4 -> { ensureSuccess(context, ar4); ResultSet updateResult2 = ar4.result(); long id2 = updateResult2.getResults().get(0).getLong(0); checkConsistency(context, async, conn, id1, name1, id2, name2); }); }); }); }); }
@Test public void testInsertedIds(TestContext context) { String name1 = "Adele"; String name2 = "Betty"; Async async = context.async(); client.getConnection(ar -> { ensureSuccess(context, ar); conn = ar.result(); setupAutoIncrementTable(conn, ar2 -> { ensureSuccess(context, ar2); conn.queryWithParams("INSERT INTO test_table (name) VALUES (?) RETURNING id", new JsonArray().add(name1), ar3 -> { ensureSuccess(context, ar3); ResultSet updateResult1 = ar3.result(); long id1 = updateResult1.getResults().get(0).getLong(0); conn.queryWithParams("INSERT INTO test_table (name) VALUES (?) RETURNING id", new JsonArray().add(name2), ar4 -> { ensureSuccess(context, ar4); ResultSet updateResult2 = ar4.result(); long id2 = updateResult2.getResults().get(0).getLong(0); checkConsistency(context, async, conn, id1, name1, id2, name2); }); }); }); }); }
@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 testInsertedIds(TestContext context) { String name1 = "Adele"; String name2 = "Betty"; Async async = context.async(); client.getConnection(ar -> { ensureSuccess(context, ar); conn = ar.result(); setupAutoIncrementTable(conn, ar2 -> { ensureSuccess(context, ar2); conn.queryWithParams("INSERT INTO test_table (name) VALUES (?) RETURNING id", new JsonArray().add(name1), ar3 -> { ensureSuccess(context, ar3); ResultSet updateResult1 = ar3.result(); long id1 = updateResult1.getResults().get(0).getLong(0); conn.queryWithParams("INSERT INTO test_table (name) VALUES (?) RETURNING id", new JsonArray().add(name2), ar4 -> { ensureSuccess(context, ar4); ResultSet updateResult2 = ar4.result(); long id2 = updateResult2.getResults().get(0).getLong(0); checkConsistency(context, async, conn, id1, name1, id2, name2); }); }); }); }); }
@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(); }); }); }); }); }