Revision 892efc69
Added by Andreas Kohlbecker almost 14 years ago
cdmlib-io/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/validation/BerlinModelTaxonRelationImportValidator.java | ||
---|---|---|
47 | 47 |
Source source = bmiConfig.getSource(); |
48 | 48 |
String strSQL = |
49 | 49 |
" SELECT RelPTaxon.RelPTaxonId, RelPTaxon.RelQualifierFk, FromName.FullNameCache AS FromName, RelPTaxon.PTNameFk1 AS FromNameID, " + |
50 |
" Status.Status AS FromStatus, ToName.FullNameCache AS ToName, RelPTaxon.PTNameFk2 AS ToNameId, ToStatus.Status AS ToStatus " +
|
|
50 |
" Status.Status AS FromStatus, ToName.FullNameCache AS ToName, RelPTaxon.PTNameFk2 AS ToNameId, ToStatus.Status AS ToStatus, FromTaxon.DoubtfulFlag AS doubtfulFrom, ToTaxon.DoubtfulFlag AS doubtfulTo" +
|
|
51 | 51 |
" FROM PTaxon AS FromTaxon " + |
52 | 52 |
" INNER JOIN RelPTaxon ON FromTaxon.PTNameFk = RelPTaxon.PTNameFk1 AND FromTaxon.PTRefFk = RelPTaxon.PTRefFk1 " + |
53 | 53 |
" INNER JOIN PTaxon AS ToTaxon ON RelPTaxon.PTNameFk2 = ToTaxon.PTNameFk AND RelPTaxon.PTRefFk2 = ToTaxon.PTRefFk " + |
... | ... | |
76 | 76 |
String toName = rs.getString("ToName"); |
77 | 77 |
int toNameId = rs.getInt("ToNameId"); |
78 | 78 |
String toStatus = rs.getString("ToStatus"); |
79 |
String doubtfulFrom = String.valueOf(rs.getObject("doubtfulFrom")); |
|
80 |
String doubtfulTo = String.valueOf(rs.getObject("doubtfulTo")); |
|
81 |
|
|
79 | 82 |
|
80 | 83 |
System.out.println("RelPTaxonId:" + relPTaxonId + |
81 |
"\n FromName: " + fromName + "\n FromNameID: " + fromNameID + "\n FromStatus: " + fromStatus + |
|
82 |
"\n ToName: " + toName + "\n ToNameId: " + toNameId + "\n ToStatus: " + toStatus); |
|
84 |
"\n FromName: " + fromName + "\n FromNameID: " + fromNameID + "\n FromStatus: " + fromStatus + "\n FromDoubtful: " + doubtfulFrom +
|
|
85 |
"\n ToName: " + toName + "\n ToNameId: " + toNameId + "\n ToStatus: " + toStatus + "\n ToDoubtful: " + doubtfulTo );
|
|
83 | 86 |
result = firstRow = false; |
84 | 87 |
} |
85 | 88 |
if (i > 0){ |
Also available in: Unified diff
merging /branches/cdmlib/SPRINT-Chichorieae1/ to trunk