Exemplo n.º 1
0
 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);
   }
 }
Exemplo n.º 2
0
  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.");
  }
Exemplo n.º 3
0
  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.");
  }
Exemplo n.º 4
0
  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.");
  }