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

Diff of /android/TrainInfoService/src/dk/thoerup/traininfoservice/DumpResultSet.java

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 810 by torben, Tue May 18 17:56:43 2010 UTC revision 811 by torben, Wed Jun 9 20:16:01 2010 UTC
# Line 140  public class DumpResultSet extends HttpS Line 140  public class DumpResultSet extends HttpS
140                                  res = dumpResultset("SELECT * FROM trainstations WHERE aliases IS NOT null");                                  res = dumpResultset("SELECT * FROM trainstations WHERE aliases IS NOT null");
141                          } else if (dump.equals("updatecoords")) {                          } else if (dump.equals("updatecoords")) {
142                                  res = dumpUpdate("UPDATE trainstations SET earth_coord = ll_to_earth(latitude,longitude)");                                  res = dumpUpdate("UPDATE trainstations SET earth_coord = ll_to_earth(latitude,longitude)");
143                            } else if (dump.equals("trainstatistics")) {
144                                    res = dumpResultset("SELECT * FROM trainstatistics");
145                            } else if (dump.equals("trainstatistics_avg")) {
146                                    res = dumpResultset("SELECT avg(location), avg(name), avg(favorites), avg(departure), avg(depcache), avg(deperror), avg(timetable), avg(timecache), avg(timeerror) FROM trainstatistics");
147                          }                          }
148                  }                  }
149                  if (res == null) {                  if (res == null) {
Legend:
Removed from v.810  
changed lines
  Added in v.811
  ViewVC Help
Powered by ViewVC 1.1.20