package gisdcl.counties;



import gisdcl.PMF;

import gisdcl.schools.DistrictIdToZip;

import gisdcl.schools.SchoolDistrictGeoprocessorsResource;



import java.util.List;

import java.util.logging.Logger;



import javax.jdo.PersistenceManager;

import javax.jdo.Query;



public class CountyGeomDAO {

	private static final Logger log = Logger.getLogger(CountyGeomDAO.class.getName());

	

	public CountyGeom getCountyByFips(String pFIPS) throws Exception{

		log.info(" starting getCountyByFips method ");

		

		//DataStore

		PersistenceManager pm = PMF.get().getPersistenceManager();

		Query query = pm.newQuery(CountyGeom.class);

	    query.setFilter("fips == pFIPS");

	    //query.setOrdering("hireDate desc");

	    query.declareParameters("String pFIPS");



	    try {

	        List<CountyGeom> results = (List<CountyGeom>) query.execute(pFIPS);

	        if(results.size()==1){

	        	CountyGeom e = results.get(0);

	        	log.info("..................");

                log.info("e.getCountyid()   : " + e.getCountyid());

                log.info("e.getFips() 		: " + e.getFips());

                log.info("e.getName()		: " + e.getName());

                log.info("e.getGeom()		: " + e.getGeom());

                return e;

	        } else if (results.size()>1){

	            log.info("More than two counties found in data base. Check database please. Counties found: "+ results.size() +" for fips: " + pFIPS);

	            //return ("More than two counties found in data base. Check database please. Counties found: "+ results.size() +" for fips: " + pFIPS);

	            return null;

	        } else {

	        	log.info("No counties found");

	        	//return ("No counites found");

	        	return null;

	        }

	    } catch (Exception e){

	    	log.info("Exception at DAO DistrictIdToZip");

	    	//return "Exception at DAO DistrictIdToZip";

	    	throw e;

	    }finally {

	        query.closeAll();

	        pm.close();

	    }

	}

	

}