Revision b08ed055
Added by Andreas Müller about 3 years ago
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/SingleTermRemover.java | ||
---|---|---|
87 | 87 |
//get representation ids |
88 | 88 |
List<Integer> repIDs = new ArrayList<>(); |
89 | 89 |
getRepIds(datasource, id, repIDs, "representations_id", "DefinedTermBase_Representation", caseType ); |
90 |
getRepIds(datasource, id, repIDs, "inverserepresentations_id", "RelationshipTermBase_inverseRepresentation", caseType);
|
|
90 |
getRepIds(datasource, id, repIDs, "inverserepresentations_id", "DefinedTermBase_inverseRepresentation", caseType);
|
|
91 | 91 |
|
92 | 92 |
//remove from MN table |
93 | 93 |
String sql = " DELETE FROM %s WHERE DefinedTermBase_id = %d"; |
94 | 94 |
sql = String.format(sql, caseType.transformTo("DefinedTermBase_Representation"), id); |
95 | 95 |
datasource.executeUpdate(sql); |
96 | 96 |
sql = " DELETE FROM %s WHERE DefinedTermBase_id = %d"; |
97 |
sql = String.format(sql, caseType.transformTo("RelationshipTermBase_inverseRepresentation"), id);
|
|
97 |
sql = String.format(sql, caseType.transformTo("DefinedTermBase_inverseRepresentation"), id);
|
|
98 | 98 |
datasource.executeUpdate(sql); |
99 | 99 |
|
100 | 100 |
//remove representations |
Also available in: Unified diff
ref #6591 fix SingleTermRemover