103 |
} |
} |
104 |
|
|
105 |
public void saveNewAddresses(List<Address> addresses) { |
public void saveNewAddresses(List<Address> addresses) { |
106 |
|
|
107 |
logger.info("DB::saveNewAddresses size:" + addresses.size() ); |
logger.info("DB::saveNewAddresses size:" + addresses.size() ); |
108 |
|
|
109 |
String sql = "INSERT IGNORE INTO fulddaekning.adressetabel " + |
String sql = "INSERT IGNORE INTO fulddaekning.adressetabel " + |
181 |
public void updateAddresses(List<Address> addresses) { |
public void updateAddresses(List<Address> addresses) { |
182 |
logger.info("DB::UpdateAddresses size:" + addresses.size() ); |
logger.info("DB::UpdateAddresses size:" + addresses.size() ); |
183 |
|
|
184 |
String sql = "UPDATE fulddaekning.adressetabel " + |
/*String sql = "UPDATE fulddaekning.adressetabel " + |
185 |
"SET " + |
"SET " + |
186 |
"RuteMa=?, KorelisteMa=?, " + |
"RuteMa=?, KorelisteMa=?, " + |
187 |
"RuteTi=?, KorelisteTi=?, " + |
"RuteTi=?, KorelisteTi=?, " + |
193 |
"Distributor=?, " + |
"Distributor=?, " + |
194 |
"DBKBane=?, " + |
"DBKBane=?, " + |
195 |
"Aendret=now() " + |
"Aendret=now() " + |
196 |
"WHERE id=? "; |
"WHERE id=? ";*/ |
197 |
|
String sql = "INSERT INTO fulddaekning.adressetabel " + |
198 |
|
"(id, " + |
199 |
|
"RuteMa, KorelisteMa, RuteTi, KorelisteTi, RuteOn, KorelisteOn, " + |
200 |
|
"RuteTo, KorelisteTo, RuteFr, KorelisteFr, RuteLo, KorelisteLo, " + |
201 |
|
"RuteSo, KorelisteSo, " + |
202 |
|
"Distributor, DBKBane, Aendret, " + |
203 |
|
"vejnavn,husnr,husnrbogstav,kommunekode,vejkode,gadeid,postnr) \n" + //Disse har ingen default value |
204 |
|
"VALUES " + |
205 |
|
"(?," + |
206 |
|
"?,?,?,?,?,?," + |
207 |
|
"?,?,?,?,?,?," + |
208 |
|
"?,?," + |
209 |
|
"?,?, now(), " + |
210 |
|
"'',0,'',0,0,0,0 ) \n" + |
211 |
|
|
212 |
|
"ON DUPLICATE KEY UPDATE " + |
213 |
|
"RuteMa=VALUES(RuteMa), KorelisteMa=VALUES(KorelisteMa), " + |
214 |
|
"RuteTi=VALUES(RuteTi), KorelisteTi=VALUES(KorelisteTi), " + |
215 |
|
"RuteOn=VALUES(RuteOn), KorelisteOn=VALUES(KorelisteOn), " + |
216 |
|
"RuteTo=VALUES(RuteTo), KorelisteTo=VALUES(KorelisteTo), " + |
217 |
|
"RuteFr=VALUES(RuteFr), KorelisteFr=VALUES(KorelisteFr), " + |
218 |
|
"RuteLo=VALUES(RuteLo), KorelisteLo=VALUES(KorelisteLo), " + |
219 |
|
"RuteSo=VALUES(RuteSo), KorelisteSo=VALUES(KorelisteSo), " + |
220 |
|
"Distributor=VALUES(Distributor), " + |
221 |
|
"DBKBane=VALUES(DBKBane) "; |
222 |
|
|
223 |
|
|
224 |
|
|
225 |
|
|
230 |
int count = 0; |
int count = 0; |
231 |
|
|
232 |
for (Address addr : addresses) { |
for (Address addr : addresses) { |
233 |
stmt.setString(1, addr.ruteMandag); |
stmt.setInt(1, addr.id); |
234 |
stmt.setString(2, addr.korelisteMandag); |
stmt.setString(2, addr.ruteMandag); |
235 |
stmt.setString(3, addr.ruteTirsdag); |
stmt.setString(3, addr.korelisteMandag); |
236 |
stmt.setString(4, addr.korelisteTirsdag); |
stmt.setString(4, addr.ruteTirsdag); |
237 |
stmt.setString(5, addr.ruteOnsdag); |
stmt.setString(5, addr.korelisteTirsdag); |
238 |
stmt.setString(6, addr.korelisteOnsdag); |
stmt.setString(6, addr.ruteOnsdag); |
239 |
stmt.setString(7, addr.ruteTorsdag); |
stmt.setString(7, addr.korelisteOnsdag); |
240 |
stmt.setString(8, addr.korelisteTorsdag); |
stmt.setString(8, addr.ruteTorsdag); |
241 |
stmt.setString(9, addr.ruteFredag); |
stmt.setString(9, addr.korelisteTorsdag); |
242 |
stmt.setString(10, addr.korelisteFredag); |
stmt.setString(10, addr.ruteFredag); |
243 |
stmt.setString(11, addr.ruteLordag); |
stmt.setString(11, addr.korelisteFredag); |
244 |
stmt.setString(12, addr.korelisteLordag); |
stmt.setString(12, addr.ruteLordag); |
245 |
stmt.setString(13, addr.ruteSondag); |
stmt.setString(13, addr.korelisteLordag); |
246 |
stmt.setString(14, addr.korelisteSondag); |
stmt.setString(14, addr.ruteSondag); |
247 |
|
stmt.setString(15, addr.korelisteSondag); |
248 |
|
|
249 |
stmt.setString(15, addr.distributor); |
stmt.setString(16, addr.distributor); |
250 |
stmt.setInt(16, addr.dbkBane); |
stmt.setInt(17, addr.dbkBane); |
251 |
stmt.setInt(17, addr.id); |
|
252 |
|
|
253 |
|
|
254 |
stmt.addBatch(); |
stmt.addBatch(); |
255 |
count++; |
count++; |
256 |
if (count >= 100) { |
if ( (count%200) == 0) { |
257 |
stmt.executeBatch(); |
stmt.executeBatch(); |
258 |
count = 0; |
|
259 |
|
if ( (count%50000) == 0 ) { |
260 |
|
logger.info("Update count " + count); |
261 |
|
} |
262 |
} |
} |
263 |
} |
} |
264 |
|
|