Revision 959bcc8d
Added by Andreas Müller over 5 years ago
| app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/BerlinModelAreaImport.java | ||
|---|---|---|
| 64 | 64 |
|
| 65 | 65 |
@Override |
| 66 | 66 |
protected String getIdQuery(BerlinModelImportState state) {
|
| 67 |
String result = " SELECT AreaId FROM " + getTableName(); |
|
| 68 |
// if (StringUtils.isNotBlank(state.getConfig().getOccurrenceFilter())){
|
|
| 69 |
// result += " WHERE " + state.getConfig().getOccurrenceFilter(); |
|
| 70 |
// } |
|
| 67 |
String result = |
|
| 68 |
" SELECT AreaId " |
|
| 69 |
+ " FROM " + getTableName(); |
|
| 70 |
if (state.getConfig().isEuroMed()){
|
|
| 71 |
result += " WHERE AreaID NOT IN (1, 21, 650, 653, 1718, 654) "; //#3986 |
|
| 72 |
} |
|
| 71 | 73 |
return result; |
| 72 | 74 |
} |
| 73 | 75 |
|
| ... | ... | |
| 77 | 79 |
" SELECT * " |
| 78 | 80 |
+ " FROM emArea a " |
| 79 | 81 |
+ " WHERE (a.AreaId IN (" + ID_LIST_TOKEN + ") )"
|
| 80 |
// + " ORDER BY PTaxon.RIdentifier"
|
|
| 82 |
+ " ORDER BY a.AreaId "
|
|
| 81 | 83 |
; |
| 82 | 84 |
return strQuery; |
| 83 | 85 |
} |
| ... | ... | |
| 87 | 89 |
|
| 88 | 90 |
private TermVocabulary<NamedArea> createEuroMedAreas(BerlinModelImportState state) throws SQLException {
|
| 89 | 91 |
|
| 90 |
|
|
| 91 | 92 |
logger.warn("Start creating E+M areas");
|
| 92 | 93 |
Source source = state.getConfig().getSource(); |
| 93 | 94 |
Reference sourceReference = state.getConfig().getSourceReference(); |
Also available in: Unified diff
ref #3986 , ref #7346 remove some areas from area import