Project

General

Profile

Revision 2971012a

ID2971012af3c3f76c4491f7eea2b90f038e3b68cc
Parent 3d88a9ce
Child a2228e59

Added by Andreas Müller about 2 months ago

fix #7514 update symbols for MAN and ppSynonyms

View differences:

cdmlib-model/src/main/resources/terms/TaxonRelationshipType.csv
1 1
"15db0cf7-7afc-4a86-a7d4-221c73b0c9ac",,"Taxon Relationship Type","Taxon Relationship Type","TRT","1"
2 2
"d13fecdf-eb44-4dd7-9244-26679c05df1c",,"Taxonomically Included in","Taxonomically Included in","⊂","Taxonomically Includes","Taxonomically Includes","⊃",FALSE,TRUE
3
"1ed87175-59dd-437e-959e-0d71583d8417",,"Misapplied Name for","Misapplied Name for","–","Has Misapplied Name","Has Misapplied Name","–",FALSE,FALSE
4
"b59b4bd2-11ff-45d1-bae2-146efdeee206",,"Pro parte Misapplied Name for","Pro parte Misapplied Name for","p.p.MAN","Has pro parte misapplied name","Has pro parte misapplied name",,FALSE,FALSE
5
"859fb615-b0e8-440b-866e-8a19f493cd36",,"Partial Misapplied Name for","Partial Misapplied Name for","partial MAN","Has partial misapplied name","Has partial misapplied name",,FALSE,FALSE
3
"1ed87175-59dd-437e-959e-0d71583d8417",,"Misapplied Name for","Misapplied Name for","–","Has Misapplied Name","Has Misapplied Name","–",FALSE,FALSE
4
"b59b4bd2-11ff-45d1-bae2-146efdeee206",,"Pro parte Misapplied Name for","Pro parte Misapplied Name for","––(p.p.)","Has pro parte misapplied name","Has pro parte misapplied name","-(p.p.)",FALSE,FALSE
5
"859fb615-b0e8-440b-866e-8a19f493cd36",,"Partial Misapplied Name for","Partial Misapplied Name for","––(part.)","Has partial misapplied name","Has partial misapplied name","-(part.)",FALSE,FALSE
6 6
"605b1d01-f2b1-4544-b2e0-6f08def3d6ed",,"Invalid Designation for","Invalid Designation for","–","Has Invalid Designation","Has Invalid Designation",,FALSE,FALSE
7
"8a896603-0fa3-44c6-9cd7-df2d8792e577",,"Pro parte synonym for","Pro parte synonym for","p.p.","Has pro parte synonym","Has pro parte synonym","⊃p.p.",FALSE,FALSE
8
"9d7a5e56-973c-474c-b6c3-a1cb00833a3c",,"Partial synonym for","Partial synonym for","partim","Has partial synonym","Has partial synonym","⊃partim",FALSE,FALSE
7
"8a896603-0fa3-44c6-9cd7-df2d8792e577",,"Pro parte synonym for","Pro parte synonym for","⊃p.p.","Has pro parte synonym","Has pro parte synonym","p.p.",FALSE,FALSE
8
"9d7a5e56-973c-474c-b6c3-a1cb00833a3c",,"Partial synonym for","Partial synonym for","⊃part.","Has partial synonym","Has partial synonym","part.",FALSE,FALSE
9 9
"a8f03491-2ad6-4fae-a04c-2a4c117a2e9b",,"Contradiction","Contradiction","∅","Contradiction","Contradiction","∅",TRUE,FALSE
10 10
"60974c98-64ab-4574-bb5c-c110f6db634d",,"Congruent to","Congruent to","≜","Congruent to","Congruent to","≜",TRUE,FALSE
11 11
"0501c385-cab1-4fbe-b945-fc747419bb13",,"Includes","Includes","⊃","Included in","Included in","⊂",FALSE,TRUE
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v50_51/SchemaUpdater_50_55.java
114 114
        step = ColumnTypeChanger.NewStringSizeInstance(stepName, tableName, columnName, 36, !INCLUDE_AUDIT);
115 115
        stepList.add(step);
116 116

  
117
        //7514 change symbols for pro parte synonyms and misapplied name relationship types
118
        updateConceptRelationshipSymbols(stepList);
117 119

  
118 120
        return stepList;
119 121

  
120 122
	}
121 123

  
122 124

  
123
	//7857 update name realtionships
125
	//7514
126
    private void updateConceptRelationshipSymbols(List<ISchemaUpdaterStep> stepList) {
127

  
128
        //Update misapplied name symbols
129
        String stepName = "Update misapplied name symbols";
130
        String query = "UPDATE @@DefinedTermBase@@ "
131
                + " SET symbol='––' , inverseSymbol = '-' "
132
                + " WHERE uuid = '1ed87175-59dd-437e-959e-0d71583d8417' ";
133
        String tableName = "DefinedTermBase";
134
        ISchemaUpdaterStep step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
135
        stepList.add(step);
136

  
137
        //Update pro parte misapplied name symbols
138
        stepName = "Update pro parte misapplied name symbols";
139
        query = "UPDATE @@DefinedTermBase@@ "
140
                + " SET symbol='––(p.p.)' , inverseSymbol = '-(p.p.)' "
141
                + " WHERE uuid = 'b59b4bd2-11ff-45d1-bae2-146efdeee206' ";
142
        tableName = "DefinedTermBase";
143
        step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
144
        stepList.add(step);
145

  
146
        //Update partial misapplied name symbols
147
        stepName = "Update partial misapplied name symbols";
148
        query = "UPDATE @@DefinedTermBase@@ "
149
                + " SET symbol='––(part.)' , inverseSymbol = '-(part.)' "
150
                + " WHERE uuid = '859fb615-b0e8-440b-866e-8a19f493cd36' ";
151
        tableName = "DefinedTermBase";
152
        step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
153
        stepList.add(step);
154

  
155
        //Update pro parte synonym symbols
156
        stepName = "Update pro parte synonym symbols";
157
        query = "UPDATE @@DefinedTermBase@@ "
158
                + " SET symbol='⊃p.p.' , inverseSymbol = 'p.p.' "
159
                + " WHERE uuid = '8a896603-0fa3-44c6-9cd7-df2d8792e577' ";
160
        tableName = "DefinedTermBase";
161
        step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
162
        stepList.add(step);
163

  
164
        //Update partial synonym symbols
165
        stepName = "Update partial synonym symbols";
166
        query = "UPDATE @@DefinedTermBase@@ "
167
                + " SET symbol='⊃part.' , inverseSymbol = 'part.' "
168
                + " WHERE uuid = '9d7a5e56-973c-474c-b6c3-a1cb00833a3c' ";
169
        tableName = "DefinedTermBase";
170
        step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
171
        stepList.add(step);
172

  
173
    }
174

  
175
    //7857 update name realtionships
124 176
    private void updateNameRelationships(List<ISchemaUpdaterStep> stepList) {
125 177

  
126 178
        //7857 Update symmetrical for name relationships

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)