Project

General

Profile

« Previous | Next » 

Revision a8446552

Added by Andreas Müller over 9 years ago

last changes euroMed activator

View differences:

app-import/src/main/java/eu/etaxonomy/cdm/app/berlinModelImport/EuroMedActivator.java
56 56 
//	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_euroMed();
57 57
58 58 
	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_pesi_euromed();
59 
//	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_euromed();
59 
//	static final ICdmDataSource cdmDestination = CdmDestinations.cdm_test_local_euromed3();
60 60 
//	static final ICdmDataSource cdmDestination = CdmDestinations.localH2();
61 61
62 62 
	static final boolean includePesiExport = false;
......
79 79 
	//editor - import
80 80 
	static final EDITOR editor = EDITOR.EDITOR_AS_EDITOR;
81 81
82 
	//NomeclaturalCode
82 
	//NomenclaturalCode
83 83 
	static final NomenclaturalCode nomenclaturalCode = NomenclaturalCode.ICNAFP;
84 84 

  		




  85
  85
  
    
	//ignore null


  		




  ......




  101
  101
  
    
	


  		




  102
  102
  
    
	static String taxonTable = "v_cdm_exp_taxaAll";


  		




  103
  103
  
    
	static String classificationQuery = " SELECT DISTINCT t.PTRefFk, r.RefCache FROM PTaxon t INNER JOIN Reference r ON t.PTRefFk = r.RefId WHERE t.PTRefFk = " + sourceSecId; 


  		




  104
  
  
    
	static String relPTaxonIdQuery = " SELECT TOP (100) PERCENT r.RelPTaxonId " + 


  		




  
  104
  
    
	static String relPTaxonIdQuery = " SELECT r.RelPTaxonId " + 


  		




  105
  105
  
    
					" FROM RelPTaxon AS r INNER JOIN v_cdm_exp_taxaDirect AS a ON r.PTNameFk2 = a.PTNameFk AND r.PTRefFk2 = a.PTRefFk" +


  		




  106
  
  
    
					" ORDER BY r.RelPTaxonId ";  // AND r.RelQualifierFk =1 


  		




  
  106
  
    
					" WHERE r.RelPTaxonID NOT IN (1883791,1883800,1883823,1883852,1883853,1883864,1883896,1883921,1883943,1883944,1883955,1883972,1884008,1884030,1884031,1884035) " + //Unpublished Kew taxa which are not imported anymore


  		




  
  107
  
    
					" ";  // AND r.RelQualifierFk =1 


  		




  107
  108
  
    
	static String nameIdTable = " v_cdm_exp_namesAll ";


  		




  108
  109
  
    
	static String referenceIdTable = " v_cdm_exp_refAll ";


  		




  109
  110
  
    
	static String refDetailFilter =  " RefDetailID IN (SELECT RefDetailID FROM v_cdm_exp_RefDetail) ";


  		












Also available in:  Unified diff