--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Lookup.java	2014/05/07 07:59:03	2151
+++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Lookup.java	2015/02/09 13:21:39	2259
@@ -1,55 +1,56 @@
 package dk.daoas.fulddaekning;
 
-import java.io.File;
-import java.io.FileReader;
-import java.io.IOException;
-import java.sql.Connection;
-import java.sql.DriverManager;
-import java.sql.SQLException;
-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;
 
 import dk.daoas.fulddaekning.BoundingBox.BoundingBoxException;
 
 public class Lookup {
-	static int max_workers;
-	static boolean verbose;
+
+	
 	
-	static Properties conf;
-	static Logger logger = Logger.getLogger( Lookup.class.toString() );
+	final static Logger logger = Logger.getLogger( Lookup.class.toString() );
 	
-	int postnr;
+	String postnr;
 	Database db;
 		
-	ArrayList<Adresse> daekkedeAdresser;
+	Adresse daekkedeAdresser[];
 	Queue<Adresse> queue;
 	
 	Map<Integer, LookupWorker> workers = new ConcurrentHashMap<Integer, LookupWorker>();
 
+	ThreadPoolExecutor threadPool;	
+
+		
 	
-	
-	public Lookup(int postnr, Database db) {
+	public Lookup(String postnr, Database db, ThreadPoolExecutor threadPool) {
 		this.postnr = postnr;
 		this.db = db;
+		this.threadPool = threadPool;
 	}
 	
-	
+
 	
 	public void doLookup() throws BoundingBoxException {
 		logger.info("Starting for postnr=" + postnr);
 		
-		int queueSize=-1;
-		
+		Statistik stat = new Statistik();
+				
 		long start1 = System.currentTimeMillis();		
 		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();
 			
@@ -60,26 +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);
-			queueSize = queue.size();
-			
+			stat.postnr = postnr;
+			stat.antalDaekkede = daekkedeAdresser.length;
+			stat.antalIkkeDaekkede = queue.size();
+			stat.totalDataset = stat.antalDaekkede * stat.antalIkkeDaekkede;
+									
 			
 			logger.info("Starter beregning for " + postnr);
 			start2 = System.currentTimeMillis();
 						 								
-			for (int i =0; i<max_workers; i++) {
+			for (int i =0; i < LookupMain.max_workers; i++) {
 				LookupWorker worker = new LookupWorker(i, this);
-				Thread t = new Thread(worker);
+				/*Thread t = new Thread(worker);
 				t.start();
 				
-				workers.put(i, worker);
+				workers.put(i, worker);*/
 			}
 			
-			while (workers.size() > 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);
@@ -92,16 +96,13 @@
 		}
 		long now = System.currentTimeMillis();
 		
-		logger.info("Antal daekkede:" + daekkedeAdresser.size() );
-		logger.info("Antal ikke-daekkede:" + queueSize );
-		
-		logger.info("Done! elapsed=" + (now-start1) + "/" +  (now-start2) );
+		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
 		
@@ -112,7 +113,7 @@
 
 
 
-	public ArrayList<Adresse> getDaekkedeAdresser() {
+	public Adresse[] getDaekkedeAdresser() {
 		return daekkedeAdresser;
 	}
 
@@ -121,82 +122,4 @@
 	}
 
 
-	
-	
-	
-	
-	/////////////////////////////
-	// Static functions
-
-
-
-	
-	public static void main(String[] args) throws Exception {
-		
-		File confFile = new File("fulddaekning.properties");
-		if (! confFile.exists() ) {
-			logger.warning("Config file not found");
-			System.exit(1);
-		}
-				
-		conf = new Properties();
-		conf.load( new FileReader(confFile) );
-		
-		max_workers = Integer.parseInt( conf.getProperty("MAX_WORKERS") );
-		logger.info("Starting with MAX_WORKERS:" + max_workers);
-		
-		verbose = Boolean.parseBoolean( conf.getProperty("VERBOSE") );
-		logger.info("Starting with VERBOSE:" + verbose);
-		
-		Connection conn = getConnection();
-		Database db = new Database(conn);
-		
-		db.resetResultTable();
-
-		
-		
-		
-		
-		long start = System.currentTimeMillis();
-		
-		logger.info("Finder postnumre");
-		List<Integer> postnumre = db.hentPostnumre();
-		
-		for(Integer postnr : postnumre) {
-			Lookup lookup = new Lookup(postnr, db);
-			lookup.doLookup();			
-		}
-		
-		long now = System.currentTimeMillis();
-		
-		logger.info("Fuld load done : " + (now-start) );
-		
-		
-		//Lookup lookup = new Lookup(7400, db);
-		//lookup.doLookup();		
-	}
-	
-	public static Connection getConnection() throws SQLException, IOException {
-				
-		String db_host = conf.getProperty("DB_HOST");
-		String db_user = conf.getProperty("DB_USER");
-		String db_pass = conf.getProperty("DB_PASS");
-
-		
-		
-
-	    Connection conn = null;
-	    Properties connectionProps = new Properties();
-	    connectionProps.put("user", db_user);
-	    connectionProps.put("password", db_pass);
-
-	        conn = DriverManager.getConnection(
-	                   "jdbc:mysql://" +
-	                   db_host +
-	                   ":3306/",
-	                   connectionProps);
-	    logger.info("Connected to database");
-	    return conn;
-	}
-	
 }