TestStatsDao.java

/*
 * Copyright 2015-Present Entando Inc. (http://www.entando.com) All rights reserved.
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 * THE SOFTWARE.
 */
package com.agiletec.plugins.jpstats.aps.system.services.stats;

import java.util.Calendar;
import java.util.Date;
import java.util.List;
import java.util.Map;

import javax.sql.DataSource;

import org.jfree.data.time.TimeSeries;

import com.agiletec.aps.system.exception.ApsSystemException;
import com.agiletec.aps.util.DateConverter;
import com.agiletec.plugins.jpstats.aps.ApsPluginBaseTestCase;
import com.agiletec.plugins.jpstats.aps.util.CalendarConverter;
import com.agiletec.plugins.jpstats.util.TestStatsUtils;

public class TestStatsDao extends ApsPluginBaseTestCase {
	
	public void testAddStatsRecord() throws Throwable{
		String today = DateConverter.getFormattedDate(new Date(), "dd/MM/yyyy");
		Calendar start = CalendarConverter.getCalendarDay(today, 0, 0, 0, 0);
		Calendar end = CalendarConverter.getCalendarDay(today, 23, 59, 59, 999);
		try {
			this._statsDAO.addStatsRecord(this.createRecordForTest());
			List<StatsRecord> records = _statsDAO.loadStatsRecord(start.getTime(), end.getTime());
			assertEquals(1, records.size());
		} catch (Throwable t) {
			throw t;
		} finally {
			this._statsDAO.deleteStatsRecord(start.getTime(), end.getTime());
			List<StatsRecord> records = _statsDAO.loadStatsRecord(start.getTime(), end.getTime());
			assertEquals(0, records.size());
		}
	}
	
	private StatsRecord createRecordForTest() {
		StatsRecord statsRecord = new StatsRecord(Calendar.getInstance());
		statsRecord.setIp("127.0.0.1");
		statsRecord.setReferer("http://www.japsportal.org/japsportal/it/chi_siamo.wp");
		statsRecord.setSessionId("A3EFA0BC2E5FB24436609B5BE786EDCA");
		statsRecord.setRole("");
		statsRecord.setPageCode("chi_siamo");
		statsRecord.setLangcode("it");
		statsRecord.setUseragent("Mozilla/5.0 (X11; U; Linux i686; it; rv:1.9.0.7) Gecko/2009030422 Ubuntu/8.10 (intrepid) Firefox/3.0.7");
		statsRecord.setBrowserLang("it-it,it;q=0.8,en-us;q=0.5,en;q=0.3");
		statsRecord.setContentId("ART124");
		return statsRecord;
	}
	
	public void testGetHitsByInterval() throws ApsSystemException{
		TimeSeries result = null;
		CalendarConverter converter = new CalendarConverter();
		Calendar initialDate = converter.getCalendarDay("06/03/2007", 0, 0, 0, 0);
		Calendar finalDate = converter.getCalendarDay("10/03/2007", 23, 59, 59, 999);
		try{
			result = _statsDAO.getHitsByInterval(initialDate,finalDate);
		} catch (Throwable t) {
			throw new ApsSystemException("error in get hits by interval", t);
		}
		assertNotNull(result);
	}
	
	public void testGetAverageTimeSite() throws ApsSystemException{
		String result = null;
		CalendarConverter converter = new CalendarConverter();
		Calendar initialDate = converter.getCalendarDay("06/03/2007", 0, 0, 0, 0);
		Calendar finalDate = converter.getCalendarDay("10/03/2007", 23, 59, 59, 999);
		try{
			result = _statsDAO.getAverageTimeSite(initialDate,finalDate);
		} catch (Throwable t) {
			throw new ApsSystemException("error in get average time site", t);
		}
		assertNotNull(result);
	}

	public void testGetAverageTimePage() throws ApsSystemException{
		String result = null;
		CalendarConverter converter = new CalendarConverter();
		Calendar initialDate = converter.getCalendarDay("06/03/2007", 0, 0, 0, 0);
		Calendar finalDate = converter.getCalendarDay("10/03/2007", 23, 59, 59, 999);
		try {
			result = _statsDAO.getAverageTimePage(initialDate,finalDate);
		} catch (Throwable t) {
			throw new ApsSystemException("error in get average time site", t);
		}
		assertNotNull(result);
	}

	public void testGetNumPageSession() throws ApsSystemException{
		int result;
		CalendarConverter converter = new CalendarConverter();
		Calendar initialDate = converter.getCalendarDay("06/03/2007", 0, 0, 0, 0);
		Calendar finalDate = converter.getCalendarDay("10/03/2007", 23, 59, 59, 999);
		try{
			result = _statsDAO.getNumPageSession(initialDate,finalDate);
		} catch (Throwable t) {
			throw new ApsSystemException("error in get average time site", t);
		}
		assertTrue(result >= 0);
	}
	
	public void testGetPageVisitedDesc() throws ApsSystemException{
		Map result = null;
		CalendarConverter converter = new CalendarConverter();
		Calendar initialDate = converter.getCalendarDay("06/03/2007", 0, 0, 0, 0);
		Calendar finalDate = converter.getCalendarDay("10/03/2007", 23, 59, 59, 999);
		try{
			result = _statsDAO.getTopPages(initialDate,finalDate);
		} catch (Throwable t) {
			throw new ApsSystemException("error in get average time site", t);
		}
		assertNotNull(result);
	}

	public void testGetTopContents() throws ApsSystemException{
		Map result = null;
		CalendarConverter converter = new CalendarConverter();
		Calendar initialDate = converter.getCalendarDay("06/03/2007", 0, 0, 0, 0);
		Calendar finalDate = converter.getCalendarDay("10/03/2007", 23, 59, 59, 999);
		try {
			result = _statsDAO.getTopContents(initialDate, finalDate);
		} catch (Throwable t) {
			throw new ApsSystemException("error in get average time site", t);
		}
		assertNotNull(result);
	}

	public void testGetFirstCalendarDay() throws ApsSystemException{
		Calendar firstDay = null;
		try {
			firstDay = _statsDAO.getFirstCalendarDay();
		} catch (Throwable t) {
			throw new ApsSystemException("error in get first day");
		}
		assertNotNull(firstDay);
	}
	
	public void testGetIPByDateInterval() throws ApsSystemException{
		Map result = null;
		CalendarConverter converter = new CalendarConverter();
		Calendar initialDate = converter.getCalendarDay("06/03/2007", 0, 0, 0, 0);
		Calendar finalDate = converter.getCalendarDay("10/03/2007", 23, 59, 59, 999);
		try{
			result = _statsDAO.getIPByDateInterval(initialDate,finalDate);
		}catch (Throwable t) {
			throw new ApsSystemException("error in get average time site", t);
		}
		assertNotNull(result);
	}
	
	protected void tearDown() throws Exception {
		try {
			DataSource dataSource = (DataSource) this.getApplicationContext().getBean("portDataSource");
			TestStatsUtils.cleanDB(ip, dataSource);
		} catch (Throwable e) {
			throw new Exception(e);
		}
		super.tearDown();
	}
	
	@Override
	protected void init() throws Exception {
		super.init();
		_statsDAO = (StatsDAO) this.getApplicationContext().getBean("jpstatsStatsDAO");
	}
	
	private StatsDAO _statsDAO;
	private String ip = "0.0.0.0";

}