Project

General

Profile

Revision 959bcc8d

ID959bcc8d8b05d5b03d05240f2493b74e4e57a740
Parent 4982a63b
Child 37bb08e2

Added by Andreas Müller about 3 years ago

ref #3986 , ref #7346 remove some areas from area import

View differences:

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

Add picture from clipboard (Maximum size: 40 MB)