package net.ytguide.listener;

import java.sql.Connection;
import java.sql.SQLException;

import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;

import org.apache.empire.db.DBDatabaseDriver;
import org.apache.empire.db.mysql.DBDatabaseDriverMySQL;
import org.apache.tomcat.dbcp.dbcp2.BasicDataSource;

import net.ytguide.model.db.YTGuideDB;

public class AppListener implements ServletContextListener {

	@Override
	public void contextInitialized(ServletContextEvent sce) {

		// Connection initialisieren
		BasicDataSource ds = initDataSource();
		Connection conn = getConnection(ds);

		// Datenbank/treiber initialisieren
		YTGuideDB db = new YTGuideDB();
		DBDatabaseDriver driver = new DBDatabaseDriverMySQL();

	}

	private BasicDataSource initDataSource() {
		BasicDataSource ds = new BasicDataSource();
		ds.setMaxTotal(30);
		ds.setMaxIdle(15);
		ds.setMaxWaitMillis(-1);
		ds.setDriverClassName("com.mysql.jdbc.Driver");
		ds.setUrl("jdbc:mysql://127.0.0.1:8889/ytguide");
		ds.setUsername("noel2");
		ds.setPassword("root");
		return ds;
	}

	private Connection getConnection(BasicDataSource ds) {
		try {
			Connection conn = ds.getConnection();
			conn.setAutoCommit(false);
			return conn;
		} catch (SQLException ex) {
			System.out.println("!! Unable to get connection !!");
			throw new RuntimeException(ex);
		}
	}

	@Override
	public void contextDestroyed(ServletContextEvent arg0) {
		// TODO Auto-generated method stub

	}

}