/*******************************************************************************
 * Copyright 2014 Federal Chancellery Austria
 * MOA-ID has been developed in a cooperation between BRZ, the Federal
 * Chancellery Austria - ICT staff unit, and Graz University of Technology.
 *
 * Licensed under the EUPL, Version 1.1 or - as soon they will be approved by
 * the European Commission - subsequent versions of the EUPL (the "Licence");
 * You may not use this work except in compliance with the Licence.
 * You may obtain a copy of the Licence at:
 * http://www.osor.eu/eupl/
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the Licence is distributed on an "AS IS" basis,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the Licence for the specific language governing permissions and
 * limitations under the Licence.
 *
 * This product combines work with different licenses. See the "NOTICE" text
 * file for details on the various modules and licenses.
 * The "NOTICE" text file is part of the distribution. Any derivative works
 * that you distribute must include a readable copy of the "NOTICE" text file.
 *******************************************************************************/
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.api.AuthConfiguration;
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.session.AssertionStore;
import at.gv.egovernment.moa.id.commons.db.dao.statistic.StatisticLog;
import at.gv.egovernment.moa.id.config.auth.AuthConfigurationProviderFactory;
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>();
		
		AuthConfiguration config = AuthConfigurationProviderFactory.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{
		
		List<String> publicURLPreFix = AuthConfigurationProviderFactory.getInstance().getPublicURLPrefix();
	
		if (MiscUtil.isEmpty(publicURLPreFix))
			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
		
	}
}