EDIT

/**

* Copyright (C) 2007 EDIT

* http://www.e-taxonomy.eu

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

import org.apache.log4j.Logger;

import eu.etaxonomy.cdm.io.common.IOValidator;

import eu.etaxonomy.cdm.io.common.Source;

import eu.etaxonomy.cdm.io.pesi.erms.ErmsImportConfigurator;

/**

 * @author a.mueller

 * @since 17.02.2010

 */

public class ErmsRankImportValidator implements IOValidator<ErmsImportState>{

	private static final Logger logger = Logger.getLogger(ErmsRankImportValidator.class);

		boolean result = true;

		ErmsImportConfigurator config = state.getConfig();

		logger.info("Checking for ranks not yet fully implemented");

		//TODO ranks with not existing kingdoms (e.g. kingdom_id = 8)

		return result;

	}

	private boolean checkTaxonStatus(ErmsImportConfigurator bmiConfig){

		try {

			boolean result = true;

			Source source = bmiConfig.getSource();

			String strSQL = " SELECT RelPTaxon.RelQualifierFk, RelPTaxon.relPTaxonId, PTaxon.PTNameFk, PTaxon.PTRefFk, PTaxon_1.PTNameFk AS Expr1, PTaxon.RIdentifier, PTaxon_1.RIdentifier AS Expr3, Name.FullNameCache "  +

					" INNER JOIN Name ON PTaxon.PTNameFk = Name.NameId " +

				" WHERE (dbo.PTaxon.StatusFk = 1) AND ((RelPTaxon.RelQualifierFk = 7) OR (RelPTaxon.RelQualifierFk = 6) OR (RelPTaxon.RelQualifierFk = 2)) ";

			ResultSet rs = source.getResultSet(strSQL);

				int refFk = rs.getInt("PTRefFk");

				int relPTaxonId = rs.getInt("relPTaxonId");

				String taxonName = rs.getString("FullNameCache");

						"\n  taxonName: " + taxonName + "\n  refId: " + refFk + "\n  RelPTaxonId: " + relPTaxonId );

				result = firstRow = false;

			}

			if (i > 0){

				System.out.println(" ");

			}

			return result;

		} catch (SQLException e) {

			e.printStackTrace();

			return false;

		}

	}

}