/**
* Get Single object from the database
*
* @param id Primary key
* @return WeatherData object
*/
public WeatherData getweather(int id) {
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor =
db.query(
TABLE_WEATHER,
new String[] {"id", NAME, LONG_NAME, LONG_NAME},
"id" + "=?",
new String[] {String.valueOf(id)},
null,
null,
null,
null);
if (cursor != null) cursor.moveToFirst();
WeatherData weatherData = new WeatherData();
weatherData.setCity(cursor.getString(0));
weatherData.setCoordLon(Double.parseDouble(cursor.getString(1)));
weatherData.setCoordLon(Double.parseDouble(cursor.getString(2)));
return weatherData;
}
/**
* 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;
}
