设计思路:32G免费资源网
1.程序一旦run起来,python会把mysql中最近一段时间的数据全部提取出来32G免费资源网
2.然后实例化redis类,将数据简单解析后逐条传入redis队列32G免费资源网
3.定时器设计每天凌晨12点开始跑32G免费资源网
ps:redis是个内存数据库,做后台消息队列的缓存时有很大的用处,有兴趣的小伙伴可以去查看相关的文档。32G免费资源网
# -*- coding:utf-8 -*-
import MySQLdb
import schedule
import time
import datetime
import random
import string
import redis
# get the data from mysql
class FromSql(object):
def __init__(self, conn):
self.conn = conn
def acquire(self):
cursor = self.conn.cursor()
try:
sql = "SELECT * FROM test WHERE TO_DAYS(NOW()) - TO_DAYS(t) <= 1"
cursor.execute(sql)
rs = cursor.fetchall()
#print (rs)
for eve in rs:
print('%s, %s, %s, %s' % eve)
copy_rs = rs
<