#!/usr/bin/python
import sys
import Adafruit_DHT
import time
import os
import RPi.GPIO as GPIO
import sqlite3

GPIO.setmode(GPIO.BCM)
lampara = int(5)
contadorTEMP = int(120)
while True:
        if contadorTEMP == 120:
                conex = sqlite3.connect('/var/sqlite/fasito')
                TempCursor = conex.cursor()
                TempCursor.execute('SELECT TempMax, TempMin FROM TestTemp')
                for i in TempCursor:
                        tempMAX = float(i[0])
                        tempMIN = float(i[1])
                contadorTEMP = 0
                TempCursor.close()
                conex.close()
                print 'La nueva temp Maxima es:', tempMAX
                print 'La nueva temp Minima es:', tempMIN
        humidity, temperature = Adafruit_DHT.read_retry(11, 22)
        GPIO.setup(lampara, GPIO.OUT)
        if temperature > tempMAX and GPIO.input(lampara) != 1:
                GPIO.output(lampara, GPIO.HIGH)
                print "Se apago la luz"
                print temperature
                time.sleep(30)
                contadorTEMP + 6
        elif temperature < tempMIN and GPIO.input(lampara) != 0:
                GPIO.output(lampara, GPIO.LOW)
                print "Se prendio la luz"
                print temperature
                time.sleep(30)
                contadorTEMP + 6
        print temperature
        time.sleep(5)
        contadorTEMP + 1