public void deleteTrack(Long value) {
try {
DatabaseManager.getDb().delete(TABLE_NAME, COL_ID + "=" + value, null);
} catch (Exception e) {
Log.e(TAG, "Can't delete row", e);
}
}
public Long saveTrack(TrackDob trackDob) {
long insertId = -1;
try {
ContentValues values = new ContentValues();
values.put(COL_TAG, trackDob.getTag());
values.put(COL_START_TIME, trackDob.getStartTime());
values.put(COL_FIRST_LAT, trackDob.getFirstLat());
values.put(COL_FIRST_LON, trackDob.getFirstLon());
values.put(COL_FIRST_ADDRESS, trackDob.getFirstAddress());
values.put(COL_FINISH_TIME, trackDob.getFinishTime());
values.put(COL_LAST_LAT, trackDob.getLastLat());
values.put(COL_LAST_LON, trackDob.getLastLon());
values.put(COL_LAST_ADDRESS, trackDob.getLastAddress());
values.put(COL_DISTANCE, trackDob.getDistance());
values.put(COL_MAX_SPEED, trackDob.getMaxSpeed());
values.put(COL_AVE_SPEED, trackDob.getAveSpeed());
values.put(COL_MAX_ALT, trackDob.getMaxAlt());
values.put(COL_MIN_ALT, trackDob.getMinAlt());
values.put(COL_ELEV_DIFF_UP, trackDob.getElevDiffUp());
values.put(COL_ELEV_DIFF_DOWN, trackDob.getElevDiffDown());
values.put(COL_NOTE, trackDob.getNote());
insertId = DatabaseManager.getDb().insert(TABLE_NAME, null, values);
if (Const.LOG_ENHANCED) Log.i(TAG, "Track successfully saved with id = " + insertId);
} catch (Exception e) {
Log.e(TAG, "Cannot save track", e);
}
return insertId;
}
/**
* Delete track, keep only last N number
*
* @param keepOnlyTracks
*/
public Boolean keepOnlyLastTracks(Integer keepOnlyTracks) {
return DatabaseManager.getDb()
.delete(
TABLE_NAME,
COL_ID
+ " NOT IN (SELECT "
+ COL_ID
+ " FROM "
+ TABLE_NAME
+ " ORDER BY "
+ COL_ID
+ " DESC LIMIT ?)",
new String[] {String.valueOf(keepOnlyTracks)})
> 0;
}
public ArrayList<TrackDob> getAllTracks() {
ArrayList<TrackDob> locations = new ArrayList<TrackDob>();
try {
Cursor cursor =
DatabaseManager.getDb()
.query(TABLE_NAME, allColumns, null, null, null, null, COL_ID + " DESC");
cursor.moveToFirst();
while (!cursor.isAfterLast()) {
TrackDob loc = cursorToLocation(cursor);
locations.add(loc);
cursor.moveToNext();
}
// make sure to close the cursor
cursor.close();
} catch (Exception e) {
Log.e(TAG, "Cannot read all tracks", e);
}
return locations;
}
public Cursor getAllTracksCursor() {
return DatabaseManager.getDb()
.query(TABLE_NAME, allColumns, null, null, null, null, COL_ID + " DESC");
}
/**
* Complete table erase
*
* @throws SQLException
*/
public void EraseTable() {
init(DatabaseManager.getDb()); // sqlite doesn't have TRUNCATE - drop is recomended
}
