Revision b01c2d5a
Added by Patrick Plitzner about 8 years ago
| app-import/src/main/java/eu/etaxonomy/cdm/io/redlist/gefaesspflanzen/RedListGefaesspflanzenImportTaxa.java | ||
|---|---|---|
| 53 | 53 |
|
| 54 | 54 |
@Override |
| 55 | 55 |
protected String getIdQuery(RedListGefaesspflanzenImportState state) {
|
| 56 |
return "SELECT NAMNR FROM V_TAXATLAS_D20_EXPORT t "
|
|
| 57 |
// + " ORDER BY NAMNR"
|
|
| 58 |
; |
|
| 56 |
return "SELECT NAMNR " |
|
| 57 |
+ "FROM V_TAXATLAS_D20_EXPORT t "
|
|
| 58 |
+ " ORDER BY NAMNR";
|
|
| 59 | 59 |
} |
| 60 | 60 |
|
| 61 | 61 |
@Override |
| ... | ... | |
| 79 | 79 |
Set<TaxonBase> taxaToSave = new HashSet<>(); |
| 80 | 80 |
try {
|
| 81 | 81 |
while (rs.next()){
|
| 82 |
taxaToSave = makeSingleTaxon(state, rs);
|
|
| 82 |
makeSingleTaxon(state, rs, taxaToSave);
|
|
| 83 | 83 |
|
| 84 | 84 |
} |
| 85 | 85 |
} catch (SQLException e) {
|
| ... | ... | |
| 90 | 90 |
return true; |
| 91 | 91 |
} |
| 92 | 92 |
|
| 93 |
private Set<TaxonBase> makeSingleTaxon(RedListGefaesspflanzenImportState state, ResultSet rs)
|
|
| 93 |
private void makeSingleTaxon(RedListGefaesspflanzenImportState state, ResultSet rs, Set<TaxonBase> taxaToSave)
|
|
| 94 | 94 |
throws SQLException {
|
| 95 |
Set<TaxonBase> taxaToSave = new HashSet<>(); |
|
| 96 | 95 |
long id = rs.getLong("NAMNR");
|
| 97 | 96 |
String taxonNameString = rs.getString("TAXNAME");
|
| 98 | 97 |
|
| ... | ... | |
| 105 | 104 |
//id |
| 106 | 105 |
ImportHelper.setOriginalSource(taxon, state.getTransactionalSourceReference(), id, TAXON_NAMESPACE); |
| 107 | 106 |
ImportHelper.setOriginalSource(name, state.getTransactionalSourceReference(), id, TAXON_NAMESPACE); |
| 108 |
|
|
| 109 |
return taxaToSave; |
|
| 110 | 107 |
} |
| 111 | 108 |
|
| 112 | 109 |
private Rank makeRank(RedListGefaesspflanzenImportState state, String rankStr) {
|
Also available in: Unified diff
Ordered input for easier comparison