/** * Test subscribe. * * @throws Exception - if something is wrong this exception is thrown. */ @Test public void testSubscribe() throws Exception { User user = getUser(userDao, "subuser1"); CollectionItem root = (CollectionItem) contentDao.getRootItem(user); CollectionItem collection = getCollection(root, "subcoll1"); Ticket ticket = generateTicket(collection, user); CollectionSubscription sub1 = new HibCollectionSubscription(); sub1.setDisplayName("sub1"); sub1.setCollection(collection); sub1.setTicket(ticket); user.addSubscription(sub1); userDao.updateUser(user); clearSession(); user = getUser(userDao, "subuser1"); Assert.assertFalse("no subscriptions saved", user.getCollectionSubscriptions().isEmpty()); CollectionSubscription querySub = user.getSubscription("sub1"); Assert.assertNotNull("sub1 not found", querySub); Assert.assertEquals("sub1 not same subscriber", user.getUid(), querySub.getOwner().getUid()); Assert.assertEquals( "sub1 not same collection", collection.getUid(), querySub.getCollectionUid()); Assert.assertEquals("sub1 not same ticket", ticket.getKey(), querySub.getTicketKey()); querySub.setDisplayName("sub2"); userDao.updateUser(user); clearSession(); user = getUser(userDao, "subuser1"); querySub = user.getSubscription("sub1"); Assert.assertNull("sub1 mistakenly found", querySub); querySub = user.getSubscription("sub2"); Assert.assertNotNull("sub2 not found", querySub); user.removeSubscription(querySub); userDao.updateUser(user); clearSession(); user = getUser(userDao, "subuser1"); querySub = user.getSubscription("sub1"); Assert.assertNull("sub1 mistakenly found", querySub); querySub = user.getSubscription("sub2"); Assert.assertNull("sub2 mistakenly found", querySub); }
@Test public void testGetUsersWithAuthority() throws SQLException { String expectedQuery = "select \"public\".\"users\".\"username\", \"public\".\"users\".\"locked\", \"public\".\"authorities\".\"authority\", count(\"public\".\"users\".\"username\") over () as \"count\" from \"public\".\"users\" join \"public\".\"authorities\" on \"public\".\"users\".\"username\" = \"public\".\"authorities\".\"username\" where \"public\".\"authorities\".\"authority\" = 'ROLE_ADMIN' order by \"public\".\"users\".\"username\" asc limit 5 offset 0"; Pageable pageable = Mockito.mock(Pageable.class); ResultSet resultSet = Mockito.mock(ResultSet.class); Mockito.when(pageable.getPageNumber()).thenReturn(0); Mockito.when(pageable.getPageSize()).thenReturn(5); Mockito.when(resultSet.getInt(PagingConstants.COUNT)).thenReturn(1); Mockito.when(resultSet.getString("username")).thenReturn("admin"); RESTPage<UserDTO> page = userDao.getUsersWithAuthority("ROLE_ADMIN", pageable); ArgumentCaptor<PagingRowCallbackHandler> pagingRowCallbackHandlerCaptor = ArgumentCaptor.forClass(PagingRowCallbackHandler.class); Mockito.verify(jdbcTemplate) .query(Matchers.eq(expectedQuery), pagingRowCallbackHandlerCaptor.capture()); PagingRowCallbackHandler pagingRowCallbackHandler = pagingRowCallbackHandlerCaptor.getValue(); pagingRowCallbackHandler.processRow(resultSet); Mockito.verify(resultSet).getInt(PagingConstants.COUNT); Mockito.verify(resultSet).getString("username"); Assert.assertEquals(1, page.getContentSize()); Assert.assertEquals("admin", page.getContent().get(0).getUsername()); }
@Test public void testCRUDUser() { UserDaoImpl dao = new UserDaoImpl(); String login = "******"; String password = "******"; String email = "*****@*****.**"; User user = new User(login, password); user.setEmail(email); dao.insert(user); user = dao.selectWithLogin(login); assertEquals(login, user.getLogin()); assertEquals(password, user.getPassword()); assertEquals(email, user.getEmail()); user.setEmail("*****@*****.**"); dao.update(user); user = dao.selectWithLogin(login); assertEquals(login, user.getLogin()); assertEquals(password, user.getPassword()); assertEquals("*****@*****.**", user.getEmail()); dao.delete(user); user = dao.selectWithLogin(login); assertNull(user); }
public static void main(String args[]) { FillTablesRoleAndMusicTypes.FillRole(); FillTablesRoleAndMusicTypes.FillMusicType(); Role role = new Role(2, "Moderator"); Address address = new Address(4, "coury", "steeeet", 6122); MusicType type1 = new MusicType(1, "rock"); MusicType type2 = new MusicType(3, "rap"); Set<MusicType> MT = new HashSet<MusicType>(); MT.add(type1); MT.add(type2); User user2 = new User(1, "login", "paword", "ftname", "ltname", 58, address, role, MT); UserDaoImpl Ivan2 = new UserDaoImpl(); try { Ivan2.delete(user2); } catch (SQLException e) { e.printStackTrace(); } ConnectToDB.closeConn(); }
@Test public void testGetUsersWithAuthority_page2() { String expectedQuery = "select \"public\".\"users\".\"username\", \"public\".\"users\".\"locked\", \"public\".\"authorities\".\"authority\", count(\"public\".\"users\".\"username\") over () as \"count\" from \"public\".\"users\" join \"public\".\"authorities\" on \"public\".\"users\".\"username\" = \"public\".\"authorities\".\"username\" where \"public\".\"authorities\".\"authority\" = 'ROLE_ADMIN' order by \"public\".\"users\".\"username\" asc limit 5 offset 5"; Pageable pageable = Mockito.mock(Pageable.class); Mockito.when(pageable.getPageNumber()).thenReturn(1); Mockito.when(pageable.getPageSize()).thenReturn(5); userDao.getUsersWithAuthority("ROLE_ADMIN", pageable); Mockito.verify(jdbcTemplate) .query(Matchers.eq(expectedQuery), Matchers.any(PagingRowCallbackHandler.class)); }