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();
}
