public void recordingStopped() { endTime_ = now(); mDb.open(); mDb.updateTripStatus(tripid, STATUS_RECORDING_COMPLETE); mDb.setEndTime(tripid, endTime_); mDb.close(); }
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
public void addPointNow(Location loc) { int lat = (int) (loc.getLatitude() * 1E6); int lgt = (int) (loc.getLongitude() * 1E6); float accuracy = loc.getAccuracy(); double altitude = loc.getAltitude(); float speed = loc.getSpeed(); endTime_ = (loc.getTime() / 1000); CyclePoint pt = new CyclePoint(lat, lgt, endTime_, accuracy, altitude, speed); if (gpspoints.size() > 1) { CyclePoint gp = gpspoints.get(gpspoints.size() - 1); float segmentDistance = gp.distanceTo(pt); if (segmentDistance == 0) return; // we haven't gone anywhere distance += segmentDistance; } // if ... gpspoints.add(pt); mDb.open(); mDb.addCoordToTrip(tripid, pt); mDb.setDistance(tripid, distance); mDb.close(); return; } // addPointNow
private void setMessages() { dbHelper.open(); for (Message message : dbHelper.getMessages()) { addMessageToLayout(message); } dbHelper.close(); messagesScroll.fullScroll(ScrollView.FOCUS_DOWN); }
public void onDestroy() { try { db.close(); } catch (Exception e) { } super.onDestroy(); }
private Message createMessage() { dbHelper.open(); Message message = dbHelper.createMessage( settings.getUsername(), content.getText().toString(), Calendar.getInstance().getTimeInMillis()); TransportConfiguration tc = new TransportConfiguration(); dbHelper.close(); return message; }
private void initializeData() { startTime_ = now(); endTime_ = now(); distance = 0; purp_ = fancystart_ = info_ = ""; gpspoints = new ArrayList<>(); mDb.open(); mDb.setStartTime(tripid, startTime_); mDb.close(); }
public void updateTrip( String purpose, String fancyStart, String fancyInfo, String notes, String age, String gender, String experience) { // Save the trip details to the phone database. W00t! mDb.open(); mDb.updateNotes(tripid, purpose, fancyStart, fancyInfo, notes, age, gender, experience); mDb.close(); purp_ = purpose; note_ = notes; age_ = age; gender_ = gender; experience_ = experience; } // updateTrip
public static PokemonSpecies[] createSpeciesArray() { PokemonSpecies[] speciesArray = new PokemonSpecies[668]; PokemonSpecies base_poke = null; ResultSet info = null; ResultSet moves = null; DbAdapter adapter; try { System.out.print("Loading Pokedex."); adapter = new DbAdapter(); for (int i = 1; i < 668; i++) { if (i % 50 == 0) { System.out.print('.'); } info = null; info = adapter.makeQuery("SELECT * FROM pokemon WHERE id = '" + i + "'"); if (info.next()) { base_poke = new PokemonSpecies(info); } speciesArray[i] = base_poke; } info.close(); for (int i = 1; i < 668; i++) { if (i % 50 == 0) { System.out.print('.'); } moves = null; moves = adapter.makeQuery("SELECT * FROM pokemon_moves WHERE pokemon_id = '" + i + "'"); speciesArray[i].setMoves(moves); } moves.close(); adapter.close(); } catch (Exception e) { e.printStackTrace(); } return speciesArray; }
// 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(); }
private void setSettings() { dbHelper.open(); settings = dbHelper.getSettings(); dbHelper.close(); }
private void updateTripStatus(int tripStatus) { mDb.open(); mDb.updateTripStatus(tripid, tripStatus); mDb.close(); }
void dropTrip() { mDb.open(); mDb.deleteAllCoordsForTrip(tripid); mDb.deleteTrip(tripid); mDb.close(); }
private void createTripInDatabase(Context c) { mDb.open(); tripid = mDb.createTrip(); mDb.close(); }
public void finish() { mDb.close(); super.finish(); }