public Track getTrack(long track_id) {
SQLiteDatabase database = this.getWritableDatabase();
String select = "SELECT * FROM track WHERE id =" + track_id;
Cursor cursor = database.rawQuery(select, null);
if (cursor != null) cursor.moveToFirst();
Track track = new Track();
track.name = (cursor.getString(1));
track.distance = (cursor.getDouble(2));
track.time = (cursor.getLong(3));
track.altitude = (cursor.getDouble(4));
return track;
}
public List<Track> getAllTracks() {
List<Track> tracks = new ArrayList<Track>();
String select = "SELECT * FROM track";
SQLiteDatabase database = this.getReadableDatabase();
Cursor cursor = database.rawQuery(select, null);
if (cursor.moveToFirst()) {
do {
Track track = new Track();
track.name = (cursor.getString(1));
track.distance = (cursor.getDouble(2));
track.time = (cursor.getLong(3));
track.altitude = (cursor.getDouble(4));
tracks.add(track);
} while (cursor.moveToFirst());
}
return tracks;
}
