conn = pymysql.connect(host='127.0.0.1', port=3306, user='***', passwd='***', db='***')
cur = conn.cursor()

cur.execute("SELECT preset, datespec, timespec, priority FROM schedule WHERE `enabled`='1' ORDER BY priority DESC")

for r in cur.fetchall():
	if datecheck(r[1],r[2]) == 1:
		execstring = "UPDATE preset SET `enabled`=1, `priority`=" + str(r[3]) + " WHERE id=" + str(r[0])
		#execstring = "UPDATE preset SET enabled=1, priority=20 WHERE id=0"
		print execstring
		cur.execute(execstring)
		print cur.fetchall()
		print "Enabled"
	else:
		execstring = "UPDATE preset SET `enabled`=0 WHERE id=" + str(r[0])
		print execstring
		cur.execute(execstring)
		print cur.fetchall()
		print "Disabled"

conn.commit()