53 |
|
|
54 |
logger.info("Rename tables"); |
logger.info("Rename tables"); |
55 |
sql = "RENAME TABLE fulddaekning.afstand_anden_rute" + ext + " TO fulddaekning.afstand_anden_rute_old" + ext + ", fulddaekning.afstand_anden_rute_ny TO fulddaekning.afstand_anden_rute" + ext; |
sql = "RENAME TABLE fulddaekning.afstand_anden_rute" + ext + " TO fulddaekning.afstand_anden_rute_old" + ext + ", fulddaekning.afstand_anden_rute_ny TO fulddaekning.afstand_anden_rute" + ext; |
56 |
|
|
57 |
|
logger.info("Executing: " + sql); |
58 |
conn.createStatement().executeUpdate(sql); |
conn.createStatement().executeUpdate(sql); |
59 |
} |
} |
60 |
|
|
158 |
String sql = "SELECT id,postnr,adresse,gadeid,husnr,husnrbogstav,latitude,longitude,rute " + |
String sql = "SELECT id,postnr,adresse,gadeid,husnr,husnrbogstav,latitude,longitude,rute " + |
159 |
"FROM fulddaekning.adressetabel " + |
"FROM fulddaekning.adressetabel " + |
160 |
"WHERE rute IS NOT NULL " + |
"WHERE rute IS NOT NULL " + |
161 |
"AND latitude IS NOT NULL" + |
"AND latitude IS NOT NULL " + |
162 |
"AND longitude IS NOT NULL " + |
"AND longitude IS NOT NULL " + |
163 |
"AND distributor = ? "; |
"AND distributor = ? "; |
164 |
|
|