/[projects]/android/TrainInfoService/src/dk/thoerup/traininfoservice/banedk/DepartureFetcher.java
ViewVC logotype

Annotation of /android/TrainInfoService/src/dk/thoerup/traininfoservice/banedk/DepartureFetcher.java

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1255 - (hide annotations) (download)
Mon Apr 4 10:56:44 2011 UTC (13 years, 1 month ago) by torben
File size: 12883 byte(s)
Move database related classes to it's own package
1 torben 305 package dk.thoerup.traininfoservice.banedk;
2    
3 torben 978
4 torben 992 import java.net.URL;
5 torben 994 import java.net.URLEncoder;
6 torben 307 import java.util.Collections;
7 torben 428 import java.util.Map;
8 torben 348 import java.util.logging.Logger;
9 torben 305
10 torben 992 import org.jsoup.nodes.Document;
11     import org.jsoup.nodes.Element;
12     import org.jsoup.select.Elements;
13 torben 305
14 torben 1061 import dk.thoerup.android.traininfo.common.DepartureBean;
15     import dk.thoerup.android.traininfo.common.DepartureEntry;
16     import dk.thoerup.android.traininfo.common.StationBean.StationEntry;
17 torben 468 import dk.thoerup.circuitbreaker.CircuitBreaker;
18     import dk.thoerup.circuitbreaker.CircuitBreakerManager;
19 torben 711 import dk.thoerup.traininfoservice.Statistics;
20 torben 1255 import dk.thoerup.traininfoservice.db.StationDAO;
21 torben 307
22 torben 305 public class DepartureFetcher {
23 torben 348
24 torben 972 enum TrainType{
25     STOG,
26     REGIONAL
27     }
28    
29 torben 1248 enum FetchTrainType {
30     STOG,
31     REGIONAL,
32     BOTH
33     }
34    
35 torben 348 Logger logger = Logger.getLogger(DepartureFetcher.class.getName());
36 torben 387
37 torben 978 Map<String, DepartureBean> cache;
38 torben 387
39 torben 588 StationDAO stationDao = new StationDAO();
40    
41 torben 1034 private boolean useAzureSite;
42 torben 1026 private int replyTimeout;
43 torben 580
44 torben 1034 public DepartureFetcher(boolean azureSite, int cacheTimeout, int replyTimeout) {
45 torben 1026 this.replyTimeout = replyTimeout;
46 torben 1034 useAzureSite = azureSite;
47 torben 978 cache = new TimeoutMap<String,DepartureBean>(cacheTimeout);
48 torben 580 }
49    
50    
51 torben 307
52 torben 387
53 torben 1248 public DepartureBean cachedLookupDepartures(int stationID, boolean arrival, FetchTrainType type) throws Exception {
54 torben 980
55 torben 1248 final String key = "" + stationID + ":" + arrival + ":" + type.toString();
56    
57 torben 978 DepartureBean departureBean = cache.get(key);
58 torben 308
59 torben 387
60 torben 978 if (departureBean == null) {
61 torben 1248 departureBean = lookupDepartures(stationID, arrival, type);
62 torben 978 cache.put(key, departureBean);
63 torben 387 } else {
64 torben 711 Statistics.getInstance().incrementDepartureCacheHits();
65 torben 829 logger.info("Departure: Cache hit " + key); //remove before production
66 torben 387 }
67 torben 980 return departureBean;
68 torben 387 }
69    
70    
71 torben 1248 public DepartureBean lookupDepartures(int stationID, boolean arrival, FetchTrainType type) throws Exception {
72 torben 307
73 torben 978 DepartureBean departureBean = new DepartureBean();
74    
75 torben 1060 StationEntry station = stationDao.getById(stationID);
76 torben 307
77 torben 1021 departureBean.stationName = station.getName();
78 torben 1252
79 torben 1248 if (station.getRegional() != null && (type == FetchTrainType.REGIONAL||type == FetchTrainType.BOTH) ) {
80 torben 978 DepartureBean tempBean = lookupDepartures(station.getRegional(), TrainType.REGIONAL, arrival);
81 torben 1063 departureBean.entries.addAll( tempBean.entries );
82 torben 978 departureBean.notifications.addAll(tempBean.notifications);
83 torben 307 }
84    
85 torben 1248 if (station.getStrain() != null && (type == FetchTrainType.STOG||type == FetchTrainType.BOTH)) {
86 torben 978 DepartureBean tempBean = lookupDepartures(station.getStrain(), TrainType.STOG, arrival);
87 torben 1063 departureBean.entries.addAll( tempBean.entries );
88 torben 978 departureBean.notifications.addAll(tempBean.notifications);
89 torben 588 }
90    
91 torben 1063 if (departureBean.entries.size() == 0) {
92 torben 1037 logger.info("No departures found for station " + stationID);
93     }
94    
95 torben 1252 if (type == FetchTrainType.BOTH) { //if we have both S-tog and regional order by departure/arrival time
96     Collections.sort( departureBean.entries );
97     }
98 torben 588
99    
100 torben 978 return departureBean;
101 torben 305 }
102    
103 torben 978 public DepartureBean lookupDepartures(String stationcode, TrainType type, boolean arrival) throws Exception {
104 torben 1034 if (useAzureSite == true) {
105     return lookupDeparturesAzureSite(stationcode, type, arrival);
106     } else {
107     return lookupDeparturesWwwSite(stationcode, type, arrival);
108 torben 580 }
109     }
110    
111 torben 1034 private String getTypeStringAzure(TrainType type) {
112 torben 972 switch (type) {
113     case STOG:
114     return "S-Tog";
115     case REGIONAL:
116     return "Fjerntog";
117     default:
118     return ""; //Can not happen
119     }
120     }
121    
122 torben 1034 private String getTypeStringWww(TrainType type) {
123     switch (type) {
124     case STOG:
125     return "S2";
126     case REGIONAL:
127     return "FJRN";
128     default:
129     return ""; //Can not happen
130     }
131     }
132    
133     public DepartureBean lookupDeparturesAzureSite(String stationcode, TrainType type, boolean arrival) throws Exception {
134 torben 305
135 torben 978 DepartureBean departureBean = new DepartureBean();
136 torben 992
137 torben 970
138 torben 1034 String typeString = getTypeStringAzure(type);
139 torben 970 String arrivalDeparture = (arrival==false) ? "Afgang" : "Ankomst";
140 torben 994
141     stationcode = URLEncoder.encode(stationcode,"ISO-8859-1");
142 torben 970
143 torben 1034 String uri = "http://trafikinfo.bane.dk/Trafikinformation/AfgangAnkomst/" + arrivalDeparture + "/" + stationcode + "/" + typeString + "/UdvidetVisning";
144 torben 994
145 torben 1048 logger.fine("URI: " + uri);
146 torben 1026 JsoupInvocation wrapper = new JsoupInvocation( new URL(uri), replyTimeout);
147 torben 421 CircuitBreaker breaker = CircuitBreakerManager.getManager().getCircuitBreaker("banedk");
148 torben 305
149 torben 992 Document page = (Document) breaker.invoke(wrapper);
150 torben 305
151 torben 829 String tableName = arrival == false ? "afgangtabel" : "ankomsttabel";
152 torben 992 Element table = page.getElementById(tableName);
153 torben 829
154 torben 342 if (table != null) {
155 torben 992 Elements tableRows = table.getElementsByTag("tr");
156 torben 342
157 torben 1188 //boolean tidsstregExists = (table.getElementsByAttributeValue("class", "Tidsstreg").size() > 0);
158     //boolean passedTidsstreg = false;
159 torben 1020
160 torben 992 for (Element currentRow : tableRows) {
161     String rowClass = currentRow.attr("class");
162 torben 1188 /*
163 torben 1020 if (tidsstregExists == true && passedTidsstreg == false) {
164     if (currentRow.getElementsByAttributeValue("class", "Tidsstreg").size() > 0) {
165     passedTidsstreg = true;
166     } else {
167     continue;
168     }
169 torben 1188 }*/
170 torben 1020
171 torben 342 if (rowClass != null && rowClass.toLowerCase().contains("station") ) {
172 torben 1020
173 torben 992 Elements fields = currentRow.getElementsByTag("td");
174 torben 342
175 torben 978 DepartureEntry departure = new DepartureEntry();
176 torben 342
177 torben 992 String time = fields.get(0).text();
178 torben 375 if (time.equals(""))
179     time = "0:00"; //Bane.dk bug work-around
180 torben 342 departure.setTime(time);
181    
182     int updated = extractUpdated( fields.get(1) );
183     departure.setUpdated(updated);
184    
185 torben 992 String trainNumber = fields.get(2).text();
186 torben 972 if (type == TrainType.STOG) //If it is S-train we need to extract the trainNumber
187 torben 1039 trainNumber = trainNumber + " " + extractTrainNumberAzure(fields.get(2));
188 torben 342 departure.setTrainNumber(trainNumber);
189    
190 torben 992 String destination = fields.get(3).text();
191 torben 342 departure.setDestination(destination);
192    
193 torben 992 String origin = fields.get(4).text();
194 torben 342 departure.setOrigin(origin);
195    
196 torben 992 String location = fields.get(5).text();
197 torben 342 departure.setLocation(location);
198    
199 torben 992 String status = fields.get(6).text().trim();
200 torben 342 departure.setStatus(status);
201    
202     String note = extractNote( fields.get(7) );
203     departure.setNote(note);
204    
205 torben 972 departure.setType(typeString);
206 torben 697
207 torben 1063 departureBean.entries.add( departure );
208 torben 342 }
209     }
210 torben 348 } else {
211     logger.warning("No departures found for station=" + stationcode + ", type=" + type);
212 torben 305 }
213 torben 978
214 torben 992 Element notifDiv = page.getElementById("station_planlagte_text");
215 torben 978 if (notifDiv != null) {
216    
217 torben 992 Elements tables = notifDiv.getElementsByTag("table");
218     for (Element tab : tables) {
219 torben 978
220 torben 992 Elements anchors = tab.getElementsByTag("a");
221 torben 978 if (anchors.size() == 2) {
222 torben 992 departureBean.notifications.add( anchors.get(1).text() );
223 torben 978 }
224     }
225    
226     }
227    
228    
229     return departureBean;
230 torben 305 }
231    
232 torben 1038
233    
234 torben 1040 public static String cleanText(String input) {
235     //apparently JSoup translates &nbsp; characters on www.bane.dk to 0xA0
236 torben 1038 return input.replace((char) 0xA0, (char)0x20).trim();
237     }
238    
239 torben 1034 public DepartureBean lookupDeparturesWwwSite(String stationcode, TrainType trainType, boolean arrival) throws Exception {
240 torben 580
241 torben 1034 DepartureBean departureBean = new DepartureBean();
242 torben 580
243 torben 1034 String type = getTypeStringWww(trainType);
244    
245 torben 1045 stationcode = URLEncoder.encode(stationcode, "ISO-8859-1");
246    
247 torben 1034
248     String uri = "http://www.bane.dk/visStation.asp?ArtikelID=4275&W=" + type + "&S=" + stationcode;
249 torben 1048 logger.fine("URI:" + uri);
250    
251 torben 1047
252 torben 1034 JsoupInvocation wrapper = new JsoupInvocation( new URL(uri), replyTimeout);
253 torben 580 CircuitBreaker breaker = CircuitBreakerManager.getManager().getCircuitBreaker("banedk");
254    
255 torben 1034 Element page = (Element) breaker.invoke(wrapper);
256 torben 580
257 torben 1034 String tableName = arrival == false ? "afgangtabel" : "ankomsttabel";
258     Element table = page.getElementById(tableName);
259 torben 580
260 torben 1046
261    
262 torben 1034 if (table != null) {
263     Elements tableRows = table.getElementsByTag("tr");
264 torben 580
265 torben 1188 //boolean passedTidsstreg = false;
266     //boolean tidsstregExists = (table.getElementsByAttributeValue("class", "Tidsstreg").size() > 0);
267 torben 1046
268 torben 1034 for (Element currentRow : tableRows) {
269     String rowClass = currentRow.attr("class");
270 torben 1188 /*
271 torben 1046 if (tidsstregExists == true && passedTidsstreg == false) {
272     if (currentRow.getElementsByAttributeValue("class", "Tidsstreg").size() > 0) {
273     passedTidsstreg = true;
274     } else {
275     continue;
276     }
277 torben 1188 }*/
278 torben 1046
279    
280 torben 1034 if (rowClass != null && rowClass.toLowerCase().contains("station") ) {
281     Elements fields = currentRow.getElementsByTag("td");
282    
283     DepartureEntry departure = new DepartureEntry();
284    
285    
286    
287 torben 1038 String time = cleanText( fields.get(0).getAllElements().get(2).text() );
288 torben 1034 if (time.equals(""))
289     time = "0:00"; //Bane.dk bug work-around
290     departure.setTime(time);
291    
292     int updated = extractUpdated( fields.get(1) );
293     departure.setUpdated(updated);
294    
295 torben 1038 String trainNumber = cleanText( fields.get(2).text() );
296 torben 1034 if (type.equalsIgnoreCase("S2")) //If it is S-train we need to extract the trainNumber
297 torben 1039 trainNumber = trainNumber + " " + extractTrainNumberWww(fields.get(2));
298 torben 1034 departure.setTrainNumber(trainNumber);
299    
300 torben 1038 String destination = cleanText( fields.get(3).text() );
301 torben 1034 departure.setDestination(destination);
302    
303 torben 1038 String origin = cleanText( fields.get(4).text() );
304 torben 1034 departure.setOrigin(origin);
305    
306 torben 1038 String location = cleanText( fields.get(5).text() );
307 torben 1034 departure.setLocation(location);
308    
309 torben 1038 String status = cleanText( fields.get(6).text() );
310 torben 1034 departure.setStatus(status);
311    
312 torben 1038 String note = cleanText( extractNote( fields.get(7) ) );
313 torben 1034 departure.setNote(note);
314    
315     departure.setType(type);
316    
317 torben 1063 departureBean.entries.add(departure);
318 torben 1034
319    
320 torben 580 }
321     }
322     } else {
323     logger.warning("No departures found for station=" + stationcode + ", type=" + type);
324     }
325    
326 torben 591
327 torben 1034 return departureBean;
328     }
329    
330 torben 580
331 torben 992 private int extractUpdated(Element updatedTd) { //extract the digit (in this case: 4) from "media/trafikinfo/opdater4.gif"
332 torben 305 int updated = -1;
333    
334 torben 992 Elements updatedImgs = updatedTd.getElementsByTag("img");
335     String updatedStr = updatedImgs.get(0).attr("src");
336 torben 305
337     if (updatedStr != null) {
338     for (int i=0; i<updatedStr.length(); i++) {
339     char c = updatedStr.charAt(i);
340     if ( Character.isDigit(c)) {
341     updated = Character.digit(c, 10);
342     break;
343     }
344     }
345     }
346     return updated;
347     }
348    
349 torben 992 private String extractNote(Element noteTd) {
350     String note = noteTd.text().trim();
351 torben 313
352 torben 992
353     Elements elems = noteTd.getElementsByClass("bemtype");
354 torben 313 if (elems.size() > 0 && note.charAt(note.length()-1) == 'i')
355     note = note.substring(0,note.length() -1 );
356    
357 torben 1038 return note.trim();
358 torben 313 }
359    
360 torben 1039 private String extractTrainNumberAzure(Element trainTd) {
361 torben 992 Element anchorElement = trainTd.getElementsByTag("a").get(0);
362     String href = anchorElement.attr("href");
363 torben 349
364 torben 973 int pos = href.lastIndexOf('/');
365     String number = href.substring(pos+1);
366 torben 970
367 torben 349 return number;
368     }
369    
370 torben 1039 private String extractTrainNumberWww(Element trainTd) {
371     String number = "";
372     Element anchorElement = trainTd.getElementsByTag("a").get(0);
373     String href = anchorElement.attr("href");
374     String argstring = href.substring( href.indexOf('?') + 1);
375    
376     String args[] = argstring.split("&");
377     for (String arg : args) {
378     String pair[] = arg.split("="); // Key=pair[0], Value=pair[1]
379    
380     if (pair[0].equalsIgnoreCase("TogNr"))
381     number = pair[1];
382     }
383    
384    
385     return number;
386     }
387    
388    
389 torben 305 //test
390 torben 580 /*
391 torben 451 public static void main(String args[]) throws Exception {
392 torben 305 DepartureFetcher f = new DepartureFetcher();
393 torben 307 List<DepartureBean> deps = f.lookupDepartures("AR", "FJRN");
394 torben 305 for(DepartureBean d : deps) {
395     System.out.println( d.getTime() + ";" + d.getUpdated() + ";" + d.getTrainNumber() + ";" +
396     d.getDestination() + ";" + d.getOrigin() + ";" + d.getLocation() + ";" + d.getStatus() + ";" + d.getNote() );
397     }
398    
399     System.out.println("--------------------------");
400 torben 580 }*/
401 torben 305 }

  ViewVC Help
Powered by ViewVC 1.1.20