Revision f37a28e7
Added by Andreas Müller over 5 years ago
app-import/src/main/java/eu/etaxonomy/cdm/app/berlinModelImport/EuroMedActivator.java | ||
---|---|---|
83 | 83 |
// static final Source berlinModelSource = BerlinModelSources.euroMed_PESI3(); |
84 | 84 |
// |
85 | 85 |
// static final ICdmDataSource cdmDestination = CdmDestinations.localH2(); |
86 |
static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_euroMed(); |
|
87 |
|
|
88 | 86 |
// static final ICdmDataSource cdmDestination = CdmDestinations.cdm_local_euromed(); |
87 |
static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_euroMed(); |
|
89 | 88 |
|
90 |
boolean invers = !(hbm2dll == DbSchemaValidation.CREATE); |
|
89 |
//check - import |
|
90 |
static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK; |
|
91 | 91 |
|
92 | 92 |
static final boolean doUser = true; |
93 | 93 |
// //authors |
... | ... | |
105 | 105 |
static final boolean doTaxa = true; |
106 | 106 |
static final boolean doFacts = true; |
107 | 107 |
static final boolean doCommonNames = false; //currently takes very long |
108 |
static final boolean doOccurences = true;
|
|
108 |
static final boolean doOccurences = false;
|
|
109 | 109 |
static final boolean doRelTaxa = true; |
110 | 110 |
static final boolean doRunTransmissionEngine = (hbm2dll == DbSchemaValidation.VALIDATE); |
111 | 111 |
|
112 | 112 |
//etc. |
113 | 113 |
static final boolean doMarker = false; |
114 | 114 |
|
115 |
boolean invers = !(hbm2dll == DbSchemaValidation.CREATE); |
|
115 | 116 |
|
116 |
//check - import |
|
117 |
static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK; |
|
118 | 117 |
|
119 | 118 |
static final boolean includePesiExport = false; |
120 | 119 |
|
... | ... | |
159 | 158 |
|
160 | 159 |
static String taxonTable = "v_cdm_exp_taxaAll"; |
161 | 160 |
static String classificationQuery = " SELECT DISTINCT t.PTRefFk, r.RefCache FROM PTaxon t INNER JOIN Reference r ON t.PTRefFk = r.RefId WHERE t.PTRefFk = " + sourceSecId; |
162 |
static String relPTaxonIdQuery = " SELECT r.RelPTaxonId " + |
|
163 |
" FROM RelPTaxon AS r INNER JOIN v_cdm_exp_taxaDirect AS a ON r.PTNameFk2 = a.PTNameFk AND r.PTRefFk2 = a.PTRefFk" + |
|
164 |
" WHERE r.RelPTaxonID NOT IN (1874890,1874959,1874932,1874793,1874956,1874971,1874902,1874696) " + //Relations to unpublished Kew genus taxa of Bethulaceae which are not imported anymore, but Bethalaceae is still imported |
|
165 |
" "; |
|
161 |
static String relPTaxonIdQuery = " SELECT r.RelPTaxonId " |
|
162 |
+ " FROM RelPTaxon AS r " |
|
163 |
+ " INNER JOIN v_cdm_exp_taxaDirect AS a ON r.PTNameFk2 = a.PTNameFk AND r.PTRefFk2 = a.PTRefFk " |
|
164 |
+ " INNER JOIN PTaxon As pt1 ON pt1.PTNameFk = r.PTNameFk1 AND pt1.PTRefFk = r.PTRefFk1 " |
|
165 |
+ " WHERE r.RelPTaxonID NOT IN (1874890,1874959,1874932,1874793,1874956,1874971,1874902,1874696) " //Relations to unpublished Kew genus taxa of Bethulaceae which are not imported anymore, but Bethalaceae is still imported |
|
166 |
+ " AND NOT (pt1.PTRefFk = 8000000 AND pt1.publishFlag = 0) "; |
|
166 | 167 |
static String nameIdTable = " v_cdm_exp_namesAll "; |
167 | 168 |
static String referenceIdTable = " v_cdm_exp_refAll "; |
168 | 169 |
static String refDetailFilter = " RefDetailID IN (SELECT RefDetailID FROM v_cdm_exp_RefDetail) "; |
Also available in: Unified diff
latest changes to EuroMedActivator (including changes in TaxonRelation ID selection)