--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Lookup.java 2014/05/10 09:26:42 2158 +++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Lookup.java 2015/02/09 13:21:39 2259 @@ -1,13 +1,8 @@ package dk.daoas.fulddaekning; -import java.io.File; -import java.io.FileReader; -import java.util.ArrayList; -import java.util.List; import java.util.Map; -import java.util.Properties; import java.util.Queue; -import java.util.concurrent.ConcurrentHashMap; +import java.util.concurrent.*; import java.util.logging.Level; import java.util.logging.Logger; @@ -15,52 +10,29 @@ public class Lookup { - static final String CONFIG_FILENAME = "fulddaekning.properties"; - - static int max_workers; - static boolean verbose; - static SafeProperties conf; - static Logger logger = Logger.getLogger( Lookup.class.toString() ); - int postnr; + final static Logger logger = Logger.getLogger( Lookup.class.toString() ); + + String postnr; Database db; - ArrayList daekkedeAdresser; + Adresse daekkedeAdresser[]; Queue queue; Map workers = new ConcurrentHashMap(); + ThreadPoolExecutor threadPool; + + - static Statistik flestDaekkede = new Statistik(); - static Statistik flestIkkeDaekkede = new Statistik(); - - - static class Statistik { - int postnr; - int antalDaekkede = 0; - int antalIkkeDaekkede = 0; - - @Override - public String toString() { - return "postnr=" + postnr + " antalIkkeDaekkede=" + antalIkkeDaekkede + " antalDaekkede=" + antalDaekkede; - } - } - - - public Lookup(int postnr, Database db) { + public Lookup(String postnr, Database db, ThreadPoolExecutor threadPool) { this.postnr = postnr; this.db = db; + this.threadPool = threadPool; } - public static void saveStatistics(Statistik stat) { - if (stat.antalDaekkede > flestDaekkede.antalDaekkede) { - flestDaekkede = stat; - } - if (stat.antalIkkeDaekkede > flestIkkeDaekkede.antalIkkeDaekkede) { - flestIkkeDaekkede = stat; - } - } + public void doLookup() throws BoundingBoxException { logger.info("Starting for postnr=" + postnr); @@ -71,6 +43,14 @@ long start2 = 0; try { + + logger.info("Henter _ikke_ daekkede adresser i " + postnr); + queue = db.hentIkkedaekkedeAdresser(postnr); + if (queue.size() == 0) { + logger.info("Fandt ikke nogen _ikke_ daekkede adresser i " + postnr); + return; + } + BoundingBox bbox = db.getBoundingbox(postnr); bbox.validateBbox(); @@ -81,31 +61,29 @@ logger.info("Henter daekkede adresser i " + postnr); daekkedeAdresser = db.hentDaekkedeAdresser(bbox); - logger.info("Henter _ikke_ daekkede adresser i " + postnr); - queue = db.hentIkkedaekkedeAdresser(postnr); - stat.postnr = postnr; - stat.antalDaekkede = daekkedeAdresser.size(); + stat.antalDaekkede = daekkedeAdresser.length; stat.antalIkkeDaekkede = queue.size(); - - saveStatistics(stat); - + stat.totalDataset = stat.antalDaekkede * stat.antalIkkeDaekkede; + logger.info("Starter beregning for " + postnr); start2 = System.currentTimeMillis(); - for (int i =0; i 0) { + while (threadPool.getActiveCount() > 0) { Thread.sleep(10);//wait for worker threads } + db.saveBatch();//Save any unsaved rows + } catch(Exception e) { logger.log(Level.WARNING, "Exception during lookup", e); @@ -118,15 +96,13 @@ } long now = System.currentTimeMillis(); + stat.forbrugtTid = (now-start1); + LookupMain.saveStatistics(stat); logger.info( stat.toString() ); logger.info("Done! elapsed=" + (now-start1) + "/" + (now-start2) + " postnr=" + postnr); } - public void shutdownWorker(int workerid) { - logger.info("Shutting down worker: " + workerid); - workers.remove(workerid); - } // Getters and setters @@ -137,7 +113,7 @@ - public ArrayList getDaekkedeAdresser() { + public Adresse[] getDaekkedeAdresser() { return daekkedeAdresser; } @@ -146,61 +122,4 @@ } - - - - - ///////////////////////////// - // Static functions - - - - - public static void main(String[] args) throws Exception { - - File confFile = new File( CONFIG_FILENAME ); - if (! confFile.exists() ) { - logger.warning("Config file not found: " + CONFIG_FILENAME); - System.exit(1); - } - - conf = new SafeProperties(); - conf.load( new FileReader(confFile) ); - - max_workers = Integer.parseInt( conf.getSafeProperty("MAX_WORKERS") ); - logger.info("Starting with MAX_WORKERS:" + max_workers); - - verbose = Boolean.parseBoolean( conf.getSafeProperty("VERBOSE") ); - logger.info("Starting with VERBOSE:" + verbose); - - Database db = new Database(conf); - - db.resetResultTable(); - - - - - - long start = System.currentTimeMillis(); - - logger.info("Finder postnumre"); - List postnumre = db.hentPostnumre(); - - for(Integer postnr : postnumre) { - Lookup lookup = new Lookup(postnr, db); - lookup.doLookup(); - } - - long now = System.currentTimeMillis(); - - logger.info("Flest Ikke-dækkede, " + flestIkkeDaekkede); - logger.info("Flest Dækkede, " + flestDaekkede); - logger.info("Fuld load done : " + (now-start) ); - - - - //Lookup lookup = new Lookup(7400, db); - //lookup.doLookup(); - } - }