Project

General

Profile

« Previous | Next » 

Revision b643bc02

Added by Andreas Müller over 4 years ago

ref #8577 some changes to E+M export validation

View differences:

cdm-pesi/src/main/java/eu/etaxonomy/cdm/io/pesi/euromed/PesiEuroMedValidator.java
39 39 
    private Source source = new Source(defaultSource);
40 40 
    private Source destination = defaultDestination;
41 41 

  		




  42
  
  
    
    private String origEuroMed = "OriginalDB = 'EM' ";


  		




  
  42
  
    
    private String origEuroMed = "OriginalDB = 'E+M' ";


  		




  43
  43
  
    

  		




  44
  44
  
    
    public void invoke(Source source, Source destination){


  		




  45
  45
  
    
        logger.warn("Validate destination " +  destination.getDatabase());


  		




  ......




  726
  726
  
    

  		




  727
  727
  
    
    private boolean testSingleReferences() throws SQLException {


  		




  728
  728
  
    
        boolean success = true;


  		




  729
  
  
    
        ResultSet srcRS = source.getResultSet("SELECT s.* FROM sources s ORDER BY s.id ");


  		




  
  729
  
    
        ResultSet srcRS = source.getResultSet("SELECT r.* FROM Reference r ORDER BY r.id ");


  		




  730
  730
  
    
        ResultSet destRS = destination.getResultSet("SELECT s.* FROM Source s "


  		




  731
  731
  
    
                + " WHERE s." + origEuroMed


  		




  732
  732
  
    
                + " ORDER BY s.RefIdInSource ");  // +1 for the source reference "erms" but this has no OriginalDB


  		




  ......




  739
  739
  
    
    private boolean testSingleReference(ResultSet srcRS, ResultSet destRS) throws SQLException {


  		




  740
  740
  
    
        String id = String.valueOf(srcRS.getInt("id"));


  		




  741
  741
  
    
        boolean success = equals("Reference ID ", srcRS.getInt("id"), destRS.getInt("RefIdInSource"), id);


  		




  742
  
  
    
        success &= equals("Reference IMIS_id ", srcRS.getString("imis_id"), destRS.getString("IMIS_Id"), id);


  		




  743
  
  
    
        success &= equals("Reference SourceCategoryFk ", convertSourceTypeFk(srcRS.getString("source_type")), destRS.getInt("SourceCategoryFk"), id);


  		




  744
  
  
    
        success &= equals("Reference SourceCategoryCache ", convertSourceTypeCache(srcRS.getString("source_type")), destRS.getString("SourceCategoryCache"), id);


  		




  745
  
  
    
        success &= equals("Reference name ", srcRS.getString("source_name"), destRS.getString("Name"), id);


  		




  746
  
  
    
        success &= equals("Reference abstract ", srcRS.getString("source_abstract"), destRS.getString("Abstract"), id);


  		




  747
  
  
    
        success &= equals("Reference title ", srcRS.getString("source_title"), destRS.getString("Title"), id);


  		




  748
  
  
    
        success &= equals("Reference author string ", srcRS.getString("source_author"), destRS.getString("AuthorString"), id);


  		




  749
  
  
    
        success &= equals("Reference year ", normalizeYear(srcRS.getString("source_year")), destRS.getString("RefYear"), id);


  		




  750
  
  
    
        success &= isNull("NomRefCache", destRS);  //for ERMS no other value was found in 2014 value


  		




  751
  
  
    
        success &= equals("Reference link ", srcRS.getString("source_link"), destRS.getString("Link"), id);


  		




  752
  
  
    
        success &= equals("Reference note ", srcRS.getString("source_note"), destRS.getString("Notes"), id);


  		




  
  742
  
    
        success &= isNull("IMIS_Id", destRS);  //for E+M no IMIS id exists


  		




  
  743
  
    
        success &= equals("Reference SourceCategoryFk ", convertSourceTypeFk(srcRS.getString("refType")), destRS.getInt("SourceCategoryFk"), id);


  		




  
  744
  
    
        success &= equals("Reference SourceCategoryCache ", convertSourceTypeCache(srcRS.getString("refType")), destRS.getString("SourceCategoryCache"), id);


  		




  
  745
  
    
        success &= equals("Reference name ", srcRS.getString("titleCache"), destRS.getString("Name"), id);


  		




  
  746
  
    
        success &= equals("Reference abstract ", srcRS.getString("referenceAbstract"), destRS.getString("Abstract"), id);


  		




  
  747
  
    
        success &= equals("Reference title ", srcRS.getString("title"), destRS.getString("Title"), id);


  		




  
  748
  
    
//        success &= equals("Reference author string ", srcRS.getString("source_author"), destRS.getString("AuthorString"), id);


  		




  
  749
  
    
//        success &= equals("Reference year ", normalizeYear(srcRS.getString("source_year")), destRS.getString("RefYear"), id);


  		




  
  750
  
    
        success &= equals("Reference NomRefCache ", srcRS.getString("abbrevTitleCache"), destRS.getString("NomRefCache"), id);


  		




  
  751
  
    
        //TODO DOI


  		




  
  752
  
    
//        success &= equals("Reference link ", srcRS.getString("source_link"), destRS.getString("Link"), id);


  		




  
  753
  
    
//        success &= equals("Reference note ", srcRS.getString("source_note"), destRS.getString("Notes"), id);


  		




  
  754
  
    
        //TODO see above


  		




  753
  755
  
    
        //complete


  		




  754
  756
  
    
        return success;


  		




  755
  757
  
    
    }


  		












Also available in:  Unified diff