Project

General

Profile

« Previous | Next » 

Revision a0c48c4a

Added by Andreas Müller over 2 years ago

ref #9761 move cultivar info to new group field where necessary

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v525_527/SchemaUpdater_5251_5270.java
19 19 
import eu.etaxonomy.cdm.database.update.ISchemaUpdater;
20 20 
import eu.etaxonomy.cdm.database.update.ISchemaUpdaterStep;
21 21 
import eu.etaxonomy.cdm.database.update.SchemaUpdaterBase;
22 
import eu.etaxonomy.cdm.database.update.SimpleSchemaUpdaterStep;
22 23 
import eu.etaxonomy.cdm.database.update.TermRepresentationUpdater;
23 24 
import eu.etaxonomy.cdm.database.update.v523_525.SchemaUpdater_5250_5251;
24 25 
import eu.etaxonomy.cdm.model.metadata.CdmMetaData.CdmVersion;
......
73 74 
		newColumnName = "cultivarGroupEpithet";
74 75 
		ColumnAdder.NewStringInstance(stepList, stepName, tableName, newColumnName, INCLUDE_AUDIT);
75 76 

  		




  76
  
  
    
		//TODO update where rank = CultivarGroup


  		




  
  77
  
    
		//update where rank = CultivarGroup


  		




  
  78
  
    
		String sql = "UPDATE @@TaxonName@@ "


  		




  
  79
  
    
		        + " SET cultivarGroupEpithet = cultivarEpithet,  cultivarEpithet = null "


  		




  
  80
  
    
		        + " WHERE rank_id IN (SELECT id FROM @@DefinedTermBase@@ r WHERE r.uuid = 'd763e7d3-e7de-4bb1-9d75-225ca6948659')";


  		




  
  81
  
    
		SimpleSchemaUpdaterStep.NewAuditedInstance(stepList, stepName, sql, "TaxonName", -99);


  		




  77
  82
  
    

  		




  78
  83
  
    
		//#9755 Add Gp abbreviation to cultivar group rank


  		




  79
  84
  
    
		stepName = "Add abbrev to cultivar group rank";


  		












Also available in:  Unified diff