--- dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java	2015/02/26 11:25:26	2383
+++ dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java	2015/02/26 13:11:45	2384
@@ -15,6 +15,7 @@
 import dk.daoas.daoadresseservice.beans.Address;
 import dk.daoas.daoadresseservice.beans.ExtendedBean;
 import dk.daoas.daoadresseservice.beans.HundredePctBean;
+import dk.daoas.daoadresseservice.beans.LoggedAddress;
 import dk.daoas.daoadresseservice.beans.SearchResult;
 import dk.daoas.daoadresseservice.util.DeduplicateHelper;
 
@@ -195,6 +196,41 @@
 		}		
 	}
 	
+	/*
+	 * Bruges til at sammenligne gammel og ny adresse service - kan fjernes engang efter at vi er skiftet til ny service 
+	 */
+	public static List<LoggedAddress> getLoggedAdresses(int antaldage) throws SQLException {
+		String sql = "select postnr,adresse,status from logs.hentruteinformation where indlast>=date_sub(curdate(), interval " + antaldage + " day) " +
+				"and status IN (10,11,12) " +
+				"group by postnr,adresse "
+				;
+
+		try ( Connection conn = DBConnection.getConnection();		
+				Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);
+				) {
+
+
+			stmt.setFetchSize(Integer.MIN_VALUE);
+
+			ResultSet res = stmt.executeQuery(sql);
+
+			List<LoggedAddress> result = new ArrayList<LoggedAddress>();
+
+			while (res.next()) {
+				LoggedAddress a = new LoggedAddress();				
+				a.postnr = res.getInt(1);				
+				a.adresse = res.getString(2);
+				a.status = res.getInt(3);
+
+				result.add(a);
+			}
+
+			res.close();
+
+			return result;
+		}
+	}
+	
 	private static int getStatusInt(SearchResult.Status status) {
 
 		switch (status) {