EDIT

/**

* Copyright (C) 2007 EDIT

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

*/

 */

public class CyprusAltitudeActivator {

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

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

	static DbSchemaValidation hbm2dll = DbSchemaValidation.VALIDATE;

//	static final URI source = cyprus_distribution();

	static final URI source = cyprus_altitude();

	static final ICdmDataSource cdmDestination = CdmDestinations.localH2();

//	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_mysql_test();

//	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_cyprus_dev();

//	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_cyprus_production();

	//feature tree uuid

	public static final UUID featureTreeUuid = UUID.fromString("14d1e912-5ec2-4d10-878b-828788b70a87");

	//classification

	static final UUID classificationUuid = UUID.fromString("0c2b5d25-7b15-4401-8b51-dd4be0ee5cab");

	private static final String sourceReferenceTitle = "Cyprus Excel Altitude Import";

	//TODO move to Feature vocabulary

	private static final UUID uuidAltitudeFeature = UUID.fromString("1a28ed59-e15f-4001-b5c2-ea89f0012671");

	//check - import

	static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK;

	private void doImport(ICdmDataSource cdmDestination){

		ArrayList<HashMap<String, String>> excel;

		try {

			excel = ExcelUtils.parseXLS(source, "coreTax");

			e.printStackTrace();

			return;

		}

		CdmApplicationController app = CdmIoApplicationController.NewInstance(cdmDestination, hbm2dll);

		Set<TaxonBase> taxaToSave = new HashSet<TaxonBase>();

		TransactionStatus tx = app.startTransaction();

		UUID uuidMikle77 = UUID.fromString("9f5fa7ee-538b-4ae5-bd82-2a9503fea1d6");

		UUID uuidMikle85 = UUID.fromString("994403c4-c400-413d-9a1a-8531a40bfd8c");

		Feature altitudeFeature = (Feature) app.getTermService().find(uuidAltitudeFeature);

		if (altitudeFeature == null){

//			altitudeFeature = Feature.NewInstance("Altitude", "Altitude", "alt.");

//			featureVoc.addTerm(altitudeFeature);

			throw new RuntimeException("Could not find altitudinal range feature");

		}

		MeasurementUnit meter = (MeasurementUnit)app.getTermService().find(UUID.fromString("8bef5055-789c-41e5-bea2-8dc2ea8ecdf6"));

//		NamedArea cyprus = (NamedArea)app.getTermService().find(UUID.fromString("da4cce9a-439b-4cc4-8073-85dc75bae169"));

		int count =1;

		for (HashMap<String, String> row : excel){

			count++;

			UUID baseUuid = makeUuid(row, "uuid");

			UUID acceptedUuid = makeUuid(row, "acceptedNameUuid");

			UUID parentUuid = makeUuid(row, "parentUuid");

//			String altitude = row.get("Altitude-kumuliert");

			String altitudeMin = row.get("Min");

			String altitudeMax = row.get("Max");

			String acceptedName = row.get("AcceptedName");

			String source = row.get("Source");

			if (StringUtils.isBlank(altitudeMin)){

				continue;

			}

			boolean hasAltitude = false;

			Taxon taxon = getTaxon(app, baseUuid, acceptedUuid, parentUuid, acceptedName, count);

			if (taxon != null){

				TaxonDescription desc = getDescription(taxon, sourceRef);

				hasAltitude = makeAltitude(altitudeMin, altitudeMax, altitudeFeature, sourceRef, desc, meter, count);

//				hasAltitude = makeAltitudeOld(altitude, altitudeFeature, sourceRef, desc, meter, count);

				if (hasAltitude){

		}

		app.getTaxonService().saveOrUpdate(taxaToSave);

//		tx.setRollbackOnly();

		app.commitTransaction(tx);

	}

	private Taxon getTaxon(CdmApplicationController app, UUID baseUuid, UUID acceptedUuid, UUID parentUuid, String acceptedName, int row) {

		TaxonBase<?> base = app.getTaxonService().find(baseUuid);

//		TaxonBase<?> parent = app.getTaxonService().find(parentUuid);

		//TODO

		Taxon result = null;

		if (base.isInstanceOf(Taxon.class)){

				}else{

					logger.warn("Synonym relation has changed somehow. Row: " + row +  ", Taxon: " + base.getTitleCache());

				}

			}else{

				logger.warn("Accepted taxon not in classification. Row: " + row +  ", Taxon: " + base.getTitleCache());

			}

		}

		if (result != null){

			if (! result.getName().getTitleCache().equals(acceptedName)){

				logger.warn("AcceptedName and taxon name is not equal in " + row + ".\n" +

						" Taxon    Name: " + result.getName().getTitleCache());

			}

		}

		return result;

	}

//	private static final Pattern altitudePattern = Pattern.compile("\\d{1,4}(-\\d{1,4})?");

		QuantitativeData data = QuantitativeData.NewInstance(altitudeFeature);

		//Meikle

		if (source != null){

			TaxonNameBase<?,?> nameUsedInSource = null;  //TODO

//		//Excel   //excel source not wanted by Ralf

//		TaxonNameBase<?,?> nameUsedInSource = null;  //TODO probably we don't want this

//		data.addSource(OriginalSourceType.Import, String.valueOf(row), "row", getSourceReference(), null, nameUsedInSource, null);

		data.setUnit(meter);

		Integer min = Integer.valueOf(altitudeMin);

		StatisticalMeasurementValue minValue = StatisticalMeasurementValue.NewInstance(StatisticalMeasure.MIN(), min);

		data.addStatisticalValue(minValue);

		Integer max = Integer.valueOf(altitudeMax);

		StatisticalMeasurementValue maxValue = StatisticalMeasurementValue.NewInstance(StatisticalMeasure.MAX(), max);

		data.addStatisticalValue(maxValue);

		desc.addElement(data);

		return true;

	}

//		String altitude = altitudeOrig.trim().replace(" ", "");

//		Matcher matcher = altitudePattern.matcher(altitude);

//		if (matcher.matches()){

//			QuantitativeData data = QuantitativeData.NewInstance(feature);

//			//Meikle

//			if (source != null){

//				TaxonNameBase<?,?> nameUsedInSource = null;  //TODO

//			TaxonNameBase<?,?> nameUsedInSource = null;  //TODO probably we don't want this

//			data.addSource(OriginalSourceType.Import, String.valueOf(row), "row", getSourceReference(), null, nameUsedInSource, null);

//			data.setUnit(meter);

//			String[] split = altitude.split("-");

//

//			Integer min = Integer.valueOf(split[0]);

//		}

//	}

		if (taxon != null){

			//TODO Mikle existiert derzeit nicht also Source

			TaxonDescription desc = TaxonDescription.NewInstance();

			desc.setTitleCache("Import from " + getSourceReference().getTitleCache(), true);

			desc.addSource(OriginalSourceType.PrimaryTaxonomicSource, null, null, sourceRef,null);

			desc.addSource(OriginalSourceType.Import, null, null, getSourceReference(), null);

			return desc;

		}

		return null;

	}

		if(StringUtils.isNotBlank(source)){

			if (source.equals("Meikle 1977")){

				return m77;

//		// TODO Auto-generated method stub

//		HashMap<String, Object> = new HashM

//		row

//	}

		if (sourceReference == null){

			sourceReference = ReferenceFactory.newGeneric();

			sourceReference.setTitleCache(sourceReferenceTitle, true);

		}

		return sourceReference;

	}

	//Cyprus

	public static URI cyprus_altitude() {

		URI sourceUrl;

	private void testMatcher() {

//		makeAltitude("0-4400", null, null);

	}

}