@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());
    }
  }
  @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();
    }
  }
  @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 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));
    }
  }