Revision fdf9eec2
Added by Andreas Müller almost 10 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/test/ValidateForeignKeys.java | ||
|---|---|---|
| 71 | 71 |
|
| 72 | 72 |
|
| 73 | 73 |
private String sql(String thisTable, String thisField, String foreignTable){
|
| 74 |
String sql = "SELECT * FROM %s WHERE %s.%s NOT IN (SELECT id FROM %s)"; |
|
| 74 |
String sql = "SELECT * FROM %s WHERE %s.%s_id NOT IN (SELECT id FROM %s)";
|
|
| 75 | 75 |
sql = String.format(sql, thisTable, thisTable, thisField, foreignTable); |
| 76 | 76 |
return sql; |
| 77 | 77 |
} |
Also available in: Unified diff
better use of generics in service layer and persistence list methods