Revision d0b0c36b
Added by Andreas Müller almost 8 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v36_40/SchemaUpdater_36_40.java | ||
|---|---|---|
| 98 | 98 |
stepList.add(step); |
| 99 | 99 |
|
| 100 | 100 |
stepName = "Update symbols for terms"; |
| 101 |
query = "UPDATE @@DefinedTermBase@@ SET symbol = idInVocabulary WHERE idInVocabulary <> ''"; |
|
| 101 |
query = "UPDATE @@DefinedTermBase@@ SET symbol = idInVocabulary WHERE idInVocabulary <> '' AND termType IN ('PAT','TRT')";
|
|
| 102 | 102 |
step = SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepName, query, -99); |
| 103 | 103 |
stepList.add(step); |
| 104 | 104 |
|
| ... | ... | |
| 111 | 111 |
stepList.add(step); |
| 112 | 112 |
|
| 113 | 113 |
stepName = "Update symbols for terms"; |
| 114 |
query = "UPDATE DefinedTermBase dtb SET inverseSymbol = ( " + |
|
| 115 |
" SELECT r.abbreviatedlabel " + |
|
| 116 |
" FROM RelationshipTermBase_inverseRepresentation MN " + |
|
| 117 |
" INNER JOIN Representation r ON r.id = MN.inverserepresentations_id " + |
|
| 118 |
" WHERE dtb.id = MN.DefinedTermBase_id AND r.abbreviatedlabel <> '' ) "; |
|
| 114 |
query = "UPDATE DefinedTermBase dtb " |
|
| 115 |
+ "SET inverseSymbol = ( " + |
|
| 116 |
" SELECT r.abbreviatedlabel " + |
|
| 117 |
" FROM RelationshipTermBase_inverseRepresentation MN " + |
|
| 118 |
" INNER JOIN Representation r ON r.id = MN.inverserepresentations_id " + |
|
| 119 |
" WHERE dtb.id = MN.DefinedTermBase_id AND r.abbreviatedlabel <> '' ) " |
|
| 120 |
+ " WHERE termType IN ('PAT','TRT') ";
|
|
| 119 | 121 |
step = SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepName, query, -99); |
| 120 | 122 |
stepList.add(step); |
| 121 | 123 |
|
Also available in: Unified diff
Add getter/setter/termloader for (inverse)symbol, fix update script
#5734