private void loadJourney() { // Otherwise, we need to query DB and build points from scratch. gpspoints = new ArrayList<>(); mDb.openReadOnly(); Cursor points = mDb.fetchAllCoordsForTrip(tripid); int COL_LAT = points.getColumnIndex("lat"); int COL_LGT = points.getColumnIndex("lgt"); int COL_TIME = points.getColumnIndex("time"); int COL_ACC = points.getColumnIndex(DbAdapter.K_POINT_ACC); int COL_SPEED = points.getColumnIndex(DbAdapter.K_POINT_SPEED); int COL_ALT = points.getColumnIndex(DbAdapter.K_POINT_ALT); while (!points.isAfterLast()) { int lat = points.getInt(COL_LAT); int lgt = points.getInt(COL_LGT); long time = points.getInt(COL_TIME); double altitude = points.getDouble(COL_ALT); float speed = (float) points.getDouble(COL_SPEED); float acc = (float) points.getDouble(COL_ACC); gpspoints.add(new CyclePoint(lat, lgt, time, acc, altitude, speed)); points.moveToNext(); } // while points.close(); mDb.close(); } // loadJourney
// Get lat/long extremes, etc, from trip record private void populateDetails() { mDb.openReadOnly(); Cursor tripdetails = mDb.fetchTrip(tripid); startTime_ = tripdetails.getInt(tripdetails.getColumnIndex("start")); status = tripdetails.getInt(tripdetails.getColumnIndex("status")); endTime_ = tripdetails.getInt(tripdetails.getColumnIndex("endtime")); distance = tripdetails.getFloat(tripdetails.getColumnIndex("distance")); purp_ = tripdetails.getString(tripdetails.getColumnIndex("purp")); fancystart_ = tripdetails.getString(tripdetails.getColumnIndex("fancystart")); info_ = tripdetails.getString(tripdetails.getColumnIndex("fancyinfo")); note_ = tripdetails.getString(tripdetails.getColumnIndex("note")); age_ = tripdetails.getString(tripdetails.getColumnIndex("age")); gender_ = tripdetails.getString(tripdetails.getColumnIndex("gender")); experience_ = tripdetails.getString(tripdetails.getColumnIndex("experience")); tripdetails.close(); mDb.close(); loadJourney(); }