Project

General

Profile

« Previous | Next » 

Revision c1a5c2bd

Added by Andreas Müller about 12 years ago

some updates to erms import and export

View differences:

cdm-pesi/src/main/java/eu/etaxonomy/cdm/io/pesi/erms/ErmsTaxonImport.java
168 168
		Set<Integer> result = new HashSet<Integer>();
169 169
		String parentCol = "tu_parent";
170 170
		String accCol = " tu_acctaxon";
171
		String idCol = " id ";
171 172
		String tuFk = "tu_id";
172 173
		String taxonTable = "tu";
173 174
		String vernacularsTable = "vernaculars";
174 175
		String distributionTable = "dr";
175 176
		String sql = " SELECT DISTINCT %s FROM %s  " +
177
				" UNION  SELECT %s FROM %s WHERE %s is NULL" +
176 178
				" UNION  SELECT DISTINCT %s FROM %s " +
177 179
				" UNION  SELECT DISTINCT %s FROM %s " +
178 180
				" UNION  SELECT DISTINCT %s FROM %s ";
179 181
		sql = String.format(sql, 
180 182
				parentCol, taxonTable, 
183
				idCol, taxonTable, accCol,  
181 184
				accCol, taxonTable,
182 185
				tuFk, vernacularsTable,
183 186
				tuFk, distributionTable);

Also available in: Unified diff