2 * Copyright (C) 2007 EDIT
3 * European Distributed Institute of Taxonomy
4 * http://www.e-taxonomy.eu
6 * The contents of this file are subject to the Mozilla Public License Version 1.1
7 * See LICENSE.TXT at the top of this package for the full license terms.
10 package eu
.etaxonomy
.cdm
.app
.pesi
;
12 import java
.util
.UUID
;
14 import org
.apache
.log4j
.Logger
;
16 import eu
.etaxonomy
.cdm
.api
.application
.ICdmApplicationConfiguration
;
17 import eu
.etaxonomy
.cdm
.app
.common
.CdmDestinations
;
18 import eu
.etaxonomy
.cdm
.database
.DbSchemaValidation
;
19 import eu
.etaxonomy
.cdm
.database
.ICdmDataSource
;
20 import eu
.etaxonomy
.cdm
.io
.common
.CdmDefaultImport
;
21 import eu
.etaxonomy
.cdm
.io
.common
.IImportConfigurator
.CHECK
;
22 import eu
.etaxonomy
.cdm
.io
.common
.IImportConfigurator
.DO_REFERENCES
;
23 import eu
.etaxonomy
.cdm
.io
.common
.Source
;
24 import eu
.etaxonomy
.cdm
.io
.pesi
.erms
.ErmsImportConfigurator
;
25 import eu
.etaxonomy
.cdm
.model
.common
.ISourceable
;
26 import eu
.etaxonomy
.cdm
.model
.name
.NomenclaturalCode
;
27 import eu
.etaxonomy
.cdm
.model
.name
.ZoologicalName
;
31 * TODO add the following to a wiki page:
32 * 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
33 * you must set the mysql system variable lower_case_table_names = 0 in order to create data base with table compatible names.
39 public class ErmsActivator
{
40 private static final Logger logger
= Logger
.getLogger(ErmsActivator
.class);
42 //database validation status (create, update, validate ...)
43 static DbSchemaValidation hbm2dll
= DbSchemaValidation
.CREATE
;
44 static final Source ermsSource
= PesiSources
.PESI_ERMS();
45 // static final ICdmDataSource cdmDestination = CdmDestinations.cdm_pesi_erms();
46 static final ICdmDataSource cdmDestination
= CdmDestinations
.cdm_test_local_mysql_test();
47 static final UUID treeUuid
= UUID
.fromString("8bd27d84-fd4f-4bfa-bde0-3e6b7311b334");
48 static final UUID featureTreeUuid
= UUID
.fromString("33cbf7a8-0c47-4d47-bd11-b7d77a38d0f6");
49 //static final Object[] featureKeyList = new Integer[]{1,4,5,10,11,12,13,14, 249, 250, 251, 252, 253};
52 static final CHECK check
= CHECK
.CHECK_AND_IMPORT
;
54 static final int partitionSize
= 5000;
58 static final NomenclaturalCode nomenclaturalCode
= NomenclaturalCode
.ICZN
;
61 static final boolean ignoreNull
= true;
63 // ***************** ALL ************************************************//
66 static final DO_REFERENCES doReferences
= DO_REFERENCES
.ALL
;
69 static final boolean doTaxa
= true;
70 static final boolean doRelTaxa
= true;
71 static final boolean doLinks
= true;
72 static final boolean doOccurences
= true;
73 static final boolean doImages
= true;
76 //******************** NONE ***************************************//
80 // static final DO_REFERENCES doReferences = DO_REFERENCES.NONE;
83 // static final boolean doTaxa = false;
84 // static final boolean doRelTaxa = false;
85 // static final boolean doLinks = false;
86 // static final boolean doOccurences = false;
93 public static void main(String
[] args
) {
94 System
.out
.println("Start import from ("+ ermsSource
.getDatabase() + ") ...");
97 Source source
= ermsSource
;
98 ICdmDataSource destination
= CdmDestinations
.chooseDestination(args
) != null ? CdmDestinations
.chooseDestination(args
) : cdmDestination
;
100 ErmsImportConfigurator ermsImportConfigurator
= ErmsImportConfigurator
.NewInstance(source
, destination
);
102 ermsImportConfigurator
.setClassificationUuid(treeUuid
);
103 ermsImportConfigurator
.setNomenclaturalCode(nomenclaturalCode
);
105 ermsImportConfigurator
.setIgnoreNull(ignoreNull
);
106 ermsImportConfigurator
.setDoReferences(doReferences
);
108 ermsImportConfigurator
.setDoTaxa(doTaxa
);
109 ermsImportConfigurator
.setDoRelTaxa(doRelTaxa
);
110 ermsImportConfigurator
.setDoLinks(doLinks
);
111 ermsImportConfigurator
.setDoOccurrence(doOccurences
);
112 ermsImportConfigurator
.setDbSchemaValidation(hbm2dll
);
114 ermsImportConfigurator
.setCheck(check
);
115 ermsImportConfigurator
.setRecordsPerTransaction(partitionSize
);
118 CdmDefaultImport
<ErmsImportConfigurator
> ermsImport
= new CdmDefaultImport
<ErmsImportConfigurator
>();
119 ermsImport
.invoke(ermsImportConfigurator
);
121 if (ermsImportConfigurator
.getCheck().equals(CHECK
.CHECK_AND_IMPORT
) || ermsImportConfigurator
.getCheck().equals(CHECK
.IMPORT_WITHOUT_CHECK
) ){
122 ICdmApplicationConfiguration app
= ermsImport
.getCdmAppController();
123 ISourceable obj
= app
.getCommonService().getSourcedObjectByIdInSource(ZoologicalName
.class, "1000027", null);
126 // //make feature tree
127 // FeatureTree tree = TreeCreator.flatTree(featureTreeUuid, ermsImportConfigurator.getFeatureMap(), featureKeyList);
128 // app = ermsImport.getCdmAppController();
129 // app.getFeatureTreeService().saveOrUpdate(tree);
131 System
.out
.println("End import from ("+ source
.getDatabase() + ")...");