package at.gv.egovernment.moa.id.monitoring;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import at.gv.egovernment.moa.id.commons.db.ConfigurationDBRead;
import at.gv.egovernment.moa.id.commons.db.ConfigurationDBUtils;
import at.gv.egovernment.moa.id.commons.db.MOASessionDBUtils;
import at.gv.egovernment.moa.id.commons.db.StatisticLogDBUtils;
import at.gv.egovernment.moa.id.commons.db.dao.config.MOAIDConfiguration;
import at.gv.egovernment.moa.id.commons.db.dao.session.AssertionStore;
import at.gv.egovernment.moa.id.commons.db.dao.statistic.StatisticLog;
import at.gv.egovernment.moa.id.config.auth.AuthConfigurationProvider;
import at.gv.egovernment.moa.logging.Logger;
import at.gv.egovernment.moa.util.MiscUtil;

public class DatabaseTestModule implements TestModuleInterface{

	public List<String> performTests() throws Exception {
		Logger.trace("Start MOA-ID Database Test.");
		
		List<String> errors = new ArrayList<String>();
		
		AuthConfigurationProvider config = AuthConfigurationProvider.getInstance();
		
		String error = testMOAConfigurationDatabase();
		if (MiscUtil.isNotEmpty(error))
			errors.add(error);
		
		error = testMOASessionDatabase();
		if (MiscUtil.isNotEmpty(error))
			errors.add(error);
		
		if (config.isAdvancedLoggingActive()) {
			error = testMOAAdvancedLoggingDatabase();
			if (MiscUtil.isNotEmpty(error))
				errors.add(error);
		}
		
		return errors;
	}

	
	private String testMOASessionDatabase() throws Exception{
		Logger.trace("Start Test: MOASessionDatabase");
		
		Date expioredate = new Date(new Date().getTime() - 120);
 
		try {
			List<AssertionStore> results;
			Session session = MOASessionDBUtils.getCurrentSession();
			
			synchronized (session) {			
				session.beginTransaction();
				Query query = session.getNamedQuery("getAssertionWithTimeOut");
				query.setTimestamp("timeout", expioredate);		
				results = query.list();
				session.getTransaction().commit();
			}
			
			Logger.trace("Finish Test: MOASessionDatabase");
			return null;
			
		} catch (Throwable e) {
			Logger.warn("Failed Test: MOASessionDatabase", e);
			return "MOASessionDatabase: " + e.getMessage();
		}
	}
	
	private String testMOAConfigurationDatabase() throws Exception{
		
		MOAIDConfiguration moaidconfig = ConfigurationDBRead.getMOAIDConfiguration();	
		ConfigurationDBUtils.closeSession();
		
		if (moaidconfig == null)
			return ("MOA-ID 2.x configuration can not be loaded from Database.");
		
		return null;
	}
	
	private String testMOAAdvancedLoggingDatabase() {
		
		Date expioredate = new Date(new Date().getTime() - 120);
		try {
			Session session = StatisticLogDBUtils.getCurrentSession();
		
			List<StatisticLog> results;
		
			synchronized (session) {			
				session.beginTransaction();
				Query query = session.getNamedQuery("getAllEntriesNotBeforeTimeStamp");
				query.setTimestamp("timeout", expioredate);		
				results = query.list();
				session.getTransaction().commit();
			}
		
			Logger.trace("Finish Test: AdvancedLoggingDataBase");
			return null;
			
		} catch (Throwable e) {
			Logger.warn("Failed Test: AdvancedLoggingDataBase", e);
			return "AdvancedLoggingDataBase: " + e.getMessage();
		}
	}


	public String getName() {
		return "DatabaseTest";
	}


	public void initializeTest(long delayParam, String url) throws Exception {
		// TODO Auto-generated method stub
		
	}
}