--- dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java 2015/07/15 13:39:46 2615 +++ dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java 2015/07/15 13:42:30 2616 @@ -11,12 +11,10 @@ import java.util.Map; import dk.daoas.daoadresseservice.AddressUtils; -import dk.daoas.daoadresseservice.DaekningsType; import dk.daoas.daoadresseservice.beans.Address; import dk.daoas.daoadresseservice.beans.AliasBean; 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; @@ -252,41 +250,7 @@ } } - /* - * Bruges til at sammenligne gammel og ny adresse service - kan fjernes engang efter at vi er skiftet til ny service - */ - @Deprecated - public static List 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 result = new ArrayList(); - - 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 safeInt(String str) {