Revision 1ffd1c27
Added by Andreas Müller over 3 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v515_518/SchemaUpdater_5185_5186.java | ||
|---|---|---|
| 17 | 17 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdaterStep; |
| 18 | 18 |
import eu.etaxonomy.cdm.database.update.SchemaUpdaterBase; |
| 19 | 19 |
import eu.etaxonomy.cdm.database.update.SimpleSchemaUpdaterStep; |
| 20 |
import eu.etaxonomy.cdm.database.update.SingleTermRemover; |
|
| 20 | 21 |
import eu.etaxonomy.cdm.model.metadata.CdmMetaData.CdmVersion; |
| 21 | 22 |
|
| 22 | 23 |
/** |
| ... | ... | |
| 49 | 50 |
|
| 50 | 51 |
adaptNomenclaturalStanding(stepList); |
| 51 | 52 |
|
| 53 |
//#9322 remove Invalid Designation taxon relationship |
|
| 54 |
String stepName = "remove invalid designation taxon relationship type"; |
|
| 55 |
String uuidTerm = "605b1d01-f2b1-4544-b2e0-6f08def3d6ed"; |
|
| 56 |
String checkUsedQueries = "SELECT count(*) FROM @@TaxonRelationship@@ tr " |
|
| 57 |
+ " INNER JOIN @@DefinedTermBase@@ trType ON trType.id = tr.type_id " |
|
| 58 |
+ " WHERE trType.uuid = '605b1d01-f2b1-4544-b2e0-6f08def3d6ed'"; |
|
| 59 |
SingleTermRemover.NewInstance(stepList, stepName, uuidTerm, checkUsedQueries, -99); |
|
| 60 |
|
|
| 52 | 61 |
return stepList; |
| 53 | 62 |
} |
| 54 | 63 |
|
Also available in: Unified diff
ref #9322 remove invalid designation relationship from cdmlib