public void createCalendar() {
List<Service> services = db.getCalendars();
Calendar start = null;
Calendar end = null;
int doyStart, doyEnd, dow = -1;
int[] validityVector = null;
boolean[] validity = null;
String dbVector = null;
for (Service s : services) {
start = new GregorianCalendar();
end = new GregorianCalendar();
start.setFirstDayOfWeek(Calendar.MONDAY);
end.setFirstDayOfWeek(Calendar.MONDAY);
validityVector = new int[366];
dbVector = new String();
for (int i = 0; i < 366; i++) validityVector[i] = 0;
start.setTimeInMillis(parseDateToMillis(s.getStartDate()));
end.setTimeInMillis(parseDateToMillis(s.getEndDate()));
doyStart = start.get(Calendar.DAY_OF_YEAR);
doyEnd = end.get(Calendar.DAY_OF_YEAR);
validity = s.getValidity();
Calendar c = (Calendar) start.clone();
while (doyStart <= doyEnd) {
dow = c.get(Calendar.DAY_OF_WEEK);
if (validity[dow - 1]) validityVector[doyStart - 1] = 1;
c.add(Calendar.DAY_OF_YEAR, +1);
doyStart = c.get(Calendar.DAY_OF_YEAR);
}
for (int i = 0; i < 366; i++) dbVector += validityVector[i];
db.insertService(s.getId(), s.getStartDate(), s.getEndDate(), dbVector, city);
}
}
public void parseStops() {
try {
// System.out.println("[INFO] Parsing bus stops...");
BufferedReader br = new BufferedReader(new FileReader(new File(gtfs + "stops.txt")));
br.readLine(); // next line skipped
String line = br.readLine();
StringTokenizer st = null;
int id = -1;
String name = null;
double longi = 0.0;
double lat = 0.0;
String script = "";
script = "DELETE FROM vdv_gtfs_tmp.stops CASCADE;";
Statement stmt = DBConnector.getConnection().createStatement();
stmt.execute(script);
boolean comma = false;
while (line != null) {
script = "INSERT INTO vdv_gtfs_tmp.stops VALUES\n";
String aux = "";
// if(comma)
// aux += ",\n";
// comma = true;
st = new StringTokenizer(line, ",");
id = Integer.parseInt(st.nextToken());
name = st.nextToken();
String s = st.nextToken() + "." + st.nextToken();
String s1 = st.nextToken() + "." + st.nextToken();
lat = Double.parseDouble(s.substring(1, s.length() - 2));
longi = Double.parseDouble(s1.substring(1, s.length() - 2));
// bs = new BusStop(id, name, longi, lat);
// stops.add(bs);
// if(name.contains("\'"))
// name.replaceAll("\'", "\\'");
name = name.replace("\'", " ");
aux += "(" + id + ", '" + name + "', " + lat + ", " + longi + ")";
// db.insertStop(id, name, lat, longi);
line = br.readLine();
// if(line != null)
// script += ",\n";
script += aux;
script += ";";
// System.out.println(script);
stmt = DBConnector.getConnection().createStatement();
stmt.execute(script);
}
// System.out.println(script);
br.close();
} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e1) {
e1.printStackTrace();
}
// System.out.println("[INFO] Parsing bus stops...Done.");
}
public void parseTripSequence() {
// System.out.println("[INFO] Parsing trips sequence...");
try {
BufferedReader br = new BufferedReader(new FileReader(new File(gtfs + "stop_times.txt")));
StringTokenizer st = null;
br.readLine();
String s = br.readLine();
String script = "";
// script = "INSERT INTO vdv_gtfs_tmp.stop_times VALUES\n";
Statement stmt = DBConnector.getConnection().createStatement();
while (s != null) {
script = "INSERT INTO vdv_gtfs_tmp.stop_times VALUES\n";
st = new StringTokenizer(s, ",");
script +=
"('"
+ Integer.parseInt(st.nextToken())
+ "', '"
+ Integer.parseInt(st.nextToken())
+ "', '"
+ st.nextToken()
+ "', '"
+ st.nextToken()
+ "', '"
+ Integer.parseInt(st.nextToken())
+ "')";
s = br.readLine();
// if(s != null)
// script += ",\n";
script += ";";
stmt.execute(script);
}
// System.out.println(script);
br.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
// System.out.println("[INFO] Parsing trips sequence...Done.");
}
public void parseCalendar() {
// System.out.println("[INFO] Parsing calendar...");
try {
BufferedReader br = new BufferedReader(new FileReader(new File(gtfs + "calendar.txt")));
StringTokenizer st = null;
br.readLine();
String s = br.readLine();
String script = "";
script =
"INSERT INTO vdv_gtfs_tmp.calendar(service_id,"
+ "monday,"
+ "tuesday,"
+ "wednesday,"
+ "thursday,"
+ "friday,"
+ "saturday,"
+ "sunday,"
+ "start_date,"
+ "end_date) VALUES\n";
while (s != null) {
st = new StringTokenizer(s, ",");
script +=
"('"
+ Integer.parseInt(st.nextToken())
+ "', '"
+ isValidDay(st.nextToken())
+ "', '"
+ isValidDay(st.nextToken())
+ "', '"
+ isValidDay(st.nextToken())
+ "', '"
+ isValidDay(st.nextToken())
+ "', '"
+ isValidDay(st.nextToken())
+ "', '"
+ isValidDay(st.nextToken())
+ "', '"
+ isValidDay(st.nextToken())
+ "', '"
+ st.nextToken()
+ "', '"
+ st.nextToken()
+ "'),\n";
s = br.readLine();
}
br.close();
br = new BufferedReader(new FileReader(new File(gtfs + "calendar_dates.txt")));
br.readLine();
s = br.readLine();
Calendar c = null;
while (s != null) {
st = new StringTokenizer(s, ",");
int id = Integer.parseInt(st.nextToken());
// System.out.println(id);
String date = st.nextToken();
// System.out.println(date);
c = parseDateToCalendar(date);
boolean[] validity = {false, false, false, false, false, false, false};
validity[c.get(Calendar.DAY_OF_WEEK) - 1] = true;
script +=
"('"
+ id
+ "', '"
+ validity[0]
+ "', '"
+ validity[1]
+ "', '"
+ validity[2]
+ "', '"
+ validity[3]
+ "', '"
+ validity[4]
+ "', '"
+ validity[5]
+ "', '"
+ validity[6]
+ "', '"
+ date
+ "', '"
+ date
+ "')";
s = br.readLine();
if (s != null) script += ",\n";
}
script += ";";
// System.out.println(script);
Statement stmt = DBConnector.getConnection().createStatement();
stmt.execute(script);
br.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
// System.out.println("[INFO] Parsing calendar...Done.");
}
