cdmlib-io/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/validation/BerlinModelTaxonImportValidator.java

   1 // $Id$
   2 /**
   3 * Copyright (C) 2007 EDIT
   4 * European Distributed Institute of Taxonomy
   5 * http://www.e-taxonomy.eu
   6 *
   7 * The contents of this file are subject to the Mozilla Public License Version 1.1
   8 * See LICENSE.TXT at the top of this package for the full license terms.
   9 */
  10
  11 package eu.etaxonomy.cdm.io.berlinModel.in.validation;
  12
  13 import java.sql.ResultSet;
  14 import java.sql.SQLException;
  15
  16 import org.apache.log4j.Logger;
  17
  18 import eu.etaxonomy.cdm.io.berlinModel.in.BerlinModelImportConfigurator;
  19 import eu.etaxonomy.cdm.io.berlinModel.in.BerlinModelImportState;
  20 import eu.etaxonomy.cdm.io.common.IOValidator;
  21 import eu.etaxonomy.cdm.io.common.Source;
  22
  23 /**
  24  * @author a.mueller
  25  * @created 17.02.2010
  26  * @version 1.0
  27  */
  28 public class BerlinModelTaxonImportValidator implements IOValidator<BerlinModelImportState>{
  29         private static final Logger logger = Logger.getLogger(BerlinModelTaxonImportValidator.class);
  30
  31         public boolean validate(BerlinModelImportState state){
  32                 boolean result = true;
  33                 BerlinModelImportConfigurator bmiConfig = state.getConfig();
  34                 logger.warn("Checking for Taxa not yet fully implemented");
  35                 result &= checkTaxonStatus(bmiConfig);
  36                 result &= checkInactivated(bmiConfig);
  37                 return result;
  38         }
  39
  40         private boolean checkTaxonStatus(BerlinModelImportConfigurator bmiConfig){
  41                 try {
  42                         boolean result = true;
  43                         Source source = bmiConfig.getSource();
  44                         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 "  +
  45                                 " FROM RelPTaxon " +
  46                                         " INNER JOIN PTaxon ON RelPTaxon.PTNameFk1 = PTaxon.PTNameFk AND RelPTaxon.PTRefFk1 = PTaxon.PTRefFk " +
  47                                         " INNER JOIN PTaxon AS PTaxon_1 ON RelPTaxon.PTNameFk2 = PTaxon_1.PTNameFk AND RelPTaxon.PTRefFk2 = PTaxon_1.PTRefFk  " +
  48                                         " INNER JOIN Name ON PTaxon.PTNameFk = Name.NameId " +
  49                                 " WHERE (dbo.PTaxon.StatusFk = 1) AND ((RelPTaxon.RelQualifierFk = 7) OR (RelPTaxon.RelQualifierFk = 6) OR (RelPTaxon.RelQualifierFk = 2)) ";
  50                         ResultSet rs = source.getResultSet(strSQL);
  51                         boolean firstRow = true;
  52                         int i = 0;
  53                         while (rs.next()){
  54                                 i++;
  55                                 if (firstRow){
  56                                         System.out.println("========================================================");
  57                                         logger.warn("There are taxa that have a 'is synonym of' - relationship but having taxon status 'accepted'!");
  58                                         System.out.println("========================================================");
  59                                 }
  60                                 int rIdentifier = rs.getInt("RIdentifier");
  61                                 int nameFk = rs.getInt("PTNameFk");
  62                                 int refFk = rs.getInt("PTRefFk");
  63                                 int relPTaxonId = rs.getInt("relPTaxonId");
  64                                 String taxonName = rs.getString("FullNameCache");
  65
  66                                 System.out.println("RIdentifier:" + rIdentifier + "\n  name: " + nameFk +
  67                                                 "\n  taxonName: " + taxonName + "\n  refId: " + refFk + "\n  RelPTaxonId: " + relPTaxonId );
  68                                 result = firstRow = false;
  69                         }
  70                         if (i > 0){
  71                                 System.out.println(" ");
  72                         }
  73
  74                         return result;
  75                 } catch (SQLException e) {
  76                         e.printStackTrace();
  77                         return false;
  78                 }
  79         }
  80
  81         private boolean checkInactivated(BerlinModelImportConfigurator bmiConfig){
  82                 try {
  83                         boolean result = true;
  84                         Source source = bmiConfig.getSource();
  85                         String strSQL = " SELECT * "  +
  86                                 " FROM PTaxon " +
  87                                         " INNER JOIN Name ON PTaxon.PTNameFk = Name.NameId " +
  88                                 " WHERE (PTaxon.DoubtfulFlag = 'i') ";
  89                         ResultSet rs = source.getResultSet(strSQL);
  90                         boolean firstRow = true;
  91                         int i = 0;
  92                         while (rs.next()){
  93                                 i++;
  94                                 if (firstRow){
  95                                         System.out.println("========================================================");
  96                                         logger.warn("There are taxa that have a doubtful flag 'i'(inactivated). Inactivated is not supported by CDM!");
  97                                         System.out.println("========================================================");
  98                                 }
  99                                 int rIdentifier = rs.getInt("RIdentifier");
 100                                 int nameFk = rs.getInt("PTNameFk");
 101                                 int refFk = rs.getInt("PTRefFk");
 102                                 String taxonName = rs.getString("FullNameCache");
 103
 104                                 System.out.println("RIdentifier:" + rIdentifier + "\n  nameId: " + nameFk +
 105                                                 "\n  taxonName: " + taxonName + "\n  refId: " + refFk  );
 106                                 result = firstRow = false;
 107                         }
 108                         if (i > 0){
 109                                 System.out.println(" ");
 110                         }
 111
 112                         return result;
 113                 } catch (SQLException e) {
 114                         e.printStackTrace();
 115                         return false;
 116                 }
 117         }
 118
 119
 120 }