@Test
  public void remove() throws Exception {
    try (DbContext dbContext = contextProvider.getDbContext()) {
      MessageRatingDAO messageRatingDAO = dbContext.getMessageRatingDAO();
      PersonDAO personDAO = dbContext.getPersonDAO();
      MessageDAO messageDAO = dbContext.getMessageDAO();

      Person person = personDAO.getById(118);
      Message message = messageDAO.getById(2);
      MessageRating rating =
          dbContext.getMessageRatingDAO().findRatingByPersonAndMessage(message, person);
      message.removeMesasgeRating(rating);
      person.removeMesasgeRating(rating);
      messageRatingDAO.remove(rating);
      dbContext.commit();
    }

    try (DbContext dbContext = contextProvider.getDbContext()) {
      MessageRatingDAO messageRatingDAO = dbContext.getMessageRatingDAO();
      MessageDAO messageDAO = dbContext.getMessageDAO();
      Message message = messageDAO.getById(2);
      List<Person> raters = messageRatingDAO.loadAllRatersByMessage(message);
      assertEquals(0, raters.size());
    }
  }
  @Test
  public void insert() throws Exception, ConstraintViolationException {

    Person p = new Person("etester", "Tester", "Ehrenfried", "1234567");

    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      personDAO.insert(p);
      dbContext.commit();

      assertNotEquals(0, p.getPersonId());

    } catch (Exception e) {

      e.printStackTrace();
      fail("Exception " + e.getMessage());

    } finally {

      if (p.getPersonId() != 0) {
        try (DbContext dbContext = contextProvider.getDbContext()) {

          PersonDAO personDAO = dbContext.getPersonDAO();

          personDAO.remove(p.getPersonId());

          dbContext.commit();
        }
      }
    }
  }
  @Test(expected = EntityNotFoundException.class)
  public void getUserByInvalidEMailAddress() throws Exception {
    DbContext dbContext = contextProvider.getDbContext();

    PersonDAO personDAO = dbContext.getPersonDAO();
    Person p = personDAO.getByEmailAddress("*****@*****.**");
    assertEquals(p, new Person("", "", "", ""));
  }
  @Test(expected = ParameterException.class)
  public void removeOnNull() throws Exception {
    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      personDAO.remove(null);
    }
  }
  @Test(expected = EntityNotFoundException.class)
  public void getByIdNoneFound() throws Exception {

    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      personDAO.getById(-1);
    }
  }
  @Test(expected = ParameterException.class)
  public void removeOnIdZero() throws Exception {
    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      Person p = new Person();
      p.setPersonId(0);

      personDAO.remove(p);
    }
  }
  @Test
  public void loadAllRatersByMessage() throws Exception {
    try (DbContext dbContext = contextProvider.getDbContext()) {
      PersonDAO personDAO = dbContext.getPersonDAO();
      MessageDAO messageDAO = dbContext.getMessageDAO();
      MessageRatingDAO messageRatingDAO = dbContext.getMessageRatingDAO();

      Person person = personDAO.getById(108);
      Message message = messageDAO.getById(1);

      List<Person> raters = messageRatingDAO.loadAllRatersByMessage(message);
      assertEquals(person, raters.get(0));
    }
  }
  @Test
  public void findRatingByPersonAndMessage() throws Exception {
    try (DbContext dbContext = contextProvider.getDbContext()) {
      PersonDAO personDAO = dbContext.getPersonDAO();
      MessageDAO messageDAO = dbContext.getMessageDAO();
      MessageRatingDAO messageRatingDAO = dbContext.getMessageRatingDAO();

      Person person = personDAO.getById(108);
      Message message = messageDAO.getById(1);

      MessageRating rating = messageRatingDAO.findRatingByPersonAndMessage(message, person);
      assertEquals(message, rating.getMessage());
      assertEquals(person, rating.getPerson());
    }
  }
  @Test
  public void getByUsernameXaseMismatch() {

    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      Person p = personDAO.getByUsername("Pse_system");

      assertNull(p);

    } catch (Exception e) {
      e.printStackTrace();
      fail("Exception " + e.getMessage());
    }
  }
  @Test
  public void getByEmailAddress() {

    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      Person p = personDAO.getByEmailAddress("*****@*****.**");

      assertEquals(p.getPersonId(), 2);

    } catch (Exception e) {
      e.printStackTrace();
      fail("Exception " + e.getMessage());
    }
  }
  @Test
  public void getByUsernameNoneFound() {

    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      Person p = personDAO.getByUsername("gnurmifgjp�sh l hlfdyghlfd glkdfghv y");

      assertEquals(p, null);

    } catch (Exception e) {
      e.printStackTrace();
      fail("Exception " + e.getMessage());
    }
  }
  @Test
  public void getById() {

    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      Person p = personDAO.getById(1); // 1 is the system internal user
      // that should always exist

      assertEquals(p.getUserName(), "pse_system");

    } catch (Exception e) {
      e.printStackTrace();
      fail("Exception " + e.getMessage());
    }
  }
  @Test(expected = EntityNotFoundException.class)
  public void insertRemovCycle() throws Exception {

    Person p = new Person("etester", "Tester", "Ehrenfried", "12345678");

    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      personDAO.insert(p);
      dbContext.commit();

      assertNotEquals(0, p.getPersonId());
    }

    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      Person x = personDAO.getById(p.getPersonId());

      personDAO.remove(x);

      dbContext.commit();
    }

    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      Person x = personDAO.getById(p.getPersonId());
      assertEquals(x, new Person());
    }
  }
  @Test
  public void insert() throws Exception {
    try (DbContext dbContext = contextProvider.getDbContext()) {
      MessageRatingDAO messageRatingDAO = dbContext.getMessageRatingDAO();
      PersonDAO personDAO = dbContext.getPersonDAO();
      MessageDAO messageDAO = dbContext.getMessageDAO();

      Person person = personDAO.getById(104);
      Message message = messageDAO.getById(4);

      MessageRating rating = new MessageRating(new Date(), message, person);

      messageRatingDAO.insert(rating);

      List<Person> raters = messageRatingDAO.loadAllRatersByMessage(message);
      assertEquals(person, raters.get(0));
    }
  }
Ejemplo n.º 15
0
  @After
  public void teardown() throws Exception {

    try (DbContext context = contextProvider.getDbContext()) {

      CommunityDAO communityDAO = context.getCommunityDAO();

      for (Community c : toDelete) {
        communityDAO.remove(c.getCommunityId());
      }

      PersonDAO personDao = context.getPersonDAO();

      personDao.remove(plainPerson.getPersonId());
      personDao.remove(adminPerson.getPersonId());
      personDao.remove(inActivePerson.getPersonId());

      context.commit();
    }
  }
  @Test(expected = ConstraintViolationException.class)
  public void insertDuplicate() throws Exception {

    try (DbContext dbContext = contextProvider.getDbContext()) {

      PersonDAO personDAO = dbContext.getPersonDAO();

      Person p1 = new Person("etester", "Tester", "Ehrenfried", "12345678");

      Person p2 = new Person("etester", "Tester", "Ehrenfried", "12345678");

      personDAO.insert(p1);
      personDAO.insert(p2);
      dbContext.commit();

    } catch (Exception e) {

      throw e;
    }
  }
  @BeforeClass
  public static void setup() throws Exception {
    DbTestBase.prepare();

    try (DbContext dbContext = contextProvider.getDbContext()) {
      MessageRatingDAO messageRatingDAO = dbContext.getMessageRatingDAO();
      PersonDAO personDAO = dbContext.getPersonDAO();
      MessageDAO messageDAO = dbContext.getMessageDAO();

      Person person = personDAO.getById(118);
      Message message = messageDAO.getById(2);
      MessageRating rating = new MessageRating(new Date(), message, person);
      messageRatingDAO.insert(rating);

      person = personDAO.getById(114);
      message = messageDAO.getById(3);
      rating = new MessageRating(new Date(), message, person);
      messageRatingDAO.insert(rating);

      dbContext.commit();
    }
  }