Project

General

Profile

Revision 2a562e3e

ID2a562e3e7df76e7db87a38796dfe604adb9b9e7b
Parent 71757814
Child 32e833cb

Added by Andreas Müller over 5 years ago

#5921 Change symbol for congruence relationship.

View differences:

cdmlib-model/src/main/resources/terms/TaxonRelationshipType.csv
3 3
"1ed87175-59dd-437e-959e-0d71583d8417",,"Misapplied Name for","Misapplied Name for","–","Has Misapplied Name","Has Misapplied Name",,FALSE,FALSE
4 4
"605b1d01-f2b1-4544-b2e0-6f08def3d6ed",,"Invalid Designation for","Invalid Designation for","–","Has Invalid Designation","Has Invalid Designation",,FALSE,FALSE
5 5
"a8f03491-2ad6-4fae-a04c-2a4c117a2e9b",,"Contradiction","Contradiction","∅","Contradiction","Contradiction","∅",TRUE,FALSE
6
"60974c98-64ab-4574-bb5c-c110f6db634d",,"Congruent to","Congruent to","≅","Congruent to","Congruent to","≅",TRUE,FALSE
6
"60974c98-64ab-4574-bb5c-c110f6db634d",,"Congruent to","Congruent to","≜","Congruent to","Congruent to","≜",TRUE,FALSE
7 7
"0501c385-cab1-4fbe-b945-fc747419bb13",,"Includes","Includes","⊃","Included in","Included in","⊂",FALSE,TRUE
8
"b55cb3a2-6e20-4ca3-95bc-12b59d3235b0",,"Congruent to or Includes","Congruent to or Includes","≅⊃","Congruent to or Included in","Congruent to or Included in","≅⊂",FALSE,TRUE
8
"b55cb3a2-6e20-4ca3-95bc-12b59d3235b0",,"Congruent to or Includes","Congruent to or Includes","≜⊃","Congruent to or Included in","Congruent to or Included in","≜⊂",FALSE,TRUE
9 9
"c3ed5089-6779-4051-bb24-f5ea0eca80d5",,"Included in or Includes","Included in or Includes","⊂⊃","Included in or Includes","Included in or Includes","⊂⊃",TRUE,FALSE
10
"0170cd83-93ad-43c2-9ad1-7ac879300e2f",,"Congruent to or Included in or Includes","Congruent to or Included in or Includes","≅⊂⊃","Congruent to or Included in or Includes","Congruent to or Included in or Includes","≅⊂⊃",TRUE,FALSE
10
"0170cd83-93ad-43c2-9ad1-7ac879300e2f",,"Congruent to or Included in or Includes","Congruent to or Included in or Includes","≜⊂⊃","Congruent to or Included in or Includes","Congruent to or Included in or Includes","≜⊂⊃",TRUE,FALSE
11 11
"2046a0fd-4fd6-45a1-b707-2b91547f3ec7",,"Overlaps","Overlaps","⊕","Overlaps","Overlaps","⊕",TRUE,FALSE
12
"78355cfa-5200-432f-8e00-82b97afad0ed",,"Congruent to or Overlaps","Congruent to or Overlaps","≅⊕","Congruent to or Overlaps","Congruent to or Overlaps","≅⊕",TRUE,FALSE
12
"78355cfa-5200-432f-8e00-82b97afad0ed",,"Congruent to or Overlaps","Congruent to or Overlaps","≜⊕","Congruent to or Overlaps","Congruent to or Overlaps","≜⊕",TRUE,FALSE
13 13
"f1ec567b-3c73-436b-8625-b4fd53588abb",,"Includes or Overlaps","Includes or Overlaps","⊃⊕","Included in or Overlaps","Included in or Overlaps","⊂⊕",FALSE,FALSE
14
"2d923b1a-6c0f-414c-ac9b-bbc502e18078",,"Congruent to or Includes or Overlaps","Congruent to or Includes or Overlaps","≅⊃⊕","Congruent to or Included in or Overlaps","Congruent to or Included in or Overlaps","≅⊂⊕",FALSE,FALSE
14
"2d923b1a-6c0f-414c-ac9b-bbc502e18078",,"Congruent to or Includes or Overlaps","Congruent to or Includes or Overlaps","≜⊃⊕","Congruent to or Included in or Overlaps","Congruent to or Included in or Overlaps","≜⊂⊕",FALSE,FALSE
15 15
"43466aa9-e431-4f37-8bca-febfd9f63716",,"Included in or Includes or Overlaps","Included in or Includes or Overlaps","⊂⊃⊕","Included in or Includes or Overlaps","Included in or Includes or Overlaps","⊂⊃⊕",TRUE,FALSE
16
"0e5099bb-87c0-400e-abdc-bcfed5b5eece",,"Does Not Exclude","Does Not Exclude","≅⊂⊃⊕","Does Not Exclude","Does Not Exclude","≅⊂⊃⊕",TRUE,FALSE
16
"0e5099bb-87c0-400e-abdc-bcfed5b5eece",,"Does Not Exclude","Does Not Exclude","≜⊂⊃⊕","Does Not Exclude","Does Not Exclude","≜⊂⊃⊕",TRUE,FALSE
17 17
"4535a63c-4a3f-4d69-9350-7bf02e2c23be",,"Excludes","Excludes","!","Excludes","Excludes","!",TRUE,FALSE
18
"758e6cf3-05a0-49ed-9496-d8c4a9fd02ae",,"Congruent to or Excludes","Congruent to or Excludes","≅!","Congruent to or Excludes","Congruent to or Excludes","≅!",TRUE,FALSE
18
"758e6cf3-05a0-49ed-9496-d8c4a9fd02ae",,"Congruent to or Excludes","Congruent to or Excludes","≜!","Congruent to or Excludes","Congruent to or Excludes","≜!",TRUE,FALSE
19 19
"6ee440bc-fd3d-4da2-ad85-906d35a94731",,"Includes or Excludes","Includes or Excludes","⊃!","Included in or Excludes","Included in or Excludes","⊂!",FALSE,FALSE
20
"d5c6953d-aa53-46f8-aafc-ebc6428ad5d0",,"Congruent to or Includes or Excludes","Congruent to or Includes or Excludes","≅⊃!","Congruent to or Included in or Excludes","Congruent to or Included in or Excludes","≅⊂!",FALSE,FALSE
20
"d5c6953d-aa53-46f8-aafc-ebc6428ad5d0",,"Congruent to or Includes or Excludes","Congruent to or Includes or Excludes","≜⊃!","Congruent to or Included in or Excludes","Congruent to or Included in or Excludes","≜⊂!",FALSE,FALSE
21 21
"43d8492c-8bd5-4f38-a633-f1ad910a34dd",,"Included in or Includes or Excludes","Included in or Includes or Excludes","⊂⊃!","Included in or Includes or Excludes","Included in or Includes or Excludes","⊂⊃",TRUE,FALSE
22
"ecd2382b-3d94-4169-9dd2-2c4ea1d24605",,"Does Not Overlap","Does Not Overlap","≅⊂⊃!","Does Not Overlap","Does Not Overlap","≅⊂⊃!",TRUE,FALSE
22
"ecd2382b-3d94-4169-9dd2-2c4ea1d24605",,"Does Not Overlap","Does Not Overlap","≜⊂⊃!","Does Not Overlap","Does Not Overlap","≜⊂⊃!",TRUE,FALSE
23 23
"623ecdeb-ff1f-471d-a8dc-0d75b2fe8d94",,"Overlaps or Excludes","Overlaps or Excludes","⊕!","Overlaps or Excludes","Overlaps or Excludes","⊕!",TRUE,FALSE
24
"6fabef72-5264-44f1-bfc0-8e2e141375f2",,"Congruent to or Overlaps or Excludes","Congruent to or Overlaps or Excludes","≅⊕!","Congruent to or Overlaps or Excludes","Congruent to or Overlaps or Excludes","≅⊕!",TRUE,FALSE
24
"6fabef72-5264-44f1-bfc0-8e2e141375f2",,"Congruent to or Overlaps or Excludes","Congruent to or Overlaps or Excludes","≜⊕!","Congruent to or Overlaps or Excludes","Congruent to or Overlaps or Excludes","≜⊕!",TRUE,FALSE
25 25
"b7153c89-cc6c-4f8c-bf74-216f10feac46",,"Includes or Overlaps or Excludes","Includes or Overlaps or Excludes","⊃⊕!","Included in or Overlaps or Excludes","Included in or Overlaps or Excludes","⊂⊕!",FALSE,FALSE
26
"89dffa4e-e004-4d42-b0d1-ae1827529e43",,"Not Included in","Not Included in","≅⊃⊕!","Does Not Include","Does Not Include","≅⊂⊕!",FALSE,FALSE
26
"89dffa4e-e004-4d42-b0d1-ae1827529e43",,"Not Included in","Not Included in","≜⊃⊕!","Does Not Include","Does Not Include","≜⊂⊕!",FALSE,FALSE
27 27
"6c16c33b-cfc5-4a00-92bd-a9f9e448f389",,"Not Congruent to","Not Congruent to","⊂⊃⊕!","Not Congruent to","Not Congruent to","⊂⊃⊕!",TRUE,FALSE
28
"831fcd88-e5c9-49e0-b06e-bbb67d1c05c9",,"All Relationships","All Relationships","≅⊂⊃⊕!","All Relationships","All Relationships","≅⊂⊃⊕!",TRUE,FALSE
28
"831fcd88-e5c9-49e0-b06e-bbb67d1c05c9",,"All Relationships","All Relationships","≜⊂⊃⊕!","All Relationships","All Relationships","≜⊂⊃⊕!",TRUE,FALSE
29 29
"4c48ba25-c1d0-4bdd-9260-c1fa2e42a5d3",,"Unclear","Unclear","??","Unclear","Unclear","??",TRUE,FALSE
30 30
"8d47e59a-790d-428f-8060-01d443519166",,"Not yet worked on","Not yet worked on","⌛","Unclear","Unclear","⌛",TRUE,FALSE
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v40_41/SchemaUpdater_40_41.java
90 90
        SimpleSchemaUpdaterStep simpleStep = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, "DescriptionBase", -99);
91 91
        stepList.add(simpleStep);
92 92

  
93
//        //#5717
94
//        //Add sec micro reference
95
//        stepName = "Add secMicroReference to TaxonBase";
96
//        tableName = "TaxonBase";
97
//        newColumnName = "secMicroReference";
98
//        step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT);
99
//        stepList.add(step);
93
        //#5921
94
        //UPDATE congruent symbol in DefinedTermBase
95
        stepName = "UPDATE congruent symbol in DefinedTermBase";
96
        query = " UPDATE @@DefinedTermBase@@ "
97
                + " SET idInVocabulary = Replace(idInVocabulary, '\u2245', '\u225c'), symbol = Replace(symbol, '\u2245', '\u225c'), inverseSymbol = Replace(inverseSymbol, '\u2245', '\u225c')"
98
                + " WHERE DTYPE like 'TaxonRel%' "
99
                + "     AND (idInVocabulary like '%\u2245%' OR symbol like '%\u2245%' OR inverseSymbol like '%\u2245%' )";
100
        simpleStep = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, "DefinedTermBase", -99);
101
        stepList.add(simpleStep);
102

  
103
        //#5921
104
        //UPDATE congruent symbol in Representations
105
        stepName = "UPDATE congruent symbol in Representations";
106
        query = " UPDATE @@Representation@@ "
107
                + " SET abbreviatedLabel = Replace(abbreviatedLabel, '\u2245', '\u225c') "
108
                + " WHERE (abbreviatedLabel like '%\u2245%' )";
109
        simpleStep = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, "Representation", -99);
110
        stepList.add(simpleStep);
100 111

  
101 112
        return stepList;
102 113

  

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)