EDIT

/**

* Copyright (C) 2016 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.greece;

import java.net.URI;

import org.apache.log4j.Logger;

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

import eu.etaxonomy.cdm.database.DatabaseTypeEnum;

import eu.etaxonomy.cdm.database.DbSchemaValidation;

import eu.etaxonomy.cdm.database.ICdmDataSource;

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

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

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

import eu.etaxonomy.cdm.io.media.in.MediaExcelImportConfigurator;

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

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

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

/**

 *

 * Import for Checklist of Greece.

 *

 * https://dev.e-taxonomy.eu/redmine/issues/6286

 *

 * @author a.mueller

 * @since 13.12.2016

 */

public class GreeceImageActivator {

    @SuppressWarnings("unused")

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

    static final ICdmDataSource cdmDestination = CdmDestinations.localH2();

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

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

//    private static final UUID sourceUuid = UUID.fromString("0fd093fe-ffdf-4ace-847b-aad6f0659678");

//    private static final UUID sourceUuid = UUID.fromString("2bb045c8-8b0e-474b-bf60-0d2ddc2a212a");

//    private static final String fileName = "20181218_fog_images.xlsx";

//    private static final String fileName = "20190117_fog_images.xlsx";

    private static final String fileName = "20190124_fog_images.xlsx";

//    NOTE!!: Darauf achten, dass die Header case sensitiv sind und keine Leerzeichen am Ende sein sollten, trim funktioniert seltsamerweise nicht immer

    //check - import

    static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK;

    private void doImport(ICdmDataSource cdmDestination){

        DbSchemaValidation schemaVal = cdmDestination.getDatabaseType() == DatabaseTypeEnum.H2 ? DbSchemaValidation.CREATE : DbSchemaValidation.VALIDATE;

        URI source = greekChecklist();  //just any

        //make Source

        MediaExcelImportConfigurator config = MediaExcelImportConfigurator.NewInstance(source, cdmDestination);

        config.setCheck(check);

        config.setDbSchemaValidation(schemaVal);

        config.setSourceReference(getSourceReference());

        config.setNomenclaturalCode(NomenclaturalCode.ICNAFP);

        CdmDefaultImport<MediaExcelImportConfigurator> myImport = new CdmDefaultImport<>();

        ImportResult result = myImport.invoke(config);

        System.out.println(result.createReport());

    }

    private URI greekChecklist(){

        return URI.create("file:////BGBM-PESIHPC/Greece/images/" + fileName);

    }

    private Reference getSourceReference(){

        Reference result = ReferenceFactory.newDatabase();

        result.setTitle(fileName);

        result.setUuid(sourceUuid);

        return result;

    }

    /**

     * @param args

     */

    public static void main(String[] args) {

        GreeceImageActivator me = new GreeceImageActivator();

        me.doImport(cdmDestination);

        System.exit(0);

    }

}