学习python好几天了,终于实现了一个有意义的脚本
从redis往mysql搬数据。记录一下,也分享一下
import redis
import MySQLdb
import datetime
import string
import time
def getUserNum():
r = redis.Redis(host='localhost', port=6379, db=0,password='*****')
conn = MySQLdb.connect(host='***',user='***',passwd='***',db='',port=3306)
chs=[' ',' ',' ',' ',' ',' ',' ',' ',' ']
prefix='messageKey'
now = datetime.datetime.now() + datetime.timedelta(-1)
timeString=now.strftime('%Y-%m-%d')
try:
cur=conn.cursor()
for c in chs:
if c=='all':
key=prefix+'-'+timeString
else:
key=prefix+'-'+timeString+'-'+c
num=r.get(key)
value=[timeString,c,num]
cur.execute('insert into table(c1,c2,c3) values (%s,%s,%s)',value)
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
conn.commit()
cur.close()
conn.close()
#while True:
# getUserNum()
# time.sleep(60*60*24)
getUserNum()
linux后台执行:
method1: nohup python script.py & 需要程序一直运行 魏永while True
method2:添加crontab任务 设置执行时间 0 0 * * * python ./script.py
crontab -l 查看
crontab -e修改 改完立即生效