@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")); }