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()