Connection connection = getConnection();
try {
CommunityUser communityUser = new CommunityUser("gw1", "ogce", "ogce@sciencegateway.org");
communityUserDAO.addCommunityUser(communityUser, "Token1", connection);
communityUser = new CommunityUser("gw1", "ogce2", "ogce@sciencegateway.org");
communityUserDAO.addCommunityUser(communityUser, "Token2", connection);
CommunityUser user = communityUserDAO.getCommunityUser("gw1", "ogce", connection);
Assert.assertNotNull(user);
Assert.assertEquals("ogce@sciencegateway.org", user.getUserEmail());
user = communityUserDAO.getCommunityUser("gw1", "ogce2", connection);
Assert.assertNotNull(user);
Assert.assertEquals("ogce@sciencegateway.org", user.getUserEmail());
user = communityUserDAO.getCommunityUserByToken("gw1", "Token1", connection);
Assert.assertNotNull(user);
Assert.assertEquals("ogce", user.getUserName());
Assert.assertEquals("ogce@sciencegateway.org", user.getUserEmail());
user = communityUserDAO.getCommunityUserByToken("gw1", "Token2", connection);
Assert.assertNotNull(user);
Assert.assertEquals("ogce2", user.getUserName());
Assert.assertEquals("ogce@sciencegateway.org", user.getUserEmail());
} finally {
connection.close();
}