/**
* Return List of All records of WeatherData from DB
*
* @return List<WeatherData>
*/
public List<WeatherData> getAllWeather() {
List<WeatherData> weatherList = new ArrayList<WeatherData>();
// Select All Query
String selectQuery = "SELECT * FROM " + TABLE_WEATHER;
SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
do {
WeatherData weatherData = new WeatherData();
weatherData.setID(cursor.getString(0));
weatherData.setCity(cursor.getString(1));
weatherData.setCoordLon(Double.parseDouble(cursor.getString(2)));
weatherData.setCoordLat(Double.parseDouble(cursor.getString(3)));
weatherList.add(weatherData);
} while (cursor.moveToNext());
}
// return weather list
return weatherList;
}
