Temps.java

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;
    }
}