Entry 3137

#!/usr/bin/python
from Tkinter import *
import pg

db = pg.connect(host='localhost', dbname='postgres', user='postgres', passwd='pg')
font = ('helvetica', 50, 'bold')
id = db.query('SELECT MAX(id) FROM car').dictresult()[0]['max'] + 1
cycle = db.query('SELECT MAX(id) FROM cycle').dictresult()[0]['max'] + 1
db.query('INSERT INTO trial (id,date) VALUES ((SELECT MAX(id) FROM trial)+1, NOW())')

print id
print cycle

def car(color):
	global id
	db.query('INSERT INTO sf (id,light,cycle) VALUES (' + str(id) + ', ' + str(color) + ', ' + str(cycle) + ')')
	id += 1

def next():
	global cycle
	db.query('INSERT INTO cycle (id,trial) VALUES (' + str(cycle) + ',' + str(trial) + ')')
	cycle += 1

root = Tk()
root.title('RED LIGHT TRACKER')

frame = Frame(root)
frame.pack()

green = Button(frame, text='Green', command=lambda:car(0), fg='dark green', font=font).pack(side=LEFT)
yellow = Button(frame, text='Yellow', command=lambda:car(1), fg='yellow', font=font).pack(side=LEFT)
orange = Button(frame, text='Orange', command=lambda:car(2), fg='orange', font=font).pack(side=LEFT)
red = Button(frame, text='Red', command=lambda:car(3), fg='red', font=font).pack(side=LEFT)
switch = Button(frame, text='Next', command=next, fg='black', font=font).pack(side=LEFT)
quit = Button(frame, text='QUIT', command=frame.quit, fg='black', font=font).pack(side=LEFT)

root.mainloop()