Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- 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
- status=readInfo()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement