Project

General

Profile

Revision 6cd6cbd2

ID6cd6cbd2ad7d76f5fd4951eb9744f3902e99d43f
Parent 9fc64ad5
Child c2cdd7ea

Added by Andreas Müller over 1 year ago

ref #8006 update labels for MAN, ppSynonyms, inval. desig. & tax. included

View differences:

cdmlib-model/src/main/resources/terms/TaxonRelationshipType.csv
1 1
"15db0cf7-7afc-4a86-a7d4-221c73b0c9ac",,"Taxon Relationship Type","Taxon Relationship Type","TRT","1"
2
"d13fecdf-eb44-4dd7-9244-26679c05df1c",,"Taxonomically Included in","Taxonomically Included in","⊂","Taxonomically Includes","Taxonomically Includes","⊃",FALSE,TRUE
3
"1ed87175-59dd-437e-959e-0d71583d8417",,"Misapplied Name for","Misapplied Name for","––","Has Misapplied Name","Has Misapplied Name","–",FALSE,FALSE
4
"b59b4bd2-11ff-45d1-bae2-146efdeee206",,"Pro parte Misapplied Name for","Pro parte Misapplied Name for","––(p.p.)","Has pro parte misapplied name","Has pro parte misapplied name","-(p.p.)",FALSE,FALSE
5
"859fb615-b0e8-440b-866e-8a19f493cd36",,"Partial Misapplied Name for","Partial Misapplied Name for","––(part.)","Has partial misapplied name","Has partial misapplied name","-(part.)",FALSE,FALSE
6
"605b1d01-f2b1-4544-b2e0-6f08def3d6ed",,"Invalid Designation for","Invalid Designation for","–","Has Invalid Designation","Has Invalid Designation",,FALSE,FALSE
7
"8a896603-0fa3-44c6-9cd7-df2d8792e577",,"Pro parte synonym for","Pro parte synonym for","⊃p.p.","Has pro parte synonym","Has pro parte synonym","p.p.",FALSE,FALSE
8
"9d7a5e56-973c-474c-b6c3-a1cb00833a3c",,"Partial synonym for","Partial synonym for","⊃part.","Has partial synonym","Has partial synonym","part.",FALSE,FALSE
2
"d13fecdf-eb44-4dd7-9244-26679c05df1c",,"is taxonomically included in","is taxonomically included in","⊂","taxonomically includes","taxonomically includes","⊃",FALSE,TRUE
3
"1ed87175-59dd-437e-959e-0d71583d8417",,"is misapplied name for","is misapplied name for","––","has misapplied name","has misapplied name","–",FALSE,FALSE
4
"b59b4bd2-11ff-45d1-bae2-146efdeee206",,"is pro parte misapplied name for","is pro parte misapplied name for","––(p.p.)","has pro parte misapplied name","has pro parte misapplied name","-(p.p.)",FALSE,FALSE
5
"859fb615-b0e8-440b-866e-8a19f493cd36",,"is partial misapplied name for","is partial misapplied name for","––(part.)","has partial misapplied name","has partial misapplied name","-(part.)",FALSE,FALSE
6
"605b1d01-f2b1-4544-b2e0-6f08def3d6ed",,"is invalid designation for","is invalid designation for","–","has invalid designation","has invalid designation",,FALSE,FALSE
7
"8a896603-0fa3-44c6-9cd7-df2d8792e577",,"is pro parte synonym for","is pro parte synonym for","⊃p.p.","has pro parte synonym","has pro parte synonym","p.p.",FALSE,FALSE
8
"9d7a5e56-973c-474c-b6c3-a1cb00833a3c",,"is partial synonym for","is partial synonym for","⊃part.","has partial synonym","has partial synonym","part.",FALSE,FALSE
9 9
"a8f03491-2ad6-4fae-a04c-2a4c117a2e9b",,"Contradiction","Contradiction","∅","Contradiction","Contradiction","∅",TRUE,FALSE
10 10
"60974c98-64ab-4574-bb5c-c110f6db634d",,"Congruent to","Congruent to","≜","Congruent to","Congruent to","≜",TRUE,FALSE
11 11
"0501c385-cab1-4fbe-b945-fc747419bb13",,"Includes","Includes","⊃","Included in","Included in","⊂",FALSE,TRUE
......
31 31
"6c16c33b-cfc5-4a00-92bd-a9f9e448f389",,"Not Congruent to","Not Congruent to","⊂⊃⊕!","Not Congruent to","Not Congruent to","⊂⊃⊕!",TRUE,FALSE
32 32
"831fcd88-e5c9-49e0-b06e-bbb67d1c05c9",,"All Relationships","All Relationships","≜⊂⊃⊕!","All Relationships","All Relationships","≜⊂⊃⊕!",TRUE,FALSE
33 33
"4c48ba25-c1d0-4bdd-9260-c1fa2e42a5d3",,"Unclear","Unclear","??","Unclear","Unclear","??",TRUE,FALSE
34
"8d47e59a-790d-428f-8060-01d443519166",,"Not yet worked on","Not yet worked on","⌛","Unclear","Unclear","⌛",TRUE,FALSE
34
"8d47e59a-790d-428f-8060-01d443519166",,"Not yet worked on","Not yet worked on","⌛","Not yet worked on","Not yet worked on","⌛",TRUE,FALSE
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v50_51/SchemaUpdater_50_55.java
117 117
        //7514 change symbols for pro parte synonyms and misapplied name relationship types
118 118
        updateConceptRelationshipSymbols(stepList);
119 119

  
120
        //8006
121
        updateTaxonRelationshipLabels(stepList);
122

  
120 123
        return stepList;
121 124

  
122 125
	}
123 126

  
127
    //8006 update taxon realtionships
128
    private void updateTaxonRelationshipLabels(List<ISchemaUpdaterStep> stepList) {
129

  
130
//        //7857 Update symmetrical for name relationships
131
//        String stepName = "Update symmetrical for name relationships";
132
//        String query = "UPDATE @@DefinedTermBase@@ "
133
//                + " SET symmetrical=0 "
134
//                + " WHERE uuid IN ('049c6358-1094-4765-9fae-c9972a0e7780', '6e23ad45-3f2a-462b-ad87-d2389cd6e26c', "
135
//                + " 'c6f9afcb-8287-4a2b-a6f6-4da3a073d5de', 'eeaea868-c4c1-497f-b9fe-52c9fc4aca53') ";
136
//        String tableName = "DefinedTermBase";
137
//        ISchemaUpdaterStep step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
138
//        stepList.add(step);
139

  
140
        //Taxonomically Included in
141
        String stepName = "Taxonomically Included in => is taxonomically included in";
142
        UUID uuidTerm = UUID.fromString("d13fecdf-eb44-4dd7-9244-26679c05df1c");
143
        UUID uuidLanguage = UUID.fromString("e9f8cdb7-6819-44e8-95d3-e2d0690c3523");
144
        String label = "is taxonomically included in";
145
        ISchemaUpdaterStep step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm,
146
                label, label, null, uuidLanguage);
147
        stepList.add(step);
148

  
149
        stepName = "taxonomically includes => taxonomically includes";
150
        label = "taxonomically includes";
151
        step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm,
152
                label, label, null, uuidLanguage);
153
        stepList.add(step);
154

  
155
        //Misapplied Name for
156
        stepName = "Misapplied Name for => is misapplied name for";
157
        uuidTerm = UUID.fromString("1ed87175-59dd-437e-959e-0d71583d8417");
158
        label = "is misapplied name for";
159
        step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm,
160
                label, label, null, uuidLanguage);
161
        stepList.add(step);
162

  
163
        stepName = "Has Misapplied Name => has misapplied name";
164
        label = "has misapplied name";
165
        step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm,
166
                label, label, null, uuidLanguage);
167
        stepList.add(step);
168

  
169
        //Pro parte Misapplied Name for
170
        stepName = "Pro parte Misapplied Name for => is pro parte misapplied name for";
171
        uuidTerm = UUID.fromString("b59b4bd2-11ff-45d1-bae2-146efdeee206");
172
        label = "is pro parte misapplied name for";
173
        step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm,
174
                label, label, null, uuidLanguage);
175
        stepList.add(step);
176

  
177
        stepName = "Has Pro parte Misapplied Name => has pro parte misapplied name";
178
        label = "has pro parte misapplied name";
179
        step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm,
180
                label, label, null, uuidLanguage);
181
        stepList.add(step);
182

  
183
        //Partial Misapplied Name for
184
        stepName = "Partial Misapplied Name for => is partial misapplied name for";
185
        uuidTerm = UUID.fromString("859fb615-b0e8-440b-866e-8a19f493cd36");
186
        label = "is partial misapplied name for";
187
        step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm,
188
                label, label, null, uuidLanguage);
189
        stepList.add(step);
190

  
191
        stepName = "Has Partial Misapplied Name => has partial misapplied name";
192
        label = "has partial misapplied name";
193
        step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm,
194
                label, label, null, uuidLanguage);
195
        stepList.add(step);
196

  
197
        //Pro parte Synonym for
198
        stepName = "Pro parte Synonym for => is pro parte synonym for";
199
        uuidTerm = UUID.fromString("8a896603-0fa3-44c6-9cd7-df2d8792e577");
200
        label = "is pro parte synonym for";
201
        step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm,
202
                label, label, null, uuidLanguage);
203
        stepList.add(step);
204

  
205
        stepName = "Has Pro parte Synonym => has pro parte synonym";
206
        label = "has pro parte synonym";
207
        step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm,
208
                label, label, null, uuidLanguage);
209
        stepList.add(step);
210

  
211
        //Partial Synonym for
212
        stepName = "Partial Synonym for => is partial synonym for";
213
        uuidTerm = UUID.fromString("9d7a5e56-973c-474c-b6c3-a1cb00833a3c");
214
        label = "is partial synonym for";
215
        step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm,
216
                label, label, null, uuidLanguage);
217
        stepList.add(step);
218

  
219
        stepName = "Has Partial Synonym => has partial synonym";
220
        label = "has partial synonym";
221
        step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm,
222
                label, label, null, uuidLanguage);
223
        stepList.add(step);
224

  
225
        //Invalid Designation for
226
        stepName = "Invalid Designation for => is invalid designation for";
227
        uuidTerm = UUID.fromString("605b1d01-f2b1-4544-b2e0-6f08def3d6ed");
228
        label = "is invalid designation for";
229
        step = TermRepresentationUpdater.NewInstanceWithTitleCache(stepName, uuidTerm,
230
                label, label, null, uuidLanguage);
231
        stepList.add(step);
232

  
233
        stepName = "Has Invalid Designation => has invalid designation";
234
        label = "has invalid designation";
235
        step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm,
236
                label, label, null, uuidLanguage);
237
        stepList.add(step);
238

  
239
        //Not yet worked on
240
        stepName = "Unclear => Not yet worked on";
241
        label = "Not yet worked on";
242
        uuidTerm = UUID.fromString("8d47e59a-790d-428f-8060-01d443519166");
243
        step = TermRepresentationUpdater.NewReverseInstance(stepName, uuidTerm,
244
                label, label, null, uuidLanguage);
245
        stepList.add(step);
246
    }
247

  
124 248

  
125 249
	//7514
126 250
    private void updateConceptRelationshipSymbols(List<ISchemaUpdaterStep> stepList) {

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)