Project

General

Profile

Revision 757c09fe

ID757c09fe2da045ef41c112d9f2c909ae2245b0bc
Parent 9d893279
Child 45fd6fd3

Added by Andreas Müller over 1 year ago

rename cdm 5.5 update script package

View differences:

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

Add picture from clipboard (Maximum size: 40 MB)