cdm-pesi/src/main/java/eu/etaxonomy/cdm/io/pesi/erms/validation/ErmsReferenceImportValidator.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.pesi.erms.validation;
  11
  12 import java.sql.ResultSet;
  13 import java.sql.SQLException;
  14
  15 import org.apache.log4j.Logger;
  16
  17 import eu.etaxonomy.cdm.io.common.IOValidator;
  18 import eu.etaxonomy.cdm.io.common.Source;
  19 import eu.etaxonomy.cdm.io.pesi.erms.ErmsImportConfigurator;
  20 import eu.etaxonomy.cdm.io.pesi.erms.ErmsImportState;
  21
  22 /**
  23  * ERMS reference validator.
  24  * NOT YET USED.
  25  *
  26  * @author a.mueller
  27  * @since 17.02.2010
  28  */
  29 public class ErmsReferenceImportValidator implements IOValidator<ErmsImportState>{
  30         private static final Logger logger = Logger.getLogger(ErmsReferenceImportValidator.class);
  31
  32         @Override
  33     public boolean validate(ErmsImportState state){
  34                 boolean result = true;
  35                 ErmsImportConfigurator config = state.getConfig();
  36                 logger.info("Checking for references not yet fully implemented");
  37 //              result &= checkTaxonStatus(config);
  38                 return result;
  39         }
  40
  41         private boolean checkTaxonStatus(ErmsImportConfigurator bmiConfig){
  42                 try {
  43                         boolean result = true;
  44                         Source source = bmiConfig.getSource();
  45                         String strSQL = " SELECT RelPTaxon.RelQualifierFk, RelPTaxon.relPTaxonId, PTaxon.PTNameFk, PTaxon.PTRefFk, PTaxon_1.PTNameFk AS Expr1, PTaxon.RIdentifier, PTaxon_1.RIdentifier AS Expr3, Name.FullNameCache "  +
  46                                 " FROM RelPTaxon " +
  47                                         " INNER JOIN PTaxon ON RelPTaxon.PTNameFk1 = PTaxon.PTNameFk AND RelPTaxon.PTRefFk1 = PTaxon.PTRefFk " +
  48                                         " INNER JOIN PTaxon AS PTaxon_1 ON RelPTaxon.PTNameFk2 = PTaxon_1.PTNameFk AND RelPTaxon.PTRefFk2 = PTaxon_1.PTRefFk  " +
  49                                         " INNER JOIN Name ON PTaxon.PTNameFk = Name.NameId " +
  50                                 " WHERE (dbo.PTaxon.StatusFk = 1) AND ((RelPTaxon.RelQualifierFk = 7) OR (RelPTaxon.RelQualifierFk = 6) OR (RelPTaxon.RelQualifierFk = 2)) ";
  51                         ResultSet rs = source.getResultSet(strSQL);
  52                         boolean firstRow = true;
  53                         int i = 0;
  54                         while (rs.next()){
  55                                 i++;
  56                                 if (firstRow){
  57                                         System.out.println("========================================================");
  58                                         logger.warn("There are taxa that have a 'is synonym of' - relationship but having taxon status 'accepted'!");
  59                                         System.out.println("========================================================");
  60                                 }
  61                                 int rIdentifier = rs.getInt("RIdentifier");
  62                                 int nameFk = rs.getInt("PTNameFk");
  63                                 int refFk = rs.getInt("PTRefFk");
  64                                 int relPTaxonId = rs.getInt("relPTaxonId");
  65                                 String taxonName = rs.getString("FullNameCache");
  66
  67                                 System.out.println("RIdentifier:" + rIdentifier + "\n  name: " + nameFk +
  68                                                 "\n  taxonName: " + taxonName + "\n  refId: " + refFk + "\n  RelPTaxonId: " + relPTaxonId );
  69                                 result = firstRow = false;
  70                         }
  71                         if (i > 0){
  72                                 System.out.println(" ");
  73                         }
  74
  75                         return result;
  76                 } catch (SQLException e) {
  77                         e.printStackTrace();
  78                         return false;
  79                 }
  80         }
  81
  82 }