public static DB<Unit> insert(Iterable<Employee> xs) { return new BatchUpdateOp<>("INSERT INTO EMPLOYEES (ID, NAME, DEPARTMENT_ID) VALUES (?, ?, ?)", x -> ps -> { ps.setInt(1, x.id); ps.setString(2, x.name); ps.setInt(3, x.departmentId); }, xs) .map(ignore -> Unit.unit()); }
@Test public void selectBy() { DB<Unit> insertIt = insertKeysOp(list("a")) .bind(ids -> insertDataOp(ids.zip(list("my_description"))).map(ignore -> Unit.unit())); DB.submit(insertIt); List<String> descriptions = DB.submit(selectByDescOp("my_description")); assertEquals(list("my_description"), descriptions); }