Skip to content

Instantly share code, notes, and snippets.

@bitsydarel
Created May 16, 2017 04:31
Show Gist options
  • Save bitsydarel/83e055d126fb4945062c744fe17f5f15 to your computer and use it in GitHub Desktop.
Save bitsydarel/83e055d126fb4945062c744fe17f5f15 to your computer and use it in GitHub Desktop.
public void saveCurrentWeatherForCity(final String cityName, final Currently currently) {
final SQLiteDatabase writableDatabase = userCitiesDatabase.getWritableDatabase();
final Cursor query = userCitiesDatabase.getReadableDatabase().rawQuery(String.format("SELECT %s FROM %s WHERE %s=\"%s\"",
CITY_NAME, CURRENT_TABLE_NAME, CITY_NAME, cityName), null);
final ContentValues databaseInsert = new ContentValues();
databaseInsert.put(CITY_NAME, cityName);
databaseInsert.put(CURRENT_TIME, currently.getTime());
databaseInsert.put(CURRENT_SUMMARY, currently.getSummary());
databaseInsert.put(CURRENT_ICON, currently.getIcon());
databaseInsert.put(CURRENT_TEMPERATURE, currently.getTemperature());
databaseInsert.put(CURRENT_APPARENT_TEMPERATURE, currently.getApparentTemperature());
databaseInsert.put(CURRENT_HUMIDITY, currently.getHumidity());
databaseInsert.put(CURRENT_PRECIPCHANCE, currently.getPrecipProbability());
databaseInsert.put(CURRENT_PRECIPTYPE, currently.getPrecipType());
databaseInsert.put(CURRENT_CLOUD_COVER, currently.getCloudCover());
databaseInsert.put(CURRENT_WIND_SPEED, currently.getWindSpeed());
databaseInsert.put(CURRENT_WIND_BEARING, currently.getWindBearing());
if (query != null && query.moveToFirst()) {
if (query.getString(query.getColumnIndex(CITY_NAME)).equalsIgnoreCase(cityName)) {
final int result = writableDatabase.update(CURRENT_TABLE_NAME,
databaseInsert,
null,
null);
databaseInsert.clear();
Log.i(ConstantHolder.TAG, String.format("Saving Current Weather For : %s, result : %d", cityName, result));
} else {
final long result = writableDatabase.insert(CURRENT_TABLE_NAME, null, databaseInsert);
databaseInsert.clear();
if (result == -1) {
Log.i(ConstantHolder.TAG, String.format("CURRENT TABLE NOT INSERTED FOR %s", cityName));
} else {
Log.i(ConstantHolder.TAG, String.format("CURRENT TABLE INSERTED FOR %s", cityName));
}
}
query.close();
}
writableDatabase.close();
}
public void saveDailyWeatherForCity(final String cityName, final List<DailyData> dailyData) {
final ContentValues databaseInsert = new ContentValues();
final SQLiteDatabase writableDatabase = userCitiesDatabase.getWritableDatabase();
final AtomicInteger index = new AtomicInteger(1);
for (final DailyData day : dailyData) {
databaseInsert.put(CITY_NAME, cityName);
databaseInsert.put(DAY_TIME, day.getTime());
databaseInsert.put(DAY_SUMMARY, day.getSummary());
databaseInsert.put(DAY_ICON, day.getIcon());
databaseInsert.put(DAY_SUNRISE_TIME, day.getSunriseTime());
databaseInsert.put(DAY_SUNSET_TIME, day.getSunsetTime());
databaseInsert.put(DAY_MOON_PHASE, day.getMoonPhase());
databaseInsert.put(DAY_PRECIPCHANCE, day.getPrecipProbability());
databaseInsert.put(DAY_PRECIPTYPE, day.getPrecipType());
databaseInsert.put(DAY_TEMPERATURE_MAX, day.getTemperatureMax());
databaseInsert.put(DAY_APPARENT_TEMPERATURE_MAX, day.getApparentTemperatureMax());
databaseInsert.put(DAY_DEW_POINT, day.getDewPoint());
databaseInsert.put(DAY_HUMIDITY, day.getHumidity());
databaseInsert.put(DAY_WIND_SPEED, day.getWindSpeed());
databaseInsert.put(DAY_WIND_BEARING, day.getWindBearing());
databaseInsert.put(DAY_VISIBILITY, day.getVisibility());
databaseInsert.put(DAY_CLOUD_COVER, day.getCloudCover());
databaseInsert.put(DAY_PRESSURE, day.getPressure());
databaseInsert.put(DAY_OZONE, day.getOzone());
final int result = writableDatabase.update(DAYS_TABLE_NAME,
databaseInsert,
DAY_ID + " = ?",
new String[] { Integer.toString(index.getAndIncrement())});
if (result == 0) {
writableDatabase.insert(DAYS_TABLE_NAME,
null,
databaseInsert);
}
databaseInsert.clear();
}
writableDatabase.close();
}
public void saveHourlyWeatherForCity(final String cityName, final List<HourlyData> data) {
final ContentValues databaseInsert = new ContentValues();
final SQLiteDatabase writableDatabase = userCitiesDatabase.getWritableDatabase();
final AtomicInteger index = new AtomicInteger(1);
for (final HourlyData hourlyData : data) {
databaseInsert.put(CITY_NAME, cityName);
databaseInsert.put(HOUR_TIME, hourlyData.getTime());
databaseInsert.put(HOUR_SUMMARY, hourlyData.getSummary());
databaseInsert.put(HOUR_ICON, hourlyData.getIcon());
databaseInsert.put(HOUR_TEMPERATURE, hourlyData.getTemperature());
databaseInsert.put(HOUR_APPARENT_TEMPERATURE, hourlyData.getApparentTemperature());
databaseInsert.put(HOUR_HUMIDITY, hourlyData.getHumidity());
databaseInsert.put(HOUR_PRECIPCHANCE, hourlyData.getPrecipProbability());
databaseInsert.put(HOUR_PRECIPTYPE, hourlyData.getPrecipType());
databaseInsert.put(HOUR_DEW_POINT, hourlyData.getDewPoint());
databaseInsert.put(HOUR_WIND_SPEED, hourlyData.getWindSpeed());
databaseInsert.put(HOUR_WIND_BEARING, hourlyData.getWindBearing());
databaseInsert.put(HOUR_CLOUD_COVER, hourlyData.getCloudCover());
databaseInsert.put(HOUR_VISIBILITY, hourlyData.getVisibility());
databaseInsert.put(HOUR_PRESSURE, hourlyData.getPressure());
databaseInsert.put(HOUR_OZONE, hourlyData.getOzone());
final int result = writableDatabase.update(HOURS_TABLE_NAME,
databaseInsert,
HOUR_ID + " = ?",
new String[]{Integer.toString(index.getAndIncrement())});
if (result == 0) {
writableDatabase.insert(HOURS_TABLE_NAME, null, databaseInsert);
}
databaseInsert.clear();
}
}
public Currently getCurrentlyWeatherForCity(final String cityName) {
final Currently currently = new Currently();
final Cursor query = userCitiesDatabase.getReadableDatabase().rawQuery(String.format(Locale.getDefault(),
"%s %s WHERE %s=\"%s\"",
SELECT_EVERYTHING_FROM , CURRENT_TABLE_NAME, CITY_NAME, cityName), null);
query.moveToFirst();
if (!query.isAfterLast()) {
currently.setTime(query.getLong(query.getColumnIndex(CURRENT_TIME)));
currently.setSummary(query.getString(query.getColumnIndex(CURRENT_SUMMARY)));
currently.setIcon(query.getString(query.getColumnIndex(CURRENT_ICON)));
currently.setTemperature(query.getDouble(query.getColumnIndex(CURRENT_TEMPERATURE)));
currently.setApparentTemperature(query.getDouble(query.getColumnIndex(CURRENT_APPARENT_TEMPERATURE)));
currently.setHumidity(query.getDouble(query.getColumnIndex(CURRENT_HUMIDITY)));
currently.setPrecipProbability(query.getDouble(query.getColumnIndex(CURRENT_PRECIPCHANCE)));
currently.setPrecipType(query.getString(query.getColumnIndex(CURRENT_PRECIPTYPE)));
currently.setCloudCover(query.getDouble(query.getColumnIndex(CURRENT_CLOUD_COVER)));
currently.setWindSpeed(query.getDouble(query.getColumnIndex(CURRENT_WIND_SPEED)));
currently.setWindBearing(query.getLong(query.getColumnIndex(CURRENT_WIND_BEARING)));
}
query.close();
return currently;
}
public List<DailyData> getDailyWeatherForCity(final String cityName) {
final List<DailyData> days = new ArrayList<>();
final Cursor query = userCitiesDatabase.getReadableDatabase().rawQuery(String.format(SELECT_EVERYTHING_FROM +
DAYS_TABLE_NAME +
" WHERE %s=\"%s\"" + ORDER_BY + DAY_ID + " ASC"
, CITY_NAME, cityName), null);
if (query != null) {
for (query.moveToFirst(); !query.isAfterLast(); query.moveToNext()) {
final DailyData day = new DailyData();
day.setTime(query.getLong(query.getColumnIndex(DAY_TIME)));
day.setSummary(query.getString(query.getColumnIndex(DAY_SUMMARY)));
day.setIcon(query.getString(query.getColumnIndex(DAY_ICON)));
day.setSunriseTime(query.getLong(query.getColumnIndex(DAY_SUNRISE_TIME)));
day.setSunsetTime(query.getLong(query.getColumnIndex(DAY_SUNSET_TIME)));
day.setMoonPhase(query.getDouble(query.getColumnIndex(DAY_MOON_PHASE)));
day.setPrecipProbability(query.getDouble(query.getColumnIndex(DAY_PRECIPCHANCE)));
day.setPrecipType(query.getString(query.getColumnIndex(DAY_PRECIPTYPE)));
day.setTemperatureMax(query.getDouble(query.getColumnIndex(DAY_TEMPERATURE_MAX)));
day.setApparentTemperatureMax(query.getDouble(query.getColumnIndex(DAY_APPARENT_TEMPERATURE_MAX)));
day.setDewPoint(query.getDouble(query.getColumnIndex(DAY_DEW_POINT)));
day.setHumidity(query.getDouble(query.getColumnIndex(DAY_HUMIDITY)));
day.setWindSpeed(query.getDouble(query.getColumnIndex(DAY_WIND_SPEED)));
day.setWindBearing(query.getLong(query.getColumnIndex(DAY_WIND_BEARING)));
day.setVisibility(query.getLong(query.getColumnIndex(DAY_VISIBILITY)));
day.setCloudCover(query.getDouble(query.getColumnIndex(DAY_CLOUD_COVER)));
day.setPressure(query.getDouble(query.getColumnIndex(DAY_PRESSURE)));
day.setOzone(query.getDouble(query.getColumnIndex(DAY_OZONE)));
days.add(day);
}
query.close();
}
return days;
}
public List<HourlyData> getHourlyWeatherForCity(final String cityName) {
final List<HourlyData> hourlyData = new ArrayList<>();
final Cursor query = userCitiesDatabase.getReadableDatabase().rawQuery(String.format(SELECT_EVERYTHING_FROM
+ HOURS_TABLE_NAME + " WHERE %s=%s" + ORDER_BY + HOUR_ID + " ASC"
, CITY_NAME, cityName), null);
if (query != null) {
for (query.moveToFirst(); !query.isAfterLast(); query.moveToNext()) {
final HourlyData hour = new HourlyData();
hour.setTime(query.getLong(query.getColumnIndex(HOUR_TIME)));
hour.setIcon(query.getString(query.getColumnIndex(HOUR_ICON)));
hour.setSummary(query.getString(query.getColumnIndex(HOUR_SUMMARY)));
hour.setTemperature(query.getDouble(query.getColumnIndex(HOUR_TEMPERATURE)));
hour.setApparentTemperature(query.getDouble(query.getColumnIndex(HOUR_APPARENT_TEMPERATURE)));
hour.setHumidity(query.getDouble(query.getColumnIndex(HOUR_HUMIDITY)));
hour.setPrecipProbability(query.getDouble(query.getColumnIndex(HOUR_PRECIPCHANCE)));
hour.setPrecipType(query.getString(query.getColumnIndex(HOUR_PRECIPTYPE)));
hour.setDewPoint(query.getDouble(query.getColumnIndex(HOUR_DEW_POINT)));
hour.setWindSpeed(query.getDouble(query.getColumnIndex(HOUR_WIND_SPEED)));
hour.setWindBearing(query.getLong(query.getColumnIndex(HOUR_WIND_BEARING)));
hour.setCloudCover(query.getDouble(query.getColumnIndex(HOUR_CLOUD_COVER)));
hour.setVisibility(query.getDouble(query.getColumnIndex(HOUR_VISIBILITY)));
hour.setPressure(query.getDouble(query.getColumnIndex(HOUR_PRESSURE)));
hour.setOzone(query.getDouble(query.getColumnIndex(HOUR_OZONE)));
hourlyData.add(hour);
}
query.close();
}
return hourlyData;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment