Revision f56ef251
Added by Andreas Müller over 12 years ago
| cdmlib-io/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/validation/BerlinModelTaxonRelationImportValidator.java | ||
|---|---|---|
| 13 | 13 |
import java.sql.ResultSet; |
| 14 | 14 |
import java.sql.SQLException; |
| 15 | 15 |
|
| 16 |
import org.apache.commons.lang.StringUtils; |
|
| 16 | 17 |
import org.apache.log4j.Logger; |
| 17 | 18 |
|
| 18 |
import eu.etaxonomy.cdm.io.berlinModel.in.BerlinModelImportConfigurator; |
|
| 19 | 19 |
import eu.etaxonomy.cdm.io.berlinModel.in.BerlinModelImportState; |
| 20 | 20 |
import eu.etaxonomy.cdm.io.common.IOValidator; |
| 21 | 21 |
import eu.etaxonomy.cdm.io.common.Source; |
| ... | ... | |
| 106 | 106 |
Source source = state.getConfig().getSource(); |
| 107 | 107 |
String strQuery = |
| 108 | 108 |
"SELECT count(*) AS n FROM RelPTaxon " + |
| 109 |
" WHERE (Notes IS NOT NULL) AND (RTRIM(LTRIM(Notes)) <> '')"; |
|
| 109 |
" WHERE (Notes IS NOT NULL) AND (RTRIM(LTRIM(Notes)) <> '') ";
|
|
| 110 | 110 |
ResultSet rs = source.getResultSet(strQuery); |
| 111 | 111 |
rs.next(); |
| 112 | 112 |
int n; |
| ... | ... | |
| 139 | 139 |
" INNER JOIN RelPTQualifier ON RelPTaxon.RelQualifierFk = RelPTQualifier.RelPTQualifierId " + |
| 140 | 140 |
" LEFT OUTER JOIN Name ON PTaxon.PTNameFk = Name.NameId " + |
| 141 | 141 |
" LEFT OUTER JOIN Name AS AcceptedName ON RelPTaxon.PTNameFk2 = AcceptedName.NameId " + |
| 142 |
" WHERE (PTaxon.StatusFk = 1) AND (RelPTaxon.RelQualifierFk IN (2, 4, 5, 6, 7))"; |
|
| 142 |
" WHERE (PTaxon.StatusFk = 1) AND (RelPTaxon.RelQualifierFk IN (2, 4, 5, 6, 7)) "; |
|
| 143 |
|
|
| 143 | 144 |
ResultSet rs = source.getResultSet(strQuery); |
| 144 | 145 |
boolean firstRow = true; |
| 145 | 146 |
int i = 0; |
| ... | ... | |
| 157 | 158 |
String fromName = rs.getString("fromName");
|
| 158 | 159 |
int fromRefFk = rs.getInt("PTRefFk");
|
| 159 | 160 |
int fromNameId = rs.getInt("fromNameId");
|
| 160 |
// String fromStatus = rs.getString("FromStatus");
|
|
| 161 |
|
|
| 162 |
|
|
| 163 | 161 |
String toName = rs.getString("acceptedName");
|
| 164 |
// int toNameId = rs.getInt("ToNameId");
|
|
| 165 |
// String toStatus = rs.getString("ToStatus");
|
|
| 166 |
// String doubtfulFrom = String.valueOf(rs.getObject("doubtfulFrom"));
|
|
| 167 |
// String doubtfulTo = String.valueOf(rs.getObject("doubtfulTo"));
|
|
| 168 |
|
|
| 169 | 162 |
|
| 170 | 163 |
System.out.println("RelPTaxonId:" + relPTaxonId +
|
| 171 | 164 |
"\n TaxonRIdentifier: " + fromIdentifier + "\n name: " + fromName + "\n nameId: " + fromNameId + "\n RefFk: " + fromRefFk + "\n RelType: " + relType |
Also available in: Unified diff
add filters to some validations