Revision 6e9517ee
Added by Andreas Müller almost 10 years ago
app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/validation/BerlinModelTaxonImportValidator.java | ||
---|---|---|
84 | 84 |
Source source = config.getSource(); |
85 | 85 |
String strSQL = " SELECT * " + |
86 | 86 |
" FROM PTaxon t " + |
87 |
" INNER JOIN Name ON t.PTNameFk = Name.NameId " +
|
|
87 |
" INNER JOIN Name n ON t.PTNameFk = n.NameId " +
|
|
88 | 88 |
" WHERE (t.DoubtfulFlag = 'i') "; |
89 | 89 |
|
90 | 90 |
if (StringUtils.isNotBlank(config.getTaxonTable())){ |
91 |
strSQL += String.format(" AND (t.RIdentifier IN " + |
|
91 |
strSQL += String.format(" AND (t.RIdentifier IN " +
|
|
92 | 92 |
" (SELECT RIdentifier FROM %s ))" , config.getTaxonTable()) ; |
93 | 93 |
} |
94 |
strSQL += " ORDER BY t.ptRefFk, n.FullNameCache"; |
|
94 | 95 |
|
95 | 96 |
ResultSet rs = source.getResultSet(strSQL); |
96 | 97 |
boolean firstRow = true; |
Also available in: Unified diff
update validation