/**
* 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));
}
