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")) { |
} else if (dump.equals("trainstatistics")) { |
144 |
res = dumpResultset("SELECT * FROM trainstatistics ORDER BY statisticsdate"); |
res = dumpResultset("SELECT * FROM trainstatistics ORDER BY statisticsdate DESC"); |
145 |
} else if (dump.equals("trainstatistics_avg")) { |
} else if (dump.equals("trainstatistics_avg")) { |
146 |
res = dumpResultset("SELECT round(avg(location),1) as location, round(avg(name),1) as name, round(avg(favorites),1) as favorites, " + |
res = dumpResultset("SELECT round(avg(location),1) as location, round(avg(name),1) as name, round(avg(favorites),1) as favorites, " + |
147 |
"round(avg(departure),1) as departure, round(avg(depcache),1) as depcache, round(avg(deperror),1) as deperror, " + |
"round(avg(departure),1) as departure, round(avg(depcache),1) as depcache, round(avg(deperror),1) as deperror, " + |