Project

General

Profile

« Previous | Next » 

Revision 8f952b7f

Added by Andreas Müller almost 8 years ago

Fix revisionnumber update for PostgreSQL #5718

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v36_40/SchemaUpdater_36_40.java
57 57 
		String tableName;
58 58 
		ISchemaUpdaterStep step;
59 59 
//		String columnName;
60 
		String query;
60 61 
		String newColumnName;
61 62 
		String oldColumnName;
62 63 
		String columnNames[];
......
83 84 
        stepList.add(step);
84 85 

  		




  85
  86
  
    
        //#5718


  		




  86
  
  
    
        //Remove autoincrement from AuditEvent.revisionnumber


  		




  
  87
  
    
        //Remove autoincrement from AuditEvent.revisionnumber if necessary


  		




  87
  88
  
    
        stepName = "Remove autoincrement from AuditEvent.revisionnumber";


  		




  88
  
  
    
//        String query = "ALTER TABLE @@AuditEvent@@ ALTER revisionnumber DROP DEFAULT";


  		




  89
  
  
    
//        step = SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepName, query, -99);


  		




  90
  
  
    
//        stepList.add(step);


  		




  91
  
  
    
        tableName = "AuditEvent";


  		




  92
  
  
    
        oldColumnName = "revisionnumber";


  		




  93
  
  
    
        newColumnName = "revisionnumberOld";


  		




  94
  
  
    
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, ! INCLUDE_AUDIT);


  		




  95
  
  
    
        stepList.add(step);


  		




  96
  
  
    

  		




  97
  
  
    
        tableName = "AuditEvent";


  		




  98
  
  
    
        String columnName = oldColumnName;


  		




  99
  
  
    
        Integer defaultValue = null;


  		




  100
  
  
    
        boolean notNull = false;  //TODO set to true after data has filled, but we are missing a NOT-NULL-Constraint adder.


  		




  101
  
  
    
        step = ColumnAdder.NewIntegerInstance(stepName, tableName, columnName, ! INCLUDE_AUDIT, defaultValue, notNull);


  		




  102
  
  
    
        stepList.add(step);


  		




  
  89
  
    
        RevisionNumberUpdater.NewInstance(stepName, stepList);


  		




  103
  90
  
    

  		




  104
  
  
    
        String query = "UPDATE @@AuditEvent@@ SET revisionnumber = revisionnumberOld";


  		




  105
  
  
    
        step = SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepName, query, -99);


  		




  106
  
  
    
        stepList.add(step);


  		




  107
  
  
    

  		




  108
  
  
    
        step = ColumnRemover.NewInstance(stepName, tableName, newColumnName, ! INCLUDE_AUDIT);


  		




  109
  
  
    
        stepList.add(step);


  		




  110
  91
  
    

  		




  111
  92
  
    
        //#5734


  		




  112
  93
  
    
        //Add symbol to terms


  		




  ......




  130
  111
  
    
        stepList.add(step);


  		




  131
  112
  
    

  		




  132
  113
  
    
        stepName = "Update symbols for terms";


  		




  133
  
  
    
        query = "UPDATE DefinedTermBase dtb SET dtb.inverseSymbol = ( " +


  		




  
  114
  
    
        query = "UPDATE DefinedTermBase dtb SET inverseSymbol = ( " +


  		




  134
  115
  
    
            " SELECT  r.abbreviatedlabel " +


  		




  135
  116
  
    
            " FROM RelationshipTermBase_inverseRepresentation MN " +


  		




  136
  117
  
    
                " INNER JOIN Representation r ON r.id = MN.inverserepresentations_id " +


  		












Also available in:  Unified diff