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 }