Instantly share code, notes, and snippets.

Embed
What would you like to do?
A script to fetch weather data from OpenWeatherMap
"""
Created by Christian Stade-Schuldt on 2014-07-28.
"""
import sqlite3
import json
import urllib
import time
import datetime
import calendar
APP_ID = YOUR_APP_ID
WEATHER_DATA_URL = 'http://api.openweathermap.org/data/2.5/weather?q=Berlin,de&units=metric&APPID=' + APP_ID
def get_data():
"""get weather data from openweathermap"""
response = urllib.urlopen(WEATHER_DATA_URL)
data = json.loads(response.read())
temp = data['main']['temp']
pressure = data['main']['pressure']
temp_min = data['main']['temp_min']
temp_max = data['main']['temp_max']
humidity = data['main']['humidity']
wind_speed = data['wind']['speed']
try:
wind_gust = data['wind']['gust']
except KeyError:
wind_gust = None
wind_deg = data['wind']['deg']
clouds = data['clouds']['all']
try:
rain = data['rain']['3h']
except KeyError:
rain = None
try:
snow = data['snow']['3h']
except KeyError:
snow = None
weather_id = data['weather'][0]['id']
sunrise = data['sys']['sunrise']
sunset = data['sys']['sunset']
return [temp, pressure, temp_min, temp_max, humidity, wind_speed, wind_gust, wind_deg, clouds, rain, snow,
weather_id, sunrise, sunset]
def save_data_to_db(data):
con = sqlite3.connect("PATH_TO_SQLITE_FILE")
con.isolation_level = None
cur = con.cursor()
query = '''INSERT INTO weather_data VALUES (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'''
cur.execute(query, tuple([datetime.datetime.now().isoformat()] + data[:-2]))
con.commit()
con.close()
def main():
data = get_data()
time.sleep(10)
now = calendar.timegm(datetime.datetime.now().timetuple())
if data[-2] < now < data[-1]:
save_data_to_db(data)
if __name__ == '__main__':
main()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment