package net.sourceforge.fenixedu.persistenceTierOracle.Oracle;

import net.sourceforge.fenixedu._development.PropertiesManager;
import net.sourceforge.fenixedu.persistenceTier.ExcepcaoPersistencia;

public class PersistentSuportMGP extends PersistentSuportOracle {

    private static PersistentSuportMGP instance = null;

    private String databaseUrl = null;

    public PersistentSuportMGP(String userNamePropertyName, String userPassPropertyName, String urlPropertyName) {
	super(userNamePropertyName, userPassPropertyName, urlPropertyName);
    }

    public static synchronized PersistentSuportOracle getProjectDBInstance() {
	if (instance == null) {
	    instance = new PersistentSuportMGP("db.projectManagement.user", "db.projectManagement.pass",
		    "db.projectManagement.alias");
	}
	return instance;
    }

    public String getDatabaseUrl() throws ExcepcaoPersistencia {
	if (databaseUrl == null) {
	    setDatabaseUrl();
	}
	return databaseUrl;
    }

    public void setDatabaseUrl() throws ExcepcaoPersistencia {
	if (databaseUrl == null) {
	    String DBUserName = PropertiesManager.getProperty(connectionProperties.userNamePropertyName);
	    String DBUserPass = PropertiesManager.getProperty(connectionProperties.userPassPropertyName);
	    String DBUrl = PropertiesManager.getProperty(connectionProperties.urlPropertyName);
	    if (DBUserName == null || DBUserPass == null || DBUrl == null) {
		throw new ExcepcaoPersistencia();
	    }
	    StringBuilder stringBuffer = new StringBuilder();
	    stringBuffer.append("jdbc:oracle:thin:");
	    stringBuffer.append(DBUserName);
	    stringBuffer.append("/");
	    stringBuffer.append(DBUserPass);
	    stringBuffer.append("@");
	    stringBuffer.append(DBUrl);
	    databaseUrl = stringBuffer.toString();
	}
    }
}