### Question:
UsersJdbcAuthzRepository extends AbstractJdbcRepository implements UsersAuthzRepository { @Override public List<Roles> findUsersRolesList(String usersGuid) { String sql = " select r.* from roles r where r.archived = 0 and r.id in (" + " select roles_id from user_roles where users_id = (" + " select id from users where guid = ? and archived = 0))"; return this.jdbcTemplate.query(sql, rolesRowMapper, usersGuid); }  @Override List<Users> findUsersByUsername(String username); @Override List<Roles> findAvailableRolesList(); @Override Users findByUsername(String username); @Override int saveUsers(final Users users); @Override Roles findRolesByGuid(String guid); @Override void insertUserRoles(final int userId, final int rolesId); @Override List<Roles> findUsersRolesList(String usersGuid); @Override List<String> findPermissionsByRoles(String rolesGuid);  }### Answer:
@Test public void findUsersRolesList() throws Exception { final List<Roles> list = usersJdbcRepository.findUsersRolesList(GuidGenerator.generate()); assertNotNull(list); assertTrue(list.isEmpty()); }