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