@Test
public void findCollaboratorByAccount() {
RiverCollaborator rc = riverDao.findCollaborator(1L, 4L);
assertEquals(1L, (long) rc.getId());
assertEquals(4L, rc.getAccount().getId());
}
@Test
public void testModifyCollaborator() {
RiverCollaborator collaborator = riverCollaboratorDao.findById(1L);
collaborator.setActive(false);
collaborator.setReadOnly(true);
riverDao.updateCollaborator(collaborator);
em.flush();
String sql =
"SELECT river_id, account_id, collaborator_active, read_only FROM river_collaborators WHERE id = ?";
Map<String, Object> results = this.jdbcTemplate.queryForMap(sql, 1L);
assertEquals(false, results.get("collaborator_active"));
assertEquals(true, results.get("read_only"));
}