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
.CdmApplicationController
;
17 import eu
.etaxonomy
.cdm
.app
.berlinModelImport
.BerlinModelSources
;
18 import eu
.etaxonomy
.cdm
.app
.common
.CdmDestinations
;
19 import eu
.etaxonomy
.cdm
.database
.DbSchemaValidation
;
20 import eu
.etaxonomy
.cdm
.database
.ICdmDataSource
;
21 import eu
.etaxonomy
.cdm
.io
.berlinModel
.in
.BerlinModelImportConfigurator
;
22 import eu
.etaxonomy
.cdm
.io
.common
.CdmDefaultImport
;
23 import eu
.etaxonomy
.cdm
.io
.common
.Source
;
24 import eu
.etaxonomy
.cdm
.io
.common
.IImportConfigurator
.CHECK
;
25 import eu
.etaxonomy
.cdm
.io
.common
.IImportConfigurator
.DO_REFERENCES
;
26 import eu
.etaxonomy
.cdm
.model
.common
.ISourceable
;
27 import eu
.etaxonomy
.cdm
.model
.name
.NomenclaturalCode
;
28 import eu
.etaxonomy
.cdm
.model
.name
.ZoologicalName
;
32 * TODO add the following to a wiki page:
33 * 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
34 * you must set the mysql system variable lower_case_table_names = 0 in order to create data base with table compatible names.
40 public class ErmsActivator
{
41 private static final Logger logger
= Logger
.getLogger(ErmsActivator
.class);
43 //database validation status (create, update, validate ...)
44 static DbSchemaValidation hbm2dll
= DbSchemaValidation
.CREATE
;
45 static final Source berlinModelSource
= FaunaEuropaeaSources
.PESI_ERMS();
46 static final ICdmDataSource cdmDestination
= CdmDestinations
.cdm_pesi_erms();
47 static final UUID treeUuid
= UUID
.fromString("8bd27d84-fd4f-4bfa-bde0-3e6b7311b334");
48 static final int sourceSecId
= 500000;
49 static final UUID featureTreeUuid
= UUID
.fromString("33cbf7a8-0c47-4d47-bd11-b7d77a38d0f6");
50 static final Object
[] featureKeyList
= new Integer
[]{1,4,5,10,11,12,13,14, 249, 250, 251, 252, 253};
53 static final CHECK check
= CHECK
.CHECK_AND_IMPORT
;
57 static final NomenclaturalCode nomenclaturalCode
= NomenclaturalCode
.ICZN
;
60 static final boolean ignoreNull
= true;
62 // ***************** ALL ************************************************//
65 static final boolean doAuthors
= true;
67 static final DO_REFERENCES doReferences
= DO_REFERENCES
.CONCEPT_REFERENCES
;
69 static final boolean doTaxonNames
= false;
70 static final boolean doRelNames
= true;
71 static final boolean doNameStatus
= true;
72 static final boolean doTypes
= true;
73 static final boolean doNameFacts
= true;
76 static final boolean doTaxa
= true;
77 static final boolean doRelTaxa
= true;
78 static final boolean doFacts
= true;
79 static final boolean doOccurences
= false;
82 //******************** NONE ***************************************//
85 // static final boolean doAuthors = true;
87 // static final DO_REFERENCES doReferences = DO_REFERENCES.NONE;
89 // static final boolean doTaxonNames = false;
90 // static final boolean doRelNames = false;
91 // static final boolean doNameStatus = false;
92 // static final boolean doTypes = false;
93 // static final boolean doNameFacts = false;
96 // static final boolean doTaxa = true;
97 // static final boolean doRelTaxa = false;
98 // static final boolean doFacts = false;
99 // static final boolean doOccurences = false;
106 public static void main(String
[] args
) {
107 System
.out
.println("Start import from BerlinModel("+ berlinModelSource
.getDatabase() + ") ...");
109 //make BerlinModel Source
110 Source source
= berlinModelSource
;
111 ICdmDataSource destination
= CdmDestinations
.chooseDestination(args
) != null ? CdmDestinations
.chooseDestination(args
) : cdmDestination
;
113 BerlinModelImportConfigurator bmImportConfigurator
= BerlinModelImportConfigurator
.NewInstance(source
, destination
);
115 bmImportConfigurator
.setClassificationUuid(treeUuid
);
116 bmImportConfigurator
.setSourceSecId(sourceSecId
);
117 bmImportConfigurator
.setNomenclaturalCode(nomenclaturalCode
);
119 bmImportConfigurator
.setIgnoreNull(ignoreNull
);
120 bmImportConfigurator
.setDoAuthors(doAuthors
);
121 bmImportConfigurator
.setDoReferences(doReferences
);
122 bmImportConfigurator
.setDoTaxonNames(doTaxonNames
);
123 bmImportConfigurator
.setDoRelNames(doRelNames
);
124 bmImportConfigurator
.setDoNameStatus(doNameStatus
);
125 bmImportConfigurator
.setDoTypes(doTypes
);
126 bmImportConfigurator
.setDoNameFacts(doNameFacts
);
128 bmImportConfigurator
.setDoTaxa(doTaxa
);
129 bmImportConfigurator
.setDoRelTaxa(doRelTaxa
);
130 bmImportConfigurator
.setDoFacts(doFacts
);
131 bmImportConfigurator
.setDoOccurrence(doOccurences
);
132 bmImportConfigurator
.setDbSchemaValidation(hbm2dll
);
134 bmImportConfigurator
.setCheck(check
);
137 CdmDefaultImport
<BerlinModelImportConfigurator
> bmImport
= new CdmDefaultImport
<BerlinModelImportConfigurator
>();
138 bmImport
.invoke(bmImportConfigurator
);
140 if (bmImportConfigurator
.getCheck().equals(CHECK
.CHECK_AND_IMPORT
) || bmImportConfigurator
.getCheck().equals(CHECK
.IMPORT_WITHOUT_CHECK
) ){
141 CdmApplicationController app
= bmImport
.getCdmAppController();
142 ISourceable obj
= app
.getCommonService().getSourcedObjectByIdInSource(ZoologicalName
.class, "1000027", null);
145 // //make feature tree
146 // FeatureTree tree = TreeCreator.flatTree(featureTreeUuid, bmImportConfigurator.getFeatureMap(), featureKeyList);
147 // app = bmImport.getCdmAppController();
148 // app.getFeatureTreeService().saveOrUpdate(tree);
150 System
.out
.println("End import from BerlinModel ("+ source
.getDatabase() + ")...");