Revision 0eb2578c
Added by Andreas Müller over 3 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v515_518/SchemaUpdater_5184_5185.java | ||
|---|---|---|
| 56 | 56 |
|
| 57 | 57 |
String stepName = "remove original spelling name relationship type"; |
| 58 | 58 |
String uuidTerm = "264d2be4-e378-4168-9760-a9512ffbddc4"; |
| 59 |
String checkUsedQueries = "SELECT count(*) FROM @@NameRelationship@@ nr " |
|
| 60 |
+ " INNER JOIN @@DefinedTermBase@@ nrType ON nrType.id = nr.type_id " |
|
| 59 |
String checkUsedQueries = "SELECT count(*) " |
|
| 60 |
+ " FROM @@NameRelationship@@ nr " |
|
| 61 |
+ " INNER JOIN @@DefinedTermBase@@ nrType ON nrType.id = nr.type_id " |
|
| 61 | 62 |
+ " WHERE nrType.uuid = '264d2be4-e378-4168-9760-a9512ffbddc4'"; |
| 62 | 63 |
SingleTermRemover.NewInstance(stepList, stepName, uuidTerm, checkUsedQueries, -99); |
| 63 | 64 |
|
| 65 |
stepName = "remove original spelling name relationship type (AUD)"; |
|
| 66 |
uuidTerm = "264d2be4-e378-4168-9760-a9512ffbddc4"; |
|
| 67 |
checkUsedQueries = "SELECT count(*) " |
|
| 68 |
+ " FROM @@NameRelationship_AUD@@ nr " |
|
| 69 |
+ " INNER JOIN @@DefinedTermBase_AUD@@ nrType ON nrType.id = nr.type_id " |
|
| 70 |
+ " WHERE nrType.uuid = '264d2be4-e378-4168-9760-a9512ffbddc4'"; |
|
| 71 |
SingleTermRemover.NewAudInstance(stepList, stepName, uuidTerm, checkUsedQueries, -99); |
|
| 72 |
|
|
| 64 | 73 |
//#9311 |
| 65 | 74 |
changeSomeTermLabels(stepList); |
| 66 | 75 |
|
| ... | ... | |
| 83 | 92 |
} |
| 84 | 93 |
|
| 85 | 94 |
//#9311 |
| 95 |
@SuppressWarnings("null")
|
|
| 86 | 96 |
private void changeSomeTermLabels(List<ISchemaUpdaterStep> stepList) {
|
| 87 | 97 |
|
| 88 | 98 |
String stepName = "Change abbrev label op. utique oppr."; |
| ... | ... | |
| 261 | 271 |
|
| 262 | 272 |
@Override |
| 263 | 273 |
public ISchemaUpdater getNextUpdater() {
|
| 264 |
return null;
|
|
| 274 |
return SchemaUpdater_5185_5186.NewInstance();
|
|
| 265 | 275 |
} |
| 266 | 276 |
} |
Also available in: Unified diff
ref #6591 handle also AUD table in SingleTermRemover for removing original spelling