import org.apache.log4j.Logger;
import eu.etaxonomy.cdm.app.common.CdmDestinations;
-import eu.etaxonomy.cdm.app.util.TestDatabase;
import eu.etaxonomy.cdm.database.DatabaseTypeEnum;
import eu.etaxonomy.cdm.database.DbSchemaValidation;
import eu.etaxonomy.cdm.database.ICdmDataSource;
private void doImport(ICdmDataSource cdmDestination) throws FileNotFoundException{
+ /*
+ * Source file:
+ * https://github.com/biosemantics/glossaries/blob/925f2c1691ed00bf2b9a9cd7f83609cffae47145/Plant/0.11/Plant_glossary_term_category.csv
+ *
+ * Cleaning data:
+ * - remove all comments in csv file
+ * - fix "coetaneouser" by adding missing paramater for "remarks" -> "active"
+ */
FileInputStream inStream = new FileInputStream("/home/pplitzner/plantglossary.csv");
PlantGlossaryCsvImportConfigurator config = PlantGlossaryCsvImportConfigurator.NewInstance(new InputStreamReader(inStream), cdmDestination);
config.setCheck(CHECK.IMPORT_WITHOUT_CHECK);
+ config.setDbSchemaValidation(DbSchemaValidation.VALIDATE);
- CdmDefaultImport<PlantGlossaryCsvImportConfigurator> myImport = new CdmDefaultImport<PlantGlossaryCsvImportConfigurator>();
+ CdmDefaultImport<PlantGlossaryCsvImportConfigurator> myImport = new CdmDefaultImport<>();
System.out.println("Start import from ("+ cdmDestination.toString() + ") ...");
myImport.invoke(config);
}
public static void main(String[] args) {
- PlantGlossaryActivator me = new PlantGlossaryActivator();
+ PlantGlossaryActivator activator = new PlantGlossaryActivator();
try {
- ICdmDataSource dataSource = CdmDestinations.makeDestination(DatabaseTypeEnum.MySQL, "127.0.0.1", "additivity", 3306, "root", "root");
- TestDatabase.initDb(dataSource, DbSchemaValidation.VALIDATE, true);
- me.doImport(dataSource);
+ ICdmDataSource dataSource = CdmDestinations.makeDestination(DatabaseTypeEnum.MySQL, "127.0.0.1", "empty", 3306, "root", null);
+ activator.doImport(dataSource);
} catch (FileNotFoundException e) {
e.printStackTrace();
}