EDIT

/**

* Copyright (C) 2007 EDIT

* European Distributed Institute of Taxonomy 

* http://www.e-taxonomy.eu

* 

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

package eu.etaxonomy.cdm.app.common;

import java.lang.reflect.InvocationTargetException;

import java.lang.reflect.Method;

import org.apache.log4j.Logger;

import eu.etaxonomy.cdm.common.AccountStore;

import eu.etaxonomy.cdm.database.CdmDataSource;

import eu.etaxonomy.cdm.database.DatabaseTypeEnum;

import eu.etaxonomy.cdm.database.ICdmDataSource;

public class CdmDestinations {

	@SuppressWarnings("unused")

	private static Logger logger = Logger.getLogger(CdmDestinations.class);

	public static ICdmDataSource cdm_1_1(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_1_1"; // values: "cdm_1_1"  "cdm_build"

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_build(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_build"; // values: "cdm_1_1"  "cdm_build"

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	/**

	 * Intended to be used for imports

	 */

	public static ICdmDataSource import_a(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "localhost";

		String cdmDB = "import_a";

		String cdmUserName = "root";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_import(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_import";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test"; // values: "cdm_1_1"  "cdm_build"

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_jaxb(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_jaxb"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_jaxb2(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_jaxb2"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_andreas_palmae(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_andreas_palmae"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_andreas_cichorieae(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_andreas_cichorieae"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_andreasM(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_andreasM"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_andreasM2(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_andreasM2"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_andreasM3(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_andreasM3"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_local_mysql(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_test"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_editor2(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_editor_test2"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

		public static ICdmDataSource cdm_portal(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_portal";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_portal_test(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_portal_test";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_patricia(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_patricia";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_eunmok(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_eunmok";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_eunmok_erms(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_eunmok_erms";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_niels1(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_niels1";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_niels2(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_niels2";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	//

	public static ICdmDataSource cdm_test_andreasK1(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_andreasK1";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_test_andreasK2(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_test_andreasK2";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_pesi_erms(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_pesi_erms";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_campanulaceae(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_campanulaceae";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_campanulaceae_production(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.151";

		String cdmDB = "cdm_production_campanulaceae";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_flora_malesiana_preview(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.201";

		String cdmDB = "cdm_edit_flora_malesiana_a";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_flora_malesiana_production(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.151";

		String cdmDB = "cdm_production_flora_malesiana";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_flora_central_africa_preview(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.201";

		String cdmDB = "cdm_edit_flora_central_africa";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_flora_central_africa_production(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.151";

		String cdmDB = "cdm_production_flora_central_africa";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_pesi_euroMed(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_pesi_euroMed";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_pesi_all(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_pesi_all";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_portal_test_localhost(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_portal_test";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_portal_test_localhost2(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_portal_test2";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_local_cichorieae(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_cichorieae";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_local_dipera(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_diptera";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_local_palmae(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_palmae";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_local_globis(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_globis";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_local_cichorieae_d(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_cichorieae_d";

		String cdmUserName = "root";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_local_postgres_CdmTest(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "CdmTest";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_local_tdwg2010(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_tdwg2010";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource NULL(){

		return null;

	}

	public static ICdmDataSource localH2(){

		return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");

	}

	public static ICdmDataSource localH2(String database, String username, String filePath){

		return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);

	}

	public static ICdmDataSource localH2Salvador(){

		return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");

	}

	public static ICdmDataSource localH2Diptera(){

		return CdmDataSource.NewH2EmbeddedInstance("diptera", "sa", "");

	}

	public static ICdmDataSource localH2Cichorieae(){

		return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");

	}

	public static ICdmDataSource localH2Palmae(){

		return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");

	}

	public static ICdmDataSource localH2EuroMed(){

		return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");

	}

	public static ICdmDataSource localH2Erms(){

		return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");

	}

	public static ICdmDataSource localH2_viola(){

		return CdmDataSource.NewH2EmbeddedInstance("testViola", "sa", "");

	}

	public static ICdmDataSource localH2_LIAS(){

		return CdmDataSource.NewH2EmbeddedInstance("testLIAS", "sa", "");

	}

	public static ICdmDataSource localH2_Erythroneura(){

		return CdmDataSource.NewH2EmbeddedInstance("testErythroneura", "sa", "");

	}

	public static ICdmDataSource localH2_Cicad(){

		return CdmDataSource.NewH2EmbeddedInstance("testCicad", "sa", "");

	}

	public static ICdmDataSource localH2_ValRosandraFRIDAKey(){

		return CdmDataSource.NewH2EmbeddedInstance("testValRosandraFRIDAKey", "sa", "");

	}

	public static ICdmDataSource localH2_FreshwaterAquaticInsects(){

		return CdmDataSource.NewH2EmbeddedInstance("testFreshwaterAquaticInsects", "sa", "");

	}

	public static ICdmDataSource cdm_portal_test_pollux(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.11";

		String cdmDB = "cdm_portal_test";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_cichorieae_PG(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_cichorieae_a"; 

		String cdmUserName = "edit";

		int port = 15432;

		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_cichorieae_a(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_edit_cichorieae_a"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_cichorieae_a_preview(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.201";

		String cdmDB = "cdm_edit_cichorieae_a"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_production_cichorieae(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.151";

		String cdmDB = "cdm_production_cichorieae"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_production_palmae(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.151";

		String cdmDB = "cdm_production_palmae"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource local_cdm_edit_cichorieae_a(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_cichorieae_a"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource local_cdm_edit_cichorieae_b(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_cichorieae_b"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_cichorieae_b(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_edit_cichorieae_b"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_diptera_a(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_edit_diptera_a"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_diptera_b(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_edit_diptera_b"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_palmae_a(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_edit_palmae_a";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_palmae_b(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_edit_palmae_b"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_diptera_preview_B(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_diptera_b"; 

		String cdmUserName = "edit";

		int port = 13306;

		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_cichorieae_preview_B(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_cichorieae_b"; 

		String cdmUserName = "edit";

		int port = 13306;

		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_palmae_preview_A(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_palmae_a"; 

		String cdmUserName = "edit";

		int port = 13306;

		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);

	}		

	public static ICdmDataSource cdm_edit_palmae_preview_B(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_palmae_b"; 

		String cdmUserName = "edit";

		int port = 13306;

		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);

	}

	public static ICdmDataSource cdm_v1_palmae(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_v1_palmae"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_edit_salvador(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_edit_salvador"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_import_cichorieae() {

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_import_cichorieae"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_import_diptera() {

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_import_diptera"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_import_palmae() {

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_import_palmae"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_import_salvador() {

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_import_salvador"; 

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

	public static ICdmDataSource cdm_salvador_production() {

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "salvador_cdm"; 

		String cdmUserName = "salvador";

		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);

	}

//	public static ICdmDataSource LAPTOP_HP(){

//		DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;

//		String cdmServer = "LAPTOPHP";

//		String cdmDB = "cdmTest"; 

//		String cdmUserName = "edit";

//		return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);

//	}

	/**

	 * initializes source

	 * TODO only supports MySQL and PostgreSQL

	 * 

	 * @param dbType

	 * @param cdmServer

	 * @param cdmDB

	 * @param port

	 * @param cdmUserName

	 * @param pwd

	 * @return

	 */

	private static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){

		//establish connection

		pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);

		ICdmDataSource destination;

		if(dbType.equals(DatabaseTypeEnum.MySQL)){

			destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);			

		} else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){

			destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);			

		} else {

			//TODO others

			throw new RuntimeException("Unsupported DatabaseType");

		}

		return destination;

	}

	/**

	 * Accepts a string array and tries to find a method returning an ICdmDataSource with 

	 * the name of the given first string in the array

	 * 

	 * @param args

	 * @return

	 */

	public static ICdmDataSource chooseDestination(String[] args) {

		if(args == null)

			return null;

		if(args.length != 1)

			return null;

		String possibleDestination = args[0];

		Method[] methods = CdmDestinations.class.getMethods();

		for (Method method : methods){

			if(method.getName().equals(possibleDestination)){

				try {

					return (ICdmDataSource) method.invoke(null, null);

				} catch (IllegalArgumentException e) {

					// TODO Auto-generated catch block

					e.printStackTrace();

				} catch (IllegalAccessException e) {

					// TODO Auto-generated catch block

					e.printStackTrace();

				} catch (InvocationTargetException e) {

					// TODO Auto-generated catch block

					e.printStackTrace();

				}

			}

		}

		return null;

	}

}