/ - Diff - EDIT - EDIT Project Management

« Previous | Next »

Revision c29d1c8f

Added by Andreas Müller over 5 years ago

ID c29d1c8f6d711b34f56ae22a1c38b07713df729f
Parent ede99ce1
Child 91f5b910

cleanup and improve BM validators

     			int count = rs.getInt("n");
     			if (count > 0){
     				System.out.println("========================================================");
     				logger.warn("There are " + count + " common names that have a languageRefFk which can not be found in the emLanguageRefernce table.");
     				System.out.println("There are " + count + " common names that have a languageRefFk which can not be found in the emLanguageReference table.");
     				System.out.println("========================================================");
+    			}
     			if (count > 0){
-...
     		try {
     			boolean result = true;
     			Source source = config.getSource();
     			String strQuery = "SELECT cn.CommonNameId, cn.CommonName, pt.StatusFk, n.FullNameCache, s.Status, pt.PTRefFk, r.RefCache " +
     			String strQuery = "SELECT cn.CommonNameId, cn.CommonName, pt.StatusFk, n.FullNameCache, s.Status, pt.PTRefFk, pt.PTNameFk, r.RefCache " +
     						" FROM emCommonName cn " +
     							" INNER JOIN PTaxon pt ON cn.PTNameFk = pt.PTNameFk AND cn.PTRefFk = pt.PTRefFk " +
     			                " INNER JOIN Name n ON pt.PTNameFk = n.NameId " +
-...
     				String status = resulSet.getString("Status");
     				String fullNameCache = resulSet.getString("FullNameCache");
     				String ptRefFk = resulSet.getString("PTRefFk");
     				String ptRef = resulSet.getString("RefCache");
     				String ptNameFk = resulSet.getString("PTNameFk");
                     String ptRef = resulSet.getString("RefCache");
     				System.out.println("CommonNameId: " + commonNameId + "\n CommonName: " + commonName +
     						"\n  Status: " + status +
     						"\n  FullNameCache: " + fullNameCache +  "\n  ptRefFk: " + ptRefFk +
     						"\n  sec: " + ptRef );
     						"\n  FullNameCache: " + fullNameCache +
     						"\n  ptRefFk: " + ptRefFk +
     						"\n  ptNameFk: " + ptNameFk +
                             "\n  sec: " + ptRef );
     				result = firstRow = false;
+    			}

                 boolean result = true;
                 Source source = config.getSource();
                 String strSelect = "SELECT OccurrenceId, PTNameFk, PTRefFk, AreaFk, Sources, Created_When, Created_Who, Updated_When, Updated_Who, Notes, Occurrence ";
                 String strCount = " SELECT count(*) ";
                 String strCount = " SELECT count(*) as n";
                 String strQueryBase =
                         " FROM emOccurrence " +
                         " WHERE (Sources LIKE '%  %') OR (Sources LIKE '% ') OR (Sources LIKE ' %') ";

      * @since 17.02.2010
      */
     public class BerlinModelOccurrenceSourceImportValidator implements IOValidator<BerlinModelImportState> {
     	private static final Logger logger = Logger.getLogger(BerlinModelOccurrenceSourceImportValidator.class);
     	@SuppressWarnings("unused")
         private static final Logger logger = Logger.getLogger(BerlinModelOccurrenceSourceImportValidator.class);
     	@Override
         public boolean validate(BerlinModelImportState state) {
-...
                 boolean result = true;
                 Source source = config.getSource();
                 String strSelect = " SELECT OccurrenceSourceId, OccurrenceFk, Source, SourceNumber, OldName, OldNameFk, PreferredReferenceFlag ";
                 String strCount = " count(*) ";
                 String strCount = " SELECT count(*) as n";
                 String strQueryBase =
                         " FROM emOccurrenceSource " +
                         " WHERE SourceNumber LIKE '% %' ";

     /**
     * Copyright (C) 2007 EDIT
     * European Distributed Institute of Taxonomy
     * European Distributed Institute of Taxonomy
     * http://www.e-taxonomy.eu
+    *
+    *
     * The contents of this file are subject to the Mozilla Public License Version 1.1
     * See LICENSE.TXT at the top of this package for the full license terms.
     */
-...
     		result &= checkObligatoryAttributes(config, refImport);
     		result &= checkPartOfWithVolume(config);
     		result &= checkArticleWithEdition(config);
     		if (result == false ){System.out.println("========================================================");}
     		return result;
+    	}
     	//******************************** CHECK *************************************************
     		private static boolean checkArticlesWithoutJournal(BerlinModelImportConfigurator config){
     			try {
     				boolean result = true;
     				Source source = config.getSource();
     				String strQuery = "SELECT Reference.RefId, InRef.RefId AS InRefID, Reference.RefCategoryFk, InRef.RefCategoryFk AS InRefCatFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, RefCategory.RefCategoryAbbrev, InRefCategory.RefCategoryAbbrev AS InRefCat, InRef.Title AS InRefTitle " +
     				String strQuery = "SELECT Reference.RefId, InRef.RefId AS InRefID, Reference.RefCategoryFk, InRef.RefCategoryFk AS InRefCatFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, RefCategory.RefCategoryAbbrev, InRefCategory.RefCategoryAbbrev AS InRefCat, InRef.Title AS InRefTitle " +
     							" FROM Reference INNER JOIN Reference AS InRef ON Reference.InRefFk = InRef.RefId INNER JOIN RefCategory ON Reference.RefCategoryFk = RefCategory.RefCategoryId INNER JOIN RefCategory AS InRefCategory ON InRef.RefCategoryFk = InRefCategory.RefCategoryId " +
     							" WHERE (Reference.RefCategoryFk = 1) AND (InRef.RefCategoryFk <> 9) ";
     				if (StringUtils.isNotBlank(config.getReferenceIdTable())){
     					strQuery += String.format(" AND (reference.refId IN " +
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
+    				}
     				ResultSet rs = source.getResultSet(strQuery);
     				boolean firstRow = true;
     				while (rs.next()){
-...
     					String nomRefCache = rs.getString("nomRefCache");
     					String title = rs.getString("title");
     					String inRefTitle = rs.getString("InRefTitle");
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache + "\n  title: " + title +
     							"\n  inRefFk: " + inRefFk + "\n  inRefCategory: " + inRefCat +
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache + "\n  title: " + title +
     							"\n  inRefFk: " + inRefFk + "\n  inRefCategory: " + inRefCat +
     							"\n  inRefTitle: " + inRefTitle );
     					result = firstRow = false;
+    				}
     				return result;
     			} catch (SQLException e) {
     				e.printStackTrace();
     				return false;
+    			}
+    		}
     		private static boolean checkPartOfJournal(BerlinModelImportConfigurator config){
     			try {
     				boolean result = true;
     				Source source = config.getSource();
     				String strQuery = "SELECT Reference.RefId, InRef.RefId AS InRefID, Reference.RefCategoryFk, InRef.RefCategoryFk AS InRefCatFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, RefCategory.RefCategoryAbbrev, InRefCategory.RefCategoryAbbrev AS InRefCat, InRef.Title AS InRefTitle " +
     				String strQuery = "SELECT Reference.RefId, InRef.RefId AS InRefID, Reference.RefCategoryFk, InRef.RefCategoryFk AS InRefCatFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, RefCategory.RefCategoryAbbrev, InRefCategory.RefCategoryAbbrev AS InRefCat, InRef.Title AS InRefTitle " +
     				" FROM Reference INNER JOIN Reference AS InRef ON Reference.InRefFk = InRef.RefId INNER JOIN RefCategory ON Reference.RefCategoryFk = RefCategory.RefCategoryId INNER JOIN RefCategory AS InRefCategory ON InRef.RefCategoryFk = InRefCategory.RefCategoryId " +
     							" WHERE (Reference.RefCategoryFk = 2) AND (InRef.RefCategoryFk = 9) ";
     				if (StringUtils.isNotBlank(config.getReferenceIdTable())){
     					strQuery += String.format(" AND (reference.refId IN " +
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
+    				}
     				ResultSet rs = source.getResultSet(strQuery);
     				boolean firstRow = true;
     				while (rs.next()){
-...
     					String nomRefCache = rs.getString("nomRefCache");
     					String title = rs.getString("title");
     					String inRefTitle = rs.getString("InRefTitle");
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache + "\n  title: " + title +
     							"\n  inRefFk: " + inRefFk + "\n  inRefCategory: " + inRefCat +
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache + "\n  title: " + title +
     							"\n  inRefFk: " + inRefFk + "\n  inRefCategory: " + inRefCat +
     							"\n  inRefTitle: " + inRefTitle );
     					result = firstRow = false;
+    				}
     				return result;
     			} catch (SQLException e) {
     				e.printStackTrace();
     				return false;
+    			}
+    		}
     		private static boolean checkPartOfUnresolved(BerlinModelImportConfigurator config){
     			try {
     				boolean result = true;
     				Source source = config.getSource();
     				String strQuery = "SELECT Reference.RefId, InRef.RefId AS InRefID, Reference.RefCategoryFk, InRef.RefCategoryFk AS InRefCatFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, RefCategory.RefCategoryAbbrev, InRefCategory.RefCategoryAbbrev AS InRefCat, InRef.Title AS InRefTitle " +
     				String strQuery = "SELECT Reference.RefId, InRef.RefId AS InRefID, Reference.RefCategoryFk, InRef.RefCategoryFk AS InRefCatFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, RefCategory.RefCategoryAbbrev, InRefCategory.RefCategoryAbbrev AS InRefCat, InRef.Title AS InRefTitle " +
     				" FROM Reference INNER JOIN Reference AS InRef ON Reference.InRefFk = InRef.RefId INNER JOIN RefCategory ON Reference.RefCategoryFk = RefCategory.RefCategoryId INNER JOIN RefCategory AS InRefCategory ON InRef.RefCategoryFk = InRefCategory.RefCategoryId " +
     							" WHERE (Reference.RefCategoryFk = 2) AND (InRef.RefCategoryFk = 10) ";
     				if (StringUtils.isNotBlank(config.getReferenceIdTable())){
     					strQuery += String.format(" AND (reference.refId IN " +
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
+    				}
     				ResultSet rs = source.getResultSet(strQuery);
-...
     					String nomRefCache = rs.getString("nomRefCache");
     					String title = rs.getString("title");
     					String inRefTitle = rs.getString("InRefTitle");
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache + "\n  title: " + title +
     							"\n  inRefFk: " + inRefFk + "\n  inRefCategory: " + inRefCat +
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache + "\n  title: " + title +
     							"\n  inRefFk: " + inRefFk + "\n  inRefCategory: " + inRefCat +
     							"\n  inRefTitle: " + inRefTitle );
     					result = firstRow = false;
+    				}
     				if (result == false){
     					System.out.println("\nChoose a specific type from the following reference types: \n" +
     							"  1) Article \n  2) Book \n  3) BookSection \n  4) CdDvd \n  5) ConferenceProceeding \n  6) Database\n" +
     							"  1) Article \n  2) Book \n  3) BookSection \n  4) CdDvd \n  5) ConferenceProceeding \n  6) Database\n" +
     							"  7) Generic \n  7) InProceedings \n  8) Journal \n  9) Map \n 10) Patent \n 11) PersonalCommunication\n" +
     							" 12) PrintSeries \n 13) Proceedings \n 14) Report \n 15) Thesis \n 16) WebPage");
+    				}
-...
     				return false;
+    			}
+    		}
     		private static boolean checkPartOfPartOf(BerlinModelImportConfigurator config){
     			try {
     				boolean result = true;
     				Source source = config.getSource();
     				String strQuery = "SELECT Reference.RefId, InRef.RefId AS InRefID, Reference.RefCategoryFk, InRef.RefCategoryFk AS InRefCatFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, RefCategory.RefCategoryAbbrev, InRefCategory.RefCategoryAbbrev AS InRefCat, InRef.Title AS InRefTitle, InRef.InRefFk as InInRefId, InInRef.Title as inInRefTitle, InInRef.RefCategoryFk as inInRefCategory " +
     				String strQuery = "SELECT Reference.RefId, InRef.RefId AS InRefID, Reference.RefCategoryFk, InRef.RefCategoryFk AS InRefCatFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, RefCategory.RefCategoryAbbrev, InRefCategory.RefCategoryAbbrev AS InRefCat, InRef.Title AS InRefTitle, InRef.InRefFk as InInRefId, InInRef.Title as inInRefTitle, InInRef.RefCategoryFk as inInRefCategory " +
     							" FROM Reference " +
     								" INNER JOIN Reference AS InRef ON Reference.InRefFk = InRef.RefId " +
     								" INNER JOIN RefCategory ON Reference.RefCategoryFk = RefCategory.RefCategoryId " +
     								" INNER JOIN Reference AS InRef ON Reference.InRefFk = InRef.RefId " +
     								" INNER JOIN RefCategory ON Reference.RefCategoryFk = RefCategory.RefCategoryId " +
     								" INNER JOIN RefCategory AS InRefCategory ON InRef.RefCategoryFk = InRefCategory.RefCategoryId " +
     								" INNER JOIN Reference AS InInRef ON InRef.InRefFk = InInRef.RefId " +
     								" INNER JOIN Reference AS InInRef ON InRef.InRefFk = InInRef.RefId " +
     							" WHERE (Reference.RefCategoryFk = 2) AND (InRef.RefCategoryFk = 2) ";
     				if (StringUtils.isNotBlank(config.getReferenceIdTable())){
     					strQuery += String.format(" AND (reference.refId IN " +
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
+    				}
     				ResultSet rs = source.getResultSet(strQuery);
-...
     				while (rs.next()){
     					if (firstRow){
     						System.out.println("========================================================");
     						System.out.println("There are part-of-references that are part of an other 'part-of' reference!\n" +
     						System.out.println("There are part-of-references that are part of an other 'part-of' reference!\n" +
     								"         This is invalid or ambigous. Please try to determine the reference types more detailed ");
     						System.out.println("========================================================");
+    					}
-...
     					int inInRefId = rs.getInt("InInRefId");
     					String inInRefTitle = rs.getString("inInRefTitle");
     					int inInRefCategory = rs.getInt("inInRefCategory");
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache + "\n  title: " + title +
     							"\n  inRefFk: " + inRefFk + "\n  inRefCategory: " + inRefCat +
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache + "\n  title: " + title +
     							"\n  inRefFk: " + inRefFk + "\n  inRefCategory: " + inRefCat +
     							"\n  inRefTitle: " + inRefTitle + "\n  inInRefId: " + inInRefId + "\n  inInRefTitle: " + inInRefTitle +
     							"\n  inInRefCategory: " + inInRefCategory );
     					result = firstRow = false;
-...
+    			}
+    		}
     		private static boolean checkPartOfArticle(BerlinModelImportConfigurator config){
     			try {
     				boolean result = true;
     				Source source = config.getSource();
     				String strQuery = "SELECT Reference.RefId, InRef.RefId AS InRefID, Reference.RefCategoryFk, InRef.RefCategoryFk AS InRefCatFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, Reference.NomTitleAbbrev as nomTitleAbbrev, RefCategory.RefCategoryAbbrev, InRefCategory.RefCategoryAbbrev AS InRefCat, InRef.Title AS InRefTitle, InRef.nomTitleAbbrev AS inRefnomTitleAbbrev, InRef.refCache AS inRefCache, InRef.nomRefCache AS inRefnomRefCache, " +
     						"	InInRefCategory.RefCategoryAbbrev AS InInRefCat, InInRef.refCache AS inInRefCache, InInRef.nomRefCache AS inInRefNomRefCache	" +
     						" FROM Reference " +
     							" INNER JOIN Reference AS InRef ON Reference.InRefFk = InRef.RefId " +
     				String strQuery = "SELECT r.RefId, InRef.RefId AS InRefID, r.RefCategoryFk, InRef.RefCategoryFk AS InRefCatFk, r.RefCache, r.NomRefCache, r.Title, r.NomTitleAbbrev as nomTitleAbbrev, RefCategory.RefCategoryAbbrev, InRefCategory.RefCategoryAbbrev AS InRefCat, InRef.Title AS InRefTitle, InRef.nomTitleAbbrev AS inRefnomTitleAbbrev, InRef.refCache AS inRefCache, InRef.nomRefCache AS inRefnomRefCache, " +
     						"	InInRefCategory.RefCategoryAbbrev AS InInRefCat, InInRef.refCache AS inInRefCache, InInRef.nomRefCache AS inInRefNomRefCache	" +
     						" FROM Reference r " +
     							" INNER JOIN Reference AS InRef ON r.InRefFk = InRef.RefId " +
     						    " INNER JOIN Reference AS InInRef ON InRef.InRefFk = InInRef.RefId " +
     							" INNER JOIN RefCategory ON Reference.RefCategoryFk = RefCategory.RefCategoryId " +
     							" INNER JOIN RefCategory ON r.RefCategoryFk = RefCategory.RefCategoryId " +
     						    " INNER JOIN RefCategory AS InRefCategory ON InRef.RefCategoryFk = InRefCategory.RefCategoryId " +
     						    " INNER JOIN RefCategory AS InInRefCategory ON InInRef.RefCategoryFk = InInRefCategory.RefCategoryId " +
     						" WHERE (Reference.RefCategoryFk = 2) AND (InRef.RefCategoryFk = 1) ";
     						" WHERE (r.RefCategoryFk = 2) AND (InRef.RefCategoryFk = 1) ";
     				if (StringUtils.isNotBlank(config.getReferenceIdTable())){
     					strQuery += String.format(" AND (reference.refId IN " +
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
     					strQuery += String.format(" AND (r.refId IN " +
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
+    				}
     				if (config.isEuroMed()){
     				    strQuery += " AND r.RefId NOT IN (6187, 10269, 26613) ";
+    				}
     				ResultSet rs = source.getResultSet(strQuery);
     				boolean firstRow = true;
     				while (rs.next()){
-...
     					String inInRefCat = rs.getString("inInRefCat");
     					String inInRefCache = rs.getString("inInRefCache");
     					String inInRefNomRefCache = rs.getString("inInRefNomRefCache");
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache + "\n  title: " + title + "\n  titleAbbrev: " + nomTitleAbbrev +
     							"\n  inRefFk: " + inRefFk + "\n  inRefCategory: " + inRefCat +
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache + "\n  title: " + title + "\n  titleAbbrev: " + nomTitleAbbrev +
     							"\n  inRefFk: " + inRefFk + "\n  inRefCategory: " + inRefCat +
     							"\n  inRefTitle: " + inRefTitle + "\n  inRefTitleAbbrev: " + inRefnomTitleAbbrev +
     							"\n  inRefnomRefCache: " + inRefnomRefCache + "\n  inRefCache: " + inRefCache +
     							"\n  inInRefCat: " + inInRefCat + "\n  inInRefCache: " + inInRefCache +
     							"\n  inInRefNomRefCache: " + inInRefNomRefCache
     							"\n  inInRefNomRefCache: " + inInRefNomRefCache
     							);
     					result = firstRow = false;
+    				}
     				return result;
     			} catch (SQLException e) {
     				e.printStackTrace();
     				return false;
+    			}
+    		}
     		private static boolean checkJournalsWithSeries(BerlinModelImportConfigurator config){
     			try {
     				boolean result = true;
     				Source source = config.getSource();
     				String strQuery = "SELECT Reference.RefId, Reference.RefCategoryFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, Reference.NomTitleAbbrev, Reference.Series, RefCategory.RefCategoryAbbrev  " +
     				String strQuery = "SELECT Reference.RefId, Reference.RefCategoryFk, Reference.RefCache, Reference.NomRefCache, Reference.Title, Reference.NomTitleAbbrev, Reference.Series, RefCategory.RefCategoryAbbrev  " +
     							" FROM Reference INNER JOIN " +
     									" RefCategory ON Reference.RefCategoryFk = RefCategory.RefCategoryId  " +
     							" WHERE (Reference.RefCategoryFk = 9)  AND ( Reference.series is not null AND Reference.series <>'') ";
     				if (StringUtils.isNotBlank(config.getReferenceIdTable())){
     					strQuery += String.format(" AND (reference.refId IN " +
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
+    				}
     				ResultSet rs = source.getResultSet(strQuery);
     				boolean firstRow = true;
     				while (rs.next()){
-...
     					String title = rs.getString("title");
     					String nomTitleAbbrev = rs.getString("nomTitleAbbrev");
     					String series = rs.getString("series");
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache +
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache +
     							"\n  title: " + title +  "\n  nomTitleAbbrev: " + nomTitleAbbrev +
     							"\n  series: " + series );
     					result = firstRow = false;
+    				}
     				return result;
     			} catch (SQLException e) {
     				e.printStackTrace();
     				return false;
+    			}
+    		}
     		private static boolean checkPartOfWithVolume(BerlinModelImportConfigurator config){
     			try {
     				boolean result = true;
     				Source source = config.getSource();
     				String strQuery = "SELECT Ref.RefId as refId, RefCategory.RefCategoryAbbrev as refCategoryAbbrev, Ref.nomRefCache as nomRefCache, Ref.refCache as refCache,Ref.volume as volume, Ref.Series as series, Ref.Edition as edition, Ref.title as title, Ref.nomTitleAbbrev as nomTitleAbbrev,InRef.RefCache as inRefRefCache, InRef.NomRefCache  as inRefNomRefCache, InRef.RefId as inRefId, InRef.Volume as inRefVol, InRef.Series as inRefSeries, InRef.Edition as inRefEdition" +
     						" FROM Reference AS Ref " +
     						" FROM Reference AS Ref " +
     						 	" INNER JOIN RefCategory ON Ref.RefCategoryFk = RefCategory.RefCategoryId " +
     						 	"  LEFT OUTER JOIN Reference AS InRef ON Ref.InRefFk = InRef.RefId " +
     						" WHERE (Ref.RefCategoryFk = 2) AND ((Ref.Volume IS NOT NULL) OR (Ref.Series IS NOT NULL) OR (Ref.Edition IS NOT NULL)) " ;
     						" WHERE (Ref.RefCategoryFk = 2) AND ((Ref.Volume IS NOT NULL) OR (Ref.Series IS NOT NULL) OR (Ref.Edition IS NOT NULL)) " ;
     				if (StringUtils.isNotBlank(config.getReferenceIdTable())){
     					strQuery += String.format(" AND (Ref.refId IN " +
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
     	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;
+    				}
     				ResultSet rs = source.getResultSet(strQuery);
     				boolean firstRow = true;
     				while (rs.next()){
-...
     					String inRefVolume = rs.getString("inRefVol");
     					String inRefSeries = rs.getString("inRefSeries");
     					String inRefEdition = rs.getString("inRefEdition");
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache +
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache +
     							"\n  title: " + title +  "\n  nomTitleAbbrev: " + nomTitleAbbrev + "\n  volume: " + volume + "\n  series: " + series +"\n  edition: " + edition +
     							"\n  inRef-ID:" + inRefId + "\n  inRef-cache: " + inRefRefCache +
     							"\n  inRef-ID:" + inRefId + "\n  inRef-cache: " + inRefRefCache +
     							"\n  inRef-nomCache: " + inRefNomRefCache + "\n  inRef-volume: " + inRefVolume +"\n  inRef-series: " + inRefSeries +"\n  inRef-edition: " + inRefEdition +
     							"" );
     					result = firstRow = false;
+    				}
     				return result;
     			} catch (SQLException e) {
     				e.printStackTrace();
     				return false;
+    			}
+    		}
     		private static boolean checkArticleWithEdition(BerlinModelImportConfigurator config){
     			try {
     				boolean result = true;
     				Source source = config.getSource();
     				String strQuery = "SELECT Ref.RefId as refId, RefCategory.RefCategoryAbbrev as refCategoryAbbrev, Ref.nomRefCache as nomRefCache, Ref.refCache as refCache,Ref.edition as edition, Ref.title as title, Ref.nomTitleAbbrev as nomTitleAbbrev,InRef.RefCache as inRefRefCache, InRef.NomRefCache  as inRefNomRefCache, InRef.RefId as inRefId, InRef.Edition as inRefEdition" +
     						" FROM Reference AS Ref " +
     						" FROM Reference AS Ref " +
     						 	" INNER JOIN RefCategory ON Ref.RefCategoryFk = RefCategory.RefCategoryId " +
     						 	"  LEFT OUTER JOIN Reference AS InRef ON Ref.InRefFk = InRef.RefId " +
     						" WHERE (Ref.RefCategoryFk = 1) AND (NOT (Ref.Edition IS NULL))  ";
     				if (StringUtils.isNotBlank(config.getReferenceIdTable())){
     					strQuery += String.format(" AND (Ref.refId IN " +
     	                        " (SELECT refId FROM %s )) " , config.getReferenceIdTable()) ;
     	                        " (SELECT refId FROM %s )) " , config.getReferenceIdTable()) ;
+    				}
     				strQuery += " ORDER BY InRef.RefId ";
     				ResultSet rs = source.getResultSet(strQuery);
     				boolean firstRow = true;
     				while (rs.next()){
-...
     					String inRefNomRefCache = rs.getString("inRefNomRefCache");
     					int inRefId = rs.getInt("inRefId");
     					String inRefEdition = rs.getString("inRefEdition");
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache +
     							"\n  title: " + title +  "\n  nomTitleAbbrev: " + nomTitleAbbrev + "\n  edition: " + edition +
     							"\n  inRef-ID:" + inRefId + "\n  inRef-cache: " + inRefRefCache +
     					System.out.println("RefID:" + refId + "\n  cat: " + cat +
     							"\n  refCache: " + refCache + "\n  nomRefCache: " + nomRefCache +
     							"\n  title: " + title +  "\n  nomTitleAbbrev: " + nomTitleAbbrev + "\n  edition: " + edition +
     							"\n  inRef-ID:" + inRefId + "\n  inRef-cache: " + inRefRefCache +
     							"\n  inRef-nomCache: " + inRefNomRefCache + "\n  inRef-edition: " + inRefEdition +
     							"" );
     					result = firstRow = false;
+    				}
     				return result;
     			} catch (SQLException e) {
     				e.printStackTrace();
     				return false;
+    			}
+    		}
     		protected boolean checkObligatoryAttributes(BerlinModelImportConfigurator config, BerlinModelReferenceImport refImport){
     			boolean result = true;
     			try {
     				String strQuery = " SELECT Reference.* " +
     				    " FROM Reference " +
-...
     					existingAttributes.add(rs.getMetaData().getColumnLabel(c+1).toLowerCase());
+    				}
     				Set<String> obligatoryAttributes = refImport.getObligatoryAttributes(true, config);
     				obligatoryAttributes.removeAll(existingAttributes);
     				for (String attr : obligatoryAttributes){
     					System.out.println("Missing attribute: " + attr);
+    				}
     				//additional Attributes
     				obligatoryAttributes = refImport.getObligatoryAttributes(true, config);
     				existingAttributes.removeAll(obligatoryAttributes);
     				for (String attr : existingAttributes){
     					System.out.println("Additional attribute: " + attr);
-...
     		protected boolean checkRefDetailUnimplementedAttributes(BerlinModelImportConfigurator config){
     			boolean result = true;
     			try {
     				String strQuery = " SELECT Count(*) as n" +
     				    " FROM RefDetail " +
-...
     				    " WHERE SecondarySources is not NULL AND SecondarySources <> '' ";
     				Source source = config.getSource();
     				ResultSet rs = source.getResultSet(strQuery);
     				rs.next();
     				int count = rs.getInt("n");
     				if (count > 0){
     					System.out.println("========================================================");
     					System.out.println("There are "+ count + " RefDetails with SecondarySources <> NULL ! Secondary sources are not yet implemented for Berlin Model Import");
     					System.out.println("========================================================");
+    				}
     				strQuery = " SELECT Count(*) as n" +
     				    " FROM RefDetail " +
     //		            	" INNER JOIN Reference ON Reference.RefId = RefDetail.RefFk " +
     				    " WHERE IdInSource is not NULL AND IdInSource <> '' ";
     				rs = source.getResultSet(strQuery);
     				rs.next();
     				count = rs.getInt("n");
     				if (count > 0){
     					System.out.println("========================================================");
     					System.out.println("There are "+ count + " RefDetails with IdInSource <> NULL ! IdInSource are not yet implemented for Berlin Model Import");
     					System.out.println("========================================================");
+    				}
     			} catch (SQLException e) {
     				logger.error(e);
     				e.printStackTrace();
-...
     		/* (non-Javadoc)
     		 * @see eu.etaxonomy.cdm.io.common.IOValidator#validate(eu.etaxonomy.cdm.io.common.IoStateBase)
     		 */
     		@Deprecated  //use validate(state, import) instead
     		@Override
             @Deprecated  //use validate(state, import) instead
     		public boolean validate(BerlinModelImportState state) {
     			logger.warn("BerlinModelReferenceImport uses wrong validation method");
     			return false;

Also available in: Unified diff

Project

General

Profile

EDIT

Revision c29d1c8f

Added by Andreas Müller over 5 years ago