def getResponse(delay):
print "Iniciando Captura de Dados => " + timestamp()
saveFile("Iniciando Captura de Dados => " + timestamp())
count = True
while count == True:
fio = ForecastIO.ForecastIO(apikey, units=ForecastIO.ForecastIO.UNITS_AUTO, lang=ForecastIO.ForecastIO.LANG_PORTUGUESE, latitude=Quixada[0], longitude=Quixada[1])
time.sleep(delay)
if fio.has_currently() is True:
currently = FIOCurrently.FIOCurrently(fio)
print "Captura => " + timestamp()
saveFile("Captura => " + timestamp())
t = datetime.datetime.fromtimestamp(currently.time).strftime('%Y-%m-%d %H:%M:%S')
summary = currently.summary
icon = currently.icon
precipIntensity = currently.precipIntensity
precipProbability = currently.precipProbability
precipType = currently.precipType
temperature = currently.temperature
apparentTemperature = currently.apparentTemperature
humidity = currently.humidity
windSpeed = currently.windSpeed
cloudCover = currently.cloudCover
pressure = currently.pressure
ozone = currently.ozone
query = "INSERT INTO currently (createdat, summary, icon, precip_intensity, precip_probability, precip_type, temperature, apparent_temperature, humidity, wind_speed, cloud_cover, pressure, ozone) VALUES (%s, %s, %s, %f, %f, %s, %f, %f, %f, %f, %f, %f, %f)" %('"'+t+'"','"'+summary+'"','"'+icon+'"',precipIntensity,precipProbability,'"'+precipType+'"', temperature, apparentTemperature, humidity,windSpeed,cloudCover,pressure ,ozone)
print query
print "\n"
WeatherDb.execQuery(query)
else:
print 'Não possui Informações'
saveFile('Não possui Informações')
def currently(self):
currently = WeatherDb.select("SELECT * FROM currently WHERE id = (SELECT MAX(id) FROM currently)")
for row in currently:
idcurrently = row[0]
createdat = row[1]
summary = row[2]
icon = row[3]
precipIntensity = row[4]
precipProbability = row[5]
precipType = row[6]
temperature = row[7]
apparentTemperature = row[8]
humidity = row[9]
windSpeed = row[10]
cloudCover = row[11]
pressure = row[12]
ozone = row[13]
#
weather = json.dumps({'id':idcurrently,'createdat':createdat,'summary':summary,'icon':icon,'precip_intensity':precipIntensity,'precip_probability':precipProbability,'precip_type':precipType,'temperature':temperature,'apparent_temperature':apparentTemperature,'humidity':humidity,'wind_speed':windSpeed,'cloud_cover':cloudCover,'pressure':pressure,'ozone':ozone})
return weather
