Revision c1a5c2bd
Added by Andreas Müller about 12 years ago
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
some updates to erms import and export