traininfoservice/banedk/DepartureFetcher.java

package dk.thoerup.traininfoservice.banedk;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import java.util.Map;
import java.util.logging.Logger;

import com.gargoylesoftware.htmlunit.WebClient;
import com.gargoylesoftware.htmlunit.html.DomNodeList;
import com.gargoylesoftware.htmlunit.html.HtmlElement;
import com.gargoylesoftware.htmlunit.html.HtmlPage;

import dk.thoerup.circuitbreaker.CircuitBreaker;
import dk.thoerup.circuitbreaker.CircuitBreakerManager;
import dk.thoerup.traininfoservice.DBConnection;

public class DepartureFetcher {
        
        Logger logger = Logger.getLogger(DepartureFetcher.class.getName());
        
        Map<Integer, List<DepartureBean>> cache;
        
        private boolean useTempSite;
        
        public DepartureFetcher(boolean tempSite, int cacheTimeout) {
                useTempSite = tempSite;
                cache = new TimeoutMap<Integer,List<DepartureBean>>(cacheTimeout);
        }
        
        
        public List<DepartureBean> cachedLookupDepartures(int stationID) throws Exception {

                List<DepartureBean> list = cache.get(stationID);
                
                if (list == null) {
                        list = lookupDepartures(stationID);
                        cache.put(stationID, list);
                } else {
                        logger.info("Departure: Cache hit " + stationID); //remove before production
                }
                return list;
        }
                

        public List<DepartureBean> lookupDepartures(int stationID) throws Exception {
                List<DepartureBean> departureList = new ArrayList<DepartureBean>();
                
                Connection conn = null;
                try 
                {
                        conn = DBConnection.getConnection();
                
                        String SQL = "SELECT stationcode_fjrn, stationcode_stog FROM trainstations WHERE id=" + stationID;
                        Statement stmt = conn.createStatement();
                        ResultSet rs = stmt.executeQuery(SQL);
                        
                        if (rs.next()) {
                                String code = rs.getString( 1 );
                                if (! rs.wasNull() ) {
                                        List<DepartureBean> list = lookupDepartures(code, "FJRN");
                                        departureList.addAll(list);
                                }
                                
                                code = rs.getString(2);
                                if (! rs.wasNull() ) {
                                        List<DepartureBean> list = lookupDepartures(code, "S2");
                                        departureList.addAll(list);     
                                }
                                Collections.sort( departureList );
                        
                        }
                        
                } finally {
                        if (conn != null && !conn.isClosed() ) {
                                conn.close();
                        }
                }
                
                return departureList;
        }
        
        public List<DepartureBean> lookupDepartures(String stationcode, String type) throws Exception {
                if (useTempSite == false) {
                        return lookupDeparturesNormalSite(stationcode, type);
                } else {
                        return lookupDeparturesFromTemporarySite(stationcode, type);
                }
        }
        
        public List<DepartureBean> lookupDeparturesNormalSite(String stationcode, String type) throws Exception {
                
                List<DepartureBean> departureList = new ArrayList<DepartureBean>();
                
            final WebClient webClient = new WebClient();
            webClient.setTimeout(2500);
            webClient.setJavaScriptEnabled(false);
                            
            String uri = "http://www.bane.dk/visStation.asp?ArtikelID=4275&W=" + type + "&S=" + stationcode;
            BanedkInvocation wrapper = new BanedkInvocation(webClient, uri);
            CircuitBreaker breaker = CircuitBreakerManager.getManager().getCircuitBreaker("banedk");
            
            HtmlPage page = (HtmlPage) breaker.invoke(wrapper);
            
            HtmlElement table = page.getElementById("afgangtabel");
            
            if (table != null) {
                    DomNodeList<HtmlElement> tableRows =  table.getElementsByTagName("tr");
                    
                    for (HtmlElement currentRow : tableRows) {
                        String rowClass = currentRow.getAttribute("class");
                        if (rowClass != null && rowClass.toLowerCase().contains("station") ) {
                                DomNodeList<HtmlElement> fields = currentRow.getElementsByTagName("td");
        
                                DepartureBean departure = new DepartureBean();
                                
                                String time = fields.get(0).asText();
                                if (time.equals(""))
                                        time = "0:00"; //Bane.dk bug work-around
                                departure.setTime(time);
                                
                                int updated = extractUpdated( fields.get(1) );
                                departure.setUpdated(updated);
                                
                                String trainNumber = fields.get(2).asText();
                                if (type.equalsIgnoreCase("S2")) //If it is S-train we need to extract the trainNumber 
                                        trainNumber = trainNumber + " " + extractTrainNumber(fields.get(2));
                                departure.setTrainNumber(trainNumber);
                                
                                String destination = fields.get(3).asText();
                                departure.setDestination(destination);
                                
                                String origin = fields.get(4).asText();
                                departure.setOrigin(origin);
                                
                                String location = fields.get(5).asText();
                                departure.setLocation(location);
                                
                                String status = fields.get(6).asText();
                                departure.setStatus(status);
                                
                                String note = extractNote( fields.get(7) );
                                departure.setNote(note);
                                
                                departureList.add(departure);
                        }
                    }
            } else {
                logger.warning("No departures found for station=" + stationcode + ", type=" + type);
            }
            
            return departureList;
        }
        
        public List<DepartureBean> lookupDeparturesFromTemporarySite(String stationcode, String type) throws Exception {
                
                List<DepartureBean> departureList = new ArrayList<DepartureBean>();
                
            final WebClient webClient = new WebClient();
            webClient.setTimeout(2500);
            webClient.setJavaScriptEnabled(false);
            

            String uri = "http://bane.dk/lite/station.asp?w=" + type + "&s=" + stationcode;
            
            BanedkInvocation wrapper = new BanedkInvocation(webClient, uri);
            CircuitBreaker breaker = CircuitBreakerManager.getManager().getCircuitBreaker("banedk");
            
            HtmlPage page = (HtmlPage) breaker.invoke(wrapper);
            
            HtmlElement table = page.getElementById("traf_afgang");
            
            if (table != null) {                        
                    DomNodeList<HtmlElement> tableRows =  table.getElementsByTagName("tr");
                    
                    boolean isFirst = true;
                    
                    for (HtmlElement currentRow : tableRows) {
                        if (isFirst == true) { //skip table headers
                                isFirst = false;
                                continue;
                        }
                        
                        DomNodeList<HtmlElement> fields = currentRow.getElementsByTagName("td");

                        DepartureBean departure = new DepartureBean();

                        String time = fields.get(0).asText().trim();

                        if (time.equals(""))
                                time = "0:00"; //Bane.dk bug work-around
                        departure.setTime(time);


                        String trainNumber = fields.get(1).asText();
                        departure.setTrainNumber(trainNumber);

                        String destination = fields.get(2).asText();
                        departure.setDestination(destination);

                        String origin = fields.get(3).asText();
                        departure.setOrigin(origin);

                        String status = fields.get(4).asText();
                        departure.setStatus(status);

                        String note = fields.get(5).asText();
                        departure.setNote(note);

                        departureList.add(departure);
                    }
            } else {
                logger.warning("No departures found for station=" + stationcode + ", type=" + type);
            }
            
            return departureList;
        }

        
        private int extractUpdated(HtmlElement updatedTd) { //extract the digit (in this case: 4) from "media/trafikinfo/opdater4.gif" 
                int updated = -1;
                
                DomNodeList<HtmlElement> updatedImgs = updatedTd.getElementsByTagName("img");
                String updatedStr = updatedImgs.get(0).getAttribute("src");
                
                if (updatedStr != null) {
                        for (int i=0; i<updatedStr.length(); i++) {
                                char c = updatedStr.charAt(i);
                                if ( Character.isDigit(c))  {
                                        updated = Character.digit(c, 10);
                                        break;
                                }
                        }
                }               
                return updated;
        }
        
        private String extractNote(HtmlElement noteTd) {
                String note = noteTd.asText().trim();
                
                List<HtmlElement> elems = noteTd.getElementsByAttribute("span", "class", "bemtype");
                if (elems.size() > 0 && note.charAt(note.length()-1) == 'i')
                        note = note.substring(0,note.length() -1 );

                return note;
        }
        
        private String extractTrainNumber(HtmlElement trainTd) {
                String number = "";
                HtmlElement anchorElement = trainTd.getElementsByTagName("a").get(0);
                String href = anchorElement.getAttribute("href");
                String argstring = href.substring( href.indexOf('?') + 1);
                
                String args[] = argstring.split("&");
                for (String arg : args) {
                        String pair[] = arg.split("="); // Key=pair[0], Value=pair[1]
                        
                        if (pair[0].equalsIgnoreCase("TogNr"))
                                number = pair[1];
                }
                
                
                return number;
        }
        
        //test
        /*
        public static void main(String args[]) throws Exception {
                DepartureFetcher f = new DepartureFetcher();
                List<DepartureBean> deps = f.lookupDepartures("AR", "FJRN");
                for(DepartureBean d : deps) {
                        System.out.println( d.getTime() + ";" + d.getUpdated() + ";" + d.getTrainNumber() + ";" + 
                                                d.getDestination() + ";" + d.getOrigin() + ";" + d.getLocation() + ";" + d.getStatus() + ";" + d.getNote()   );
                }
                
                System.out.println("--------------------------");
        }*/
}
1	package dk.thoerup.traininfoservice.banedk;
2
3	import java.sql.Connection;
4	import java.sql.ResultSet;
5	import java.sql.Statement;
6	import java.util.ArrayList;
7	import java.util.Collections;
8	import java.util.List;
9	import java.util.Map;
10	import java.util.logging.Logger;
11
12	import com.gargoylesoftware.htmlunit.WebClient;
13	import com.gargoylesoftware.htmlunit.html.DomNodeList;
14	import com.gargoylesoftware.htmlunit.html.HtmlElement;
15	import com.gargoylesoftware.htmlunit.html.HtmlPage;
16
17	import dk.thoerup.circuitbreaker.CircuitBreaker;
18	import dk.thoerup.circuitbreaker.CircuitBreakerManager;
19	import dk.thoerup.traininfoservice.DBConnection;
20
21	public class DepartureFetcher {
22
23	Logger logger = Logger.getLogger(DepartureFetcher.class.getName());
24
25	Map<Integer, List<DepartureBean>> cache;
26
27	private boolean useTempSite;
28
29	public DepartureFetcher(boolean tempSite, int cacheTimeout) {
30	useTempSite = tempSite;
31	cache = new TimeoutMap<Integer,List<DepartureBean>>(cacheTimeout);
32	}
33
34
35
36
37	public List<DepartureBean> cachedLookupDepartures(int stationID) throws Exception {
38
39	List<DepartureBean> list = cache.get(stationID);
40
41	if (list == null) {
42	list = lookupDepartures(stationID);
43	cache.put(stationID, list);
44	} else {
45	logger.info("Departure: Cache hit " + stationID); //remove before production
46	}
47	return list;
48	}
49
50
51	public List<DepartureBean> lookupDepartures(int stationID) throws Exception {
52	List<DepartureBean> departureList = new ArrayList<DepartureBean>();
53
54	Connection conn = null;
55	try
56	{
57	conn = DBConnection.getConnection();
58
59	String SQL = "SELECT stationcode_fjrn, stationcode_stog FROM trainstations WHERE id=" + stationID;
60	Statement stmt = conn.createStatement();
61	ResultSet rs = stmt.executeQuery(SQL);
62
63	if (rs.next()) {
64	String code = rs.getString( 1 );
65	if (! rs.wasNull() ) {
66	List<DepartureBean> list = lookupDepartures(code, "FJRN");
67	departureList.addAll(list);
68	}
69
70	code = rs.getString(2);
71	if (! rs.wasNull() ) {
72	List<DepartureBean> list = lookupDepartures(code, "S2");
73	departureList.addAll(list);
74	}
75	Collections.sort( departureList );
76
77	}
78
79	} finally {
80	if (conn != null && !conn.isClosed() ) {
81	conn.close();
82	}
83	}
84
85	return departureList;
86	}
87
88	public List<DepartureBean> lookupDepartures(String stationcode, String type) throws Exception {
89	if (useTempSite == false) {
90	return lookupDeparturesNormalSite(stationcode, type);
91	} else {
92	return lookupDeparturesFromTemporarySite(stationcode, type);
93	}
94	}
95
96	public List<DepartureBean> lookupDeparturesNormalSite(String stationcode, String type) throws Exception {
97
98	List<DepartureBean> departureList = new ArrayList<DepartureBean>();
99
100	final WebClient webClient = new WebClient();
101	webClient.setTimeout(2500);
102	webClient.setJavaScriptEnabled(false);
103
104	String uri = "http://www.bane.dk/visStation.asp?ArtikelID=4275&W=" + type + "&S=" + stationcode;
105	BanedkInvocation wrapper = new BanedkInvocation(webClient, uri);
106	CircuitBreaker breaker = CircuitBreakerManager.getManager().getCircuitBreaker("banedk");
107
108	HtmlPage page = (HtmlPage) breaker.invoke(wrapper);
109
110	HtmlElement table = page.getElementById("afgangtabel");
111
112	if (table != null) {
113	DomNodeList<HtmlElement> tableRows = table.getElementsByTagName("tr");
114
115	for (HtmlElement currentRow : tableRows) {
116	String rowClass = currentRow.getAttribute("class");
117	if (rowClass != null && rowClass.toLowerCase().contains("station") ) {
118	DomNodeList<HtmlElement> fields = currentRow.getElementsByTagName("td");
119
120	DepartureBean departure = new DepartureBean();
121
122	String time = fields.get(0).asText();
123	if (time.equals(""))
124	time = "0:00"; //Bane.dk bug work-around
125	departure.setTime(time);
126
127	int updated = extractUpdated( fields.get(1) );
128	departure.setUpdated(updated);
129
130	String trainNumber = fields.get(2).asText();
131	if (type.equalsIgnoreCase("S2")) //If it is S-train we need to extract the trainNumber
132	trainNumber = trainNumber + " " + extractTrainNumber(fields.get(2));
133	departure.setTrainNumber(trainNumber);
134
135	String destination = fields.get(3).asText();
136	departure.setDestination(destination);
137
138	String origin = fields.get(4).asText();
139	departure.setOrigin(origin);
140
141	String location = fields.get(5).asText();
142	departure.setLocation(location);
143
144	String status = fields.get(6).asText();
145	departure.setStatus(status);
146
147	String note = extractNote( fields.get(7) );
148	departure.setNote(note);
149
150	departureList.add(departure);
151	}
152	}
153	} else {
154	logger.warning("No departures found for station=" + stationcode + ", type=" + type);
155	}
156
157	return departureList;
158	}
159
160	public List<DepartureBean> lookupDeparturesFromTemporarySite(String stationcode, String type) throws Exception {
161
162	List<DepartureBean> departureList = new ArrayList<DepartureBean>();
163
164	final WebClient webClient = new WebClient();
165	webClient.setTimeout(2500);
166	webClient.setJavaScriptEnabled(false);
167
168
169	String uri = "http://bane.dk/lite/station.asp?w=" + type + "&s=" + stationcode;
170
171	BanedkInvocation wrapper = new BanedkInvocation(webClient, uri);
172	CircuitBreaker breaker = CircuitBreakerManager.getManager().getCircuitBreaker("banedk");
173
174	HtmlPage page = (HtmlPage) breaker.invoke(wrapper);
175
176	HtmlElement table = page.getElementById("traf_afgang");
177
178	if (table != null) {
179	DomNodeList<HtmlElement> tableRows = table.getElementsByTagName("tr");
180
181	boolean isFirst = true;
182
183	for (HtmlElement currentRow : tableRows) {
184	if (isFirst == true) { //skip table headers
185	isFirst = false;
186	continue;
187	}
188
189	DomNodeList<HtmlElement> fields = currentRow.getElementsByTagName("td");
190
191	DepartureBean departure = new DepartureBean();
192
193	String time = fields.get(0).asText().trim();
194
195	if (time.equals(""))
196	time = "0:00"; //Bane.dk bug work-around
197	departure.setTime(time);
198
199
200	String trainNumber = fields.get(1).asText();
201	departure.setTrainNumber(trainNumber);
202
203	String destination = fields.get(2).asText();
204	departure.setDestination(destination);
205
206	String origin = fields.get(3).asText();
207	departure.setOrigin(origin);
208
209	String status = fields.get(4).asText();
210	departure.setStatus(status);
211
212	String note = fields.get(5).asText();
213	departure.setNote(note);
214
215	departureList.add(departure);
216	}
217	} else {
218	logger.warning("No departures found for station=" + stationcode + ", type=" + type);
219	}
220
221	return departureList;
222	}
223
224
225	private int extractUpdated(HtmlElement updatedTd) { //extract the digit (in this case: 4) from "media/trafikinfo/opdater4.gif"
226	int updated = -1;
227
228	DomNodeList<HtmlElement> updatedImgs = updatedTd.getElementsByTagName("img");
229	String updatedStr = updatedImgs.get(0).getAttribute("src");
230
231	if (updatedStr != null) {
232	for (int i=0; i<updatedStr.length(); i++) {
233	char c = updatedStr.charAt(i);
234	if ( Character.isDigit(c)) {
235	updated = Character.digit(c, 10);
236	break;
237	}
238	}
239	}
240	return updated;
241	}
242
243	private String extractNote(HtmlElement noteTd) {
244	String note = noteTd.asText().trim();
245
246	List<HtmlElement> elems = noteTd.getElementsByAttribute("span", "class", "bemtype");
247	if (elems.size() > 0 && note.charAt(note.length()-1) == 'i')
248	note = note.substring(0,note.length() -1 );
249
250	return note;
251	}
252
253	private String extractTrainNumber(HtmlElement trainTd) {
254	String number = "";
255	HtmlElement anchorElement = trainTd.getElementsByTagName("a").get(0);
256	String href = anchorElement.getAttribute("href");
257	String argstring = href.substring( href.indexOf('?') + 1);
258
259	String args[] = argstring.split("&");
260	for (String arg : args) {
261	String pair[] = arg.split("="); // Key=pair[0], Value=pair[1]
262
263	if (pair[0].equalsIgnoreCase("TogNr"))
264	number = pair[1];
265	}
266
267
268
269	return number;
270	}
271
272	//test
273	/*
274	public static void main(String args[]) throws Exception {
275	DepartureFetcher f = new DepartureFetcher();
276	List<DepartureBean> deps = f.lookupDepartures("AR", "FJRN");
277	for(DepartureBean d : deps) {
278	System.out.println( d.getTime() + ";" + d.getUpdated() + ";" + d.getTrainNumber() + ";" +
279	d.getDestination() + ";" + d.getOrigin() + ";" + d.getLocation() + ";" + d.getStatus() + ";" + d.getNote() );
280	}
281
282	System.out.println("--------------------------");
283	}*/
284	}