1 |
package dk.daoas.fulddaekning;
|
2 |
|
3 |
import java.io.File;
|
4 |
import java.io.FileReader;
|
5 |
import java.util.List;
|
6 |
import java.util.Map;
|
7 |
import java.util.Queue;
|
8 |
import java.util.concurrent.ConcurrentHashMap;
|
9 |
import java.util.logging.FileHandler;
|
10 |
import java.util.logging.Level;
|
11 |
import java.util.logging.Logger;
|
12 |
import java.util.logging.SimpleFormatter;
|
13 |
|
14 |
import dk.daoas.fulddaekning.BoundingBox.BoundingBoxException;
|
15 |
|
16 |
public class Lookup {
|
17 |
|
18 |
static final String CONFIG_FILENAME = "fulddaekning.properties";
|
19 |
|
20 |
static int max_workers;
|
21 |
static boolean verbose;
|
22 |
|
23 |
static boolean rename_tables;
|
24 |
static String distributor;
|
25 |
|
26 |
static SafeProperties conf;
|
27 |
static Logger logger = Logger.getLogger( Lookup.class.toString() );
|
28 |
|
29 |
int postnr;
|
30 |
Database db;
|
31 |
|
32 |
Adresse daekkedeAdresser[];
|
33 |
Queue<Adresse> queue;
|
34 |
|
35 |
Map<Integer, LookupWorker> workers = new ConcurrentHashMap<Integer, LookupWorker>();
|
36 |
|
37 |
|
38 |
static Statistik flestDaekkede = new Statistik();
|
39 |
static Statistik flestIkkeDaekkede = new Statistik();
|
40 |
static Statistik mestBrugteTid = new Statistik();
|
41 |
static Statistik stoersteDataset = new Statistik();
|
42 |
|
43 |
static Adresse[] alleDaekkedeAdresser;
|
44 |
|
45 |
|
46 |
static class Statistik {
|
47 |
int postnr;
|
48 |
int antalDaekkede = 0;
|
49 |
int antalIkkeDaekkede = 0;
|
50 |
int totalDataset = 0;
|
51 |
long forbrugtTid = 0;
|
52 |
|
53 |
|
54 |
@Override
|
55 |
public String toString() {
|
56 |
return "postnr=" + postnr + " antalIkkeDaekkede=" + antalIkkeDaekkede + " antalDaekkede=" + antalDaekkede + " forbrugtTid=" + forbrugtTid + " totalDataset=" + totalDataset;
|
57 |
}
|
58 |
}
|
59 |
|
60 |
|
61 |
public Lookup(int postnr, Database db) {
|
62 |
this.postnr = postnr;
|
63 |
this.db = db;
|
64 |
}
|
65 |
|
66 |
public static void saveStatistics(Statistik stat) {
|
67 |
if (stat.antalDaekkede > flestDaekkede.antalDaekkede) {
|
68 |
flestDaekkede = stat;
|
69 |
}
|
70 |
if (stat.antalIkkeDaekkede > flestIkkeDaekkede.antalIkkeDaekkede) {
|
71 |
flestIkkeDaekkede = stat;
|
72 |
}
|
73 |
|
74 |
if (stat.totalDataset > mestBrugteTid.totalDataset) {
|
75 |
stoersteDataset = stat;
|
76 |
}
|
77 |
|
78 |
if (stat.forbrugtTid > mestBrugteTid.forbrugtTid) {
|
79 |
mestBrugteTid = stat;
|
80 |
}
|
81 |
}
|
82 |
|
83 |
public void doLookup() throws BoundingBoxException {
|
84 |
logger.info("Starting for postnr=" + postnr);
|
85 |
|
86 |
Statistik stat = new Statistik();
|
87 |
|
88 |
long start1 = System.currentTimeMillis();
|
89 |
long start2 = 0;
|
90 |
|
91 |
try {
|
92 |
|
93 |
logger.info("Henter _ikke_ daekkede adresser i " + postnr);
|
94 |
queue = db.hentIkkedaekkedeAdresser(postnr);
|
95 |
if (queue.size() == 0) {
|
96 |
logger.info("Fandt ikke nogen _ikke_ daekkede adresser i " + postnr);
|
97 |
return;
|
98 |
}
|
99 |
|
100 |
BoundingBox bbox = db.getBoundingbox(postnr);
|
101 |
bbox.validateBbox();
|
102 |
|
103 |
logger.info("Bbox=" + bbox);
|
104 |
bbox.adjustToMargin();
|
105 |
logger.info("Bbox Adjusted=" + bbox);
|
106 |
|
107 |
logger.info("Henter daekkede adresser i " + postnr);
|
108 |
daekkedeAdresser = db.hentDaekkedeAdresser(bbox);
|
109 |
|
110 |
stat.postnr = postnr;
|
111 |
stat.antalDaekkede = daekkedeAdresser.length;
|
112 |
stat.antalIkkeDaekkede = queue.size();
|
113 |
stat.totalDataset = stat.antalDaekkede * stat.antalIkkeDaekkede;
|
114 |
|
115 |
|
116 |
logger.info("Starter beregning for " + postnr);
|
117 |
start2 = System.currentTimeMillis();
|
118 |
|
119 |
for (int i =0; i<max_workers; i++) {
|
120 |
LookupWorker worker = new LookupWorker(i, this);
|
121 |
Thread t = new Thread(worker);
|
122 |
t.start();
|
123 |
|
124 |
workers.put(i, worker);
|
125 |
}
|
126 |
|
127 |
while (workers.size() > 0) {
|
128 |
Thread.sleep(10);//wait for worker threads
|
129 |
}
|
130 |
|
131 |
db.saveBatch();//Save any unsaved rows
|
132 |
|
133 |
|
134 |
} catch(Exception e) {
|
135 |
logger.log(Level.WARNING, "Exception during lookup", e);
|
136 |
|
137 |
if (e instanceof BoundingBoxException) {
|
138 |
logger.severe( e.getMessage() );
|
139 |
System.exit(1);
|
140 |
}
|
141 |
|
142 |
}
|
143 |
long now = System.currentTimeMillis();
|
144 |
|
145 |
stat.forbrugtTid = (now-start1);
|
146 |
saveStatistics(stat);
|
147 |
|
148 |
logger.info( stat.toString() );
|
149 |
logger.info("Done! elapsed=" + (now-start1) + "/" + (now-start2) + " postnr=" + postnr);
|
150 |
}
|
151 |
|
152 |
public void shutdownWorker(int workerid) {
|
153 |
//logger.info("Shutting down worker: " + workerid);
|
154 |
LookupWorker key = workers.remove(workerid);
|
155 |
|
156 |
if (key == null) {
|
157 |
System.out.println("Error removing worker from set " + workerid);
|
158 |
System.exit(0);
|
159 |
}
|
160 |
}
|
161 |
|
162 |
// Getters and setters
|
163 |
|
164 |
///////////////////////////
|
165 |
public Database getDb() {
|
166 |
return db;
|
167 |
}
|
168 |
|
169 |
|
170 |
|
171 |
public Adresse[] getDaekkedeAdresser() {
|
172 |
return daekkedeAdresser;
|
173 |
}
|
174 |
|
175 |
public Queue<Adresse> getQueue() {
|
176 |
return queue;
|
177 |
}
|
178 |
|
179 |
|
180 |
|
181 |
|
182 |
|
183 |
|
184 |
/////////////////////////////
|
185 |
// Static functions
|
186 |
|
187 |
|
188 |
|
189 |
|
190 |
public static void main(String[] args) throws Exception {
|
191 |
|
192 |
//Setup j.u.l Logger
|
193 |
Logger root = Logger.getLogger("");
|
194 |
FileHandler fhandler = new FileHandler("fulddaekning.log"); // Ingen max størrelse, ingen rotation og ingen append
|
195 |
fhandler.setFormatter( new SimpleFormatter() );
|
196 |
root.addHandler( fhandler );
|
197 |
|
198 |
|
199 |
|
200 |
|
201 |
File confFile = new File( CONFIG_FILENAME );
|
202 |
if (! confFile.exists() ) {
|
203 |
logger.warning("Config file not found: " + CONFIG_FILENAME);
|
204 |
System.exit(1);
|
205 |
}
|
206 |
|
207 |
conf = new SafeProperties();
|
208 |
conf.load( new FileReader(confFile) );
|
209 |
|
210 |
max_workers = Integer.parseInt( conf.getSafeProperty("MAX_WORKERS") );
|
211 |
logger.info("Starting with MAX_WORKERS:" + max_workers);
|
212 |
|
213 |
verbose = Boolean.parseBoolean( conf.getSafeProperty("VERBOSE") );
|
214 |
logger.info("Starting with VERBOSE:" + verbose);
|
215 |
|
216 |
rename_tables = Boolean.parseBoolean( conf.getSafeProperty("RENAMETABLES") );
|
217 |
logger.info("Starting with RENAMETABLES:" + rename_tables);
|
218 |
|
219 |
distributor = conf.getSafeProperty("DISTRIBUTOR");
|
220 |
distributor = distributor.toUpperCase();
|
221 |
logger.info("Starting for DISTRIBUTOR:" + distributor);
|
222 |
|
223 |
Constants.init(distributor);
|
224 |
Constants consts = Constants.getInstance();
|
225 |
|
226 |
Database db = new Database(conf);
|
227 |
|
228 |
|
229 |
|
230 |
|
231 |
boolean testRun= false;
|
232 |
|
233 |
|
234 |
long start = System.currentTimeMillis();
|
235 |
|
236 |
if (testRun == false) {
|
237 |
|
238 |
logger.info("Finder postnumre");
|
239 |
List<Integer> postnumre = db.hentPostnumre();
|
240 |
|
241 |
// Først validerer vi BBox på alle postnummre, for at undgå fuldt stop midt i beregningen
|
242 |
for(Integer postnr : postnumre) { //
|
243 |
logger.info("Validerer BBox for " + postnr);
|
244 |
BoundingBox bbox = db.getBoundingbox(postnr);
|
245 |
bbox.validateBbox();
|
246 |
}
|
247 |
|
248 |
if (consts.doExtendedLookup()) {
|
249 |
logger.info("Henter alle daekkede adresser");
|
250 |
alleDaekkedeAdresser = db.hentAlleDaekkedeAdresser();
|
251 |
logger.info( "AlleDaekkedeAdresser.length=" + alleDaekkedeAdresser.length);
|
252 |
}
|
253 |
|
254 |
|
255 |
//pre-check er ok - reset tmp tabel og start søgningen
|
256 |
db.resetResultTable();
|
257 |
|
258 |
for(Integer postnr : postnumre) {
|
259 |
Lookup lookup = new Lookup(postnr, db);
|
260 |
lookup.doLookup();
|
261 |
}
|
262 |
|
263 |
if (rename_tables) {
|
264 |
db.renameResultTables();
|
265 |
} else {
|
266 |
logger.info( "Rename tables is disabled !!!" );
|
267 |
}
|
268 |
|
269 |
|
270 |
|
271 |
} else {
|
272 |
/// Test
|
273 |
db.resetResultTable();
|
274 |
|
275 |
if (consts.doExtendedLookup()) {
|
276 |
alleDaekkedeAdresser = db.hentAlleDaekkedeAdresser();
|
277 |
logger.info( "AlleDaekkedeAdresser.length=" + alleDaekkedeAdresser.length);
|
278 |
}
|
279 |
|
280 |
Lookup lookup = new Lookup(4583, db);
|
281 |
lookup.doLookup();
|
282 |
}
|
283 |
|
284 |
long now = System.currentTimeMillis();
|
285 |
long elapsed = now - start ;
|
286 |
|
287 |
logger.info("Mest brugte tid: " + mestBrugteTid);
|
288 |
logger.info("Flest Ikke-dækkede, " + flestIkkeDaekkede);
|
289 |
logger.info("Flest Dækkede, " + flestDaekkede);
|
290 |
logger.info("Største Dataset, " + stoersteDataset);
|
291 |
logger.info("Fuld load done : " + formatMilliSeconds(elapsed) );
|
292 |
}
|
293 |
|
294 |
|
295 |
static String formatMilliSeconds(long milliseconds) {
|
296 |
int mseconds = (int) milliseconds % 1000;
|
297 |
int seconds = (int) (milliseconds / 1000) % 60 ;
|
298 |
int minutes = (int) ((milliseconds / (1000*60)) % 60);
|
299 |
int hours = (int) ((milliseconds / (1000*60*60)) % 24);
|
300 |
|
301 |
return String.format("%02d:%02d:%02d.%03d", hours, minutes, seconds, mseconds);
|
302 |
}
|
303 |
|
304 |
}
|