Revision 757c09fe
Added by Andreas Müller about 5 years ago
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/CdmUpdater.java | ||
---|---|---|
17 | 17 |
import eu.etaxonomy.cdm.common.monitor.IProgressMonitor; |
18 | 18 |
import eu.etaxonomy.cdm.database.CdmDataSource; |
19 | 19 |
import eu.etaxonomy.cdm.database.ICdmDataSource; |
20 |
import eu.etaxonomy.cdm.database.update.v50_51.SchemaUpdater_50_55;
|
|
20 |
import eu.etaxonomy.cdm.database.update.v50_55.SchemaUpdater_50_55;
|
|
21 | 21 |
import eu.etaxonomy.cdm.model.metadata.CdmMetaData; |
22 | 22 |
|
23 | 23 |
/** |
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_50/SchemaUpdater_47_50.java | ||
---|---|---|
30 | 30 |
import eu.etaxonomy.cdm.database.update.TableNameChanger; |
31 | 31 |
import eu.etaxonomy.cdm.database.update.TermRepresentationUpdater; |
32 | 32 |
import eu.etaxonomy.cdm.database.update.v41_47.SchemaUpdater_41_47; |
33 |
import eu.etaxonomy.cdm.database.update.v50_51.SchemaUpdater_50_55;
|
|
33 |
import eu.etaxonomy.cdm.database.update.v50_55.SchemaUpdater_50_55;
|
|
34 | 34 |
|
35 | 35 |
/** |
36 | 36 |
/** |
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v50_51/SchemaUpdater_50_55.java | ||
---|---|---|
1 |
/** |
|
2 |
* Copyright (C) 2007 EDIT |
|
3 |
* European Distributed Institute of Taxonomy |
|
4 |
* http://www.e-taxonomy.eu |
|
5 |
* |
|
6 |
* The contents of this file are subject to the Mozilla Public License Version 1.1 |
|
7 |
* See LICENSE.TXT at the top of this package for the full license terms. |
|
8 |
*/ |
|
9 |
|
|
10 |
package eu.etaxonomy.cdm.database.update.v50_51; |
|
11 |
|
|
12 |
import java.util.ArrayList; |
|
13 |
import java.util.List; |
|
14 |
import java.util.UUID; |
|
15 |
|
|
16 |
import org.apache.log4j.Logger; |
|
17 |
|
|
18 |
import eu.etaxonomy.cdm.database.update.ColumnAdder; |
|
19 |
import eu.etaxonomy.cdm.database.update.ColumnNameChanger; |
|
20 |
import eu.etaxonomy.cdm.database.update.ColumnRemover; |
|
21 |
import eu.etaxonomy.cdm.database.update.ColumnTypeChanger; |
|
22 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdater; |
|
23 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdaterStep; |
|
24 |
import eu.etaxonomy.cdm.database.update.MnTableCreator; |
|
25 |
import eu.etaxonomy.cdm.database.update.SchemaUpdaterBase; |
|
26 |
import eu.etaxonomy.cdm.database.update.SimpleSchemaUpdaterStep; |
|
27 |
import eu.etaxonomy.cdm.database.update.TableNameChanger; |
|
28 |
import eu.etaxonomy.cdm.database.update.TermRepresentationUpdater; |
|
29 |
import eu.etaxonomy.cdm.database.update.v47_50.SchemaUpdater_47_50; |
|
30 |
import eu.etaxonomy.cdm.model.common.TermType; |
|
31 |
|
|
32 |
/** |
|
33 |
/** |
|
34 |
* @author a.mueller |
|
35 |
* @date 09.06.2017 |
|
36 |
* |
|
37 |
*/ |
|
38 |
public class SchemaUpdater_50_55 extends SchemaUpdaterBase { |
|
39 |
|
|
40 |
@SuppressWarnings("unused") |
|
41 |
private static final Logger logger = Logger.getLogger(SchemaUpdater_50_55.class); |
|
42 |
private static final String startSchemaVersion = "5.0.0.0.20180514"; |
|
43 |
private static final String endSchemaVersion = "5.5.0.0.20190221"; |
|
44 |
|
|
45 |
// ********************** FACTORY METHOD ************************************* |
|
46 |
|
|
47 |
public static SchemaUpdater_50_55 NewInstance() { |
|
48 |
return new SchemaUpdater_50_55(); |
|
49 |
} |
|
50 |
|
|
51 |
/** |
|
52 |
* @param startSchemaVersion |
|
53 |
* @param endSchemaVersion |
|
54 |
*/ |
|
55 |
protected SchemaUpdater_50_55() { |
|
56 |
super(startSchemaVersion, endSchemaVersion); |
|
57 |
} |
|
58 |
|
|
59 |
@Override |
|
60 |
protected List<ISchemaUpdaterStep> getUpdaterList() { |
|
61 |
|
|
62 |
String stepName; |
|
63 |
String tableName; |
|
64 |
ISchemaUpdaterStep step; |
|
65 |
String newColumnName; |
|
66 |
String query; |
|
67 |
|
|
68 |
List<ISchemaUpdaterStep> stepList = new ArrayList<>(); |
|
69 |
|
|
70 |
|
|
71 |
//#6699 delete term version |
|
72 |
//just in case not fixed before yet |
|
73 |
stepName = "Delete term version"; |
|
74 |
query = "DELETE FROM @@CdmMetaData@@ WHERE propertyName = 'TERM_VERSION'"; |
|
75 |
step = SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepName, query, -99); |
|
76 |
stepList.add(step); |
|
77 |
|
|
78 |
//#7414 remove mediaCreatedOld column |
|
79 |
stepName = "remove mediaCreatedOld column"; |
|
80 |
tableName = "Media"; |
|
81 |
String oldColumnName = "mediaCreatedOld"; |
|
82 |
step = ColumnRemover.NewInstance(stepName, tableName, oldColumnName, INCLUDE_AUDIT); |
|
83 |
stepList.add(step); |
|
84 |
|
|
85 |
//TODO remove proparte and partial columns |
|
86 |
|
|
87 |
//#7772 rename TermBase_inverseRepresentation to DefinedTermBase_InverseRepresentation |
|
88 |
stepName = "Rename TermBase_inverseRepresentation to DefinedTermBase_InverseRepresentation"; |
|
89 |
String oldName = "TermBase_inverseRepresentation"; |
|
90 |
String newName = "DefinedTermBase_InverseRepresentation"; |
|
91 |
step = TableNameChanger.NewInstance(stepName, oldName, |
|
92 |
newName, INCLUDE_AUDIT); |
|
93 |
stepList.add(step); |
|
94 |
|
|
95 |
//#7772 rename DefinedTermBase_InverseRepresentation.term_id to .definedTermBase_id |
|
96 |
stepName = "Rename TermBase_inverseRepresentation to DefinedTermBase_InverseRepresentation"; |
|
97 |
tableName = "DefinedTermBase_InverseRepresentation"; |
|
98 |
oldColumnName = "term_id"; |
|
99 |
newColumnName = "definedTermBase_id"; |
|
100 |
step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT); |
|
101 |
stepList.add(step); |
|
102 |
|
|
103 |
//#8004 add sortindex to description element |
|
104 |
stepName = "Add sortindex to description element"; |
|
105 |
tableName = "DescriptionElementBase"; |
|
106 |
newColumnName = "sortIndex"; |
|
107 |
step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, null, !NOT_NULL); |
|
108 |
stepList.add(step); |
|
109 |
|
|
110 |
//#7682 update Point.precision from 0 to null |
|
111 |
stepName = "update Point.precision from 0 to null"; |
|
112 |
query = "UPDATE @@GatheringEvent@@ SET exactLocation_errorRadius = null WHERE exactLocation_errorRadius = 0 "; |
|
113 |
tableName = "GatheringEvent"; |
|
114 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
115 |
stepList.add(step); |
|
116 |
|
|
117 |
//#7859 CdmPreference.value as CLOB |
|
118 |
stepName = "Make CdmPreference.value a CLOB"; |
|
119 |
String columnName = "value"; |
|
120 |
tableName = "CdmPreference"; |
|
121 |
// TODO check non MySQL and with existing data (probably does not exist) |
|
122 |
step = ColumnTypeChanger.NewClobInstance(stepName, tableName, |
|
123 |
columnName, !INCLUDE_AUDIT); |
|
124 |
stepList.add(step); |
|
125 |
|
|
126 |
//#7857 update name realtionships |
|
127 |
updateNameRelationships(stepList); |
|
128 |
|
|
129 |
//#7683 allow null for ExternalLink_AUD.uuid |
|
130 |
stepName = "Allow null for ExternalLink_AUD.uuid "; |
|
131 |
columnName = "uuid"; |
|
132 |
tableName = "ExternalLink_AUD"; |
|
133 |
step = ColumnTypeChanger.NewStringSizeInstance(stepName, tableName, columnName, 36, !INCLUDE_AUDIT); |
|
134 |
stepList.add(step); |
|
135 |
|
|
136 |
//#7514 change symbols for pro parte synonyms and misapplied name relationship types |
|
137 |
updateConceptRelationshipSymbols(stepList); |
|
138 |
|
|
139 |
//#8006 |
|
140 |
updateTaxonRelationshipLabels(stepList); |
|
141 |
|
|
142 |
//#7372 |
|
143 |
stepName = "Add allowDuplicates to feature tree"; |
|
144 |
tableName = "FeatureTree"; |
|
145 |
newColumnName = "allowDuplicates"; |
|
146 |
step = ColumnAdder.NewBooleanInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, false); |
|
147 |
stepList.add(step); |
|
148 |
|
|
149 |
//#6794 add term type to feature tree |
|
150 |
stepName = "Add termType to feature tree"; |
|
151 |
tableName = "FeatureTree"; |
|
152 |
newColumnName = "termType"; |
|
153 |
step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, 255, TermType.Feature.getKey(), INCLUDE_AUDIT) |
|
154 |
.setNotNull(NOT_NULL); |
|
155 |
stepList.add(step); |
|
156 |
|
|
157 |
//#6794 add term type to feature node |
|
158 |
stepName = "Add termType to feature node"; |
|
159 |
tableName = "FeatureNode"; |
|
160 |
newColumnName = "termType"; |
|
161 |
step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, 255, TermType.Feature.getKey(), INCLUDE_AUDIT) |
|
162 |
.setNotNull(NOT_NULL); |
|
163 |
stepList.add(step); |
|
164 |
|
|
165 |
//#8120 add structure modifier |
|
166 |
stepName = "Add structure modifier to Character"; |
|
167 |
tableName = "DefinedTermBase"; |
|
168 |
String referedTableName = "DefinedTermBase"; |
|
169 |
newColumnName = "structureModifier_id"; |
|
170 |
step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, !NOT_NULL, referedTableName); |
|
171 |
stepList.add(step); |
|
172 |
|
|
173 |
//#8120 add property modifier |
|
174 |
stepName = "Add property modifier to Character"; |
|
175 |
tableName = "DefinedTermBase"; |
|
176 |
referedTableName = "DefinedTermBase"; |
|
177 |
newColumnName = "propertyModifier_id"; |
|
178 |
step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, !NOT_NULL, referedTableName); |
|
179 |
stepList.add(step); |
|
180 |
|
|
181 |
//#8142 add plural to representations |
|
182 |
stepName = "Add plural to representations"; |
|
183 |
tableName = "Representation"; |
|
184 |
newColumnName = "plural"; |
|
185 |
step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT); |
|
186 |
stepList.add(step); |
|
187 |
|
|
188 |
//#8017 add type designation sources |
|
189 |
stepName = "Add plural type designation sources"; |
|
190 |
String firstTableName = "TypeDesignationBase"; |
|
191 |
String secondTableName = "OriginalSourceBase"; |
|
192 |
step = MnTableCreator.NewMnInstance(stepName, firstTableName, null, secondTableName, null, "sources", INCLUDE_AUDIT, !IS_LIST, IS_1_TO_M); |
|
193 |
stepList.add(step); |
|
194 |
|
|
195 |
return stepList; |
|
196 |
|
|
197 |
} |
|
198 |
|
|
199 |
//8006 update taxon relationships |
|
200 |
private void updateTaxonRelationshipLabels(List<ISchemaUpdaterStep> stepList) { |
|
201 |
|
|
202 |
// //7857 Update symmetrical for name relationships |
|
203 |
// String stepName = "Update symmetrical for name relationships"; |
|
204 |
// String query = "UPDATE @@DefinedTermBase@@ " |
|
205 |
// + " SET symmetrical=0 " |
|
206 |
// + " WHERE uuid IN ('049c6358-1094-4765-9fae-c9972a0e7780', '6e23ad45-3f2a-462b-ad87-d2389cd6e26c', " |
|
207 |
// + " 'c6f9afcb-8287-4a2b-a6f6-4da3a073d5de', 'eeaea868-c4c1-497f-b9fe-52c9fc4aca53') "; |
|
208 |
// String tableName = "DefinedTermBase"; |
|
209 |
// ISchemaUpdaterStep step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
210 |
// stepList.add(step); |
|
211 |
|
|
212 |
//Taxonomically Included in |
|
213 |
String stepName = "Taxonomically Included in => is taxonomically included in"; |
|
214 |
UUID uuidTerm = UUID.fromString("d13fecdf-eb44-4dd7-9244-26679c05df1c"); |
|
215 |
UUID uuidLanguage = UUID.fromString("e9f8cdb7-6819-44e8-95d3-e2d0690c3523"); |
|
216 |
String label = "is taxonomically included in"; |
|
217 |
ISchemaUpdaterStep step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
218 |
label, label, null, uuidLanguage); |
|
219 |
stepList.add(step); |
|
220 |
|
|
221 |
stepName = "taxonomically includes => taxonomically includes"; |
|
222 |
label = "taxonomically includes"; |
|
223 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
224 |
label, label, null, uuidLanguage); |
|
225 |
stepList.add(step); |
|
226 |
|
|
227 |
//Misapplied Name for |
|
228 |
stepName = "Misapplied Name for => is misapplied name for"; |
|
229 |
uuidTerm = UUID.fromString("1ed87175-59dd-437e-959e-0d71583d8417"); |
|
230 |
label = "is misapplied name for"; |
|
231 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
232 |
label, label, null, uuidLanguage); |
|
233 |
stepList.add(step); |
|
234 |
|
|
235 |
stepName = "Has Misapplied Name => has misapplied name"; |
|
236 |
label = "has misapplied name"; |
|
237 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
238 |
label, label, null, uuidLanguage); |
|
239 |
stepList.add(step); |
|
240 |
|
|
241 |
//Pro parte Misapplied Name for |
|
242 |
stepName = "Pro parte Misapplied Name for => is pro parte misapplied name for"; |
|
243 |
uuidTerm = UUID.fromString("b59b4bd2-11ff-45d1-bae2-146efdeee206"); |
|
244 |
label = "is pro parte misapplied name for"; |
|
245 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
246 |
label, label, null, uuidLanguage); |
|
247 |
stepList.add(step); |
|
248 |
|
|
249 |
stepName = "Has Pro parte Misapplied Name => has pro parte misapplied name"; |
|
250 |
label = "has pro parte misapplied name"; |
|
251 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
252 |
label, label, null, uuidLanguage); |
|
253 |
stepList.add(step); |
|
254 |
|
|
255 |
//Partial Misapplied Name for |
|
256 |
stepName = "Partial Misapplied Name for => is partial misapplied name for"; |
|
257 |
uuidTerm = UUID.fromString("859fb615-b0e8-440b-866e-8a19f493cd36"); |
|
258 |
label = "is partial misapplied name for"; |
|
259 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
260 |
label, label, null, uuidLanguage); |
|
261 |
stepList.add(step); |
|
262 |
|
|
263 |
stepName = "Has Partial Misapplied Name => has partial misapplied name"; |
|
264 |
label = "has partial misapplied name"; |
|
265 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
266 |
label, label, null, uuidLanguage); |
|
267 |
stepList.add(step); |
|
268 |
|
|
269 |
//Pro parte Synonym for |
|
270 |
stepName = "Pro parte Synonym for => is pro parte synonym for"; |
|
271 |
uuidTerm = UUID.fromString("8a896603-0fa3-44c6-9cd7-df2d8792e577"); |
|
272 |
label = "is pro parte synonym for"; |
|
273 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
274 |
label, label, null, uuidLanguage); |
|
275 |
stepList.add(step); |
|
276 |
|
|
277 |
stepName = "Has Pro parte Synonym => has pro parte synonym"; |
|
278 |
label = "has pro parte synonym"; |
|
279 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
280 |
label, label, null, uuidLanguage); |
|
281 |
stepList.add(step); |
|
282 |
|
|
283 |
//Partial Synonym for |
|
284 |
stepName = "Partial Synonym for => is partial synonym for"; |
|
285 |
uuidTerm = UUID.fromString("9d7a5e56-973c-474c-b6c3-a1cb00833a3c"); |
|
286 |
label = "is partial synonym for"; |
|
287 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
288 |
label, label, null, uuidLanguage); |
|
289 |
stepList.add(step); |
|
290 |
|
|
291 |
stepName = "Has Partial Synonym => has partial synonym"; |
|
292 |
label = "has partial synonym"; |
|
293 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
294 |
label, label, null, uuidLanguage); |
|
295 |
stepList.add(step); |
|
296 |
|
|
297 |
//Invalid Designation for |
|
298 |
stepName = "Invalid Designation for => is invalid designation for"; |
|
299 |
uuidTerm = UUID.fromString("605b1d01-f2b1-4544-b2e0-6f08def3d6ed"); |
|
300 |
label = "is invalid designation for"; |
|
301 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
302 |
label, label, null, uuidLanguage); |
|
303 |
stepList.add(step); |
|
304 |
|
|
305 |
stepName = "Has Invalid Designation => has invalid designation"; |
|
306 |
label = "has invalid designation"; |
|
307 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
308 |
label, label, null, uuidLanguage); |
|
309 |
stepList.add(step); |
|
310 |
|
|
311 |
//Not yet worked on |
|
312 |
stepName = "Unclear => Not yet worked on"; |
|
313 |
label = "Not yet worked on"; |
|
314 |
uuidTerm = UUID.fromString("8d47e59a-790d-428f-8060-01d443519166"); |
|
315 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
316 |
label, label, null, uuidLanguage); |
|
317 |
stepList.add(step); |
|
318 |
} |
|
319 |
|
|
320 |
|
|
321 |
//7514 |
|
322 |
private void updateConceptRelationshipSymbols(List<ISchemaUpdaterStep> stepList) { |
|
323 |
|
|
324 |
//Update misapplied name symbols |
|
325 |
String stepName = "Update misapplied name symbols"; |
|
326 |
String query = "UPDATE @@DefinedTermBase@@ " |
|
327 |
+ " SET symbol='––' , inverseSymbol = '-' " |
|
328 |
+ " WHERE uuid = '1ed87175-59dd-437e-959e-0d71583d8417' "; |
|
329 |
String tableName = "DefinedTermBase"; |
|
330 |
ISchemaUpdaterStep step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
331 |
stepList.add(step); |
|
332 |
|
|
333 |
//Update pro parte misapplied name symbols |
|
334 |
stepName = "Update pro parte misapplied name symbols"; |
|
335 |
query = "UPDATE @@DefinedTermBase@@ " |
|
336 |
+ " SET symbol='––(p.p.)' , inverseSymbol = '-(p.p.)' " |
|
337 |
+ " WHERE uuid = 'b59b4bd2-11ff-45d1-bae2-146efdeee206' "; |
|
338 |
tableName = "DefinedTermBase"; |
|
339 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
340 |
stepList.add(step); |
|
341 |
|
|
342 |
//Update partial misapplied name symbols |
|
343 |
stepName = "Update partial misapplied name symbols"; |
|
344 |
query = "UPDATE @@DefinedTermBase@@ " |
|
345 |
+ " SET symbol='––(part.)' , inverseSymbol = '-(part.)' " |
|
346 |
+ " WHERE uuid = '859fb615-b0e8-440b-866e-8a19f493cd36' "; |
|
347 |
tableName = "DefinedTermBase"; |
|
348 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
349 |
stepList.add(step); |
|
350 |
|
|
351 |
//Update pro parte synonym symbols |
|
352 |
stepName = "Update pro parte synonym symbols"; |
|
353 |
query = "UPDATE @@DefinedTermBase@@ " |
|
354 |
+ " SET symbol='⊃p.p.' , inverseSymbol = 'p.p.' " |
|
355 |
+ " WHERE uuid = '8a896603-0fa3-44c6-9cd7-df2d8792e577' "; |
|
356 |
tableName = "DefinedTermBase"; |
|
357 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
358 |
stepList.add(step); |
|
359 |
|
|
360 |
//Update partial synonym symbols |
|
361 |
stepName = "Update partial synonym symbols"; |
|
362 |
query = "UPDATE @@DefinedTermBase@@ " |
|
363 |
+ " SET symbol='⊃part.' , inverseSymbol = 'part.' " |
|
364 |
+ " WHERE uuid = '9d7a5e56-973c-474c-b6c3-a1cb00833a3c' "; |
|
365 |
tableName = "DefinedTermBase"; |
|
366 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
367 |
stepList.add(step); |
|
368 |
|
|
369 |
} |
|
370 |
|
|
371 |
//7857 update name realtionships |
|
372 |
private void updateNameRelationships(List<ISchemaUpdaterStep> stepList) { |
|
373 |
|
|
374 |
//7857 Update symmetrical for name relationships |
|
375 |
String stepName = "Update symmetrical for name relationships"; |
|
376 |
String query = "UPDATE @@DefinedTermBase@@ " |
|
377 |
+ " SET symmetrical=0 " |
|
378 |
+ " WHERE uuid IN ('049c6358-1094-4765-9fae-c9972a0e7780', '6e23ad45-3f2a-462b-ad87-d2389cd6e26c', " |
|
379 |
+ " 'c6f9afcb-8287-4a2b-a6f6-4da3a073d5de', 'eeaea868-c4c1-497f-b9fe-52c9fc4aca53') "; |
|
380 |
String tableName = "DefinedTermBase"; |
|
381 |
ISchemaUpdaterStep step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
382 |
stepList.add(step); |
|
383 |
|
|
384 |
//orthographic variant for |
|
385 |
stepName = "orthographic variant for => is orthographic variant for"; |
|
386 |
UUID uuidTerm = UUID.fromString("eeaea868-c4c1-497f-b9fe-52c9fc4aca53"); |
|
387 |
UUID uuidLanguage = UUID.fromString("e9f8cdb7-6819-44e8-95d3-e2d0690c3523"); |
|
388 |
String label = "is orthographic variant for"; |
|
389 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
390 |
label, label, null, uuidLanguage); |
|
391 |
stepList.add(step); |
|
392 |
|
|
393 |
//original spelling for |
|
394 |
stepName = "original spelling for => is original spelling for"; |
|
395 |
uuidTerm = UUID.fromString("264d2be4-e378-4168-9760-a9512ffbddc4"); |
|
396 |
label = "is original spelling for"; |
|
397 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
398 |
label, label, null, uuidLanguage); |
|
399 |
stepList.add(step); |
|
400 |
|
|
401 |
//misspelling for |
|
402 |
stepName = "misspelling for => is misspelling for"; |
|
403 |
uuidTerm = UUID.fromString("c6f9afcb-8287-4a2b-a6f6-4da3a073d5de"); |
|
404 |
label = "is misspelling for"; |
|
405 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
406 |
label, label, null, uuidLanguage); |
|
407 |
stepList.add(step); |
|
408 |
|
|
409 |
//later homonym for |
|
410 |
stepName = "later homonym for => is later homonym for"; |
|
411 |
uuidTerm = UUID.fromString("80f06f65-58e0-4209-b811-cb40ad7220a6"); |
|
412 |
label = "is later homonym for"; |
|
413 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
414 |
label, label, null, uuidLanguage); |
|
415 |
stepList.add(step); |
|
416 |
|
|
417 |
//treated as later homonym for |
|
418 |
stepName = " => is treated as later homonym for"; |
|
419 |
uuidTerm = UUID.fromString("2990a884-3302-4c8b-90b2-dfd31aaa2778"); |
|
420 |
label = "is treated as later homonym for"; |
|
421 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
422 |
label, label, null, uuidLanguage); |
|
423 |
stepList.add(step); |
|
424 |
|
|
425 |
//alternative name for |
|
426 |
stepName = "alternative name for => is alternative name for"; |
|
427 |
uuidTerm = UUID.fromString("049c6358-1094-4765-9fae-c9972a0e7780"); |
|
428 |
label = "is alternative name for"; |
|
429 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
430 |
label, label, null, uuidLanguage); |
|
431 |
stepList.add(step); |
|
432 |
|
|
433 |
//basionym for |
|
434 |
stepName = "basionym for => is basionym for"; |
|
435 |
uuidTerm = UUID.fromString("25792738-98de-4762-bac1-8c156faded4a"); |
|
436 |
label = "is basionym for"; |
|
437 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
438 |
label, label, null, uuidLanguage); |
|
439 |
stepList.add(step); |
|
440 |
|
|
441 |
//replaced synonym for |
|
442 |
stepName = "replaced synonym for => is replaced synonym for"; |
|
443 |
uuidTerm = UUID.fromString("71c67c38-d162-445b-b0c2-7aba56106696"); |
|
444 |
label = "is replaced synonym for"; |
|
445 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
446 |
label, label, null, uuidLanguage); |
|
447 |
stepList.add(step); |
|
448 |
|
|
449 |
//conserved against |
|
450 |
stepName = "conserved against => is conserved against"; |
|
451 |
uuidTerm = UUID.fromString("e6439f95-bcac-4ebb-a8b5-69fa5ce79e6a"); |
|
452 |
label = "is conserved against"; |
|
453 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
454 |
label, label, null, uuidLanguage); |
|
455 |
stepList.add(step); |
|
456 |
|
|
457 |
//validated by |
|
458 |
stepName = "validated by => is validated by"; |
|
459 |
uuidTerm = UUID.fromString("a176c9ad-b4c2-4c57-addd-90373f8270eb"); |
|
460 |
label = "is validated by"; |
|
461 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
462 |
label, label, null, uuidLanguage); |
|
463 |
stepList.add(step); |
|
464 |
|
|
465 |
//later validated by |
|
466 |
stepName = "later validated by => is later validated by"; |
|
467 |
uuidTerm = UUID.fromString("a25ee4c1-863a-4dab-9499-290bf9b89639"); |
|
468 |
label = "is later validated by"; |
|
469 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
470 |
label, label, null, uuidLanguage); |
|
471 |
stepList.add(step); |
|
472 |
|
|
473 |
//blocking name for |
|
474 |
stepName = "blocking name for => is blocking name for"; |
|
475 |
uuidTerm = UUID.fromString("1dab357f-2e12-4511-97a4-e5153589e6a6"); |
|
476 |
label = "blocking name for"; |
|
477 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
478 |
label, label, null, uuidLanguage); |
|
479 |
stepList.add(step); |
|
480 |
|
|
481 |
//emendation for |
|
482 |
stepName = "emendation for => is emendation for"; |
|
483 |
uuidTerm = UUID.fromString("6e23ad45-3f2a-462b-ad87-d2389cd6e26c"); |
|
484 |
label = "is emendation for"; |
|
485 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
486 |
label, label, null, uuidLanguage); |
|
487 |
stepList.add(step); |
|
488 |
} |
|
489 |
|
|
490 |
@Override |
|
491 |
public ISchemaUpdater getNextUpdater() { |
|
492 |
return null; |
|
493 |
} |
|
494 |
|
|
495 |
@Override |
|
496 |
public ISchemaUpdater getPreviousUpdater() { |
|
497 |
return SchemaUpdater_47_50.NewInstance(); |
|
498 |
} |
|
499 |
|
|
500 |
} |
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v50_55/SchemaUpdater_50_55.java | ||
---|---|---|
1 |
/** |
|
2 |
* Copyright (C) 2007 EDIT |
|
3 |
* European Distributed Institute of Taxonomy |
|
4 |
* http://www.e-taxonomy.eu |
|
5 |
* |
|
6 |
* The contents of this file are subject to the Mozilla Public License Version 1.1 |
|
7 |
* See LICENSE.TXT at the top of this package for the full license terms. |
|
8 |
*/ |
|
9 |
|
|
10 |
package eu.etaxonomy.cdm.database.update.v50_55; |
|
11 |
|
|
12 |
import java.util.ArrayList; |
|
13 |
import java.util.List; |
|
14 |
import java.util.UUID; |
|
15 |
|
|
16 |
import org.apache.log4j.Logger; |
|
17 |
|
|
18 |
import eu.etaxonomy.cdm.database.update.ColumnAdder; |
|
19 |
import eu.etaxonomy.cdm.database.update.ColumnNameChanger; |
|
20 |
import eu.etaxonomy.cdm.database.update.ColumnRemover; |
|
21 |
import eu.etaxonomy.cdm.database.update.ColumnTypeChanger; |
|
22 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdater; |
|
23 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdaterStep; |
|
24 |
import eu.etaxonomy.cdm.database.update.MnTableCreator; |
|
25 |
import eu.etaxonomy.cdm.database.update.SchemaUpdaterBase; |
|
26 |
import eu.etaxonomy.cdm.database.update.SimpleSchemaUpdaterStep; |
|
27 |
import eu.etaxonomy.cdm.database.update.TableNameChanger; |
|
28 |
import eu.etaxonomy.cdm.database.update.TermRepresentationUpdater; |
|
29 |
import eu.etaxonomy.cdm.database.update.v47_50.SchemaUpdater_47_50; |
|
30 |
import eu.etaxonomy.cdm.model.common.TermType; |
|
31 |
|
|
32 |
/** |
|
33 |
/** |
|
34 |
* @author a.mueller |
|
35 |
* @date 09.06.2017 |
|
36 |
* |
|
37 |
*/ |
|
38 |
public class SchemaUpdater_50_55 extends SchemaUpdaterBase { |
|
39 |
|
|
40 |
@SuppressWarnings("unused") |
|
41 |
private static final Logger logger = Logger.getLogger(SchemaUpdater_50_55.class); |
|
42 |
private static final String startSchemaVersion = "5.0.0.0.20180514"; |
|
43 |
private static final String endSchemaVersion = "5.5.0.0.20190221"; |
|
44 |
|
|
45 |
// ********************** FACTORY METHOD ************************************* |
|
46 |
|
|
47 |
public static SchemaUpdater_50_55 NewInstance() { |
|
48 |
return new SchemaUpdater_50_55(); |
|
49 |
} |
|
50 |
|
|
51 |
/** |
|
52 |
* @param startSchemaVersion |
|
53 |
* @param endSchemaVersion |
|
54 |
*/ |
|
55 |
protected SchemaUpdater_50_55() { |
|
56 |
super(startSchemaVersion, endSchemaVersion); |
|
57 |
} |
|
58 |
|
|
59 |
@Override |
|
60 |
protected List<ISchemaUpdaterStep> getUpdaterList() { |
|
61 |
|
|
62 |
String stepName; |
|
63 |
String tableName; |
|
64 |
ISchemaUpdaterStep step; |
|
65 |
String newColumnName; |
|
66 |
String query; |
|
67 |
|
|
68 |
List<ISchemaUpdaterStep> stepList = new ArrayList<>(); |
|
69 |
|
|
70 |
|
|
71 |
//#6699 delete term version |
|
72 |
//just in case not fixed before yet |
|
73 |
stepName = "Delete term version"; |
|
74 |
query = "DELETE FROM @@CdmMetaData@@ WHERE propertyName = 'TERM_VERSION'"; |
|
75 |
step = SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepName, query, -99); |
|
76 |
stepList.add(step); |
|
77 |
|
|
78 |
//#7414 remove mediaCreatedOld column |
|
79 |
stepName = "remove mediaCreatedOld column"; |
|
80 |
tableName = "Media"; |
|
81 |
String oldColumnName = "mediaCreatedOld"; |
|
82 |
step = ColumnRemover.NewInstance(stepName, tableName, oldColumnName, INCLUDE_AUDIT); |
|
83 |
stepList.add(step); |
|
84 |
|
|
85 |
//TODO remove proparte and partial columns |
|
86 |
|
|
87 |
//#7772 rename TermBase_inverseRepresentation to DefinedTermBase_InverseRepresentation |
|
88 |
stepName = "Rename TermBase_inverseRepresentation to DefinedTermBase_InverseRepresentation"; |
|
89 |
String oldName = "TermBase_inverseRepresentation"; |
|
90 |
String newName = "DefinedTermBase_InverseRepresentation"; |
|
91 |
step = TableNameChanger.NewInstance(stepName, oldName, |
|
92 |
newName, INCLUDE_AUDIT); |
|
93 |
stepList.add(step); |
|
94 |
|
|
95 |
//#7772 rename DefinedTermBase_InverseRepresentation.term_id to .definedTermBase_id |
|
96 |
stepName = "Rename TermBase_inverseRepresentation to DefinedTermBase_InverseRepresentation"; |
|
97 |
tableName = "DefinedTermBase_InverseRepresentation"; |
|
98 |
oldColumnName = "term_id"; |
|
99 |
newColumnName = "definedTermBase_id"; |
|
100 |
step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT); |
|
101 |
stepList.add(step); |
|
102 |
|
|
103 |
//#8004 add sortindex to description element |
|
104 |
stepName = "Add sortindex to description element"; |
|
105 |
tableName = "DescriptionElementBase"; |
|
106 |
newColumnName = "sortIndex"; |
|
107 |
step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, null, !NOT_NULL); |
|
108 |
stepList.add(step); |
|
109 |
|
|
110 |
//#7682 update Point.precision from 0 to null |
|
111 |
stepName = "update Point.precision from 0 to null"; |
|
112 |
query = "UPDATE @@GatheringEvent@@ SET exactLocation_errorRadius = null WHERE exactLocation_errorRadius = 0 "; |
|
113 |
tableName = "GatheringEvent"; |
|
114 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
115 |
stepList.add(step); |
|
116 |
|
|
117 |
//#7859 CdmPreference.value as CLOB |
|
118 |
stepName = "Make CdmPreference.value a CLOB"; |
|
119 |
String columnName = "value"; |
|
120 |
tableName = "CdmPreference"; |
|
121 |
// TODO check non MySQL and with existing data (probably does not exist) |
|
122 |
step = ColumnTypeChanger.NewClobInstance(stepName, tableName, |
|
123 |
columnName, !INCLUDE_AUDIT); |
|
124 |
stepList.add(step); |
|
125 |
|
|
126 |
//#7857 update name realtionships |
|
127 |
updateNameRelationships(stepList); |
|
128 |
|
|
129 |
//#7683 allow null for ExternalLink_AUD.uuid |
|
130 |
stepName = "Allow null for ExternalLink_AUD.uuid "; |
|
131 |
columnName = "uuid"; |
|
132 |
tableName = "ExternalLink_AUD"; |
|
133 |
step = ColumnTypeChanger.NewStringSizeInstance(stepName, tableName, columnName, 36, !INCLUDE_AUDIT); |
|
134 |
stepList.add(step); |
|
135 |
|
|
136 |
//#7514 change symbols for pro parte synonyms and misapplied name relationship types |
|
137 |
updateConceptRelationshipSymbols(stepList); |
|
138 |
|
|
139 |
//#8006 |
|
140 |
updateTaxonRelationshipLabels(stepList); |
|
141 |
|
|
142 |
//#7372 |
|
143 |
stepName = "Add allowDuplicates to feature tree"; |
|
144 |
tableName = "FeatureTree"; |
|
145 |
newColumnName = "allowDuplicates"; |
|
146 |
step = ColumnAdder.NewBooleanInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, false); |
|
147 |
stepList.add(step); |
|
148 |
|
|
149 |
//#6794 add term type to feature tree |
|
150 |
stepName = "Add termType to feature tree"; |
|
151 |
tableName = "FeatureTree"; |
|
152 |
newColumnName = "termType"; |
|
153 |
step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, 255, TermType.Feature.getKey(), INCLUDE_AUDIT) |
|
154 |
.setNotNull(NOT_NULL); |
|
155 |
stepList.add(step); |
|
156 |
|
|
157 |
//#6794 add term type to feature node |
|
158 |
stepName = "Add termType to feature node"; |
|
159 |
tableName = "FeatureNode"; |
|
160 |
newColumnName = "termType"; |
|
161 |
step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, 255, TermType.Feature.getKey(), INCLUDE_AUDIT) |
|
162 |
.setNotNull(NOT_NULL); |
|
163 |
stepList.add(step); |
|
164 |
|
|
165 |
//#8120 add structure modifier |
|
166 |
stepName = "Add structure modifier to Character"; |
|
167 |
tableName = "DefinedTermBase"; |
|
168 |
String referedTableName = "DefinedTermBase"; |
|
169 |
newColumnName = "structureModifier_id"; |
|
170 |
step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, !NOT_NULL, referedTableName); |
|
171 |
stepList.add(step); |
|
172 |
|
|
173 |
//#8120 add property modifier |
|
174 |
stepName = "Add property modifier to Character"; |
|
175 |
tableName = "DefinedTermBase"; |
|
176 |
referedTableName = "DefinedTermBase"; |
|
177 |
newColumnName = "propertyModifier_id"; |
|
178 |
step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, !NOT_NULL, referedTableName); |
|
179 |
stepList.add(step); |
|
180 |
|
|
181 |
//#8142 add plural to representations |
|
182 |
stepName = "Add plural to representations"; |
|
183 |
tableName = "Representation"; |
|
184 |
newColumnName = "plural"; |
|
185 |
step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT); |
|
186 |
stepList.add(step); |
|
187 |
|
|
188 |
//#8017 add type designation sources |
|
189 |
stepName = "Add plural type designation sources"; |
|
190 |
String firstTableName = "TypeDesignationBase"; |
|
191 |
String secondTableName = "OriginalSourceBase"; |
|
192 |
step = MnTableCreator.NewMnInstance(stepName, firstTableName, null, secondTableName, null, "sources", INCLUDE_AUDIT, !IS_LIST, IS_1_TO_M); |
|
193 |
stepList.add(step); |
|
194 |
|
|
195 |
return stepList; |
|
196 |
|
|
197 |
} |
|
198 |
|
|
199 |
//8006 update taxon relationships |
|
200 |
private void updateTaxonRelationshipLabels(List<ISchemaUpdaterStep> stepList) { |
|
201 |
|
|
202 |
// //7857 Update symmetrical for name relationships |
|
203 |
// String stepName = "Update symmetrical for name relationships"; |
|
204 |
// String query = "UPDATE @@DefinedTermBase@@ " |
|
205 |
// + " SET symmetrical=0 " |
|
206 |
// + " WHERE uuid IN ('049c6358-1094-4765-9fae-c9972a0e7780', '6e23ad45-3f2a-462b-ad87-d2389cd6e26c', " |
|
207 |
// + " 'c6f9afcb-8287-4a2b-a6f6-4da3a073d5de', 'eeaea868-c4c1-497f-b9fe-52c9fc4aca53') "; |
|
208 |
// String tableName = "DefinedTermBase"; |
|
209 |
// ISchemaUpdaterStep step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
210 |
// stepList.add(step); |
|
211 |
|
|
212 |
//Taxonomically Included in |
|
213 |
String stepName = "Taxonomically Included in => is taxonomically included in"; |
|
214 |
UUID uuidTerm = UUID.fromString("d13fecdf-eb44-4dd7-9244-26679c05df1c"); |
|
215 |
UUID uuidLanguage = UUID.fromString("e9f8cdb7-6819-44e8-95d3-e2d0690c3523"); |
|
216 |
String label = "is taxonomically included in"; |
|
217 |
ISchemaUpdaterStep step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
218 |
label, label, null, uuidLanguage); |
|
219 |
stepList.add(step); |
|
220 |
|
|
221 |
stepName = "taxonomically includes => taxonomically includes"; |
|
222 |
label = "taxonomically includes"; |
|
223 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
224 |
label, label, null, uuidLanguage); |
|
225 |
stepList.add(step); |
|
226 |
|
|
227 |
//Misapplied Name for |
|
228 |
stepName = "Misapplied Name for => is misapplied name for"; |
|
229 |
uuidTerm = UUID.fromString("1ed87175-59dd-437e-959e-0d71583d8417"); |
|
230 |
label = "is misapplied name for"; |
|
231 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
232 |
label, label, null, uuidLanguage); |
|
233 |
stepList.add(step); |
|
234 |
|
|
235 |
stepName = "Has Misapplied Name => has misapplied name"; |
|
236 |
label = "has misapplied name"; |
|
237 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
238 |
label, label, null, uuidLanguage); |
|
239 |
stepList.add(step); |
|
240 |
|
|
241 |
//Pro parte Misapplied Name for |
|
242 |
stepName = "Pro parte Misapplied Name for => is pro parte misapplied name for"; |
|
243 |
uuidTerm = UUID.fromString("b59b4bd2-11ff-45d1-bae2-146efdeee206"); |
|
244 |
label = "is pro parte misapplied name for"; |
|
245 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
246 |
label, label, null, uuidLanguage); |
|
247 |
stepList.add(step); |
|
248 |
|
|
249 |
stepName = "Has Pro parte Misapplied Name => has pro parte misapplied name"; |
|
250 |
label = "has pro parte misapplied name"; |
|
251 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
252 |
label, label, null, uuidLanguage); |
|
253 |
stepList.add(step); |
|
254 |
|
|
255 |
//Partial Misapplied Name for |
|
256 |
stepName = "Partial Misapplied Name for => is partial misapplied name for"; |
|
257 |
uuidTerm = UUID.fromString("859fb615-b0e8-440b-866e-8a19f493cd36"); |
|
258 |
label = "is partial misapplied name for"; |
|
259 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
260 |
label, label, null, uuidLanguage); |
|
261 |
stepList.add(step); |
|
262 |
|
|
263 |
stepName = "Has Partial Misapplied Name => has partial misapplied name"; |
|
264 |
label = "has partial misapplied name"; |
|
265 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
266 |
label, label, null, uuidLanguage); |
|
267 |
stepList.add(step); |
|
268 |
|
|
269 |
//Pro parte Synonym for |
|
270 |
stepName = "Pro parte Synonym for => is pro parte synonym for"; |
|
271 |
uuidTerm = UUID.fromString("8a896603-0fa3-44c6-9cd7-df2d8792e577"); |
|
272 |
label = "is pro parte synonym for"; |
|
273 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
274 |
label, label, null, uuidLanguage); |
|
275 |
stepList.add(step); |
|
276 |
|
|
277 |
stepName = "Has Pro parte Synonym => has pro parte synonym"; |
|
278 |
label = "has pro parte synonym"; |
|
279 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
280 |
label, label, null, uuidLanguage); |
|
281 |
stepList.add(step); |
|
282 |
|
|
283 |
//Partial Synonym for |
|
284 |
stepName = "Partial Synonym for => is partial synonym for"; |
|
285 |
uuidTerm = UUID.fromString("9d7a5e56-973c-474c-b6c3-a1cb00833a3c"); |
|
286 |
label = "is partial synonym for"; |
|
287 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
288 |
label, label, null, uuidLanguage); |
|
289 |
stepList.add(step); |
|
290 |
|
|
291 |
stepName = "Has Partial Synonym => has partial synonym"; |
|
292 |
label = "has partial synonym"; |
|
293 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
294 |
label, label, null, uuidLanguage); |
|
295 |
stepList.add(step); |
|
296 |
|
|
297 |
//Invalid Designation for |
|
298 |
stepName = "Invalid Designation for => is invalid designation for"; |
|
299 |
uuidTerm = UUID.fromString("605b1d01-f2b1-4544-b2e0-6f08def3d6ed"); |
|
300 |
label = "is invalid designation for"; |
|
301 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
302 |
label, label, null, uuidLanguage); |
|
303 |
stepList.add(step); |
|
304 |
|
|
305 |
stepName = "Has Invalid Designation => has invalid designation"; |
|
306 |
label = "has invalid designation"; |
|
307 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
308 |
label, label, null, uuidLanguage); |
|
309 |
stepList.add(step); |
|
310 |
|
|
311 |
//Not yet worked on |
|
312 |
stepName = "Unclear => Not yet worked on"; |
|
313 |
label = "Not yet worked on"; |
|
314 |
uuidTerm = UUID.fromString("8d47e59a-790d-428f-8060-01d443519166"); |
|
315 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
316 |
label, label, null, uuidLanguage); |
|
317 |
stepList.add(step); |
|
318 |
} |
|
319 |
|
|
320 |
|
|
321 |
//7514 |
|
322 |
private void updateConceptRelationshipSymbols(List<ISchemaUpdaterStep> stepList) { |
|
323 |
|
|
324 |
//Update misapplied name symbols |
|
325 |
String stepName = "Update misapplied name symbols"; |
|
326 |
String query = "UPDATE @@DefinedTermBase@@ " |
|
327 |
+ " SET symbol='––' , inverseSymbol = '-' " |
|
328 |
+ " WHERE uuid = '1ed87175-59dd-437e-959e-0d71583d8417' "; |
|
329 |
String tableName = "DefinedTermBase"; |
|
330 |
ISchemaUpdaterStep step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
331 |
stepList.add(step); |
|
332 |
|
|
333 |
//Update pro parte misapplied name symbols |
|
334 |
stepName = "Update pro parte misapplied name symbols"; |
|
335 |
query = "UPDATE @@DefinedTermBase@@ " |
|
336 |
+ " SET symbol='––(p.p.)' , inverseSymbol = '-(p.p.)' " |
|
337 |
+ " WHERE uuid = 'b59b4bd2-11ff-45d1-bae2-146efdeee206' "; |
|
338 |
tableName = "DefinedTermBase"; |
|
339 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
340 |
stepList.add(step); |
|
341 |
|
|
342 |
//Update partial misapplied name symbols |
|
343 |
stepName = "Update partial misapplied name symbols"; |
|
344 |
query = "UPDATE @@DefinedTermBase@@ " |
|
345 |
+ " SET symbol='––(part.)' , inverseSymbol = '-(part.)' " |
|
346 |
+ " WHERE uuid = '859fb615-b0e8-440b-866e-8a19f493cd36' "; |
|
347 |
tableName = "DefinedTermBase"; |
|
348 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
349 |
stepList.add(step); |
|
350 |
|
|
351 |
//Update pro parte synonym symbols |
|
352 |
stepName = "Update pro parte synonym symbols"; |
|
353 |
query = "UPDATE @@DefinedTermBase@@ " |
|
354 |
+ " SET symbol='⊃p.p.' , inverseSymbol = 'p.p.' " |
|
355 |
+ " WHERE uuid = '8a896603-0fa3-44c6-9cd7-df2d8792e577' "; |
|
356 |
tableName = "DefinedTermBase"; |
|
357 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
358 |
stepList.add(step); |
|
359 |
|
|
360 |
//Update partial synonym symbols |
|
361 |
stepName = "Update partial synonym symbols"; |
|
362 |
query = "UPDATE @@DefinedTermBase@@ " |
|
363 |
+ " SET symbol='⊃part.' , inverseSymbol = 'part.' " |
|
364 |
+ " WHERE uuid = '9d7a5e56-973c-474c-b6c3-a1cb00833a3c' "; |
|
365 |
tableName = "DefinedTermBase"; |
|
366 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
367 |
stepList.add(step); |
|
368 |
|
|
369 |
} |
|
370 |
|
|
371 |
//7857 update name realtionships |
|
372 |
private void updateNameRelationships(List<ISchemaUpdaterStep> stepList) { |
|
373 |
|
|
374 |
//7857 Update symmetrical for name relationships |
|
375 |
String stepName = "Update symmetrical for name relationships"; |
|
376 |
String query = "UPDATE @@DefinedTermBase@@ " |
|
377 |
+ " SET symmetrical=0 " |
|
378 |
+ " WHERE uuid IN ('049c6358-1094-4765-9fae-c9972a0e7780', '6e23ad45-3f2a-462b-ad87-d2389cd6e26c', " |
|
379 |
+ " 'c6f9afcb-8287-4a2b-a6f6-4da3a073d5de', 'eeaea868-c4c1-497f-b9fe-52c9fc4aca53') "; |
|
380 |
String tableName = "DefinedTermBase"; |
|
381 |
ISchemaUpdaterStep step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
382 |
stepList.add(step); |
|
383 |
|
|
384 |
//orthographic variant for |
|
385 |
stepName = "orthographic variant for => is orthographic variant for"; |
|
386 |
UUID uuidTerm = UUID.fromString("eeaea868-c4c1-497f-b9fe-52c9fc4aca53"); |
|
387 |
UUID uuidLanguage = UUID.fromString("e9f8cdb7-6819-44e8-95d3-e2d0690c3523"); |
|
388 |
String label = "is orthographic variant for"; |
|
389 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
390 |
label, label, null, uuidLanguage); |
|
391 |
stepList.add(step); |
|
392 |
|
|
393 |
//original spelling for |
|
394 |
stepName = "original spelling for => is original spelling for"; |
|
395 |
uuidTerm = UUID.fromString("264d2be4-e378-4168-9760-a9512ffbddc4"); |
|
396 |
label = "is original spelling for"; |
|
397 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
398 |
label, label, null, uuidLanguage); |
|
399 |
stepList.add(step); |
|
400 |
|
|
401 |
//misspelling for |
|
402 |
stepName = "misspelling for => is misspelling for"; |
|
403 |
uuidTerm = UUID.fromString("c6f9afcb-8287-4a2b-a6f6-4da3a073d5de"); |
|
404 |
label = "is misspelling for"; |
|
405 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
406 |
label, label, null, uuidLanguage); |
|
407 |
stepList.add(step); |
|
408 |
|
|
409 |
//later homonym for |
|
410 |
stepName = "later homonym for => is later homonym for"; |
|
411 |
uuidTerm = UUID.fromString("80f06f65-58e0-4209-b811-cb40ad7220a6"); |
|
412 |
label = "is later homonym for"; |
|
413 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
414 |
label, label, null, uuidLanguage); |
|
415 |
stepList.add(step); |
|
416 |
|
|
417 |
//treated as later homonym for |
|
418 |
stepName = " => is treated as later homonym for"; |
|
419 |
uuidTerm = UUID.fromString("2990a884-3302-4c8b-90b2-dfd31aaa2778"); |
|
420 |
label = "is treated as later homonym for"; |
|
421 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
422 |
label, label, null, uuidLanguage); |
|
423 |
stepList.add(step); |
|
424 |
|
|
425 |
//alternative name for |
|
426 |
stepName = "alternative name for => is alternative name for"; |
|
427 |
uuidTerm = UUID.fromString("049c6358-1094-4765-9fae-c9972a0e7780"); |
|
428 |
label = "is alternative name for"; |
|
429 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
430 |
label, label, null, uuidLanguage); |
|
431 |
stepList.add(step); |
|
432 |
|
|
433 |
//basionym for |
|
434 |
stepName = "basionym for => is basionym for"; |
|
435 |
uuidTerm = UUID.fromString("25792738-98de-4762-bac1-8c156faded4a"); |
|
436 |
label = "is basionym for"; |
|
437 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
438 |
label, label, null, uuidLanguage); |
|
439 |
stepList.add(step); |
|
440 |
|
|
441 |
//replaced synonym for |
|
442 |
stepName = "replaced synonym for => is replaced synonym for"; |
|
443 |
uuidTerm = UUID.fromString("71c67c38-d162-445b-b0c2-7aba56106696"); |
|
444 |
label = "is replaced synonym for"; |
|
445 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
446 |
label, label, null, uuidLanguage); |
|
447 |
stepList.add(step); |
|
448 |
|
|
449 |
//conserved against |
|
450 |
stepName = "conserved against => is conserved against"; |
|
451 |
uuidTerm = UUID.fromString("e6439f95-bcac-4ebb-a8b5-69fa5ce79e6a"); |
|
452 |
label = "is conserved against"; |
|
453 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
454 |
label, label, null, uuidLanguage); |
|
455 |
stepList.add(step); |
|
456 |
|
|
457 |
//validated by |
|
458 |
stepName = "validated by => is validated by"; |
|
459 |
uuidTerm = UUID.fromString("a176c9ad-b4c2-4c57-addd-90373f8270eb"); |
|
460 |
label = "is validated by"; |
|
461 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
462 |
label, label, null, uuidLanguage); |
|
463 |
stepList.add(step); |
|
464 |
|
|
465 |
//later validated by |
|
466 |
stepName = "later validated by => is later validated by"; |
|
467 |
uuidTerm = UUID.fromString("a25ee4c1-863a-4dab-9499-290bf9b89639"); |
|
468 |
label = "is later validated by"; |
|
469 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
470 |
label, label, null, uuidLanguage); |
|
471 |
stepList.add(step); |
|
472 |
|
|
473 |
//blocking name for |
|
474 |
stepName = "blocking name for => is blocking name for"; |
|
475 |
uuidTerm = UUID.fromString("1dab357f-2e12-4511-97a4-e5153589e6a6"); |
|
476 |
label = "blocking name for"; |
|
477 |
step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm, |
|
478 |
label, label, null, uuidLanguage); |
|
479 |
stepList.add(step); |
|
480 |
|
|
481 |
//emendation for |
|
482 |
stepName = "emendation for => is emendation for"; |
|
483 |
uuidTerm = UUID.fromString("6e23ad45-3f2a-462b-ad87-d2389cd6e26c"); |
|
484 |
label = "is emendation for"; |
|
485 |
step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm, |
|
486 |
label, label, null, uuidLanguage); |
|
487 |
stepList.add(step); |
|
488 |
} |
|
489 |
|
|
490 |
@Override |
|
491 |
public ISchemaUpdater getNextUpdater() { |
|
492 |
return null; |
|
493 |
} |
|
494 |
|
|
495 |
@Override |
|
496 |
public ISchemaUpdater getPreviousUpdater() { |
|
497 |
return SchemaUpdater_47_50.NewInstance(); |
|
498 |
} |
|
499 |
|
|
500 |
} |
Also available in: Unified diff
rename cdm 5.5 update script package