9 |
import java.util.List; |
import java.util.List; |
10 |
|
|
11 |
|
|
12 |
|
|
13 |
import dk.daoas.adressevedligehold.beans.Address; |
import dk.daoas.adressevedligehold.beans.Address; |
14 |
import dk.daoas.adressevedligehold.beans.Address.AddressState; |
import dk.daoas.adressevedligehold.beans.Address.AddressState; |
15 |
|
import dk.daoas.adressevedligehold.tasks.TaskLogger; |
16 |
import dk.daoas.adressevedligehold.util.DeduplicateHelper; |
import dk.daoas.adressevedligehold.util.DeduplicateHelper; |
17 |
import dk.daoas.adressevedligehold.util.TimingHelper; |
import dk.daoas.adressevedligehold.util.TimingHelper; |
18 |
|
|
26 |
|
|
27 |
//static boolean DEBUG = false; |
//static boolean DEBUG = false; |
28 |
|
|
29 |
|
private TaskLogger logger = TaskLogger.getInstance(); |
30 |
|
|
31 |
|
|
32 |
public List<Address> getAllAdresses() throws SQLException { |
public List<Address> getAllAdresses() throws SQLException { |
33 |
TimingHelper timing = new TimingHelper(); |
TimingHelper timing = new TimingHelper(); |
42 |
; |
; |
43 |
|
|
44 |
try ( Connection conn = DBConnection.getConnection(); |
try ( Connection conn = DBConnection.getConnection(); |
45 |
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); |
Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); |
46 |
) { |
) { |
47 |
stmt.setFetchSize(Integer.MIN_VALUE); |
stmt.setFetchSize(Integer.MIN_VALUE); |
48 |
ResultSet res = stmt.executeQuery(sql); |
ResultSet res = stmt.executeQuery(sql); |
98 |
res.close(); |
res.close(); |
99 |
|
|
100 |
|
|
101 |
System.out.println("DB Loaded " + list.size() + " adresses in " + timing.getElapsed() + "ms"); |
logger.info("DB Loaded " + list.size() + " adresses in " + timing.getElapsed() + "ms"); |
102 |
|
|
103 |
return list; |
return list; |
104 |
} |
} |
105 |
} |
} |
106 |
|
|
107 |
public void saveNewAddresses(List<Address> addresses) { |
public void saveNewAddresses(List<Address> addresses) { |
108 |
System.out.println("DB::saveNewAddresses size:" + addresses.size() ); |
logger.info("DB::saveNewAddresses size:" + addresses.size() ); |
109 |
|
|
110 |
String sql = "INSERT IGNORE INTO fulddaekning.adressetabel " + |
String sql = "INSERT IGNORE INTO fulddaekning.adressetabel " + |
111 |
"(vejnavn,husnr,husnrbogstav,kommunekode,vejkode,postnr,gadeid,dbkbane,indlast,aendret,david,googlechecked," + |
"(vejnavn,husnr,husnrbogstav,kommunekode,vejkode,postnr,gadeid,dbkbane,indlast,aendret,david,googlechecked," + |
151 |
|
|
152 |
stmt.execute(); |
stmt.execute(); |
153 |
if (stmt.getUpdateCount() != 1) { |
if (stmt.getUpdateCount() != 1) { |
154 |
System.out.println("Error executing insert: " + addr); |
logger.info("Error executing insert: " + addr); |
155 |
addr.state = AddressState.CREATE_FAIL; |
addr.state = AddressState.CREATE_FAIL; |
156 |
} |
} |
157 |
|
|
160 |
|
|
161 |
//con.commit(); |
//con.commit(); |
162 |
} catch (SQLException e) { |
} catch (SQLException e) { |
163 |
System.out.println("Error inserting addresses" + e.getMessage() ); |
logger.warning("Error inserting addresses", e ); |
164 |
} |
} |
165 |
} |
} |
166 |
|
|
167 |
public void updateAddresses(List<Address> addresses) { |
public void updateAddresses(List<Address> addresses) { |
168 |
System.out.println("DB::UpdateAddresses size:" + addresses.size() ); |
logger.info("DB::UpdateAddresses size:" + addresses.size() ); |
169 |
|
|
170 |
String sql = "UPDATE fulddaekning.adressetabel " + |
String sql = "UPDATE fulddaekning.adressetabel " + |
171 |
"SET " + |
"SET " + |
210 |
|
|
211 |
stmt.execute(); |
stmt.execute(); |
212 |
if (stmt.getUpdateCount() != 1) { |
if (stmt.getUpdateCount() != 1) { |
213 |
System.out.println("Error executing update"); |
logger.warning("Error executing update: " + addr); |
214 |
} |
} |
215 |
|
|
216 |
} |
} |
218 |
|
|
219 |
//con.commit(); |
//con.commit(); |
220 |
} catch (SQLException e) { |
} catch (SQLException e) { |
221 |
System.out.println("Error updating addresses" + e.getMessage() ); |
logger.warning("Error updating addresses", e ); |
222 |
} |
} |
223 |
} |
} |
224 |
|
|