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) { |