import sqlite3
import os
import glob
import time
#import pytz
import dateutil.parser
from datetime import datetime

conn = sqlite3.connect('temp.sqlite3')
cur = conn.cursor()

cur.execute('''
CREATE TABLE IF NOT EXISTS templog
(date TEXT, hour TEXT, temp_f FLOAT, temp_c FLOAT)''')


os.system('modprobe w1-gpio')
os.system('modprobe w1-therm')

base_dir = '/sys/bus/w1/devices/'
device_folder = glob.glob(base_dir + '28*')[0]
device_file = device_folder + '/w1_slave'

def read_temp_raw():
    f = open(device_file, 'r')
    lines = f.readlines()
    f.close()
    return lines

def read_temp():
    lines = read_temp_raw()
    while lines[0].strip()[-3:] != 'YES':
        time.sleep(0.2)
        lines = read_temp_raw()
    equals_pos = lines[1].find('t=')
    if equals_pos != -1:
        temp_string = lines[1][equals_pos+2:]
        temp_c = float(temp_string) / 1000.0
        temp_f = temp_c * 9.0 / 5.0 + 32.0
        return temp_c, temp_f
	
while True:

#get the time:
	timenow = datetime.today()
#parse the time into date and hours/minutes:
	timedate =  timenow.strftime("%Y-%m-%d")
	timehours = timenow.strftime("%H:%M")
#Print it to the screen:
	print timedate, timehours, read_temp()
#Read the temp using the fucntion above, and then grab the values from the tempearture tuple in F and C
	temp = read_temp()
	temp_f = temp[1]
	temp_c = temp[0]
#Insert the data into the databse
	cur.execute('''INSERT INTO templog (date, hour, temp_f, temp_c) VALUES (?, ?, ?, ?)''', (timedate, timehours, temp_f, temp_c))
	conn.commit()
#wait 60 seconds to loop to the top of the While statement
	time.sleep(60)