#!/usr/bin/python
import sys
import Adafruit_DHT

import subprocess
import re
import os
import time
import MySQLdb as mdb
import datetime

databaseUsername="root"
databasePassword="Admin33556"
databaseName="WordPressDB"

sensor=Adafruit_DHT.DHT22
pinNum=4

def saveToDatabase(temperature,humidity):

    con=mdb.connect("localhost", databaseUsername, databasePassword, databaseName)
        currentDate=datetime.datetime.now().date()

        now=datetime.datetime.now()
        midnight=datetime.datetime.combine(now.date(),datetime.time())
        minutes=((now-midnight).seconds)/60 #minutes after midnight, use datead$


        with con:
                cur=con.cursor()

                cur.execute("INSERT INTO temperatures (temperature,humidity, dateMeasured, hourMeasured) VALUES (%s,%s,%s,%s)",(temperature,humidity,currentDate, minutes))

        print "Saved temperature"
        return "true"


def readInfo():

    humidity, temperature = Adafruit_DHT.read_retry(sensor, pinNum)

    print "Temperature: %.1f C" % temperature
    print "Humidity:    %s %%" % humidity

    if humidity is not None and temperature is not None:
        return saveToDatabase(temperature,humidity) #success, save the readings
    else:
        print 'Failed to get reading. Try again!'
        sys.exit(1)


try:
    queryFile=file("createTable.sql","r")

    con=mdb.connect("localhost", databaseUsername,databasePassword,databaseName)
        currentDate=datetime.datetime.now().date()

        with con:
        line=queryFile.readline()
        query=""
        while(line!=""):
            query+=line
            line=queryFile.readline()

        cur=con.cursor()
        cur.execute(query)

        queryFile.close()
            os.rename("createTable.sql","createTable.sql.bkp")


except IOError:
    pass #table has already been created


status=readInfo()