Project

General

Profile

Revision f37a28e7

IDf37a28e70853087a1d6faf68606d37721387a13b
Parent 4298d81b
Child edeb0e69

Added by Andreas Müller 9 months ago

latest changes to EuroMedActivator (including changes in TaxonRelation ID selection)

View differences:

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

Add picture from clipboard (Maximum size: 40 MB)