app-import/src/main/java/eu/etaxonomy/cdm/io/algaterra/AlgaTerraImageImportBase.java

   1 /**
   2 * Copyright (C) 2007 EDIT
   3 * European Distributed Institute of Taxonomy
   4 * http://www.e-taxonomy.eu
   5 *
   6 * The contents of this file are subject to the Mozilla Public License Version 1.1
   7 * See LICENSE.TXT at the top of this package for the full license terms.
   8 */
   9
  10 package eu.etaxonomy.cdm.io.algaterra;
  11
  12 import java.net.URI;
  13 import java.sql.Date;
  14 import java.sql.ResultSet;
  15 import java.sql.SQLException;
  16 import java.util.Map;
  17 import java.util.Set;
  18 import java.util.UUID;
  19
  20 import javassist.runtime.Desc;
  21
  22 import org.apache.commons.lang.StringUtils;
  23 import org.apache.log4j.Logger;
  24 import org.springframework.transaction.TransactionStatus;
  25
  26 import eu.etaxonomy.cdm.api.facade.DerivedUnitFacade;
  27 import eu.etaxonomy.cdm.common.media.ImageInfo;
  28 import eu.etaxonomy.cdm.io.berlinModel.in.BerlinModelImportBase;
  29 import eu.etaxonomy.cdm.io.berlinModel.in.BerlinModelTaxonNameImport;
  30 import eu.etaxonomy.cdm.io.common.ResultSetPartitioner;
  31 import eu.etaxonomy.cdm.io.common.Source;
  32 import eu.etaxonomy.cdm.model.agent.Team;
  33 import eu.etaxonomy.cdm.model.common.CdmBase;
  34 import eu.etaxonomy.cdm.model.common.Language;
  35 import eu.etaxonomy.cdm.model.common.OrderedTermVocabulary;
  36 import eu.etaxonomy.cdm.model.common.TimePeriod;
  37 import eu.etaxonomy.cdm.model.description.DescriptionBase;
  38 import eu.etaxonomy.cdm.model.description.DescriptionElementBase;
  39 import eu.etaxonomy.cdm.model.description.Feature;
  40 import eu.etaxonomy.cdm.model.description.SpecimenDescription;
  41 import eu.etaxonomy.cdm.model.description.State;
  42 import eu.etaxonomy.cdm.model.description.TextData;
  43 import eu.etaxonomy.cdm.model.location.NamedArea;
  44 import eu.etaxonomy.cdm.model.location.Point;
  45 import eu.etaxonomy.cdm.model.location.ReferenceSystem;
  46 import eu.etaxonomy.cdm.model.location.TdwgArea;
  47 import eu.etaxonomy.cdm.model.location.WaterbodyOrCountry;
  48 import eu.etaxonomy.cdm.model.media.Media;
  49 import eu.etaxonomy.cdm.model.name.TaxonNameBase;
  50 import eu.etaxonomy.cdm.model.occurrence.Collection;
  51 import eu.etaxonomy.cdm.model.occurrence.DerivedUnit;
  52 import eu.etaxonomy.cdm.model.occurrence.DerivedUnitBase;
  53 import eu.etaxonomy.cdm.model.occurrence.SpecimenOrObservationBase;
  54 import eu.etaxonomy.cdm.model.reference.Reference;
  55
  56 /**
  57  * @author a.mueller
  58  * @created 12.09.2012
  59  */
  60 public abstract class AlgaTerraImageImportBase extends BerlinModelImportBase{
  61         private static final Logger logger = Logger.getLogger(AlgaTerraImageImportBase.class);
  62
  63         public static final String TERMS_NAMESPACE = "ALGA_TERRA_TERMS";
  64
  65
  66
  67
  68         /**
  69          * Creates a media object and
  70          * @param rs
  71          * @param derivedUnit
  72          * @param state
  73          * @param partitioner
  74          * @return
  75          * @throws SQLException
  76          */
  77         protected Media handleSingleImage(ResultSet rs, SpecimenOrObservationBase derivedUnit, AlgaTerraImportState state, ResultSetPartitioner partitioner) throws SQLException {
  78                 try {
  79                         String fileName = rs.getString("fileName");
  80                         String figurePhrase = rs.getString("FigurePhrase");
  81                         //TODO refFk, refDetailFk, publishFlag
  82                         Integer refFk = nullSafeInt(rs, "refFk");
  83                         Integer refDetailFk = nullSafeInt(rs, "refDetailFk");
  84                         Boolean publishFlag = rs.getBoolean("RestrictedFlag");
  85
  86
  87                         if (isBlank(fileName)){
  88                                 throw new RuntimeException("FileName is missing");
  89                         }
  90                         String fullPath = state.getAlgaTerraConfigurator().getImageBaseUrl() + fileName;
  91
  92                         boolean isFigure = false;
  93                         Media media = getImageMedia(fullPath, READ_MEDIA_DATA, isFigure);
  94
  95                         if (media == null){
  96                                 throw new RuntimeException ("Media not found for " +fullPath);
  97                         }
  98                         if (isNotBlank(figurePhrase)){
  99                                 media.putTitle(Language.DEFAULT(), figurePhrase);
 100                         }
 101
 102                         //TODO ref
 103                         Reference<?> ref = null;
 104                         if (derivedUnit != null){
 105                                 SpecimenDescription desc = getSpecimenDescription(derivedUnit, ref, IMAGE_GALLERY, CREATE);
 106                                 TextData textData = null;
 107                                 for (DescriptionElementBase descEl : desc.getElements()){
 108                                         if (descEl.isInstanceOf(TextData.class)){
 109                                                 textData = CdmBase.deproxy(descEl, TextData.class);
 110                                         }
 111                                 }
 112                                 if (textData == null){
 113                                         textData = TextData.NewInstance(Feature.IMAGE());
 114                                 }
 115                                 desc.addElement(textData);
 116                                 textData.addMedia(media);
 117                         }else{
 118                                 logger.warn("Derived unit is null. Can't add media ");
 119                         }
 120
 121                         //notes
 122
 123                         //TODO restrictedFlag
 124
 125                         //TODO id, created for
 126                         //      this.doIdCreatedUpdatedNotes(state, descriptionElement, rs, id, namespace);
 127
 128                         return media;
 129                 } catch (Exception e) {
 130                         throw new RuntimeException(e);
 131                 }
 132
 133         }
 134
 135
 136
 137
 138
 139 }