EDIT

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/common/BerlinModelSources.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/common/CdmDestinations.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/common/ImportUtils.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/common/TestDatabase.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/common/TreeCreator.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/ErmsActivator.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/EuroMedActivator.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/FaunaEuropaeaActivator.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/FaunaEuropaeaSources.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/PesiDestinations.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/PesiExportActivator.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/erms/ErmsActivator.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/merging/FaunaEuErmsFindIdenticalNamesActivator.java -text

cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/merging/FaunaEuErmsMergeActivator.java -text

/**

* 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 org.apache.log4j.Logger;

import eu.etaxonomy.cdm.common.AccountStore;

import eu.etaxonomy.cdm.io.common.Source;

public class BerlinModelSources {

	@SuppressWarnings("unused")

	private static final Logger logger = Logger.getLogger(BerlinModelSources.class);

	public static Source euroMed(){

		//	BerlinModel - Euro+Med

		String dbms = Source.SQL_SERVER_2005;

		String strServer = "BGBM42";

		String strDB = "EuroPlusMed_00_Edit";

		int port = 1247;

		String userName = "webUser";

		return  makeSource(dbms, strServer, strDB, port, userName, null);

	}

	public static Source PESI_ERMS(){

		//	BerlinModel - Pesi-ERMS

		String dbms = Source.SQL_SERVER_2005;

		String strServer = "SQL2000Intern\\SQL2005";

		String strDB = "BM_ERMS";

		int port = 1433;

		String userName = "WebUser";

		return  makeSource(dbms, strServer, strDB, port, userName, null);

	}

	/**

	 * Initializes the source.

	 * @param dbms

	 * @param strServer

	 * @param strDB

	 * @param port

	 * @param userName

	 * @param pwd

	 * @return the source

	 */

	private static Source makeSource(String dbms, String strServer, String strDB, int port, String userName, String pwd ){

		//establish connection

		Source source = null;

		source = new Source(dbms, strServer, strDB);

		source.setPort(port);

		pwd = AccountStore.readOrStorePassword(dbms, strServer, userName, pwd);

		source.setUserAndPwd(userName, pwd);

		// write pwd to account store

		return source;

	}

}

/**

* 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);

	/**

	 * 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_test_alex(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "192.168.2.10";

		String cdmDB = "cdm_production_palmae"; 

		String cdmUserName = "edit";

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

	}

	public static ICdmDataSource cdm_test_useSummary(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "localhost";

		String cdmDB = "palmae_2011_07_17"; 

		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_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_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_test_local_mysql_fdac(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "fdac"; 

		String cdmUserName = "edit";

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

	}

	public static ICdmDataSource cdm_test_local_mysql_test(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "test"; 

		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_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_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_ildis_dev(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.201";

		String cdmDB = "cdm_edit_ildis";

		String cdmUserName = "edit";

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

	}

//

//	public static ICdmDataSource cdm_ildis_production(){

//		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

//		String cdmServer = "160.45.63.151";

//		String cdmDB = "cdm_edit_ildis";

//		String cdmUserName = "edit";

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

//	}

	public static ICdmDataSource cdm_cyprus_dev(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.201";

		String cdmDB = "cdm_cyprus";

		String cdmUserName = "edit";

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

	}

	public static ICdmDataSource cdm_cyprus_production(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.151";

		String cdmDB = "cdm_production_cyprus";

		String cdmUserName = "edit";

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

	}

	public static ICdmDataSource cdm_cyprus_production_tunnel(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		int port = 13306;

		String cdmDB = "cdm_production_cyprus";

		String cdmUserName = "edit";

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

	}

	public static ICdmDataSource cdm_cyprus_dev_tunnel(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		int port = 13306;

		String cdmDB = "cdm_cyprus";

		String cdmUserName = "edit";

		return makeDestination(dbType, cdmServer, cdmDB, port, 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";

		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_algaterra_preview(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.201";

		String cdmDB = "cdm_edit_algaterra"; 

		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_cichorieae_preview(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.201";

		String cdmDB = "cdm_edit_cichorieae"; 

		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 cdmServer = "127.0.0.1";

		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 cdm_production_diptera(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "160.45.63.151";

		String cdmDB = "cdm_production_diptera"; 

		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_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_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(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_cichorieae"; 

		String cdmUserName = "edit";

		int port = 13306;

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

	}

	public static ICdmDataSource cdm_edit_palmae_preview(){

		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;

		String cdmServer = "127.0.0.1";

		String cdmDB = "cdm_edit_palmae"; 

		String cdmUserName = "edit";

		int port = 13306;

		return makeDestination(dbType, cdmServer, cdmDB, port, 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_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;

	}

}

/**

* 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 eu.etaxonomy.cdm.common.AccountStore;

import eu.etaxonomy.cdm.io.common.Source;

/**

 * @author a.babadshanjan

 * @created 12.05.2009

 *

 */

public class ImportUtils {

	/**

	 * Initializes the source.

	 * @param dbms

	 * @param strServer

	 * @param strDB

	 * @param port

	 * @param userName

	 * @param pwd

	 * @return the source

	 */

	public static Source makeSource(String dbms, String strServer, String strDB, int port, String userName, String pwd ){

		//establish connection

		Source source = null;

		source = new Source(dbms, strServer, strDB);

		source.setPort(port);

		pwd = AccountStore.readOrStorePassword(dbms, strServer, userName, pwd);

		source.setUserAndPwd(userName, pwd);

		// write pwd to account store

		return source;

	}

}

/**

* Copyright (C) 2008 EDIT

* European Distributed Institute of Taxonomy 

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

*/

package eu.etaxonomy.cdm.app.common;

import java.util.ArrayList;

import java.util.GregorianCalendar;

import java.util.List;

import org.apache.log4j.Logger;

import org.springframework.transaction.TransactionStatus;

import eu.etaxonomy.cdm.api.application.CdmApplicationController;

import eu.etaxonomy.cdm.common.AccountStore;

import eu.etaxonomy.cdm.database.CdmDataSource;

import eu.etaxonomy.cdm.database.DbSchemaValidation;

import eu.etaxonomy.cdm.database.ICdmDataSource;

import eu.etaxonomy.cdm.io.jaxb.DataSet;

import eu.etaxonomy.cdm.model.agent.AgentBase;

import eu.etaxonomy.cdm.model.agent.Institution;

import eu.etaxonomy.cdm.model.agent.InstitutionalMembership;

import eu.etaxonomy.cdm.model.agent.Person;

import eu.etaxonomy.cdm.model.common.AnnotatableEntity;

import eu.etaxonomy.cdm.model.common.DefinedTermBase;

import eu.etaxonomy.cdm.model.common.TimePeriod;

import eu.etaxonomy.cdm.model.common.VersionableEntity;

import eu.etaxonomy.cdm.model.description.Feature;

import eu.etaxonomy.cdm.model.description.IndividualsAssociation;

import eu.etaxonomy.cdm.model.description.QuantitativeData;

import eu.etaxonomy.cdm.model.description.StatisticalMeasure;

import eu.etaxonomy.cdm.model.description.StatisticalMeasurementValue;

import eu.etaxonomy.cdm.model.description.TaxonDescription;

import eu.etaxonomy.cdm.model.description.TaxonInteraction;

import eu.etaxonomy.cdm.model.description.TaxonNameDescription;

import eu.etaxonomy.cdm.model.location.NamedAreaType;

import eu.etaxonomy.cdm.model.location.WaterbodyOrCountry;

import eu.etaxonomy.cdm.model.name.BotanicalName;

import eu.etaxonomy.cdm.model.name.NomenclaturalCode;

import eu.etaxonomy.cdm.model.name.Rank;

import eu.etaxonomy.cdm.model.name.TaxonNameBase;

import eu.etaxonomy.cdm.model.occurrence.Specimen;

import eu.etaxonomy.cdm.model.occurrence.SpecimenOrObservationBase;

import eu.etaxonomy.cdm.model.reference.Reference;

import eu.etaxonomy.cdm.model.reference.ReferenceFactory;

import eu.etaxonomy.cdm.model.taxon.Synonym;

import eu.etaxonomy.cdm.model.taxon.SynonymRelationshipType;

import eu.etaxonomy.cdm.model.taxon.Taxon;

import eu.etaxonomy.cdm.model.taxon.TaxonBase;

import eu.etaxonomy.cdm.model.taxon.TaxonNode;

import eu.etaxonomy.cdm.model.taxon.Classification;

/**

 * @author a.babadshanjan

 * @created 28.10.2008

 */

public class TestDatabase {

	private static final String server = "192.168.2.10";

	private static final String username = "edit";

	private static final Logger logger = Logger.getLogger(TestDatabase.class);

	public static ICdmDataSource CDM_DB(String dbname) {

		logger.info("Setting DB " + dbname);

		String password = AccountStore.readOrStorePassword(dbname, server, username, null);

		ICdmDataSource datasource = CdmDataSource.NewMySqlInstance(server, dbname, username, password, NomenclaturalCode.ICBN);

		return datasource;

	}

    public static CdmApplicationController 

    initDb(ICdmDataSource db, DbSchemaValidation dbSchemaValidation, boolean omitTermLoading) {

		logger.info("Initializing database '" + db.getName() + "'");

		CdmApplicationController appCtrInit = null;

		appCtrInit = CdmApplicationController.NewInstance(db, dbSchemaValidation, omitTermLoading);

		return appCtrInit;

    }

	public static void loadTestData(String dbname, CdmApplicationController appCtr) {

		logger.info("Loading test data into " + dbname);

		TransactionStatus txStatus = appCtr.startTransaction();

		DataSet dataSet = buildDataSet();

		appCtr.getTermService().save(dataSet.getTerms());

		appCtr.getTaxonService().save(dataSet.getTaxonBases());

		appCtr.commitTransaction(txStatus);

		appCtr.close();

    }

	/**

	 * This method constructs a small sample classification to test JAXB marshaling.

	 * The sample tree contains four taxa. The root taxon has two children taxa, and

	 * there is one "free" taxon without a parent and children.

	 */

	private static DataSet buildDataSet() {

		List<AgentBase> agents = new ArrayList<AgentBase>();

	    List<VersionableEntity> agentData = new ArrayList<VersionableEntity>();

	    //List<Agent> agentData = new ArrayList<Agent>();

	    //List<TermBase> terms = new ArrayList<TermBase>();

	    List<DefinedTermBase> terms = new ArrayList<DefinedTermBase>();

	    List<Reference> references = new ArrayList<Reference>();

	    List<TaxonNameBase> taxonomicNames = new ArrayList<TaxonNameBase>();

	    List<TaxonBase> taxonBases = new ArrayList<TaxonBase>();

	    List<Feature> features = new ArrayList<Feature>();

	    Feature feature1 = Feature.BIOLOGY_ECOLOGY();

	    TaxonNameDescription taxNameDescription = TaxonNameDescription.NewInstance();

	    taxNameDescription.addFeature(feature1);

	    QuantitativeData element = QuantitativeData.NewInstance();

	    StatisticalMeasurementValue statisticalValue = StatisticalMeasurementValue.NewInstance();

	    statisticalValue.setType(StatisticalMeasure.MAX());

	    statisticalValue.setValue((float) 2.1);

	    element.addStatisticalValue(statisticalValue);

	    taxNameDescription.addElement(element);

	    SpecimenOrObservationBase specimen = Specimen.NewInstance();

	    specimen.setIndividualCount(12);

	    Feature featureIndAss = Feature.INDIVIDUALS_ASSOCIATION();

	    TaxonNameDescription newTaxNameDesc = TaxonNameDescription.NewInstance();

	    newTaxNameDesc.addFeature(featureIndAss);

	    IndividualsAssociation indAss = IndividualsAssociation.NewInstance();

	    indAss.setAssociatedSpecimenOrObservation(specimen);

	    newTaxNameDesc.addElement(indAss);

//	    List<Synonym> synonyms = new ArrayList<Synonym>();

	    List<AnnotatableEntity> homotypicalGroups;

		Reference citRef, sec;

		BotanicalName name1, name2, name21, nameRoot1, nameFree, synName11, synName12, synName2, synNameFree;

		BotanicalName nameRoot2, nameR2_1, nameR2_2;

		Taxon child1, child2, child21, root1T, root2T, freeT;

		Taxon childR2_1, childR2_2;

		TaxonNode child1Node, child2Node, child21Node, root1TNode, root2TNode, freeTNode;

		TaxonNode childR2_1Node, childR2_2Node;

		Classification taxTree, taxTree2;

		Synonym syn11, syn12, syn2, synFree;

		Rank rankSpecies, rankSubspecies, rankGenus;

		// agents 

		// - persons, institutions 

		Person linne = new Person("Carl", "Linne", "L.");

		linne.setTitleCache("Linne & Karl", true);

		GregorianCalendar birth = new GregorianCalendar(1707, 4, 23);

		GregorianCalendar death = new GregorianCalendar(1778, 0, 10);

		TimePeriod period = TimePeriod.NewInstance(birth, death);

		linne.setLifespan(period);

//		Keyword keyword = Keyword.NewInstance("plantarum", "lat", "");

//		linne.addKeyword(keyword);

		Institution institute = Institution.NewInstance();

		agents.add(linne);

		agents.add(institute);

		// agent data

		// - contacts, addresses, memberships

		//Contact contact1 = new Contact();

		//contact1.setEmail("someone@somewhere.org");

		InstitutionalMembership membership 

		= new InstitutionalMembership(institute, linne, period, "Biodiversity", "Head");

		//agentData.add(contact1);

		agentData.add(membership);

		// terms

		// - ranks, keywords

		rankSpecies = Rank.SPECIES();

		rankSubspecies = Rank.SUBSPECIES();

		rankGenus = Rank.GENUS();

//		terms.add(keyword);

        // taxonomic names

		nameRoot1 = BotanicalName.NewInstance(rankGenus,"Calendula",null,null,null,linne,null,"p.100", null);

		nameRoot1.addDescription(taxNameDescription);

		nameRoot1.addDescription(newTaxNameDesc);

		name1 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"arvensis",null,linne,null,"p.1", null);

		synName11 = BotanicalName.NewInstance(rankSpecies,"Caltha",null,"arvensis",null,linne,null,"p.11", null);

		synName12 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"sancta",null,linne,null,"p.12", null);

		name2 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"lanzae",null,linne,null,"p.2", null);

		synName2 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"echinata",null,linne,null,"p.2", null);

		name21 = BotanicalName.NewInstance(rankSubspecies,"Calendula",null,"lanzea","something",linne,null,"p.1", null);

		//name211 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"lanzea",null,linne,null,"p.1", null);

		//name212 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"lanzea",null,linne,null,"p.1", null);

		nameRoot2 = 

			BotanicalName.NewInstance(rankGenus,"Sonchus",null,null,null,linne,null,"p.200", null);

		nameR2_1 = BotanicalName.NewInstance(rankSpecies,"Sonchus",null,"child1",null,linne,null,"p.1", null);

		nameR2_2 = BotanicalName.NewInstance(rankSpecies,"Sonchus",null,"child2",null,linne,null,"p.2", null);

		nameFree = BotanicalName.NewInstance(rankSpecies,"Cichorium",null,"intybus",null,linne,null,"p.200", null);

		synNameFree = BotanicalName.NewInstance(rankSpecies,"Cichorium",null,"balearicum",null,linne,null,"p.2", null);

		taxonomicNames.add(nameRoot1);

		taxonomicNames.add(name1);

		taxonomicNames.add(synName11);

		taxonomicNames.add(synName12);

		taxonomicNames.add(name2);

		taxonomicNames.add(name21);

		taxonomicNames.add(synName2);

		taxonomicNames.add(nameFree);

		taxonomicNames.add(synNameFree);

		taxonomicNames.add(nameRoot2);

        // references

		ReferenceFactory refFactory = ReferenceFactory.newInstance();

		sec = refFactory.newBook();

		sec.setAuthorTeam(linne);

		sec.setTitleCache("Plant Specification & Taxonomy", true);

		references.add(sec);

		citRef = refFactory.newDatabase();

		citRef.setAuthorTeam(linne);

		citRef.setTitleCache("BioCASE", true);

		references.add(citRef);

		// taxa

		root1T = Taxon.NewInstance(nameRoot1, sec);

		root2T = Taxon.NewInstance(nameRoot2, sec);

		freeT = Taxon.NewInstance(nameFree, sec);

		child1 = Taxon.NewInstance(name1, sec);

		child2 = Taxon.NewInstance(name2, sec);

		child21 = Taxon.NewInstance(name21, sec);

		childR2_1 = Taxon.NewInstance(nameR2_1, sec);

		childR2_2 = Taxon.NewInstance(nameR2_2, sec);

		//TaxonInteractions

		TaxonInteraction descBase = TaxonInteraction.NewInstance();

		descBase.setTaxon2(root1T);

		Feature hostplant = Feature.HOSTPLANT();

		descBase.setFeature(hostplant);

		TaxonDescription taxDesc = TaxonDescription.NewInstance();

		taxDesc.addElement(descBase);

		root2T.addDescription(taxDesc);

		//locations

		taxDesc = TaxonDescription.NewInstance();

		Feature locationFeature = Feature.DISTRIBUTION();

		//locationFeature.

		WaterbodyOrCountry area = WaterbodyOrCountry.NewInstance("", "locationTest", null);

		area.setType(NamedAreaType.NATURAL_AREA());

		//WaterbodyOrCountry woC= WaterbodyOrCountry.NewInstance();

		area.addWaterbodyOrCountry(WaterbodyOrCountry.AFGHANISTAN());

		taxDesc.addGeoScope(area);

		taxDesc.addFeature(locationFeature);

		root1T.addDescription(taxDesc);

		// synonyms

		synFree = Synonym.NewInstance(synNameFree, sec);

		syn11 = Synonym.NewInstance(synName11, sec);

		syn12 = Synonym.NewInstance(synName12, sec);

		syn2 = Synonym.NewInstance(synName2, sec);

		child1.addSynonym(syn11, SynonymRelationshipType.HOMOTYPIC_SYNONYM_OF());

		child1.addSynonym(syn12, SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF());

		child2.addSynonym(syn2, SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF());

		freeT.addSynonym(synFree, SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF());

		taxonBases.add(synFree);

		taxonBases.add(syn11);

		taxonBases.add(syn12);

		taxonBases.add(syn2);

		// taxonomic children

		//TODO: Adapt to classification

		taxTree = Classification.NewInstance("TestTree");

		root1TNode = taxTree.addChildTaxon(root1T, sec, null, null);

		child1Node = root1TNode.addChildTaxon(child1, null, null, null);

		child2Node = root1TNode.addChildTaxon(child2, null, null, null);

		child21Node = child2Node.addChildTaxon(child21, null, null, null);

		taxTree2 = Classification.NewInstance("TestTree2");

		root2TNode = taxTree2.addChildTaxon(root2T, sec, null, null);

		root2TNode.addChildTaxon(child1, sec, "p.1010", syn11);

		root2TNode.addChildTaxon(child2, null, null, null);

		/*

		root1T.addTaxonomicChild(child1, sec, "p.1010");

		root1T.addTaxonomicChild(child2, sec, "p.1020");

		child2.addTaxonomicChild(child21, sec, "p.2000");

		root2T.addTaxonomicChild(child1, sec, "p.1010");

		root2T.addTaxonomicChild(child2, sec, "p.1020");

		*/

		//

		taxonBases.add(root1T);

		taxonBases.add(root2T);

		taxonBases.add(freeT);

		taxonBases.add(child1);

		taxonBases.add(child2);

		taxonBases.add(child21);

		taxonBases.add(childR2_1);

		taxonBases.add(childR2_2);

		DataSet dataSet = new DataSet();

		logger.warn("WARNING: TestDatabase has been commented in parts. Mainly, must be adapted to classification.");

		dataSet.setTerms(terms);

		dataSet.setAgents(agents);

//		dataSet.setAgentData(agentData); //TODO

		dataSet.setReferences(references);

		dataSet.setTaxonomicNames(taxonomicNames);

		dataSet.setTaxonBases(taxonBases);

		return dataSet;

	}

}

/**

* 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.util.HashMap;

import java.util.Map;

import java.util.UUID;

import org.apache.log4j.Logger;

import eu.etaxonomy.cdm.model.description.Feature;

import eu.etaxonomy.cdm.model.description.FeatureNode;

import eu.etaxonomy.cdm.model.description.FeatureTree;

/**

 * @author a.mueller

 * @created 03.07.2008

 * @version 1.0

 */

public class TreeCreator {

	@SuppressWarnings("unused")

	private static final Logger logger = Logger.getLogger(TreeCreator.class);

	public static FeatureTree flatTree(UUID featureTreeUuid, Map<Integer, Feature> featureMap, Object[] featureKeyList){

		FeatureTree result = FeatureTree.NewInstance(featureTreeUuid);

		FeatureNode root = result.getRoot();

		for (Object featureKey : featureKeyList){

			Feature feature = featureMap.get(featureKey);

			if (feature != null){

				FeatureNode child = FeatureNode.NewInstance(feature);

				root.addChild(child);	

			}

		}

		return result;

	}

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		Map<Integer, Feature>  map = new HashMap<Integer, Feature>(null);

		map.put(1, Feature.DISTRIBUTION());

		map.put(2, Feature.ECOLOGY());

		Object[] strFeatureList = new Integer[]{1,2}; 

		FeatureTree tree = TreeCreator.flatTree(UUID.randomUUID(), map, strFeatureList);

		System.out.println(tree.getRootChildren());

	}

}

/**

* 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.pesi;

import java.util.UUID;

import org.apache.log4j.Logger;

import eu.etaxonomy.cdm.api.application.ICdmApplicationConfiguration;

import eu.etaxonomy.cdm.app.common.CdmDestinations;

import eu.etaxonomy.cdm.database.DbSchemaValidation;

import eu.etaxonomy.cdm.database.ICdmDataSource;

import eu.etaxonomy.cdm.io.berlinModel.in.BerlinModelImportConfigurator;

import eu.etaxonomy.cdm.io.common.CdmDefaultImport;

import eu.etaxonomy.cdm.io.common.IImportConfigurator.CHECK;

import eu.etaxonomy.cdm.io.common.IImportConfigurator.DO_REFERENCES;

import eu.etaxonomy.cdm.io.common.Source;

import eu.etaxonomy.cdm.model.common.ISourceable;

import eu.etaxonomy.cdm.model.name.NomenclaturalCode;

import eu.etaxonomy.cdm.model.name.ZoologicalName;

/**

 * TODO add the following to a wiki page:

 * HINT: If you are about to import into a mysql data base running under windows and if you wish to dump and restore the resulting data base under another operation systen 

 * you must set the mysql system variable lower_case_table_names = 0 in order to create data base with table compatible names.

 * 

 * 

 * @author a.mueller

 *

 */

public class ErmsActivator {

	private static final Logger logger = Logger.getLogger(ErmsActivator.class);

	//database validation status (create, update, validate ...)

	static DbSchemaValidation hbm2dll = DbSchemaValidation.CREATE;

	static final Source berlinModelSource = FaunaEuropaeaSources.PESI_ERMS();

	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_pesi_erms();

	static final UUID treeUuid = UUID.fromString("8bd27d84-fd4f-4bfa-bde0-3e6b7311b334");

	static final int sourceSecId = 500000;

	static final UUID featureTreeUuid = UUID.fromString("33cbf7a8-0c47-4d47-bd11-b7d77a38d0f6");

	static final Object[] featureKeyList = new Integer[]{1,4,5,10,11,12,13,14, 249, 250, 251, 252, 253}; 

	//check - import

	static final CHECK check = CHECK.CHECK_AND_IMPORT;

	//NomeclaturalCode

	static final NomenclaturalCode nomenclaturalCode = NomenclaturalCode.ICZN;

	//ignore null

	static final boolean ignoreNull = true;

// ***************** ALL ************************************************//

	//authors

	static final boolean doAuthors = true;

	//references

	static final DO_REFERENCES doReferences =  DO_REFERENCES.CONCEPT_REFERENCES;

	//names

	static final boolean doTaxonNames = false;

	static final boolean doRelNames = true;

	static final boolean doNameStatus = true;

	static final boolean doTypes = true;

	static final boolean doNameFacts = true;

	//taxa

	static final boolean doTaxa = true;

	static final boolean doRelTaxa = true;

	static final boolean doFacts = true;

	static final boolean doOccurences = false;

//******************** NONE ***************************************//

//	//authors

//	static final boolean doAuthors = true;

//	//references

//	static final DO_REFERENCES doReferences =  DO_REFERENCES.NONE;

//	//names

//	static final boolean doTaxonNames = false;

//	static final boolean doRelNames = false;

//	static final boolean doNameStatus = false;

//	static final boolean doTypes = false;

//	static final boolean doNameFacts = false;

//	

//	//taxa

//	static final boolean doTaxa = true;

//	static final boolean doRelTaxa = false;

//	static final boolean doFacts = false;

//	static final boolean doOccurences = false;

//	

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		System.out.println("Start import from BerlinModel("+ berlinModelSource.getDatabase() + ") ...");

		//make BerlinModel Source

		Source source = berlinModelSource;

		ICdmDataSource destination = CdmDestinations.chooseDestination(args) != null ? CdmDestinations.chooseDestination(args) : cdmDestination;

		BerlinModelImportConfigurator bmImportConfigurator = BerlinModelImportConfigurator.NewInstance(source,  destination);

		bmImportConfigurator.setClassificationUuid(treeUuid);

		bmImportConfigurator.setSourceSecId(sourceSecId);

		bmImportConfigurator.setNomenclaturalCode(nomenclaturalCode);

		bmImportConfigurator.setIgnoreNull(ignoreNull);

		bmImportConfigurator.setDoAuthors(doAuthors);

		bmImportConfigurator.setDoReferences(doReferences);

		bmImportConfigurator.setDoTaxonNames(doTaxonNames);

		bmImportConfigurator.setDoRelNames(doRelNames);

		bmImportConfigurator.setDoNameStatus(doNameStatus);

		bmImportConfigurator.setDoTypes(doTypes);

		bmImportConfigurator.setDoNameFacts(doNameFacts);

		bmImportConfigurator.setDoTaxa(doTaxa);

		bmImportConfigurator.setDoRelTaxa(doRelTaxa);

		bmImportConfigurator.setDoFacts(doFacts);

		bmImportConfigurator.setDoOccurrence(doOccurences);

		bmImportConfigurator.setDbSchemaValidation(hbm2dll);

		bmImportConfigurator.setCheck(check);

		// invoke import

		CdmDefaultImport<BerlinModelImportConfigurator> bmImport = new CdmDefaultImport<BerlinModelImportConfigurator>();

		bmImport.invoke(bmImportConfigurator);

		if (bmImportConfigurator.getCheck().equals(CHECK.CHECK_AND_IMPORT)  || bmImportConfigurator.getCheck().equals(CHECK.IMPORT_WITHOUT_CHECK)    ){

			ICdmApplicationConfiguration app = bmImport.getCdmAppController();

			ISourceable obj = app.getCommonService().getSourcedObjectByIdInSource(ZoologicalName.class, "1000027", null);

			logger.info(obj);

//			//make feature tree

//			FeatureTree tree = TreeCreator.flatTree(featureTreeUuid, bmImportConfigurator.getFeatureMap(), featureKeyList);

//			app = bmImport.getCdmAppController();

//			app.getFeatureTreeService().saveOrUpdate(tree);

		}

		System.out.println("End import from BerlinModel ("+ source.getDatabase() + ")...");

	}

}

/**

* 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.pesi;

import java.util.UUID;

import org.apache.log4j.Logger;

import eu.etaxonomy.cdm.api.application.ICdmApplicationConfiguration;

import eu.etaxonomy.cdm.app.common.BerlinModelSources;

import eu.etaxonomy.cdm.app.common.CdmDestinations;

import eu.etaxonomy.cdm.app.common.TreeCreator;

import eu.etaxonomy.cdm.database.DbSchemaValidation;

import eu.etaxonomy.cdm.database.ICdmDataSource;

import eu.etaxonomy.cdm.io.berlinModel.in.BerlinModelImportConfigurator;

import eu.etaxonomy.cdm.io.common.CdmDefaultImport;

import eu.etaxonomy.cdm.io.common.IImportConfigurator.CHECK;

import eu.etaxonomy.cdm.io.common.IImportConfigurator.DO_REFERENCES;

import eu.etaxonomy.cdm.io.common.IImportConfigurator.EDITOR;

import eu.etaxonomy.cdm.io.common.Source;

import eu.etaxonomy.cdm.model.description.Feature;

import eu.etaxonomy.cdm.model.description.FeatureNode;

import eu.etaxonomy.cdm.model.description.FeatureTree;

import eu.etaxonomy.cdm.model.name.NomenclaturalCode;

/**

 * TODO add the following to a wiki page:

 * HINT: If you are about to import into a mysql data base running under windows and if you wish to dump and restore the resulting data bas under another operation systen 

 * you must set the mysql system variable lower_case_table_names = 0 in order to create data base with table compatible names.

 * 

 * 

 * @author a.mueller

 *

 */

public class EuroMedActivator {

	@SuppressWarnings("unused")

	private static final Logger logger = Logger.getLogger(EuroMedActivator.class);

	//database validation status (create, update, validate ...)

	static DbSchemaValidation hbm2dll = DbSchemaValidation.CREATE;

	static final Source berlinModelSource = BerlinModelSources.euroMed();

//	static final Source berlinModelSource = BerlinModelSources.EDIT_CICHORIEAE();

//	static final Source berlinModelSource = BerlinModelSources.EDIT_Diptera();

	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_andreasM();

	static final int sourceSecId = 7000000; //500000

	static final UUID classificationUuid = UUID.fromString("314a68f9-8449-495a-91c2-92fde8bcf344");

	static final UUID featureTreeUuid = UUID.fromString("6a5e1c2b-ec0d-46c8-9c7d-a2059267ffb7");

	static final Object[] featureKeyList = new Integer[]{1, 31, 4, 98, 41}; 	

	// set to zero for unlimited nameFacts

	static final int maximumNumberOfNameFacts = 0;

	static final int partitionSize = 2000;

	//check - import

	static final CHECK check = CHECK.CHECK_AND_IMPORT;

	//editor - import

	static final EDITOR editor = EDITOR.EDITOR_AS_EDITOR;

	//NomeclaturalCode

	static final NomenclaturalCode nomenclaturalCode = NomenclaturalCode.ICBN;

	//ignore null

	static final boolean ignoreNull = true;

	static boolean useClassification = true;

// **************** ALL *********************	

//

	static final boolean doUser = true;

	//authors

	static final boolean doAuthors = true;

	//references

	static final DO_REFERENCES doReferences =  DO_REFERENCES.ALL;

	//names

	static final boolean doTaxonNames = true;

	static final boolean doRelNames = true;

	static final boolean doNameStatus = true;

	static final boolean doTypes = true;

	static final boolean doNameFacts = true;

	//taxa

	static final boolean doTaxa = true;

	static final boolean doRelTaxa = true;

	static final boolean doFacts = true;

	static final boolean doOccurences = true;

	static final boolean doCommonNames = true;

	//etc.

	static final boolean doMarker = true;

// **************** SELECTED *********************

//	static final boolean doUser = true;

//	//authors

//	static final boolean doAuthors = false;

//	//references

//	static final DO_REFERENCES doReferences =  DO_REFERENCES.NONE;

//	//names

//	static final boolean doTaxonNames = false;

//	static final boolean doRelNames = false;

//	static final boolean doNameStatus = false;

//	static final boolean doTypes = false;

//	static final boolean doNameFacts = false;

//	

//	//taxa 

//	static final boolean doTaxa = false;

//	static final boolean doRelTaxa = false;

//	static final boolean doFacts = false;

//	static final boolean doOccurences = false;

//	

//	//etc.

//	static final boolean doMarker = false;

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		System.out.println("Start import from BerlinModel("+ berlinModelSource.getDatabase() + ") to " + cdmDestination.getDatabase() + " ...");

		//make BerlinModel Source

		Source source = berlinModelSource;

		ICdmDataSource destination = CdmDestinations.chooseDestination(args) != null ? CdmDestinations.chooseDestination(args) : cdmDestination;

		BerlinModelImportConfigurator bmImportConfigurator = BerlinModelImportConfigurator.NewInstance(source,  destination);