@Test
public void testCreateRiver() {
River river = new River();
Account account = accountDao.findByUsernameOrEmail("user1");
river.setRiverName("Test river");
river.setDescription("test description");
river.setAccount(account);
river.setRiverPublic(false);
riverDao.create(river);
assertNotNull(river.getId());
String sql =
"SELECT account_id, river_name, description, river_public, river_name_canonical FROM rivers WHERE id = ?";
Map<String, Object> results = this.jdbcTemplate.queryForMap(sql, river.getId());
assertEquals("Test river", (String) results.get("river_name"));
assertEquals(3L, ((Number) results.get("account_id")).longValue());
assertEquals(TextUtil.getURLSlug("Test river"), (String) results.get("river_name_canonical"));
assertEquals("test description", (String) results.get("description"));
assertEquals(false, results.get("river_public"));
}
