Project

General

Profile

« Previous | Next » 

Revision 9c80e7d1

Added by Andreas Müller almost 10 years ago

Some updates for AlgaTerra Types import

View differences:

app-import/src/main/java/eu/etaxonomy/cdm/io/algaterra/AlgaTerraSpecimenImportBase.java
27 27 
import eu.etaxonomy.cdm.io.common.TdwgAreaProvider;
28 28 
import eu.etaxonomy.cdm.model.agent.Team;
29 29 
import eu.etaxonomy.cdm.model.agent.TeamOrPersonBase;
30 
import eu.etaxonomy.cdm.model.common.Annotation;
31 
import eu.etaxonomy.cdm.model.common.AnnotationType;
32 
import eu.etaxonomy.cdm.model.common.Language;
30 33 
import eu.etaxonomy.cdm.model.common.OrderedTermVocabulary;
31 34 
import eu.etaxonomy.cdm.model.common.TermType;
32 35 
import eu.etaxonomy.cdm.model.common.TimePeriod;
......
155 158 
			}
156 159
157 160 
			//areas
158 
			OrderedTermVocabulary<NamedArea> informalAreasVoc = (OrderedTermVocabulary<NamedArea>)getVocabulary(TermType.NamedArea, AlgaTerraImportTransformer.uuidNamedAreaVocAlgaTerraInformalAreas, "AlgaTerra Informal Areas", "AlgaTerra Informal Areas", abbrevLabel, uri, true, NamedArea.NewInstance());
161 
			OrderedTermVocabulary<NamedArea> informalAreasVoc = (OrderedTermVocabulary<NamedArea>)getVocabulary(TermType.NamedArea, AlgaTerraImportTransformer.uuidNamedAreaVocAlgaTerraInformalAreas, "AlgaTerra Specific Areas", "AlgaTerra Specific Areas", abbrevLabel, uri, true, NamedArea.NewInstance());
159 162 
			getVocabularyService().save(informalAreasVoc);
160 
			getNamedArea(state, AlgaTerraImportTransformer.uuidNamedAreaPatagonia,"Patagonia", "Patagonia", null, NamedAreaType.NATURAL_AREA(), null, informalAreasVoc, TermMatchMode.UUID_ONLY, null);
161 
			getNamedArea(state, AlgaTerraImportTransformer.uuidNamedAreaTierraDelFuego,"Terra del Fuego", "Terra del Fuego", null, NamedAreaType.NATURAL_AREA(), null, informalAreasVoc, TermMatchMode.UUID_ONLY, null);
162 
			getNamedArea(state, AlgaTerraImportTransformer.uuidNamedAreaBorneo,"Borneo", "Borneo", null, NamedAreaType.NATURAL_AREA(), null, informalAreasVoc, TermMatchMode.UUID_ONLY, null);
163 163
164 
			NamedArea patagonia = NamedArea.NewInstance("Patagonia", "Patagonia", null);
165 
			NamedArea tierraDelFuego = NamedArea.NewInstance("Tierra del Fuego", "Tierra del Fuego", null);
166 
			NamedArea borneo = NamedArea.NewInstance("Borneo", "Borneo", null);
167 
			informalAreasVoc.addTerm(patagonia);
168 
			informalAreasVoc.addTerm(tierraDelFuego);
169 
			informalAreasVoc.addTerm(borneo);
164 
			String areaSql = "SELECT * FROM TDWGGazetteer WHERE subL4 = 1 ";
165 
			rs = source.getResultSet(areaSql);
166 
			while (rs.next()){
167 
				String l1Code = rs.getString("L1Code");
168 
				String l2Code = rs.getString("L2Code");
169 
				String l3Code = rs.getString("L3Code");
170 
				String l4Code = rs.getString("L4Code");
171 
				String gazetteer = rs.getString("Gazetteer");
172 
				Integer id = rs.getInt("ID");
173 
				String notes = rs.getString("Notes");
174 
//				UUID uuid = UUID.fromString(rs.getString("UUID"));
175
176 
				String tdwgCode =  (l4Code != null) ? l4Code : (l3Code != null) ? l3Code : (l2Code != null) ? l2Code : l1Code;
177
178 
				NamedArea tdwgArea = TdwgAreaProvider.getAreaByTdwgAbbreviation(tdwgCode);
179 
				NamedArea newArea  = getNamedArea(state, AlgaTerraImportTransformer.uuidNamedAreaPatagonia,gazetteer, gazetteer, null, null, null, informalAreasVoc, TermMatchMode.UUID_ONLY, null);
180 
				if (isNotBlank(notes)){
181 
					newArea.addAnnotation(Annotation.NewInstance(notes, AnnotationType.EDITORIAL(), Language.DEFAULT()));
182 
				}
183
184 
				addOriginalSource(newArea, id.toString(), "TDWGGazetteer", state.getTransactionalSourceReference());
185 
				getTermService().saveOrUpdate(newArea);
186 
				newArea.setPartOf(tdwgArea);
187 
				informalAreasVoc.addTerm(newArea);
188 
			}
170 189
171 190 
			this.commitTransaction(txStatus);
172 191

Also available in: Unified diff