/*
*
* Copyright 2013 Entando S.r.l. (http://www.entando.com) All rights reserved.
*
* This file is part of Entando Enterprise Edition software.
* You can redistribute it and/or modify it
* under the terms of the Entando's EULA
*
* See the file License for the specific language governing permissions
* and limitations under the License
*
*
*
* Copyright 2013 Entando S.r.l. (http://www.entando.com) All rights reserved.
*
*/
package com.agiletec.plugins.jpwebdynamicform.aps.system.services.message;
import java.util.Date;
import java.util.List;
import javax.sql.DataSource;
import com.agiletec.plugins.jpwebdynamicform.aps.ApsPluginBaseTestCase;
import com.agiletec.plugins.jpwebdynamicform.util.JpwebdynamicformTestHelper;
import com.agiletec.aps.system.SystemConstants;
import com.agiletec.aps.system.common.entity.IEntityManager;
import com.agiletec.aps.system.common.entity.model.ApsEntityRecord;
import com.agiletec.aps.system.common.entity.model.EntitySearchFilter;
import com.agiletec.aps.system.services.lang.ILangManager;
import com.agiletec.aps.util.DateConverter;
import com.agiletec.plugins.jpwebdynamicform.aps.system.services.message.IMessageDAO;
import com.agiletec.plugins.jpwebdynamicform.aps.system.services.message.IMessageSearcherDAO;
import com.agiletec.plugins.jpwebdynamicform.aps.system.services.message.MessageDAO;
import com.agiletec.plugins.jpwebdynamicform.aps.system.services.message.MessageSearcherDAO;
import com.agiletec.plugins.jpwebdynamicform.aps.system.services.message.model.Answer;
import com.agiletec.plugins.jpwebdynamicform.aps.system.services.message.model.Message;
import com.agiletec.plugins.jpwebdynamicform.aps.system.services.message.model.MessageRecordVO;
public class TestMessageSearcherDAO extends ApsPluginBaseTestCase {
@Override
protected void setUp() throws Exception {
super.setUp();
this.init();
}
public void testSearchRecords() throws Throwable {
Date currentDate = new Date();
Message message1 = this._helper.createMessage("TEST", "admin", "it", currentDate, "MyName", "MySurname", "MyAddress", JpwebdynamicformTestHelper.EMAIL, "MyNotes");
this._messageDao.addEntity(message1);
List<ApsEntityRecord> records = this._messageSearcherDao.searchRecords(null);
assertEquals(1, records.size());
MessageRecordVO record = (MessageRecordVO) records.get(0);
assertEquals(message1.getId(), record.getId());
assertEquals(message1.getTypeCode(), record.getTypeCode());
assertEquals(message1.getUsername(), record.getUsername());
assertEquals(DateConverter.getFormattedDate(currentDate, "dd/MM/yyyy"),
DateConverter.getFormattedDate(record.getCreationDate(), "dd/MM/yyyy"));
Date start = new Date(currentDate.getTime()-86400001);
Date end = new Date(currentDate.getTime()+86400001);
EntitySearchFilter filter = new EntitySearchFilter(IMessageSearcherDAO.CREATION_DATE_FILTER_KEY, false, start, end);
records = this._messageSearcherDao.searchRecords(new EntitySearchFilter[] { filter });
assertEquals(1, records.size());
end = new Date(currentDate.getTime()-86400001);
filter = new EntitySearchFilter(IMessageSearcherDAO.CREATION_DATE_FILTER_KEY, false, start, end);
records = this._messageSearcherDao.searchRecords(new EntitySearchFilter[] { filter });
assertEquals(0, records.size());
filter = new EntitySearchFilter(IMessageSearcherDAO.CREATION_DATE_FILTER_KEY, false, null, end);
records = this._messageSearcherDao.searchRecords(new EntitySearchFilter[] { filter });
assertEquals(0, records.size());
filter = new EntitySearchFilter(IMessageSearcherDAO.CREATION_DATE_FILTER_KEY, false, start, null);
records = this._messageSearcherDao.searchRecords(new EntitySearchFilter[] { filter });
assertEquals(1, records.size());
}
public void testSearchId() throws Throwable {
Date currentDate = new Date();
Message message1 = this._helper.createMessage("TEST1", "admin", "it", currentDate, "MyName", "MySurname", "MyAddress", JpwebdynamicformTestHelper.EMAIL, "MyNotes");
this._messageDao.addEntity(message1);
Message message2 = this._helper.createMessage("TEST2", "mainEditor", "it", currentDate, "MyCompany", "MyAddress", JpwebdynamicformTestHelper.EMAIL, "MyNotes");
this._messageDao.addEntity(message2);
List<String> messageIds = this._messageSearcherDao.searchId(null);
assertEquals(2, messageIds.size());
assertTrue(messageIds.contains("TEST1"));
assertTrue(messageIds.contains("TEST2"));
EntitySearchFilter filter = new EntitySearchFilter(IEntityManager.ENTITY_TYPE_CODE_FILTER_KEY, false, "PER", true);
messageIds = this._messageSearcherDao.searchId(new EntitySearchFilter[] { filter });
assertEquals(1, messageIds.size());
assertTrue(messageIds.contains("TEST1"));
filter = new EntitySearchFilter(IMessageSearcherDAO.USERNAME_FILTER_KEY, false, "mainEditor", true);
messageIds = this._messageSearcherDao.searchId(new EntitySearchFilter[] { filter });
assertEquals(1, messageIds.size());
assertTrue(messageIds.contains("TEST2"));
messageIds = this._messageSearcherDao.searchId("COM", new EntitySearchFilter[] {});
assertEquals(1, messageIds.size());
assertTrue(messageIds.contains("TEST2"));
}
public void testSearchIdAnswered() throws Throwable {
Date currentDate = new Date();
Message message1 = this._helper.createMessage("TEST1", "admin", "it", currentDate, "MyName", "MySurname", "MyAddress", JpwebdynamicformTestHelper.EMAIL, "MyNotes");
this._messageDao.addEntity(message1);
String message1Id = message1.getId();
Answer answer1 = this._helper.createAnswer(null, message1Id, "admin", new Date(), "text1");
this._helper.addAnswer(answer1);
Message message2 = this._helper.createMessage("TEST2", "mainEditor", "it", currentDate, "MyCompany", "MyAddress", JpwebdynamicformTestHelper.EMAIL, "MyNotes");
this._messageDao.addEntity(message2);
String message2Id = message2.getId();
List<String> messageIds = this._messageSearcherDao.searchId(null, true);
assertEquals(1, messageIds.size());
assertTrue(messageIds.contains(message1Id));
messageIds = this._messageSearcherDao.searchId(null, false);
assertEquals(1, messageIds.size());
assertTrue(messageIds.contains(message2Id));
EntitySearchFilter filter = new EntitySearchFilter(IEntityManager.ENTITY_TYPE_CODE_FILTER_KEY, false, "PER", true);
messageIds = this._messageSearcherDao.searchId(new EntitySearchFilter[] { filter }, true);
assertEquals(1, messageIds.size());
assertTrue(messageIds.contains(message1Id));
filter = new EntitySearchFilter(IMessageSearcherDAO.USERNAME_FILTER_KEY, false, "mainEditor", true);
messageIds = this._messageSearcherDao.searchId(new EntitySearchFilter[] { filter }, true);
assertEquals(0, messageIds.size());
filter = new EntitySearchFilter(IMessageSearcherDAO.USERNAME_FILTER_KEY, false, "admin", true);
messageIds = this._messageSearcherDao.searchId(new EntitySearchFilter[] { filter }, true);
assertEquals(1, messageIds.size());
assertTrue(messageIds.contains(message1Id));
}
private void init() throws Exception {
try {
MessageDAO messageDAO = new MessageDAO();
messageDAO.setDataSource((DataSource) this.getApplicationContext().getBean("servDataSource"));
messageDAO.setLangManager((ILangManager) this.getService(SystemConstants.LANGUAGE_MANAGER));
this._messageDao = messageDAO;
MessageSearcherDAO searcherDAO = new MessageSearcherDAO();
searcherDAO.setDataSource((DataSource) this.getApplicationContext().getBean("servDataSource"));
this._messageSearcherDao = searcherDAO;
} catch (Throwable e) {
throw new Exception(e);
}
}
private IMessageDAO _messageDao;
private IMessageSearcherDAO _messageSearcherDao;
}