EDIT

/**

* Copyright (C) 2009 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.io.sdd.in;

import static org.junit.Assert.assertEquals;

import static org.junit.Assert.assertNotNull;

import java.io.File;

import java.io.FileNotFoundException;

import java.net.MalformedURLException;

import java.net.URI;

import java.net.URISyntaxException;

import java.net.URL;

import java.sql.SQLException;

import org.apache.log4j.Level;

import org.junit.Assert;

import org.junit.Before;

import org.junit.Ignore;

import org.junit.Test;

import org.unitils.spring.annotation.SpringBeanByType;

import eu.etaxonomy.cdm.api.service.IClassificationService;

import eu.etaxonomy.cdm.api.service.INameService;

import eu.etaxonomy.cdm.api.service.ITaxonService;

import eu.etaxonomy.cdm.common.CdmUtils;

import eu.etaxonomy.cdm.database.CdmDataSource;

import eu.etaxonomy.cdm.database.CdmPersistentDataSource;

import eu.etaxonomy.cdm.database.DataSourceNotFoundException;

import eu.etaxonomy.cdm.database.ICdmDataSource;

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

import eu.etaxonomy.cdm.io.sdd.out.SDDCdmExporter;

import eu.etaxonomy.cdm.io.sdd.out.SDDExportConfigurator;

import eu.etaxonomy.cdm.io.sdd.out.SDDExportState;

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

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

import eu.etaxonomy.cdm.test.integration.CdmTransactionalIntegrationTest;

/**

 * @author l.morris

 * @since 14 Nov 2012

 *

 */

public class SDDImportExportTest extends CdmTransactionalIntegrationTest {

    @SpringBeanByType

    SDDImport sddImport;

    private SDDImportConfigurator importConfigurator;

    @SpringBeanByType

    SDDCdmExporter sddCdmExporter;

    @SpringBeanByType

    INameService nameService;

    @SpringBeanByType

    ITaxonService taxonService;

    @SpringBeanByType

    IClassificationService classificationService;

    private IExportConfigurator exportConfigurator;

    @Before

    @Ignore

    //calling before testInit testDoInvoke. db stuff into devlopeACustomDatabase

    //setDefaultRollback

    public void setUp() throws URISyntaxException, MalformedURLException {

        // input data

        //URL url = this.getClass().getResource("/eu/etaxonomy/cdm/io/sdd/SDDImportTest-input3.xml");

        URL url = this.getClass().getResource("/eu/etaxonomy/cdm/io/sdd/ant.sdd.xml");

        URI uri = url.toURI();

        // export data

        String exporturlStr = "SDDImportExportTest.sdd.xml";

        File f = new File(exporturlStr);

        exporturlStr = f.toURI().toURL().toString();

        logger.debug("The exporturlStr is " + exporturlStr);

        // URI.create("file:///C:/localCopy/Data/xper/Cichorieae-DA2.sdd.xml");

        Assert.assertNotNull(url);

        ICdmDataSource loadedDataSource = null;

        /*

         * enable below line if you wish to use a custom data source

         */

        //loadedDataSource = customDataSource();

        importConfigurator = SDDImportConfigurator.NewInstance(uri, loadedDataSource);

        exportConfigurator = SDDExportConfigurator.NewInstance(loadedDataSource, exporturlStr);

    }

    @Test

    @Ignore

    public void testDoInvoke() {

        assertNotNull("sddImport should not be null", sddImport);

        assertNotNull("sddCdmExporter should not be null", sddCdmExporter);

        setDefaultRollback(false);

        //printDataSet(System.err, new String[]{"DEFINEDTERMBASE"});

        sddImport.doInvoke(new SDDImportState(importConfigurator));

        //logger.setLevel(Level.DEBUG);

        commitAndStartNewTransaction(new String[]{"DEFINEDTERMBASE"});

        logger.setLevel(Level.DEBUG);

        logger.debug("Name count: " + (nameService.count(null)));

        logger.debug("Classification count: " + (classificationService.count(Classification.class)));

        logger.debug("Taxon count: " + (taxonService.count(Taxon.class)));

        //sddCdmExporter.doInvoke(null);

        sddCdmExporter.doInvoke(new SDDExportState((SDDExportConfigurator) exportConfigurator));

        assertEquals("Number of TaxonNames should be 1", 1, nameService.count(null));

    }

    /**

     * @param loadedDataSource

     * @return

     */

    private ICdmDataSource customDataSource() {

         CdmPersistentDataSource loadedDataSource = null;

        //ICdmDataSource dataSource = CdmDataSource.NewMySqlInstance("192.168.2.10", "cdm_test_niels2", 3306, "edit", password, code);

        String dataSourceName = "cdm_test2";

        String password = CdmUtils.readInputLine("Password: ");

        ICdmDataSource dataSource = CdmDataSource.NewMySqlInstance("127.0.0.1", "cdm_test2", 3306, "ljm", password);

        //ICdmDataSource dataSource = CdmDataSource.NewMySqlInstance("160.45.63.201", "cdm_test", 3306, "edit", password);

        boolean connectionAvailable;

        try {

            connectionAvailable = dataSource.testConnection();

            logger.debug("Is connection avaiable " + connectionAvailable);

            Assert.assertTrue("Testdatabase is not available", connectionAvailable);

        } catch (ClassNotFoundException e1) {

            e1.printStackTrace();

        } catch (SQLException e1) {

            e1.printStackTrace();

        }

        CdmPersistentDataSource.save(dataSourceName, dataSource);

        try {

            loadedDataSource = CdmPersistentDataSource.NewInstance(dataSourceName);

//			CdmApplicationController.NewInstance(loadedDataSource, DbSchemaValidation.CREATE);

//            NomenclaturalCode loadedCode = loadedDataSource.getNomenclaturalCode();

//

//            Assert.assertEquals(NomenclaturalCode.ICNAFP, loadedCode);

        } catch (DataSourceNotFoundException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

        //return loadedDataSource;

        return dataSource;

    }

    @Override

    public void createTestDataSet() throws FileNotFoundException {}

}