import RPi.GPIO as GPIO
import sys
import Adafruit_DHT
import time
import pyodbc
from mysql.connector import connect

DEMO = 1

GPIO.setmode(GPIO.BCM)
pinList = [26, 13]
manualPinList = [5, 6]

# loop through pins and set mode and state to 'off'

for i in pinList:
    GPIO.setup(i, GPIO.OUT)
    GPIO.output(i, GPIO.LOW)


for j in manualPinList:
    GPIO.setup(j, GPIO.OUT)
    GPIO.output(j, GPIO.HIGH)

SERVER_CONNECTOR = ['']

def Connect_MYSQL():

    SERVER = 'smartpanel.cywrzfld2wji.us-west-2.rds.amazonaws.com' #'r2ocontainers.cywrzfld2wji.us-west-2.rds.amazonaws.com'
    PORT = 3306 #1433
    DATABASE_NAME = 'smartpanel' #'SmartPanel'
    LOGIN = 'admin' #'r2oadmin'
    PASSWORD = 'smartpaneltest' #'pop90909'


    conn = connect(user=LOGIN, password=PASSWORD, database=DATABASE_NAME, port=PORT, host=SERVER)
    #conn = pyodbc.connect( 'DRIVER=FreeTDS;SERVER={};PORT={};DATABASE={};UID={};PWD={};'.format(SERVER, PORT, DATABASE_NAME, LOGIN, PASSWORD))

    # conn = pyodbc.connect(
    #     'DRIVER={ODBC Driver 13 for SQL Server};SERVER=' + SERVER + ';DATABASE=' + DATABASE_NAME + ';UID=' + LOGIN + ';PWD=' + PASSWORD)

    return conn


def Read_from_db_table(conn):
    cursor = conn.cursor(buffered=True)
    cursor.execute("select mode, humidity, humidity_threshold, fan1, fan2 from demo where demo = {0}".format(DEMO))
    rows = cursor.fetchall()
    return rows[0]


def main():
    conn = Connect_MYSQL()
    while True:
        #demo, mode, humidity, humidity_threshold, fan1, fan2 = Read_from_db_table(conn)
        mode, humidity, humidity_threshold, fan1, fan2 = Read_from_db_table(conn)
        #print(demo, mode, humidity, humidity_threshold, fan1, fan2)
        print(mode, humidity, humidity_threshold, fan1, fan2)
        # if logic, compare humidity to humidity_threshold
        if mode == 'logic':
            print "logic"
            # if 'humidity' > 'humidity_threshold' -> turn on both fans
            if humidity > humidity_threshold:
                print "humidity > threshold - turn both fans on"
                GPIO.output(26, True)
                GPIO.output(13, True)
        # if 'humidity' < 'humidity_threshold' -> turn off both fans
            else:
                print "humidity < threshold - turn both fans off"
                GPIO.output(26, False)
                GPIO.output(13, False)
        # if manual, read values from 'fan1_control' and 'fan2_control'
        elif mode == 'manual':
            print "manual"
        # if 'fan1_control' is high -> turn fan1 on
            if fan1 == '1':
                print "manual - fan 1 on"
                GPIO.output(26, True)
            else:
                print "manual - fan 1 off"
                GPIO.output(26, False)
        # if 'fan2_control' is high -> turn fan2 on
            if fan2 == '1':
                print "manual - fan 2 on"
                GPIO.output(13, True)
            else:
                print "manual - fan 2 off"
                GPIO.output(13, False)
        time.sleep(1)


if __name__ == '__main__':
    main()