--- android/TrainInfoService/src/dk/thoerup/traininfoservice/DumpResultSet.java 2010/06/09 14:20:50 810 +++ android/TrainInfoService/src/dk/thoerup/traininfoservice/DumpResultSet.java 2010/06/09 20:16:01 811 @@ -140,6 +140,10 @@ res = dumpResultset("SELECT * FROM trainstations WHERE aliases IS NOT null"); } else if (dump.equals("updatecoords")) { res = dumpUpdate("UPDATE trainstations SET earth_coord = ll_to_earth(latitude,longitude)"); + } else if (dump.equals("trainstatistics")) { + res = dumpResultset("SELECT * FROM trainstatistics"); + } else if (dump.equals("trainstatistics_avg")) { + res = dumpResultset("SELECT avg(location), avg(name), avg(favorites), avg(departure), avg(depcache), avg(deperror), avg(timetable), avg(timecache), avg(timeerror) FROM trainstatistics"); } } if (res == null) {