Revision c29d1c8f
Added by Andreas Müller over 5 years ago
| app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/validation/BerlinModelCommonNamesImportValidator.java | ||
|---|---|---|
| 173 | 173 |
int count = rs.getInt("n");
|
| 174 | 174 |
if (count > 0){
|
| 175 | 175 |
System.out.println("========================================================");
|
| 176 |
logger.warn("There are " + count + " common names that have a languageRefFk which can not be found in the emLanguageRefernce table.");
|
|
| 177 |
|
|
| 176 |
System.out.println("There are " + count + " common names that have a languageRefFk which can not be found in the emLanguageReference table.");
|
|
| 178 | 177 |
System.out.println("========================================================");
|
| 179 | 178 |
} |
| 180 | 179 |
if (count > 0){
|
| ... | ... | |
| 194 | 193 |
try {
|
| 195 | 194 |
boolean result = true; |
| 196 | 195 |
Source source = config.getSource(); |
| 197 |
String strQuery = "SELECT cn.CommonNameId, cn.CommonName, pt.StatusFk, n.FullNameCache, s.Status, pt.PTRefFk, r.RefCache " + |
|
| 196 |
String strQuery = "SELECT cn.CommonNameId, cn.CommonName, pt.StatusFk, n.FullNameCache, s.Status, pt.PTRefFk, pt.PTNameFk, r.RefCache " +
|
|
| 198 | 197 |
" FROM emCommonName cn " + |
| 199 | 198 |
" INNER JOIN PTaxon pt ON cn.PTNameFk = pt.PTNameFk AND cn.PTRefFk = pt.PTRefFk " + |
| 200 | 199 |
" INNER JOIN Name n ON pt.PTNameFk = n.NameId " + |
| ... | ... | |
| 220 | 219 |
String status = resulSet.getString("Status");
|
| 221 | 220 |
String fullNameCache = resulSet.getString("FullNameCache");
|
| 222 | 221 |
String ptRefFk = resulSet.getString("PTRefFk");
|
| 223 |
String ptRef = resulSet.getString("RefCache");
|
|
| 222 |
String ptNameFk = resulSet.getString("PTNameFk");
|
|
| 223 |
String ptRef = resulSet.getString("RefCache");
|
|
| 224 | 224 |
|
| 225 | 225 |
System.out.println("CommonNameId: " + commonNameId + "\n CommonName: " + commonName +
|
| 226 | 226 |
"\n Status: " + status + |
| 227 |
"\n FullNameCache: " + fullNameCache + "\n ptRefFk: " + ptRefFk + |
|
| 228 |
"\n sec: " + ptRef ); |
|
| 227 |
"\n FullNameCache: " + fullNameCache + |
|
| 228 |
"\n ptRefFk: " + ptRefFk + |
|
| 229 |
"\n ptNameFk: " + ptNameFk + |
|
| 230 |
"\n sec: " + ptRef ); |
|
| 229 | 231 |
|
| 230 | 232 |
result = firstRow = false; |
| 231 | 233 |
} |
Also available in: Unified diff
cleanup and improve BM validators