Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement