def weather(self, city): conn = sqlite3.Connection("geonames.sql") cur = conn.cursor() cur.execute('SELECT * FROM cities WHERE city LIKE ?', (city,)) row = cur.fetchone() if row != None: geoname = row[1].encode("utf-8") city = row[0].encode("utf-8") print "Weather for " + geoname try: y = yr(geoname) w = y.weather[0] self.sendmsg("Weather in " + city.capitalize() + ": " + w["weather"]["name"]) self.sendmsg("Temperature: " + w["temperature"]["value"] + " C") self.sendmsg("Rain: " + w["precipitation"]["value"] + " mm") self.sendmsg("Wind: " + w["wind"]["speed"]["mps"] + " m/s " + w["wind"]["direction"]["name"]) except Exception: self.sendmsg("Problem requesting weather for " + geoname) else: self.sendmsg("Could not find city " + city.encode("utf-8")) conn.close()
def create_yr_test(self): y = yr("Finland/Western_Finland/Turku") self.assertIsInstance(y, yr)